Question

$75 $15 1 $20 Materials = Holding costs = Marginal cost of backorder = Hiring and training cost = Layoff costs = Straight time labor cost/hr. $250 $300 Beginning Workers Beginning inventory = Productive hours/worker/day = Paid straight hrs/day = Working days per month = Units per worker per month El ng Inventory goal (December) 110 2200 7.25 8 20 100 1000 $18 Question 8 1 pts Given the following production plan, use a level production strategy to compute the monthly production, ending inventory/(backlog), net requirements and required workforce levels. A worker can produce 100 units per month. Assume that the beginning inventory in January is 2200 units, and the firm desires to have 1000 units of inventory at the end of December. Month Jan Feb Mar Apr May Jun Demand 15,400 13,250 9.000 9,700 14,650 16,000 What is the amount of required workers for January through December? Jul 22,400 Aug 2 3,100 Sept 19,050 Oct 17.400 Nov Dec | 14,000 12,300 110 P Question 9 1 pts Given the following production plan, use a level production strategy to compute the monthly production, ending inventory (backlog), net requirements and required workforce levels. A worker can produce 75 units per month. Assume that the beginning inventory in January is 2200 units, and the firm desires to have 1000 units of inventory at the end of December. Apr Jun Month Jan Feb Mar Demand 15,400 13,250 9.000 1 22,400 Aug 23,100 Sept 19,050 Oct 17,400 Nov Dec 14.000 12,300 9,700 14,650 16,000 What will be the monthly production level? 15.500 15,000 o 11.000 4.500 P Question 10 1 pts Given the following production plan, use a level production strategy to compute the monthly production, ending inventory/(backlog), net requirements and required workforce levels. A worker can produce 100 units per month. Assume that the beginning inventory in January is 2200 units, and the firm desires to have 1000 units of inventory at the end of December. Month Jan Feb Mar Demand 15,400 13,250 9.000 Apr 9,700 May 14,650 Jun 16,000 Jul 22,400 Aug 23,100 Sept 19,050 Oct 17,400 Nov Dec 14.000 12,300 What is the ending inventory for September? -850 850 2,700 12.800

Answer 1

Below is the production schedule -

Month	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
Beginning Inventory	2200	2300	4550	11050	16850	17700	17200	10300	2700	-850	-2750	-1250
Demand	15400	13250	9000	9700	14650	16000	22400	23100	19050	17400	14000	12300	186250
Worker Required	155	155	155	155	155	155	155	155	155	155	155	155
Monthly Production	15500	15500	15500	15500	15500	15500	15500	15500	15500	15500	15500	15500
Ending Inventory	2300	4550	11050	16850	17700	17200	10300	2700	-850	-2750	-1250	1950

From above below is the answer to the question asked -

1) 155

2) 15500

3) -850

Below is the screenshot of the formula applied -