Question: Given the following information, formulate an inventory management system. The item is demanded 5 0 weeks a year. PARAMETERVALUEItem cost$ 1 2 . 0 0
Given the following information, formulate an inventory management system. The item is demanded weeks a year.
PARAMETERVALUEItem cost$ Order cost$ per orderAnnual holding costof item costAnnual demandunitsAverage weekly demandper weekStandard deviation of weekly demandunitsLead timeweekService probability
Determine the order quantity and reorder point.
Note: Use Excel's NORMSINV function to find the correct critical value for the given level. Do not round intermediate calculations. Round z value to decimal places and final answer to the nearest whole number.
Determine the annual holding and order costs.
Note: Do not round any intermediate calculations. Round your final answers to decimal places.
Assume a price break of $ per order was offered for purchase quantities of or more units per order. If you took advantage of this price break, how much would you save annually?
Note: Do not round any intermediate calculations including number of setups per year Round your final answer to decimal places.
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
