PLEASE WRITE OUT THE FORMULAS IN EXCEL AND PLEASE EXPLAIN ALL THE STEPS

IIxpaond, Inporparahed utes wisthed$-$w wrape carting and har thag departments $-$ mairg and paciapine. The foll owing irfarmatian relates ba work in the moirg department far the month at July:

$\backslash$table$[[$Workin procese, tenininint$],[$Untr in procent,$39],[$Cempletion whth terpect is maherials,$504],[$Cempletian whth rerpect is pawwervist,$424],[$Coets in the berieniln irewhary.$],[$Maherialu cart,$310\mathrm{.}501],[$Cemaerdar cart,$34,79],[$Lrila itarted inta profucten durirn the parisd,$6\mathrm{.}200],[$Carts added ta probuctsen durirn the perise:$],[$Materiak ant,$3118,292],[$Cerumuion ast,$],[$Work in procem, ensing$],[$Untr in procers,$49],[$Cempletion whth terpect is maherials,$424],[$Cempletian whth rerpect is nawervisn,$35]]$

Requinnd:

Lue the tats $t=$ fll in the follswing intarration.

$[$Use calt MS ta $119$ Prom the glven linfarmatlon to camplete thin quettion.$)$

Compute equlalent anit.

$\backslash$table$[[\backslash$table$[[$Waing Department$],[$Coint per Iquvalent Unt$]]],[,$Macotals,Conurtion$],[$Urike tranderted to the next department,r$,],[$Cnding work in procent:$],[$Matwials$,$r$,],[$Cerumion$,$r$],[$tzulvalent unite at zratuctian,$],[2.$ Compute csuts.$],[\backslash$table$[[$Maing Department$],[$Coits per Iqulalent Unit$]]],[,$Masprals,Convertion.$],[$Cart ef bepinning wark in precent imuentory,sacon$^($r$),$$$4,000],[$Carts added dering the period,r$,],[$Tetal nart,T$,],[$Rolivalent unite at pratudten,$\backslash$bar $(=),\backslash$bar $((715)],[$Cant per equlvalent ant,sinr$,$sin$00]]$

Aatim cats

$\backslash$table$[[$Miarna Dwastrmant$],[$Corat of Kinding Work in Frocest inventery and the Units Trandfomed Dut$],[,$Macorals,Conversion,Total$],[$Tndinr work in proceut imentery:$],[$qulvalent units of prodaction,$\backslash$table$[[$r$],[$r$],[112,100,00]],4,790,],[$Ceet per egulvalert unlt,s$\backslash$int cos$00,],[$Ceat at ending wark in procest inwentary,$],[$Uribe parplebed and tranterened wut:$],[$Unts tanuterred ta the nest tepartnont:,r$,,],[$Ceat per egulvalert unit,r$,],[$Cout et aria tranthemed aut,r$,],[$A$.$ Prepare report.$],[$Maing Department$],[$Ceut Recenciliarlon$],[$Corts to be arcsantsd far:$],[$Cout at bepirring wark in praceet imertary,r$],[$Ceets adfed to poratactian turing the periad,r$],[$Toral couk ts be actsurted for,T$],[$Carts acrsunted for an fallowx:$],[$Coet et enting wark in proceut inwentary,r$],[$Ceut at arhe tranderned aut,r$,,],[$Total cont acrounted far,$=,,]]$