YELLOW CELLS NEED FILLED. EXCEL FORMULAS ONLY - PLEASE DO NOT JUST GIVE NUMBERS, NEED EXCEL FORMULAS.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline A1 & & & fx & Alan & . manu & res a variety of p & products and is & ly maun & all & \\ \hline & A & B & c & D & E & F & G & H & 1 & \\ \hline 1 & Alanco, Ind & manufactu & es a variety of & oduct & is curre & naunfacturing al & I of its own com & t parts. & & \\ \hline 2 & An outside s & upplier has & offered to sell & e of t & compon & to Alanco. To ev & valuate this offe & llowing & & \\ \hline 3 & information & has been g & thered relating & o the & f produ & he component & internally: & & & \\ \hline 4 & & & & & & & & & & \\ \hline 5 & Direct mate & rials & & & & & 4.00 & & & \\ \hline 6 & Direct labor & & & & & & 6.00 & & & \\ \hline 7 & Variable ma & nufacturin & g overhead & & & & 2.00 & & & \\ \hline 8 & Fixed manu & facturing 0 & verhead, direct & & & & 5.00 & & & \\ \hline 9 & Fixed manu & facturing 0 & verhead, comm & n but & ted & & 8.00 & & & \\ \hline 10 & Total cost & & & & & & 25.00 & & & \\ \hline 11 & & & & & & & & & & \\ \hline 12 & Supplier pri & & & & & 21.00 & & & & \\ \hline 13 & & & & & & & & & & \\ \hline 14 & Units used & per year & & & & 12,000 & & & & \\ \hline 15 & & & & & & & & & & \\ \hline 16 & The fixed m & hanufactur & ng overhead, di & & & & & & & \\ \hline 17 & Depreci & ation of ec & uipment (no res & le val & & 30% & & & & \\ \hline 18 & Supervi & sor salary & & & & 70% & & & & \\ \hline 19 & & & & & & & & & & \\ \hline 201 & 1. Assuming & the compa & ny has no altern & tive u & the fac & now being used & to produce the & & & \\ \hline 21c & component, & complete & he following an & ysis to & rmine i & butside supplier & 's offer should b & pted. & & \\ \hline 22 & & & & & & & & & & \\ \hline 23 & & & & & Per Un & erential Cost & Total for 1 & units & & \\ \hline & & Sheet1 & & & & 1 & & & & \\ \hline \end{tabular}