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

Sep 5th, 2015
Anonymous
Category:
Accounting
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) Studypool Tutor
School: Boston College
PREMIUM TUTOR

Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 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