Per unit differential cost | 12,000 Units | ||||||
Make | Buy | Make | Buy | ||||
Cost of purchasing | $ 21.0 | $ 252,000 | |||||
Direct materials | $ 4.0 | $ 48,000 | |||||
Direct labor | $ 6.0 | $ 72,000 | |||||
Variable manufacturing overhead | $ 2.0 | $ 24,000 | |||||
Fixed manufacturing overhead, Treacable | $ 3.5 | $ 42,000 | |||||
Fixed manufacturing overhead, Common | $ 8.0 | $ 96,000 | |||||
Total costs | $ 23.5 | $ 282,000 |
Excel Link
Per unit differential cost | 12,000 Units | ||||||
Make | Buy | Make | Buy | ||||
Cost of purchasing | =F12 | =F26*F14 | |||||
Direct materials | =G5 | =E27*F14 | |||||
Direct labor | =G6 | =E28*F14 | |||||
Variable manufacturing overhead | =G7 | =E29*F14 | |||||
Fixed manufacturing overhead, Treacable | =G8*(100%-F17) | =E30*F14 | |||||
Fixed manufacturing overhead, Common | =G9 | =E31*F14 | |||||
Total costs | =SUM(E27:E31) | =SUM(G27:G31) |
You can reach me over comment box if you have any doubts. Please
rate this answer
H . . HOME FILE INSERT PAGE LAYOUT Prepare a make or buy analysis - Excel...
Prepare a make or buy analysis. XUS Prepare a make or buy analysis - Excel ? - X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri -11-AA Paste B IU, L - A Alignment Number Conditional Format as Cell Cells Formatting* Table Styles - Clipboard Font El Styles A1 X for Alanco, Inc. manufactures a variety of products and is currently maunfacturing all A B C D E HI Alanco, Ind. manufactures a variety of products...
Can you post the answers as a formula? Prepare a make or buy analysis. ? X - Sign In FILE Prepare a make or buy analysis - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri -11 TA À B I U - - A - Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles Paste Cells Editing Clipboard A1 V : * fic of its own component parts. A B C D E F G Hн...
Complete the make-or-buy analysis. All answers must be inputted in the form of formulas. SS FILE HOME Prepare a make-or-buy analysis - Excel FORMULAS DATA REVIEW INSERT PAGE LAYOUT VIEW Sign In Paste B I Clipboard U. . - A - Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Fonts Alanco, Inc. manufactures a variety of products and is currently maunfacturing all Styles A1 5 6 Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead, direct...
D E 1 2 B Alanco, Ine. manufactures a variety of products and is currently maunfacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. To evaluate this offer, the following information has been gathered relating to the cost of producing the component internally: 4 S 9 Direct materials 4.00 Direct labor 6.00 7 Variable manufacturing overhead 2.00 Fixed manufacturing overhead, direct 5,00 Fixed manufacturing overhead, common but allocated 8.00...
MUST SHOW ALL CORRECT EXCEL FORMULAS Portfolio expected return - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Arial 12 -A A Paste BIU- A- % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing > Clipboard Font D14 v fx A B c D E F H K 3 You own a portfolio that has $2,650 invested in Stock A and $4,450 invested in Stock B. If the expected returns on...
? Dividend per Share - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Paste - A Cells Editing B IU- Font Alignment Number Conditional Format as Cell Formatting* Table Styles Styles Clipboard G A1 A B Suppose a firm has a retention ratio of 60 percent, net income of $36.5 million, and 215 million shares outstanding. What would be the dividend per share paid out on the firm's stock? (Round your answer to 2 decimal...
EXERCISE 12-3 Make or Buy a Component [LO3] Climate-Control, Inc., manufactures a variety of heating and air-conditioning units. The company is currently manufacturing all of its own component parts. An outside supplier has offered to sell a thermostat to Climate Control for $20 per unit. To evaluate this offer, Climate-Control, Inc., has gathered the following information relating to its own cost of producing the thermostat internally: Chapter 12 Per Unit 15,000 Units per Year $ 6 8 1 Direct materials...
? X XUS FILE HOME Arial - Sign In Calculating future values - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW -12 AA = % D D U 21 -A Alignment Number Conditional Format as CellCells Formatting Table Styles Font Styles x fe A Editing B I Clipboard D14 А в You are planning to make monthly deposits of $450 into a retirement account that pays 10 percent interest compounded monthly. If your first deposit will be made one month...
Exercise 11-3 Make or Buy Decision (LO11-3) Troy Engines, Ltd., manufactures a variety of engines for use in heavy equipment. The company has always produced all of the necessary parts for its engines, including all of the carburetors. An outside supplier has offered to sell one type of carburetor to Troy Engines, Ltd., for a cost of $30 per unit. To evaluate this offer, Troy Engines, Ltd., has gathered the following information relating to its own cost of producing the...
XES FILE HOME Calculating dividend yield and capital gains yield - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In % Arial - - 12 - A A Paste B IU B A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font D15 AB DE F G H The next dividend payment by Halestorm, Inc., will be $2.04 per share. The dividends are anticipated to maintain a growth rate of 4.5 percent forever....