Complete a variance analysis for the BerkshireToy Case using the provided Excel template, ensuring all calculations are shown in designated cells and final answers are recorded on the third page. Indicate whether variances are favorable or unfavorable in the interpretation rows. VARIANCE ANALYSIS $-$ STAIRCASE APPROACH $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline COSTS & & Budget & Budget & Budget & Actual & Actual & Actual & Static Budget Variance $\backslash \backslash$

$\backslash$hline Direct Material & & Costs & Units p$.$ bear & Price per unit & Costs & Units $($total$)$ & Price per unit & $\backslash \backslash$

$\backslash$hline Acrylic fabric & $[$bolts$]$ & $\backslash$$$233,324$ & $0\mathrm{.}02381$ & $\backslash$$$35\mathrm{.}00$ & $\backslash$$$256,422$ & $7,910$ & $\backslash$$$32\mathrm{.}4174$ & $-\backslash$$$23,098\backslash \backslash$

$\backslash$hline Acrylic eyes & $[$eyes$]$ & $\backslash$$$106,400$ & $2\mathrm{.}00$ & $\backslash$$$0\mathrm{.}19$ & $\backslash$$$125,637$ & $661,248$ & $\backslash$$$0\mathrm{.}19$ & $-\backslash$$$19,237\backslash \backslash$

$\backslash$hline Plastic joints & $[$joints$]$ & $\backslash$$$196,000$ & $5\mathrm{.}00$ & $\backslash$$$0\mathrm{.}14$ & $\backslash$$$246,002$ & $1,937,023$ & $\backslash$$$0\mathrm{.}13$ & $-\backslash$$$50,002\backslash \backslash$

$\backslash$hline Polyester filling & $[$pounds$]$ & $\backslash$$$365,400$ & $0\mathrm{.}90$ & $\backslash$$$1\mathrm{.}45$ & $\backslash$$$450,856$ & $344,165$ & $\backslash$$$1\mathrm{.}31$ & $-\backslash$$$85,456\backslash \backslash$

$\backslash$hline Woven label & $[$labels$]$ & $\backslash$$$14,000$ & $1\mathrm{.}00$ & $\backslash$$$0\mathrm{.}05$ & $\backslash$$$16,422$ & $328,447$ & $\backslash$$$0\mathrm{.}05$ & $-\backslash$$$2,422\backslash \backslash$

$\backslash$hline Designer box & $[$boxes$]$ & $\backslash$$$67,200$ & $1\mathrm{.}00$ & $\backslash$$$0\mathrm{.}24$ & $\backslash$$$69,488$ & $315,854$ & $\backslash$$$0\mathrm{.}22$ & $-\backslash$$$2,288\backslash \backslash$

$\backslash$hline Accessories & $[$bears$]$ & $\backslash$$$33,600$ & $1\mathrm{.}00$ & $\backslash$$$0\mathrm{.}12$ & $\backslash$$$66,013$ & $325,556$ & $\backslash$$$0\mathrm{.}20$ & $-\backslash$$$32,413\backslash \backslash$

$\backslash$hline Direct Material Costs & & $\backslash$$$1,015,924$ & & & $\backslash$$$1,230,840$ & & & $-\backslash$$$214,916\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline Direct Labor & & Costs & Hours p$.$ bear & Price per hour & Costs & Hours $($total$)$ & Price per hour & $\backslash \backslash$

$\backslash$hline Sewing & $[$l$-$hours$]$ & $\backslash$$$1,120,000$ & $0\mathrm{.}50$ & $\backslash$$$8\mathrm{.}00$ & $\backslash$$$1,545,854$ & $189,211$ & $\backslash$$$8\mathrm{.}17$ & $-\backslash$$$425,854\backslash \backslash$

$\backslash$hline Stuffing and cutting & $[$l$-$hours$]$ & $\backslash$$$672,000$ & $0\mathrm{.}30$ & $\backslash$$$8\mathrm{.}00$ & $\backslash$$$850,636$ & $104,117$ & $\backslash$$$8\mathrm{.}17$ & $-\backslash$$$178,636\backslash \backslash$

$\backslash$hline Assembly & $[[-$hours$]$ & $\backslash$$$672,000$ & $0\mathrm{.}30$ & $\backslash$$$8\mathrm{.}00$ & $\backslash$$$989,011$ & $121,054$ & $\backslash$$$8\mathrm{.}17$ & $-\backslash$$$317,011\backslash \backslash$

$\backslash$hline Dressing and packing & $[[-$hours$]$ & $\backslash$$$224,000$ & $0\mathrm{.}10$ & $\backslash$$$8\mathrm{.}00$ & $\backslash$$$282,805$ & $34,615$ & $\backslash$$$8\mathrm{.}17$ & $-\backslash$$$58,805\backslash \backslash$

$\backslash$hline Direct Labor Costs & & $\backslash$$$2,688,000$ & $1\mathrm{.}20$ & $\backslash$$$8\mathrm{.}00$ & $\backslash$$$3,668,305$ & $448,997$ & $\backslash$$$8\mathrm{.}17$ & $-\backslash$$$980,305\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline Total Direct Costs & & $\backslash$$$3,703,924$ & & & $\backslash$$$4,899,145$ & & & $-\backslash$$$1,195,221\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & $\backslash \backslash$

$\backslash$hline Other & & Costs & Hours p$.$ bear & Rate per hour & Costs & Hours $($total$)$ & Rate per hour & $\backslash \backslash$

$\backslash$hline Variable overhead & $[[-$hours$]$ & $\backslash$$$1,046,304$ & $1\mathrm{.}20$ & $\backslash$$$3\mathrm{.}11$ & $\backslash$$$1,725,665$ & $448,997$ & $\backslash$$$3\mathrm{.}84$ & $-\backslash$$$679,361\backslash \backslash$

$\backslash$hline Fixed overhead & & $\backslash$$$661,920$ & n$/$a & n$/$a & $\backslash$$$658,897$ & n$/$a & n$/$a & $\backslash$$$3,023\backslash \backslash$

$\backslash$hline Variable selling & & $\backslash$$$1,218,280$ & & & $\backslash$$$1,859,594$ & & & $-\backslash$$$641,314\backslash \backslash$

$\backslash$hline Fixed selling & & $\backslash$$$4,463,000$ & n$/$a & n$/$a & $\backslash$$$5,023,192$ & n$/$a & n$/$a & $-\backslash$$$560,192\backslash \backslash$

$\backslash$hline Administrative expenses & & $\backslash$$$1,124,000$ & & & $\backslash$$$1,123,739$ & & & $\backslash$$$261\backslash \backslash$

$\backslash$hline Total Other Costs & & $\backslash$$$8,513,504$ & & & $\backslash$$$10,391,087$ & & & $-\backslash$$$1,877,583\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$