Create a table that shows the variances for each category and for overall.

Sep 5th, 2015
Price: $10 USD

Question description

Tom was hired as a budget analyst at a large aviation manufacturing business. His boss has asked that he review last year's master budget, actual results, and planned numbers, and calculate the variances for each category. The data table Tom was given follows below and the assignment is at the end of the data table.

Actual results  variance  statict budget

Units sold   20,000.00  24,000.00

Revenues  2,500,000.00  2,88,000.00

Total variable cost  1,900,200.00  2,112,000.00

Contribution margin  599,800.00  768,000.00

Fixed cost  570,000.00  552,000.00

Operating income  29,800.00  216,000.00

Create a table that shows the variances for each category and for overall.Then, in a 1-page Word document, summarize why there were variances.Include both the calculation table and summary in the same document.

Tutor Answer

(Top Tutor) Kelvin B
School: Boston College

Studypool has helped 1,244,100 students

Review from student
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1830 tutors are online

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