here are better pictures

Problem 13-6 (Algo) Jokers wild makes playing cards in several different styles, but a standard" deck of cards is used for planning purposes. The average worker at JokersRWild can make 10,000 sets of decks of cards per month at a cost of $2.80 per deck during regular production and $3.10 during overtime. The company currently employs 30 workers. Experience shows that it costs $1,400 to hire a worker and $1,400 to fire a worker, Inventory carrying cost is $.43 per deck per month. The beginning inventory is 42,000, and at least that amount is desired each month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. Month Demand January 200,000 February 180,000 March 200,000 April 470,000 May 480,000 June 690,000 Click here for the Excel Dato File a. Given the above demand estimate, develop a six-month production plan based on level production (Leave no cells blank.be certain to enter "0" wherever required.) + Larul Production Plan Month Demand Regular Production Ending Inventory Number of Workers Hira Fire layoff January February March April May June Total 0 0 0 b. Determine the cost of the level production plan. Total cos! c. Develop a six-month production plan based on chase by using overtime (no workers will be fired and inventory increases if necessary) (Leave no cells blank - be certain to enter "0" wherever required.) Overtime Inventory Number of Workers Hire Fire layoff Chase Production Plan-Using Overtimo Regular Month Demand Production January February March April May June Total 0 0 0 0 d. Determine the cost of the chase production plan. Te test e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hiro Fire Inyoff Chase Production Plan - Changing Workforce Level Month Demand Regular Ending Production Inventory January February March April May June Total 0 0 0 e. Develop a six-month production plan based on chase by changing workforce level (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hire Fire layoff Chase Production Plan - Changing Workforce Level Regular Ending Month Demand Production Inventory January February March April May June Total 0 0 0 f. Determine the cost of the chase production plan by changing workforce level. Tot cost Problem 13-6 (Algo) Jokerswild makes playing cards in several different styles, but a standard" deck of cards is used for planning purposes. The average worker at Jokers Wild can make 10,000 sets of decks of cards per month at a cost of $2.80 per deck during regular production and $310 during overtime. The company currently employs 30 workers. Experience shows that it costs $1,400 to hire a worker and $1,400 to fire a worker Inventory carrying cost is $.43 per deck per month The beginning inventory is 42,000, and at least that amount is desired each month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. March Month Demand Tebruary 180,000 April 470.000 May 480,000 June 690,000 200,000 200,000 Click here for the Excel Data File a. Given the above demand estimate, develop a six-month production plan based on level production (Leave no cells blank - be certain to enter "o" wherever required.) Level Production Plan Month Demand Regular Production Ending Inventory Number of Workers Hire Fire layoff January February March April May June Total 0 0 0 b. Determine the cost of the level production plan. Total CODE c. Develop a six-month production plan based on chase by using overtime (no workers will be fired and inventory increases if necessary). (Leave no cells blank - be certain to enter "o" wherever required.) Chase Production Plan - Using Overtime Regular Month Demand Production Inventory Number of Workers Hire Overtime Fire layoff January February March April May June Total 0 0 0 0 0 0 d. Determine the cost of the chase production plan. Total cost e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hiro Fire layoff Chase Production Plan - Changing Workforce Level Regular Ending Month Demand Production Inventory January February March April May June Total 0 0 0 0 CH e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hiro Fire layoff Chase Production Plan - Changing Workforce Level Regular Ending Month Demand Production Inventory January February March April May June Total 0 0 0 0 f. Determine the cost of the chase production plan by changing workforce level. Total Problem 13-6 (Algo) Jokers wild makes playing cards in several different styles, but a standard" deck of cards is used for planning purposes. The average worker at JokersRWild can make 10,000 sets of decks of cards per month at a cost of $2.80 per deck during regular production and $3.10 during overtime. The company currently employs 30 workers. Experience shows that it costs $1,400 to hire a worker and $1,400 to fire a worker, Inventory carrying cost is $.43 per deck per month. The beginning inventory is 42,000, and at least that amount is desired each month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. Month Demand January 200,000 February 180,000 March 200,000 April 470,000 May 480,000 June 690,000 Click here for the Excel Dato File a. Given the above demand estimate, develop a six-month production plan based on level production (Leave no cells blank.be certain to enter "0" wherever required.) + Larul Production Plan Month Demand Regular Production Ending Inventory Number of Workers Hira Fire layoff January February March April May June Total 0 0 0 b. Determine the cost of the level production plan. Total cos! c. Develop a six-month production plan based on chase by using overtime (no workers will be fired and inventory increases if necessary) (Leave no cells blank - be certain to enter "0" wherever required.) Overtime Inventory Number of Workers Hire Fire layoff Chase Production Plan-Using Overtimo Regular Month Demand Production January February March April May June Total 0 0 0 0 d. Determine the cost of the chase production plan. Te test e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hiro Fire Inyoff Chase Production Plan - Changing Workforce Level Month Demand Regular Ending Production Inventory January February March April May June Total 0 0 0 e. Develop a six-month production plan based on chase by changing workforce level (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hire Fire layoff Chase Production Plan - Changing Workforce Level Regular Ending Month Demand Production Inventory January February March April May June Total 0 0 0 f. Determine the cost of the chase production plan by changing workforce level. Tot cost Problem 13-6 (Algo) Jokerswild makes playing cards in several different styles, but a standard" deck of cards is used for planning purposes. The average worker at Jokers Wild can make 10,000 sets of decks of cards per month at a cost of $2.80 per deck during regular production and $310 during overtime. The company currently employs 30 workers. Experience shows that it costs $1,400 to hire a worker and $1,400 to fire a worker Inventory carrying cost is $.43 per deck per month The beginning inventory is 42,000, and at least that amount is desired each month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. March Month Demand Tebruary 180,000 April 470.000 May 480,000 June 690,000 200,000 200,000 Click here for the Excel Data File a. Given the above demand estimate, develop a six-month production plan based on level production (Leave no cells blank - be certain to enter "o" wherever required.) Level Production Plan Month Demand Regular Production Ending Inventory Number of Workers Hire Fire layoff January February March April May June Total 0 0 0 b. Determine the cost of the level production plan. Total CODE c. Develop a six-month production plan based on chase by using overtime (no workers will be fired and inventory increases if necessary). (Leave no cells blank - be certain to enter "o" wherever required.) Chase Production Plan - Using Overtime Regular Month Demand Production Inventory Number of Workers Hire Overtime Fire layoff January February March April May June Total 0 0 0 0 0 0 d. Determine the cost of the chase production plan. Total cost e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hiro Fire layoff Chase Production Plan - Changing Workforce Level Regular Ending Month Demand Production Inventory January February March April May June Total 0 0 0 0 CH e. Develop a six-month production plan based on chase by changing workforce level. (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Hiro Fire layoff Chase Production Plan - Changing Workforce Level Regular Ending Month Demand Production Inventory January February March April May June Total 0 0 0 0 f. Determine the cost of the chase production plan by changing workforce level. Total