Question: Consider the following partially completed sales and operations plan. Using the planning values and filled-in values as a guide, complete the plan and calculate the

Consider the following partially completed sales

Consider the following partially completed sales and operations plan. Using the planning values and filled-in values as a guide, complete the plan and calculate the layoff, hiring, and inventory costs. Click the icon to view the costs table. Click the icon to view the production plan table. Fill in the production plan table below (enter your responses rounded to the nearest whole number.) Month Forecasted sales Sales in worker hours Actual workers Workers needed to meet sales average = 44 40 Actual production Layoffs Hirings Ending inventory 46 1380 7 0 March April May 1200 1200 6,000 6,000 2.180 2360 40 46 1380 0 0 1320 6,600 44 46 1380 0 0 2420 June 1.230 6,150 41 46 1380 0 0 2570 July 1,470 7350 49 46 1380 0 0 2480 1.200 6000 40 46 1380 0 0 2660 August September 1.700 8500 57 35 1050 11 0 2010 October 1,320 6600 44 1050 0 0 1740 35 53 0 18 The hiring cost is $ 9000. (Enter your response as a whole number.) The layoff cost is $. (Enter your response as a whole number.) More info Layoff Hiring Inventory Totals Costs: Cost of plan: Planning values Starting inventory Starting and ending workforce: Hours worked per month per worker: Hours per unit: Hiring cost per worker: Layoff cost per worker: Monthly per-unit holding cost: 2.000 53 150 5 $500 $300 $1 1 More info Actual Month Forecasted sales Sales in worker hours Workers needed to meet sales average = 44 Actual production Hirings workers Layoffs Ending inventory 2,180 6.000 6,000 6.600 6,150 March April May June July August September October 0 0 0 0 0 0 0 0 0 1,230 1,470 1,200 1,700 1,320 0 0 0 18 53

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!