Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
please show inserted formula for the yellow boxes! and also if possible correct rows and letters for easier read thank you! 1 1. Complete the
please show inserted formula for the yellow boxes!and also if possible correct rows and letters for easier read thank you! 1 1. Complete the make-or-buy analysis H. 7 - X 10 points Prepare a make-or-buy analysis Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW 02:16.05 Boterences B - Calib AA M Paste TU- - Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Cipart Font Styles AI Alanco, Ine manufactures a variety of products and is currently manfacturing all D E F G H 1 1 Alanco, Ing, manufactures a variety of products and is currently maunfacturing all of its own component parts 2 An outside supplier has offered to sell one of those components to Ala To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 Direct materials $ 4.00 Direct labor 6.00 Variable manufacturing overhead 2.00 Fixed manufacturing overhead, direct S.DO Fixed manufacturing overhead, common but allocated 800 $ 25.00 11 12 Supplier price S 21.00 13 10 Total cost 14 Units used per year 12.000 -- 5 X Prepare a make-or-buy analysis - Excel FORMULAS DATA REVIEW VIEW FILE Sign In PAGE LAYOUT HOME INSERT X Calon - 11 -A % 2:14.55 Cells Paste Editing BIU. - Alignment Number Conditional Format as Cell Formatting Table Styles Font Cipboard Book Styles A32 Total costs rences C B D F H 1 17 18 E G 16 "The fixed manufacturing overhead, direct Depreciation of equipment (no resale value) 30% Supervisor salary 70% 19 20 1. Assuming the company has no alternative use for the facilities now being used to produce the 21 component, complete the following analysis to determine if the outside supplier's offer should be accepted. 22 23 Per Unit Differential Cost Make Buy Total for 12.000 units Make Buy 24 25 26 Cost of purchasing 27 Direct materials 28 Direct labor 10
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c0bff70d56_719669c0bff1220f.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c0c0057110_719669c0bffe02d4.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669c0c00ee15d_720669c0c008f12a.jpg)
and also if possible correct rows and letters for easier read thank you!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started