Question: Please provide the answer with Microsoft Excel. Complete the level production plan, using the following information. The only costs you need to consider here are

Please provide the answer with Microsoft Excel.Please provide the answer with Microsoft Excel.

Please provide the answer with Microsoft Excel.

Please provide the answer with Microsoft Excel.

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 Forecasted sales Sales in worker hours Workers needed to meet sales average = 226 Actual workers Actual production Layoffs Hiring Ending inventory 178 1,500 March 1,676 Layoff 48 $168,000 Hiring 48 $240,000 $600,380 Inventory 38,476 $192,380 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 1,500 178 270 30 $5,000 $3,500 $5 Month March April May June July August September October November December January February Forecasted sales 1,676 1,312 1,255 1,098 1,420 1,979 2,600 2,495 3,003 2,911 2,508 2,151

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!