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

Sep 5th, 2015
Steve1995
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) Daniel C.
(997)
School: New York University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

Summary
Quality
Communication
On Time
Value
pmallory
Feb 24th, 2017
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 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