Inventory - Days On Hand Help

[PJM1981]

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 can be produced for 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

<tbody>
</tbody>

 

[Marcelo Branco]

Hi and welcome to Mr Excel

Please, see Forum Rules

Rule #10:
We prefer that members do not cross-post questions to other forums, but when this does occur members must make clear that they have cross-posted and must provide links to the cross-posts. Cross-posted questions that do not comply may be deleted or locked. For a discussion on the issues with cross-posting, see this link: http://www.excelguru.ca/content.php?184

Cross-post
Calculating Production Quantities for equal Days on Hand

M.

 

[PJM1981]

My Apologies,

First time posting to forums for excel help. I've also posted this question on excelforum.com:

Calculating Production Quantities for equal Days on Hand

Any help would be greatly appreciated.


Thank you,

PJM1981

Hi and welcome to Mr Excel

Please, see Forum Rules

Rule #10:
We prefer that members do not cross-post questions to other forums, but when this does occur members must make clear that they have cross-posted and must provide links to the cross-posts. Cross-posted questions that do not comply may be deleted or locked. For a discussion on the issues with cross-posting, see this link: http://www.excelguru.ca/content.php?184

Cross-post
Calculating Production Quantities for equal Days on Hand

M.