Question: please post all answers clearly. Problem 11-15 (Algo) Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year.
please post all answers clearly.
Problem 11-15 (Algo) Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost Order cost Annual holding cost Annual demand Average weekly demand VALUE 5 11.00 5297.00 338 of Item cost 26,600 532 per week PARAMETER Standard deviation of weekly demand Lead time Service probability VALUE 30 per week 2 week 981 a. Determine the order quantity and reorder point. (Use Excel's NORM.S.INVO function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number.) Optimal order quantity Reorder point units units b. Determine the annual holding and order costs. (Round intermediate calculations to 2 decimal places. Round your answers to 2 decimal places.) Holding cost Ordering cout units units c. Assume a price break of $60 per order was offered for purchase quantities of 2,000 or more units per order. If you took advantage of this price break, how much would you save annually? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Annual savings

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
