Mile High Cycles

1886 Words Jul 19th, 2016 8 Pages
Week 3 Individual Assignment 1:
Mile High Cycles Case Analysis Questions 1, 2, & 3

ACCT 6273, Section 7
Identifying Strategic Implications in Accounting Data

MILE HIGH CYCLES CASE ANALYSIS

* (Exhibit 3 Below) * (Exhibit 4 Below) * The variances are due to the Mile High Cycle company not forecasting for increased production. The company budgeted for the production of 10,000 cycles but the actual production was 10,800 units. When the company increased production, the production efficiency decreased. The company had to use or rework parts that added extra cost to the expenses; the reworked parts added $25,000 of extra expenses to the wheel assembly production and $45,000 to the final assembly process. The material,
…show more content…
$ 3,564,000.00 | $ 3,572,100.00 | $8,100.00 | U | Paint | $ 25,000.00 | $ 27,000.00 | $ 28,187.00 | $1,187.00 | U | Labor | $ 1,500,000.00 | $ 1,620,000.00 | $ 1,528,050.00 | ($91,950.00) | F | Total Frame | $ 4,825,000.00 | $ 5,211,000.00 | $ 5,128,337.00 | ($82,663.00) | F | Wheel Parts | $ 1,200,000.00 | $ 1,296,000.00 | $ 1,317,600.00 | $21,600.00 | U | Parts Rework | -- | -- | $ 25,000.00 | $ 25,000.00 | U | Labor | $ 65,000.00 | $ 70,200.00 | $ 74,250.00 | $4,050.00 | U | Total Wheel | $ 1,265,000.00 | $ 1,366,200.00 | $ 1,416,850.00 | $50,650.00 | U | Final Assesmbly Parts | $ 3,500,000.00 | $ 3,780,000.00 | $ 3,963,600.00 | $183,600.00 | U | Assembly Parts Rework | 0 | 0 | $ 45,000.00 | $ 45,000.00 | U | Assembly Labor | $ 105,000.00 | $ 113,400.00 | $ 116,000.00 | $2,600.00 | U | Total Final Assembly | $ 3,605,000.00 | $ 3,893,400.00 | $ 4,124,600.00 | $231,200.00 | U | Total Variable Costs | $ 9,695,000.00 | $ 17,047,800.00 | $ 17,214,974.00 | $167,174.00 | U | Contribution Margin | $ 2,342,037.04 | $ (4,047,800.00) | $ (4,214,974.00) | ($167,174.00) | U | Overhead Costs | | | | | | Rent | $ 250,000.00 | $ 250,000.00 | $ 250,000.00 | $0.00 | | Office Staff | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $0.00 | | Depreciation | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $0.00 | | Other Costs (2/3 variable) | $
Open Document