Question: Idk why I am getting answers wrong. Can somebody please help me. I will not forget thumbs up. Problem 8-13 (Algo) Shoney Video Concepts produces

Idk why I am getting answers wrong. Can somebody please help me. I will not forget thumbs up.
Idk why I am getting answers wrong. Can somebody
Idk why I am getting answers wrong. Can somebody
Idk why I am getting answers wrong. Can somebody
Problem 8-13 (Algo) Shoney Video Concepts produces a line of video streaming servers that are linked to computers for storing movies. These devices have very fast access and large storage capacity Shoney is trying to determine a production plan for the next 12 months. The main criterion for this plan is that the employment level is to be held constant over the period. Shoney is continuing in its R&D efforts to develop new applications and prefers not to prompt any adverse feelings from the local workforce. For the same reason, all employees should put in full workweeks, even if that is not the lowest-cost alternative. The forecast for the next 12 months is MONTH FORECAST DEMAND MONTH January July 130 February August March September FORECAST DEMAND April May June 530 730 830 530 330 230 October November December 130 230 630 730 800 Manufacturing cost is $210 per server, equally divided between materials and labor. Inventory storage cost is $4 per month. A shortage of servers results in lost sales and is estimated to cost an overall $20 per unit short. The Inventory on-hand at the beginning of the planning period is 210 units. Eight labor hours are required per DVD player. The workday is seven hours, Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 22 working days each month except July, when the plant closes down for three weeks' vacation (leaving seven working days). Assume that total production capacity is greater than or equal to total demand. (le.compute workforce level based on annual demand and annual capacity) (Leave the cells blank, whenever zero (O) is required. Indicate monthly shortages using a negative ending inventory level. Round up the "number of workers" to the next whole number and round down your "monthly production rates" to the next lower whole number.) Answer is complete but not entirely correct. March July October Novom 130 January 530 210 3743 543 April 530 0 630 February 730 543 374 302 3 830 O 374 456 May 330 0 374 4483 June 230 443 3742 1683 Forecast Beginning inventory Available production Ending Inventory Costs Lost sales Inventory Total August 130 160 3743 4043 2 September 230 404 374 548 188 102 160 3743 548 374 292 3 1563 0 2163 216 B . 6,0403 o 6,040 9,120 0 9.120 3.120 0 3.120 o 176 176 0 752 752 0 1.816 1616 6403 640 o 2,192 2. 192 @o O 1,168 1.168 12 19 t workforce. For simplicity, assume 22 working days each n (leaving seven working days). Assume that total production ce level based on annual demand and annual capacity). (Leave bges using a negative ending inventory level. Round up the "monthly production rates" to the next lower whole number.) Total 5,830 30 0 374 1156 May 330 0 374 44 OK Answer is complete but not entirely correct. Juno July August September October November December 230 130 130 230 630 730 800 44% 188 X 160 404 548 292 0X 3743 102 374 % 374 X 374 X 374 3 374 188 160 X 404 548 292 64 X 426 4,216 3 + + 0 0 > 0 > 0 120 0 120 0 176 176 0 7523 752 640 640 1,616 1,616 680 1,280 1.960 2,192 2,192 1,168 1,168 8,520 0 X 8,520 27,480 5,480 32.960

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!