PLEASE SOLVE USING EXCEL. THANK YOU. $14\mathrm{.}2.$ Bioway, Inc., a manufacturer of medical supplies, uses aggregate planning to set labor and inventory levels for the year. While a variety of items are produced, a standard kit composed of basic supplies is used for planning purposes. Demand varies with seasonal illnesses and the quarterly ordering policies of hospitals. The average worker at Bioway can produce $1000$ kits a month at a cost of $\backslash (\backslash$$ $9\backslash )$ per kit during regular production hours and $\backslash (\backslash$$ $10\backslash )$ a kit during overtime production. Completed kits can also be purchased from outside suppliers at $\backslash (\backslash$$ $12\backslash )$ each. Inventory carrying costs are $\backslash (\backslash$$ $2\backslash )$ per kit per month. Overtime is limited to regular production, but subcontracting is unlimited. Due to high$-$quality standards and extensive training, hiring and firing costs are $\backslash (\backslash$$ $1500\backslash )$ per worker. Bioway currently employs $25$ workers. Given the demand forecast below, develop a six$-$month aggregate production plan for Bioway using $($a$)$ chase demand and $($b$)$ a mixed strategy where the current workforce is kept for April through August, and supplemented with overtime and subcontracting as needed:$14\mathrm{.}2.$ Bioway, Inc., a manufacturer of medical supplies, uses aggregate

planning to set labor and inventory levels for the year. While a variety

of items are produced, a standard kit composed of basic supplies is

used for planning purposes. Demand varies with seasonal illnesses

and the quarterly ordering policies of hospitals. The average worker

at Bioway can produce $1000$ kits a month at a cost of $$9$ per kit during

regular production hours and $$10$ a kit during overtime production.

Completed kits can also be purchased from outside suppliers at $$12$

each. Inventory carrying costs are $$2$ per kit per month. Overtime is

limited to regular production, but subcontracting is unlimited. Due to

high$-$quality standards and extensive training, hiring and firing costs

are $$1500$ per worker. Bioway currently employs $25$ workers. Given

the demand forecast below, develop a six$-$month aggregate produc$-$

tion plan for Bioway using $($a$)$ chase demand and $($b$)$ a mixed strategy

where the current workforce is kept for April through August, and

supplemented with overtime and subcontracting as needed: