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 productionplan, using the following information. The only costs you need to considerhere are layoff, hiring, and inventory costs. If you complete the plan

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

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 Accounting Questions!