Results 1 to 7 of 7

Calculating Production Quantities for equal Days on Hand

Threaded View

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Brooklyn, NYC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Calculating Production Quantities for equal Days on Hand

    Having trouble with aligning a production schedule to produce the same number of days on hand [DOH] across three packaging types. A total of 480.3 units has to be produced across the three packaging types. All three packaging types have different inventory levels and daily rate of sales [DROS]. how do I solve for A, B, and C so that X = the same number of days:

    Product Inventory DROS Breakdown DOH
    Type A 193 9.19 a x
    Type B 36 1.72 b x
    Type C 17 0.81 c x


    480.3
    Last edited by PJM1981; 09-17-2013 at 02:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-18-2011, 03:29 PM
  2. Calculating quantities using figures rather than number of rows
    By DaveThomas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2011, 03:41 PM
  3. Skip weekend days on production roster
    By SkeptiCol in forum Excel General
    Replies: 6
    Last Post: 01-25-2011, 09:16 PM
  4. Calculating Daily Quantities
    By Bob@Sun in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-22-2009, 04:47 PM
  5. Replies: 3
    Last Post: 10-19-2009, 03:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1