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 plan correctly, your hiring, layoff, and inventory costs should match those given here. E: 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 = 250 Actual workers Actual production Layoffs Hiring Ending inventory 1,500 220 250 March 1,504 45120 250 1667 0 30 1663

Answer 1

Month	Forecasted sales	Sales in Worker Hours	Workers Needed to meet sales average=250	Actual worker 220	actual production	layoffs	hiring	ending inventory
		hrs per unit x Forecasted sales	sales in workers / hrs workers per month per worker		actual workers * hrs workers per month per hour / hrs per unit	0		starting inventory + actual production - Forcecasted sales
March	1,504	37,600 =25*1,504	188 =37,600/200	250	2000 =(250*200)/ 25	0	30	1,996 =1,500+2,000-1,504