Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please answer all parts with detailed explanation else downvote. x Answer is complete but not entirely correct. January February March April May June July August
Please answer all parts with detailed explanation else downvote.
x Answer is complete but not entirely correct. January February March April May June July August September October Novemb Forecast 520 720 820 520 320 220 120 120 220 620 7 Beginning inventory 230 189 X OV OV 159 X 418 X 465 X 824 X 1,083 X 9 Available production 290 X 479 X 479 X 479 X 479 X 479 X 167 X 479 X 479 X 479 X 4 Ending inventory 189 X -52 X -341 X 41 X 159 X 418 X 465 X 824 X 1,083 X 942 X 6 Costs Lost sales 1,300 X 8,525 X 1,025 X OV OV OV OV Inventory 945 X 795 X 2,090 X 2,325 X 4,200 X 5,415 X 4,710 X 3,4 Total 945 1,300 8,525 1,025 795 2,090 2,325 4,200 5,415 4,710 3,4x Answer is complete but not entirely correct. May June July August September October November December Total 320 220 120 120 220 620 720 820 5,740 OV 159 X 418 X 465 X 824 X 1,083 X 936 X 694 X 479 X 479 X 167 X 479 X 479 X 479 X 478 X 478 X 5,424 X 159 X 418 X 465 X 824 X 1,083 X 942 X 694 X 352 X OV OV 10,950 X 795 X 2,090 X 2,325 X 4,200 X 5,415 X 4,710 X 3,470 X 1,760 X 25,520 X 795 2,090 2,325 4,200 5,415 4,710 3,470 1,760 36,470Problem 8-13 (Algo) Shoney Video Concepts produces a line of video streaming sewers 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 FORECAST DEMAND January 520 July 120 February 720 August 120 March 820 September 220 April 520 October 620 May 320 November 720 June 220 December 820 Manufacturing cost is $230 per server, equally divided between materials and labor. Inventory storage cost is $5 per month. A shortage of servers results in lost sales and is estimated to cost an overall $25 per unit short. The inventory onhand at the beginning of the planning period is 230 units. Ten labor hours are required per DVD player. The workday is eight hours. Develop an aggregate production schedule for the year using a constant workforce. For simplicity, assume 23 working days each month except July, when the plant closes down for three weeks' vacation (leaving eight working days). Assume that total production capacity is greater than or equal to total demand. (i.e., compute workforce level based on annual demand and annual capacity). (Leave the cells blank, whenever zero (0) 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.) Return toStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started