$\backslash$table$[[$Month$,$Demand Forecast,Month,Demand Forecast$],[$January$,133,067,$July,$251,630],[$February$,155,026,$August,$249,630],[$March$,168,200,$September,$200,312],[$April$,173,890,$October,$160,830],[$May$,202,759,$November,$145,266],[$June$,260,842,$December,$128,900]]$

Regular production cost

Holding cost

Backorder cost

Beginning Inventory

Beginning workforce

Regular production rate

Hiring cost

Firing cost

$$48$ per unit

$$13$ per unit per month based on ending inventory

$$17\mathrm{.}00$ per unit per month based on ending inventory

$430,000$ units

$18$ employees

$9,600$ units per employee per month

$$14,000$ per worker

$$16,000$ per worker

Task $1$a

Develop a LEVEL PRODUCTION plan: Produce at a level rate using regular time production only. Backlogs are allowed in any month except December.

Ending inventory is allowed in any month. Ending inventory for December should be as low as possible.

Task $1b$

$2.$ Develop a CHASE PRODUCTION plan. Absorb variations in demand by changing the size of the workforce, When additional employees are hired or fired, they cannot be fractions of a person. You must round up to the next whole person. When you round up$,$ all those employees work the full month which could result in some inventory that is carried to the next period. Ending inventory should be as low as possible each month.

Task $2$

PLEASE DO THIS ON EXCEL TO MAKE AN AGGREGATE PLANING TASK TO COMPLETE THESE TASKS.