Mile High Cycles Write-Up. Question 4 ONLY (at least 300 words).

timer Asked: Apr 14th, 2015
account_balance_wallet $40

Question Description

Mile High Cycles.pdf

I have answered questions 2 and 3. See attached. I only need you to answer question 4. Please write 300 words or more.

Answer the following questions:

2. Using the approach discussed in Week 3, Presentation 3, develop a 2004 flexible budget, and compute the flexible - actual variances.

3. Determine direct cost variances (six for Frame; four each for Wheel and Final) and two overhead variances.

4. Should Bob Moyer be concerned about Mile High Cycles' performance? How significant are these variances?

  • What is causing these variances? Do you see any patterns or relationships among the variances that suggest possible causes?
  • Where should Bob Moyer direct his attention? Why? What should he do?

ACCT6273 Week 4 Assignment - Q2.docx

ACCT6273 Week 4 Assignment Q3.xlsx

Unformatted Attachment Preview

9-191-056 REV: MAY 17, 2004 WILLIAM J. BRUNS, JR. Mile High Cycles In 2005, Bob Moyer was reviewing production costs for Mile High Cycles. Located in Denver, Colorado, the company sold very high-quality, handcrafted mountain bikes to bicycle retailers throughout the country. Sales for the company were $13 million that year. Bob Moyer had been an avid cyclist in college, racing for the Stanford University cycling team while completing his degree in mechanical engineering. After working for a few years as a design engineer for a company in Denver, Bob decided to start his own business. As a hobby, he had designed and built several prototypes of a mountain bike, which had been enthusiastically received by his mountain-biking friends. Approaching several friends and relatives for start-up money, Mile High Cycles was founded in 2003. A mountain bike was a bicycle with 15 to 21 speeds, designed and built to take the punishment of riding on dirt trails and roads. The bikes were first made by avid cyclists who customized their 10speed road bikes in order to ride on mountain trails and dirt roads. Some with framebuilding experience began to experiment making their own frames in order to handle better the additional demands of off-road riding. By 1992, several small companies had emerged selling bicycles specifically designed for riding under these conditions. During the rest of the 1990s, mountain bikes had taken off in popularity, not only for use off-road but also for use in the city, where their sturdy construction could withstand the pounding from potholes and curbs. In addition, many casual cyclists preferred the mountain bike’s more upright riding position in comparison to that of the hunched position of the 10-speed road bike. Sales of all bicycles in the United States had declined in 2003. However, over the same time period, sales of mountain bikes increased to more than 2.0 million units. Bob Moyer had planned to produce 10,000 bikes in 2004, all of one model. Operations at Mile High Cycles consisted of three departments: frames, wheel assembly, and final assembly. In frames, steel tubing was cut to length for the components of the frame. Then the pieces were carefully welded together to form the completed frameset. This part of the process was quite time-consuming, requiring frequent inspection and measurement to ensure that the frameset was aligned perfectly. After welding, the frame was painted in one of 10 different color schemes and prepared for final assembly. In wheel assembly, front and rear wheels were assembled from their key components: hubs, spokes, and rims. All of the components were purchased from an outside supplier. Mile High Cycles ________________________________________________________________________________________________________________ Professor William J. Bruns, Jr. and David J. Ellison prepared this case. HBS cases are developed solely as the basis for class discussion. Cases are not intended to serve as endorsements, sources of primary data, or illustrations of effective or ineffective management. Copyright © 1990 President and Fellows of Harvard College. To order copies or request permission to reproduce materials, call 1-800-545-7685, write Harvard Business School Publishing, Boston, MA 02163, or go to No part of this publication may be reproduced, stored in a retrieval system, used in a spreadsheet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of Harvard Business School. 15 191-056 Mile High Cycles used a high-quality automatic lacing and truing machine to build its wheels. This machine would lace the spokes between the hub and rim and then automatically tighten the spokes to the appropriate tension. The machine was quite precise but would occasionally damage spokes during the insertion process. In such a case, the operator would replace any damaged parts and restart the machine. Each wheel would also be inspected and trued by hand in order to insure that the wheels were in perfect alignment. In final assembly, the frame and wheels were combined with other purchased parts to create the final package that would then be shipped to bicycle dealers. In this area, the front fork and many other key components were attached to the frame, and the inner tubes and tires were mounted on the wheels. In order to minimize damage while shipping, some of the bicycles’ components were left packaged for the bicycle dealer to assemble before selling the bike to the final customer. All of the components were purchased from outside suppliers and then were combined to form kits for the bicycles. Mile High Cycles carried an inventory of spare parts to replace any parts damaged during assembly or shipping, although such replacement was quite infrequent. In reviewing his costs, Bob noted that he had produced 10,800 bicycles in 2004, 800 more than planned. Bob thought that operations during the year had done well to meet the additional demand, but he wondered if Mile High Cycles was doing a good job in managing its costs. Exhibit 1 shows the planned material, labor, and overhead costs for 2004. Exhibit 2 shows the actual material, labor, and overhead costs for that year. Questions 1. Determine the direct cost and overhead variances. variances to occur? 2. Should Bob Moyer be concerned about Mile High Cycles’s performance? Where should he be prepared to direct his attention? What additional information should he try to obtain? 3. Are there any purposes for which a total, per unit variance would be more useful than a series of functional variances? If so, for what? 2 16 What might be causing each of the Mile High Cycles Exhibit 1 191-056 2004 Production Budget Budget based on 10,000 bicycles production Frame assembly: Steel tubing Paint Labor Total frame $ 3,300,000 25,000 $ 1,500,000 (110,000 lbs. @ $30.00/lb.) (1,250 gals. @ $20.00/gal.) (100,000 hrs. @ $15.00/hr.) $ 4,825,000 Wheel assembly: Parts Labor Total wheel $ 1,200,000 65,000 (10,000 kits @ $120.00/kit) (5,000 hrs. @ $13.00/hr.) $ 1,265,000 Final assembly: Parts Labor Total final assembly $ 3,500,000 105,000 (10,000 kits @ $350.00/kit) (7,500 hrs. @ $14.00/hr.) $ 3,605,000 Overhead costs: Rent Office staff Depreciation Other costs $ 250,000 100,000 100,000 750,000 Total overhead $ 1,200,000 Total Annual Costs $10,895,000 (estimated to be 2/3 variable) 3 17 191-056 Exhibit 2 Mile High Cycles 2004 Production Costs Actual production: 10,800 bicycles Frame assembly: Steel tubing Paint Labor Total frame $ 3,572,100 28,187 $ 1,528,050 (113,400 lbs. @ $31.50/lb.) (1,375 gals. @ $20.50/gal.) (100,200 hrs. @ $15.25/hr.) $ 5,128,337 Wheel assembly: Parts Rework parts Labor $ 1,317,600 25,000 74,250 Total wheel $ 1,416,850 (10,800 kits @ $122.00/kit) (spokes and rims) (5,500 hrs. @ $13.50/hr.) Final assembly: Parts Rework parts Labor Total final assembly $ 3,963,600 45,000 116,000 $ 4,124,600 Overhead costs: Rent Office staff Depreciation Other costs $ 250,000 100,000 100,000 850,000 Total overhead $ 1,300,000 Total Annual Costs $11,969,787 4 18 (10,800 kits @ $367.00/kit) (miscellaneous parts) (8,000 hrs. @ $14.50/hr.) The master, flexible, and actual budget along with budget variances can be found in Exhibit 1. Based on the information presented in the case, it can be seen that there is an overall unfavorable variance with regards to both variable and overhead costs. For variable costs, with the exception of frame labor, all raw material and labor costs were higher than expected. Additionally, there was a total cost of $60,000 necessary for re-working wheel spokes and rims, as well as other miscellaneous parts. The total overhead costs were $100,000 more than expected, due to additional “other” costs. This resulted in total annual costs of almost $300,000 more than expected. Exhibit 1: Master, Flexible, and Actual Budget for 2004 Production Sales Revenue Variable Costs Frame Tubing Frame Paint Frame Labor Wheel Parts Wheel Parts Re-Work Wheel Labor Final Assembly Parts Final Assembly Parts Re-Work Final Assembly Labor Total Variable Costs Contribution Margin Overhead Costs Rent Office Staff Depreciation Other Costs Total Overhead Costs Total Annual Costs Net Income Master Budget 10,000 bicycles $12,037,037.04 Flexible Budget 10,800 bicycles $13,000,000.00 Actual Budget 10,800 bicycles $13,000,000 Flexible Budget Variances Favorable or Unfavorable $0.00 -- $3,300,000.00 $25,000.00 $1,500,000.00 $1,200,000.00 -$65,000.00 $3,500,000.00 -$105,000.00 $9,695,000.00 $2,342,037.04 $3,564,000.00 $27,000.00 $1,620,000.00 $1,296,000.00 -$70,200.00 $3,780,000.00 -$113,400.00 $10,470,600.00 $2,529,400.00 $3,572,100.00 $28,187.00 $1,528,050.00 $1,317,600.00 $25,000.00 $74,250.00 $3,963,600.00 $45,000.00 $116,000.00 $10,669,787.00 $2,330,213.00 $8,100.00 $1,187.00 ($91,950.00) $21,600.00 $25,000.00 $4,050.00 $183,600.00 $45,000.00 $2,600.00 $199,187.00 ($199,187.00) U U F U U U U U U U U $250,000.00 $100,000.00 $100,000.00 $750,000.00 $1,200,000.00 $10,895,000.00 $1,142,037.04 $250,000.00 $100,000.00 $100,000.00 $750,000.00 $1,200,000.00 $11,670,600.00 $1,329,400.00 $250,000.00 $100,000.00 $100,000.00 $850,000.00 $1,300,000.00 $11,969,787.00 $1,030,213.00 $0.00 $0.00 $0.00 $100,000.00 $100,000.00 $299,187.00 ($299,187.00) ---U U U U Master Budget Flexible Budget Production 10,000 bicycles 10,800 bicycles Sales Revenue ######### ######### Variable Costs Frame Tubing $3,300,000.00 $3,564,000.00 Frame Paint $ 25,000.00 $ 27,000.00 Frame Labor $1,500,000.00 $1,620,000.00 Wheel Parts $1,200,000.00 $1,296,000.00 Wheel Parts Re-Work --Wheel Labor $ 65,000.00 $ 70,200.00 Final Assesmbly Parts $3,500,000.00 $3,780,000.00 Final Assembly Parts Re-Work --Final Assembly Labor $ 105,000.00 $ 113,400.00 Total Variable Costs $9,695,000.00 ######### Contribution Margin $2,342,037.04 $2,529,400.00 Overhead Costs Rent $ 250,000.00 $ 250,000.00 Office Staff $ 100,000.00 $ 100,000.00 Depreciation $ 100,000.00 $ 100,000.00 Other Costs (2/3 variable) $ 750,000.00 $ 750,000.00 Total Overhead Costs $1,200,000.00 $1,200,000.00 Total Annual Costs ######### ######### Net Income $1,142,037.04 $1,329,400.00 Actual Budget 10,800 bicycles $13,000,000 $3,572,100.00 $ 28,187.00 $1,528,050.00 $1,317,600.00 $ 25,000.00 $ 74,250.00 $3,963,600.00 $ 45,000.00 $ 116,000.00 ######### $2,330,213.00 $ 250,000.00 $ 100,000.00 $ 100,000.00 $ 850,000.00 $1,300,000.00 ######### $1,030,213.00 Flexible Budget VariancesFavorable or Unfavorable $0.00 $ $ -- $8,100.00 $1,187.00 ($91,950.00) $21,600.00 25,000.00 $4,050.00 $183,600.00 45,000.00 $2,600.00 $199,187.00 ($199,187.00) U U F U U U U U U U U $0.00 $0.00 $0.00 $100,000.00 $100,000.00 $299,187.00 ($299,187.00) ---U U U U ...
Purchase answer to see full attachment

Tutor Answer

David G557
School: Duke University

flag Report DMCA

Tutor went the extra mile to help me with this essay. Citations were a bit shaky but I appreciated how well he handled APA styles and how ok he was to change them even though I didnt specify. Got a B+ which is believable and acceptable.

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors