Please answer in excel and show formulas. thank you. Assume you have developed and tested a prototype electronic product and are about to start your new business. You purchase pre$-$programmed computer chips at $$70$ per unit. Other component costs include: plastic casings at $$15$ per unit and assembly hardware at $$5$ per unit. Direct labor costs are $$15$ per hour and three units can be produced per hour. You intend to sell each unit at a $50$ percent mark$-$up over the total costs of producing each unit. The plan is to produce $500$ product units per month in January, February, and March. Sales are expected to be: $200$ units in January, $400$ units in February, and $800$ units in March.C$\mathrm{.}1$

Computer Chips $$70\mathrm{.}00$

Plastic casings $$15\mathrm{.}00$

Asembly Harware $$5\mathrm{.}00$

Direct Labor $$5\mathrm{.}00$

Total Costs $$95\mathrm{.}00$

Mark up

Sales Price

Sales January February March

No Units

Price per Unit

Sales

Total

C$\mathrm{.}2.$ Cost of Production schedule

Cost per Unit January February March Total

Production $-$ No of Units $500500500$

Production Costs

Computer Chips

Plastic Castings

Asembly Hardware

Direct Labor

Total Costs

C$3.$ COGS Schedule January February March Total

No of Units Sold

Sales

COGS

Gross Earning Total

C$4.$ Inventory January February March

Beg Finished Goods

Production

Materials

$+$ Direct Labor

Additions

Total $($Beg $+$ Additions$)$

Less Cost of Goods Sold

Ending Finished Goods