Prepare a make or buy analysis. 6.. FILE Paste Clipboard A1 De 10 11 HOME ...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare a make or buy analysis. 6.ले. FILE Paste Clipboard A1 De 10 11 HOME Б 12 Calibri INSERT 12 Supplier price 13 14 7 Font 11 X Units used per year PAGE LAYOUT % BIU - A Alignment Number Conditional Format as 7 A A Prepare a make or buy analysis - Excel FORMULAS REVIEW ||0| 5 Direct materials 6 Direct labor 7 Variable manufacturing overhead 8 Fixed manufacturing overhead, traceable* 9 Fixed manufacturing overhead, common but allocated Total cost DATA A B C D G F E 1 Alanco, Inc. 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 Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 $ Cell Cells Formatting Table Styles - Styles ✓ fx Alanco, Inc. manufactures a variety of products and is currently maunfacturing all 21.00 12,000 VIEW $ $ M Editing 4.00 6.00 2.00 5.00 8.00 25.00 H - Sign In I X A A1 23 A 1 B E ▸ X IND C fx Depreciation of equipment (no resale value) Supervisor salary 24 25 26 Cost of purchasing 27 Direct materials 28 Direct labor 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common Alanco should Alanco, Inc. manufactures a variety of products and is currently maunfacturing all ✓ 15 16 *Fixed manufacturing overhead, traceable is composed of two items: 17 18 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 Sheet1 D E F 30% 70% Per Unit Differential Cost Make Buy the component G 32 Total costs 33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 37 12,000 units H Make Buy I Prepare a make or buy analysis. 6.ले. FILE Paste Clipboard A1 De 10 11 HOME Б 12 Calibri INSERT 12 Supplier price 13 14 7 Font 11 X Units used per year PAGE LAYOUT % BIU - A Alignment Number Conditional Format as 7 A A Prepare a make or buy analysis - Excel FORMULAS REVIEW ||0| 5 Direct materials 6 Direct labor 7 Variable manufacturing overhead 8 Fixed manufacturing overhead, traceable* 9 Fixed manufacturing overhead, common but allocated Total cost DATA A B C D G F E 1 Alanco, Inc. 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 Alanco. To evaluate this offer, the following 3 information has been gathered relating to the cost of producing the component internally: 4 $ Cell Cells Formatting Table Styles - Styles ✓ fx Alanco, Inc. manufactures a variety of products and is currently maunfacturing all 21.00 12,000 VIEW $ $ M Editing 4.00 6.00 2.00 5.00 8.00 25.00 H - Sign In I X A A1 23 A 1 B E ▸ X IND C fx Depreciation of equipment (no resale value) Supervisor salary 24 25 26 Cost of purchasing 27 Direct materials 28 Direct labor 29 Variable manufacturing overhead 30 Fixed manufacturing overhead, traceable 31 Fixed manufacturing overhead, common Alanco should Alanco, Inc. manufactures a variety of products and is currently maunfacturing all ✓ 15 16 *Fixed manufacturing overhead, traceable is composed of two items: 17 18 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 Sheet1 D E F 30% 70% Per Unit Differential Cost Make Buy the component G 32 Total costs 33 34 Based on this analysis, write an if statement to determine if Alanco should make or buy the component. 35 36 37 12,000 units H Make Buy I
Expert Answer:
Answer rating: 100% (QA)
To perform a make or buy analysis for the component being considered by Alanco we need to compare th... View the full answer
Related Book For
Managerial Statistics
ISBN: 9780534389314
1st Edition
Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe
Posted Date:
Students also viewed these accounting questions
-
CITY OF SNOHOMISH DISCUSSION OF AUDITOR'S REPORT ON COMPLIANCE WITH LAWS AND REGULATIONS DRAFTED BY STAFF ACCOUNTANT The auditor's separate report on compliance with laws and regulations that was...
-
1. Consider the function 2xy (x, y) + (0,0) f(x,y)%3D (x,y) 3D(0,0) (a) Use a computer to draw a contour diagram for f. Which of the following is the contour diagram? figure 1 figure 2 figure 3 ...
-
Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The...
-
Patients who undergo chronic hemodialysis often experience severe anxiety. Videotapes of progressive relaxation exercises were shown to one group of patients and neutral videotapes to another group....
-
How useful are these prescriptive models if a leader does not know the answers to some of the situational questions?
-
Erkens Company uses a job costing system with normal costing and applies factory overhead on the basis of machine-hours. At the beginning of the year, management estimated that the company would...
-
Interest rates have increased since a company issued its bonds. Why would the company want to refund the bonds with another issue of bonds paying a higher rate?
-
The adjusted trial balance for Chiara Company as of December 31, 2013, follows. Required 1. Use the information in the adjusted trial balance to prepare (a) The income statement for the year ended...
-
As part of the final testing phase, just prior to releasing a new payroll system, the project manager at Nexus Ltd Company discovered that the bought payroll system was performing the following...
-
Diamant Foods Company produces a variety of food products, including a line of candies. One of its most popular candy items is Divine Diamonds, a bag of a dozen individually wrapped diamond-shaped...
-
The Marigold Division operates as a profit center. It reportsthe following for the year ending December 31, 2022.BudgetedActualSales$1,880,000$1,776,600Variable costs752,000714, 2 answers
-
In some stem-and-leaf displays with one or two unusually low values, the first stem is often written as LOW, with the complete values in the leaf section. Why and when might we do this?
-
If a sampling plan used a sample size of n = 100 for batches of N = 1,000 units with a 58.3% chance of accepting batches that have an actual proportion defective of p = 10%, what AOQ would result...
-
Do shallow waves propagate at the same speed in all fluids? Explain why or why not.
-
In addition to comparing the reaction times as a function of rotation, how else might you use these data to draw conclusions about how people process information?
-
Samples of five cans are to be selected periodically from a canning process that has a standard deviation (o) of 0.2 ounces when in control. What will the standard devia- tion in the sampling...
-
PLEASE RESPOND TO THE DISCUSSION POST WITH REFERENCES AND CITATIONS. THANKS Interpersonal communication is valuable to maintain patient-provider relationships and positive forces in the workplace....
-
Identify Thank You mission, strategy and core competencies. Identify strategy changes that have taken place at Thank You since its founding in 2008. Your answer must in text references and must be...
-
Five hundred households in a middle-class neighborhood were recently surveyed as part of an economic development study conducted by the local government. The data are in the file P4_4.XLS. Identify...
-
Consider again the one-way ANOVA hypothesis test described in Problem 11. Suppose that we are interested in comparing the mean sales achieved by salespeople with varying compensation schemes. In...
-
The file P3_59.XLS contains the proportion of annual revenue spent on research and development (R&D) activities for each of 200 randomly selected high-technology firms. Characterize this distribution...
-
Decentralization and Transfer Pricing The city of Medina Park operates a plumbing and electrical maintenance department, responsible for maintaining all water and electric service functions in...
-
Transfer Pricing The Leviathan Steel Company has a coal-mining subsidiary in West Virginia. A substantial amount of the coal produced by the subsidiary is used by Leviathan's steel foundries located...
-
Sarah Jones, the manager of the Teen Division of Eve Clothing Company, was evaluating the acquisition of a new embroidery machine. The budgeted operating income of the Teen Division was \(\$...
Study smarter with the SolutionInn App