Question: Please provide excel formulas or functions for the table. 3. The Thrifty Computer Company is trying to decide which of several lot-sizing procedures to use
Please provide excel formulas or functions for the table.
3. The Thrifty Computer Company is trying to decide which of several lot-sizing procedures to use for its MRP system. The following information pertains to one of the typical component parts: Setup cost = $120/order. Inventory holding cost $1.25/unit/week. Current inventory balance = 10 units. Week 1 2 3 4 5 6 7 8 Demand Forecast 65 320 35 256 110 25 85 3 Apply the EOQ, (only integer multiples of the EOQ can be ordered), POQ, and PPB lot-sizing cost based on the average inventory on hand at the end of each period. Assume orders are received into the beginning inventory
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
