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)
Based on the information provided in the images Alanco Inc is considering whether to make or buy a component For such an analysis you want to look at ... 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
-
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....
-
Rachel loves to bake cookies, but she has an old oven that has trouble maintaining a constant temperature. If the acceptable temperature range for making the cookies is 350 plus or minus 5 degrees,...
-
(a) Find the total cost if the marginal cost is MC = Q + 5 and fixed costs are 20. (b) Find the total cost if the marginal cost is MC = 3e0.5Q and fixed costs are 10.
-
Plaintiff contracted to install a boiler for defendant. After plaintiff had installed and tested the boiler, but before final payment to plaintiff had been made, defendant took custody of the boiler...
-
You have $1,000,000 worth of equipment at the job site and wish to minimize your risk of direct property damage by taking out an insurance policy. The insurance company provides you with its...
-
Interest I, Shakira Wishes To Barrow 8230,000 Eroun A Bank To Buy A House. The But It Is Compounded Monthly. She Wants To Know What Ber Monthly Payment 4.8% Per Year In Order To Pay Off The Loan In...
-
Complete Form 941 for the 4th quarter for TCLH Industries (which is located at 202 Whitmore Avenue, Durham, NC 27701; Employer Identification #44-4444444). Assume that all necessary deposits were...
-
Leah graduated in July 2012 with a degree in Business majoring in Project Management. She accepted a job as a project coordinator for Housing New Zealand in the Building Maintenance Department. She...
-
The Child Tax Credit may be limited, reduced, or excluded entirely due to the phaseout. What is the reduction of the Child Tax Credit for taxpayers with modified adjusted gross income over the...
-
Why did the Gold Standard break down? If the Gold Standard would have survived, whatwould have been the impact to the rise of cryptocurrencies? In what ways could the IMFmanage cryptocurrencies?
-
Q1-Make A paragraph that discusses three root causes of academic dishonesty, and explain what the solution would be for each. What you think are three root causes of plagiarism and academic...
-
For this project, the constraint is that you only have 3 engineers available per day. Answer the 2 questions with Yes or No in the space provided. According to the diagram, is it possible to schedule...
-
On May 23, CanFood Inc. received an invoice dated May 21 for $8, 500 with payment terms 6/12, 2/20, n/40, ROG. The items specified on the invoice was received May 25. (a) When is the last day of the...
-
Fair value accounting The causes of the global financial crisis (GFC) that swept the world in 2008 and 2009 are complex and open to debate. However, some regard the practice of fair valuing assets as...
-
A bubble-point liquid feed is to be distilled as shown in Figure. Use the Edmister group method to estimate the mole-fraction compositions of the distillate and bottoms. Assume initial overhead and...
-
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...
-
You need to calculate the anticipated database capacity for constructing a database with four tables, is shown below: Table 1 will be initially loaded with 200,000 records, Table 2 with 100,000...
-
You are studying the design documentation for an extremely large information system used by your organization. As expected, all entities on the logical data model are in third normal form. But in...
-
In comparing operational databases and data warehouses, which generally has fewer CRUD activities? Why?
Study smarter with the SolutionInn App