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



Please provide the answer with Microsoft Excel.
Complete the chase 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 as whole numbers). Month Forecasted sales Sales in worker hours to meet sales average = 249 Actual workers Actual production Layoffs Hiring Ending inventory 211 3,000 March 1,464 Layoff Hiring 222 222 $555,000 $1,110,000 $1,701,000 Inventory 36,000 $36,000 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 211 80 10 $5,000 $2,500 $1 Month March April May June July August September October November December January February Forecasted sales 1,464 1,304 1,160 1,176 1,792 1,920 2,368 2,568 2,936 2,888 2,400 1,896 Complete the chase 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 as whole numbers). Month Forecasted sales Sales in worker hours to meet sales average = 249 Actual workers Actual production Layoffs Hiring Ending inventory 211 3,000 March 1,464 Layoff Hiring 222 222 $555,000 $1,110,000 $1,701,000 Inventory 36,000 $36,000 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 211 80 10 $5,000 $2,500 $1 Month March April May June July August September October November December January February Forecasted sales 1,464 1,304 1,160 1,176 1,792 1,920 2,368 2,568 2,936 2,888 2,400 1,896
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
