Question: Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. a. Determine the order quantity and reorder point.
Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. a. Determine the order quantity and reorder point. Note: Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round " z " value to 2 decimal places and final answer to the nearest whole number. b. Determine the annual holding and order costs. Note: Do not round any intermediate calculations. Round your final answers to 2 decimal places. c. Assume a price break of $60 per order was offered for purchase quantities of 2,300 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 2 decimal places. Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. a. Determine the order quantity and reorder point. Note: Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round " z " value to 2 decimal places and final answer to the nearest whole number. b. Determine the annual holding and order costs. Note: Do not round any intermediate calculations. Round your final answers to 2 decimal places. c. Assume a price break of $60 per order was offered for purchase quantities of 2,300 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 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
