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:

[TABLE="width: 336"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Inventory[/TD]
[TD]DROS[/TD]
[TD]Breakdown[/TD]
[TD]DOH[/TD]
[/TR]
[TR]
[TD]Type A[/TD]
[TD] 193[/TD]
[TD]9.19[/TD]
[TD]a[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Type B[/TD]
[TD] 36[/TD]
[TD]1.72[/TD]
[TD]b[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Type C[/TD]
[TD] 17[/TD]
[TD]0.81[/TD]
[TD]c[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]480.3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.