Instructions Enter your name and Access ID ('aa1234' format) in the cells above. The data required...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Instructions Enter your name and Access ID ('aa1234' format) in the cells above. The data required for this case will not appear until you do so. You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed to provide those components to Zoom, and quoted prices (including shipping) for their delivery. Your task is to determine which, if any, of these proposals should be accepted. Prepare a make vs. buy incremental analysis for each possible course of action in an Excel worksheet. Your grade will be based on the correctness of your answers, as well as the use of Excel. That is, where possible, you should use formulas to get your answers, rather than keyed-in values. See your instructor for help with Excel basics if you need it. In a Word document, prepare a memo stating which of the proposals you suggest accepting, as well as the basis for your conclusions. Also identify any nonfinancial factors you should consider before accepting any of the outsourcing proposals. Attach both files to the Canvas assignment space by the due date of November 6th >> Below is cost data for Zoom's production of wheels, seats, and calipers. Outside suppliers have offered to provide wheels for $6.96, seats for $7.82, and calipers for $2.56 per piece. Both wheels and seats are branded with the Zoom logo, and that logo will need to be added at the Zoom factory at a cost of $0.50 each for any of these components that are outsourced. For all three components, 75% of the fixed costs are avoidable, and will be eliminated if the component's production is outsourced. In addition, seats and calipers are both produced out of the same small factory space. If both seats and calipers were outsourced, Zoom could lease the space out and increase net income by $6,000 per year, while eliminating all fixed costs for the two components. Cost category Direct materials Direct labor Variable overhead Fixed overhead Total cost Units produced Cost per unit Wheels $141,000 94,000 21,000 59,800 $315,800 40,000 $7.90 Seats $53,000 73,000 14,000 40,200 $180,200 20,000 $9.01 Calipers $90,500 41,500 16,000 29,600 $177,600 80,000 $2.22 Hints: Prepare incremental analyses for each component separately. Make wheels vs. buy wheels, etc. Since there are additional implications to outsourcing both seats and calipers, do a make vs. buy analysis assuming both are outsourced. A correct solution, then, will likely have at least four incremental analyses. You may use the second tab of this workbook to prepare your solutions, or create a new file. Since you will be attaching this file to the Canvas assignment page, there are no file naming conventions you need to observe. Instructions Enter your name and Access ID ('aa1234' format) in the cells above. The data required for this case will not appear until you do so. You are a financial manager for Zoom Corp., which manufactures bicycles. In the most recent fiscal year, Zoom manufactured and sold 20,000 bicycles. Wheels, seats, and brake calipers are three components of the bicycles currently manufactured by Zoom. Three different vendors have proposed to provide those components to Zoom, and quoted prices (including shipping) for their delivery. Your task is to determine which, if any, of these proposals should be accepted. Prepare a make vs. buy incremental analysis for each possible course of action in an Excel worksheet. Your grade will be based on the correctness of your answers, as well as the use of Excel. That is, where possible, you should use formulas to get your answers, rather than keyed-in values. See your instructor for help with Excel basics if you need it. In a Word document, prepare a memo stating which of the proposals you suggest accepting, as well as the basis for your conclusions. Also identify any nonfinancial factors you should consider before accepting any of the outsourcing proposals. Attach both files to the Canvas assignment space by the due date of November 6th >> Below is cost data for Zoom's production of wheels, seats, and calipers. Outside suppliers have offered to provide wheels for $6.96, seats for $7.82, and calipers for $2.56 per piece. Both wheels and seats are branded with the Zoom logo, and that logo will need to be added at the Zoom factory at a cost of $0.50 each for any of these components that are outsourced. For all three components, 75% of the fixed costs are avoidable, and will be eliminated if the component's production is outsourced. In addition, seats and calipers are both produced out of the same small factory space. If both seats and calipers were outsourced, Zoom could lease the space out and increase net income by $6,000 per year, while eliminating all fixed costs for the two components. Cost category Direct materials Direct labor Variable overhead Fixed overhead Total cost Units produced Cost per unit Wheels $141,000 94,000 21,000 59,800 $315,800 40,000 $7.90 Seats $53,000 73,000 14,000 40,200 $180,200 20,000 $9.01 Calipers $90,500 41,500 16,000 29,600 $177,600 80,000 $2.22 Hints: Prepare incremental analyses for each component separately. Make wheels vs. buy wheels, etc. Since there are additional implications to outsourcing both seats and calipers, do a make vs. buy analysis assuming both are outsourced. A correct solution, then, will likely have at least four incremental analyses. You may use the second tab of this workbook to prepare your solutions, or create a new file. Since you will be attaching this file to the Canvas assignment page, there are no file naming conventions you need to observe.
Expert Answer:
Related Book For
Financial and Managerial Accounting
ISBN: 978-1285078571
12th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these finance questions
-
Direct materials 689 Direct labor1096 Variable manufacturing overhead1520 Fixed manufacturing overhead 3466920 Variable selling and administrative expenses1392 Fixed selling and administrative...
-
Please fill in the missing spots in this income statement. Accounting 102 Chapter 15 Sales Direct Materials Direct Labor Overhead Total Manufacturing Costs Work in Process - January 1 Work in Process...
-
The (partial) cost sheet for the single product manufactured at Vienna Company follows. Direct labor (6 hours @ $20) (6 hours e $2) (6 hours e $4) $120 Variable overhead 12 Fixed overhead 24 The...
-
At the beginning of the year, COMET Company decided to raise additional capital by issuing 8,000 of 1,000 face amount 5-year bonds with interest rate of 12% payable semi-annually on June 30 and...
-
Describe the procedure for computing frequencies.
-
Figure Q26.7 shows three wires wrapped around an iron core. The figure shows the number of turns and the direction of each of the windings. At one particular instant,...
-
Hot water at \(50^{\circ} \mathrm{C}\) is routed from one building in which it is generated to an adjoining building in which it is used for space heating. Transfer between the buildings occurs in a...
-
Sara, a lawyer, drew a deed for Robert by which Robert was to convey land to Rick. The deed was correct in every detail. Robert examined and verbally approved it but did not sign it. Sara erased...
-
Explain the interplay between thermodynamics and statistical mechanics in describing the behavior of large ensembles of particles, focusing on the connection between macroscopic thermodynamic...
-
Mack Banta, a nonexempt account representative, worked extra hours this week as a call operator. A number of operators were out for the week and Banta was asked to pick up some of their hours. Can...
-
Determine the effective annual yield on a three-month Treasury bill selling at $9,624. (face value of the treasury bill is $10,000)
-
Give an example of situated knowledges in a specific context.
-
Do you think Co-cultural Theory provides a good explanation for the ways all marginalized people communicate when dealing with the dominant group? Why or why not? What other explanations might you...
-
What do you think about Orbes decision to label the people who participated in his research co-researchers? How does that label represent the philosophy of phenomenology? Do you think it actually...
-
A possible critique of CCT is that, although it states that people have a variety of identities, placing a large number of people in one group (i.e., co-cultural or non-dominant) may obscure this...
-
What other variables might affect peoples perception of the world in addition to their amount of television viewing?
-
Create an Income Statement and COGM Schedule for the year ended December 31, 2023. Create a Balance Sheet Owners Equity as well. Glorious Corporation Trial Balance December 31, 202 Trial Balance...
-
In Problem use absolute value on a graphing calculator to find the area between the curve and the x axis over the given interval. Find answers to two decimal places. y = x 3 ln x; 0.1 x 3.1
-
The following data are taken from the financial statements of Krawcheck Inc. Terms of all sales are 2/10, n/55. a. For 2013 and 2014, determine (1) The accounts receivable turnover (2) The number of...
-
How does the target cost concept differ from cost-plus approaches?
-
The inventory at the end of the year was understated by $14,750. (a) Did the error cause an overstatement or an understatement of the gross profit for the year? (b) Which items on the balance sheet...
-
Most countries in Europe do not have stringent laws to protect whistleblowers. True/false
-
In view of significant financial losses to investors, corporate fraud does not really affect the U.S. economy and investor confidence. True/false
-
The National Crisis Inquiry Report (2011) concluded that the financial crisis was unavoidable. True/false
Study smarter with the SolutionInn App