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...
-
With reference to Example 10.3, find an unbiased estimator of d based on the smallest sample value (that is, on the first order statistic, Y 1 ). Example 10.3 If X 1 , X 2 , . . . , X n constitute a...
-
Implement a performance-measuring environment simulator for the vacuum-cleaner world depicted in Figure 2.2 and specified on page 40. Your implementation should be modular so that the sensors,...
-
Consider the problem: \[\frac{\partial^{2} G}{\partial x^{2}}=\delta\left(x-x_{0} ight), \quad \frac{\partial G}{\partial x}\left(0, x_{0} ight)=0, \quad G\left(\pi, x_{0} ight)=0\] a. Solve by...
-
Fulco Company engaged in the following transactions in March 2014: Mar. 7 Sold merchandise on credit to James William, terms n/30, FOB shipping point, $3,000 (cost, $1,800). 8 Purchased merchandise...
-
a & b This year, Leton and Sheeno sold their home for \( \$ 848,000 \) after all selling costs. Under the following scenarios, how much taxable gain does the home sale generate for Leron and Sheena?...
-
Citigroup Inc. (Citi) is a leading global financial services company with over 200 million customer accounts and operations in more than 140 countries. Its operating units Citicorp and Citi Holdings...
-
verify that the indicated function is an explicit solution of the given differential y" + y = tan x; y = (cos x)ln(secx + tan .x) Question 2: verify that the indicated family of functions is a...
-
An employer contributes $20,000 (made up of Superannuation Guarantee and salary sacrifice contributions) to a complying superannuation fund for the year ended 30 June 2014 on behalf of employee John,...
-
During the holiday season, Toys-R-Us would often run out of toy that were in high demand. What is this called? What are the 4 options a customer has when this happens? What do you think is the most...
-
Home n Paste A1 Insert Page Layout X A BIU B Formulas Data Review Server Workbook This file is read-only. To modify the file, tap Edit. C 1 2 Problem 3: Chapter 8: Capital Gains 3 4 Instructions: 5...
-
What is the Owner Equity amount for Ernesto's Skateboard Corporation that should be reported on its balance sheet? Cash $5,000 Cash Equivalents $10,000 Accounts Receivable $30,000 Inventory $10,000...
-
The mean free path for methane at a temperature of 266 K and a pressure of 1.11 x 10 Pa is 4.81 x 10-8 m. Find the effective radius r of the methane molecule. x10-10 m r
-
Multinational Capital Budgeting. Chapter 18 Suppose you are conducting a financial analysis of a potential acquisition target, and you have been asked to identify the firm's engine of growth. Upon...
-
Create an appropriate display of the navel data collected in Exercise 25 of Section 3.1. Discuss any special properties of this distribution. Exercise 25 The navel ratio is defined to be a persons...
-
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...
-
Show that the decomposition (10.37) of the nonlinear term is correct. Use direct substitution of (10.36) into the expression for one component of vector \(N\).
-
For the flow in Problem 7, write the boundary conditions for pressure when the flow is incompressible and inviscid and there is no body force.
-
If your course involves exercises with a CFD code, study the manual to determine which of the projection schemes discussed in Section 10.4 (SIMPLE, SIMPLEC, SIMPLER, PISO) are implemented. Are there...
Study smarter with the SolutionInn App