Question
Assume that Product Z is made up of one unit of A and five units of B. A is made of three units of C
Assume that Product Z is made up of one unit of A and five units of B. A is made of three units of C and four units of D. D is made of two units of E. The demand for Z is 500 units in Week 8 and 500 units in Week 10. For Z, A, C, and D, there are no units on hand, no safety stock, and no units allocated. Item E has 900 units on hand, with a safety stock of 300 units and no units allocated. Item B has 400 units on hand, 200 units of safety stock and 200 units already allocated. There are 200 units of Item C currently scheduled to arrive in Week 1 and 200 units of item D are scheduled to arrive in Week 1.
| Week | 6 | 7 | 8 | 9 | 10 |
| Demand | -- | -- | 500 | -- | 500 |
Additional information is the following:
| Item | Z | A | B | C | D | E |
| On hand | -- | -- | 400 | -- | -- | 900 |
| Safety stock | -- | -- | 200 | -- | -- | 300 |
| Allocated | -- | -- | 200 | -- | -- | -- |
| Scheduled Receipts | -- | -- | -- | 200 in Week 1 | 200 in Week 1 | -- |
Provide the additional number of all items, including Z, that are required to meet the total demand shown for Product Z. Ignore the timing of these requirements.
please use excel solver if applicable
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditors Guide To IT Auditing
Authors: Richard E. Cascarino
2nd Edition
1118147618, 978-1118147610
