Please show the excel formulas. Al XJlAlanco, inc. manuractures a variety or pro

Question

Please show the excel formulas.

Al XJlAlanco, inc. manuractures a variety or proaucts ana is currentry maunracturng ail 4.00 6.00 2.00 5.00 Direct materias Direct labor 8 Fixed manufacturina overhead, traceable 9 Fixed manufacturing overhead, common but allocated Total cost 5 points 521.00 Supplier price 4 Units usad por yoar 6 Fixed manufacturing ovarhead, tracoable is composed of two itams 12,000 Dopreciation of aquipmant no resale valua Supervisoraary 30% 70% 47 Print 01. Assuming the company has no alternative use for the facil tes now baing used to produce the component,complets the following analysis to determine if the outside suppliar's offar should bo accopred 23 References Per Unit DiMerential C Make Make 2 Cost of purchasing 27 Diract material 2 Direct labor 0 Fxed manufacturing overhead, traceable Fixed manufacturing overhead, common 2 Total costs Basad on this analysis, write an if statement to determine if Alanco should make or buy the component ...Sheet1 10%

Explanation / Answer

Per unit 12000 units Make Buy Make Buy Cost of purchasing 21 252000 Direct materials 4 48000 Direct labor 6 72000 Variable manufacturing overhead 2 24000 Fixed manufacturing overhead,traceable 3.5 42000 Fixed manufacturing overhead,common 0 Total costs 186000 252000 Make the component

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.