Question: Given the following information, formulate an inventory management system. The item is demanded 5 0 weeks a year. a . Determine the order quantity and
Given the following information, formulate an inventory management system. The item is demanded weeks a year.
a Determine the order quantity and reorder point.
Note: Use Excel's NORM.SINV function to find the value. Round value to decimal places and final answer to the nearest
whole number.
Optimal order quantity
b Determine the annual holding and order costs.
Note: Round intermediate calculations to decimal places. Round your answers to decimal places.
c 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 intermediate calculations. Round your answer to decimal places.
Annual savings
Given the following information, formulate an inventory management system. The item is demanded weeks a year.
a Determine the order quantity and reorder point.
Note: Use Excel's NORM.SINV function to find the value. Round value to decimal places and final answer to the nearest
whole number.
b Determine the annual holding and order costs.
Note: Round intermediate calculations to decimal places. Round your answers 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
