Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

prepare make vs. buy incremental analysis for each possible course of action You are a financial manager for Zoom Corp., which manufactures bicycles. In the

prepare make vs. buy incremental analysis for each possible course of action image text in transcribed
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. If possible use excel formulas to get answers.
Below is cost data for Zoom's production of wheels, seats, and calipers. Outside suppliers have offered to provide wheels for $6.97,seats for $7.82, and calipers for $2.57 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 $O.50 each for any Of these components that are outsourced. For all three components, 75% of thefixed 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. Ifboth 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 Wheels Seats Calipers Direct materials Direct labor Variable overhead Fixed overhead Total cost 141,000 $54,500 $91,000 94,000 71,500 41,000 16,000 59,800 40,20031,400 315,800 $180,200 $179,400 21,000 14,000 Units produced Cost per unit 40,000 20,000 80,000 7.90 $9.01 $2.24 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 ofthis 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Study On The Auditing Theory Of Socialism With Chinese Characteristics

Authors: Jiayi Liu

1st Edition

1119107814, 978-1119107811

More Books

Students also viewed these Accounting questions