The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May February 1,600 June 2,200 2.200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers). Ending Period Month 0 December Demand Production Inventory Stockouts (Units) 200 1 January 1,400 1,775 2 February 1,600 1,775 3 March 1,800 1,775 4 April 1,800 1,775 5 May 2,200 1,775 6 June 2,200 1,775 7 July 1,800 1,775 8 August 1,400 1,775
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May February 1,600 June 2,200 2.200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August. In order to arrive at the costs, first compute the ending inventory and stockout units for each month by filling in the table below (enter your responses as whole numbers). Ending Period Month 0 December Demand Production Inventory Stockouts (Units) 200 1 January 1,400 1,775 2 February 1,600 1,775 3 March 1,800 1,775 4 April 1,800 1,775 5 May 2,200 1,775 6 June 2,200 1,775 7 July 1,800 1,775 8 August 1,400 1,775
Chapter19: Pricing Concepts
Section: Chapter Questions
Problem 6DRQ
Question
a) The average monthly demand requirement = ____units (round to nearest whole number.)
B) The total stockout cost = $____(nearest whole number)
C) The total inventory carrying cost = $____(nearest whole number)
D) The total cost, excluding normal time labor costs, is = $_____(nearest whole number)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps