Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 1: Make or Buy Decisions Mobility Partners makes wheelchairs and other assistive devices. For years it has made the rear wheel assembly for its

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Part 1: Make or Buy Decisions Mobility Partners makes wheelchairs and other assistive devices. For years it has made the rear wheel assembly for its wheelchairs. A local bicycle manufacturing firm, Trailblazers, Inc, offered to sell these rear wheel assemblies to Mobility. If Mobility makes the assembly, its cost per rear wheel assembly is as follows (based on annual production of 2,000 units): Trailblazers has offered to sell the absembly to Mobility for $110 each. The total order would amount to 2,000 rear wheel assemblies per year, which Mobility's management will buy instead of make if Mobility can save at feast $20,000 per year Accepting Traiblazers's offer would eliminate annual fixed overhead of $41,100 Required: a. Using Excel, prepare a schedule that shows the total differential costs. Indicate if the differential cost is higher, lower or no effect under the assumption that Status Quo is the base. a. Using Excel, prepare a schedule that shows the total differential costs. Indicate if the differential cost is higher, lower or no effect under the assumption that Status Quo is the base. b. Should Mobility make rear wheel assemblies or buy them from Trailblazers? Why? Be sure to provide a complete justification for your decision. Part 2: Classic Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Required: a. Using Excel, perform a regression analysis on the above data and generate a summary output. (Follow the instructions in your text book on pages 197-202). b. What is the equation for utility costs using the regression analysis? c. Prepare an estimate of utility costs for a month when 3,000 machine hours are worked

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

Step: 3

blur-text-image

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

The Internet Market Research Audit

Authors: Cambridge

1st Edition

1902433742, 978-1902433745

More Books

Students also viewed these Accounting questions