Q1)

Q2)

Q3)

Q4)

Please provide your answer with Excel or formula.

In order to answer the following questions, complete the CHASE production plan, using the following information. The only costs you need to consider here are production, layoff, hiring, and inventory costs. Information: Layoff Hiring Inventory Planning values Starting inventory: 1000 Starting and ending workforce: 227 Hours worked per month per worker: 160 Hours per unit: 20 Hiring cost per worker: $3,000 Layoff cost per worker: $2,000 Monthly per-unit holding cost: $6 Month Sales in Forecasted Worker Sales Hours Workers Needed to Meet Sales Actual Actual Layoffs Workers Production Hirings Ending Inventory March 1,592 April 1,400 May 1,200 June 1,000 July 1,504 August 1,992 September 2,504 October 2,504 November 3,000 December 3,000 January 2,504 February 1,992 How many actual workers should be employed in October for the Chase Plan? 94 210 313 423 What is the ending inventory after the first time period (January) for the Chase Plan? 1000 1500 2000 O 2500 What is the cost of hiring and layoff for the Chase Plan? $1,250,000 $1,500,000 $1,750,000 $2,000,000 What is the cost of the Chase Plan including only hiring and layoff costs, and inventory holding costs? $1,322,000 $2,542,000 $3,322,000 $4,230,000