Question: Complete the level production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you

Complete the level production plan, using theComplete the level production plan, using theComplete the level production plan, using the

Complete the level production plan, using the following information. The only costs you need to consider here are layoff, hiring, and inventory costs. If you complete the plan correctly, your hiring, layoff, and inventory costs should match those given here. Click the icon to view the costs table. Click the icon to view the forecasted sales. Fill in the production plan table below (enter your responses rounded to the nearest whole number). Month Layoff 3 $3,000 Hiring 3 $6,000 $123,730 Inventory 57,365 $114,730 March April May June July August September October November December January February Forecasted sales 1,530 1,368 1,218 1,099 1,530 2,029 2,567 2,525 2,997 2,918 2,563 2,172 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 3,000 224 270 30 $2,000 $1,000 $2 Month Forecasted sales Sales in worker hours Workers needed to meet sales average = 227 Actual Actual workers production Layoffs Hiring Ending inventory 224 3,000 March 1,530 45900 170 Sales in WH 30 45900 Ending inv. 3000 3513 1530 3 30 41040 0 3675 3825 30 36540 0 1368 1218 1099 1530 3000 3000 3000 30 32970 0 3944 30 45900 0 3513 Actual workers Sales average Actual Production Layoffs Hiring 270 170 227 2043 0 270 152 227 2043 0 270 135 227 2043 0 270 122 227 2043 0 270 170 227 2043 0 270 225 227 2043 0 270 285 227 2043 0 270 281 227 2043 0 270 333 227 2043 0 270 324 227 2043 0 270 285 227 2043 0 270 241 227 2043 0 2029 30 60870 0 March April May June July August September October November December January February 3000 3000 3000 3014 2567 30 77010 0 2476 2525 30 75750 0 3000 3000 2997 30 0 30 0 2918 2563 89910 87540 76890 65160 3000 3000 2518 2046 2125 2480 2871 30 0 2172 30 0 3000 3 3 0

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!