Create a table that shows the variances for each category

Reference no: EM131077359

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	Static Budget
Units Sold	$20,000.00		$24,000.00
Revenues	$2,500,000.00		$2,880,000.00
Total Variable Costs	$1,900,200.00		$2,112,000.00
Contribution Margin	$599,800.00		$768,000.00
Fixed Costs	$570,000.00		$552,000.00
Operating Income	$29,800.00		$216,000.00

For this assignment:

• 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.

Reference no: EM131077359

Questions Cloud

Network for the local business : Design a network for the local business based on the following information: The business has approximately fifty (50) employees, and the new office space will stretch across the third and fifth floors of a building. The fourth floor is currently o..

Examine the effect the issue has on society : Discuss the nature and history of your issue. Examine the effect the issue has on society. What are the costs? Select at least two elements of persuasion utilized in your campaign.

Some of the predictive models : Write 3 page paper on What is a systems development life cycle and What are some of the predictive models associated with the systems development life cycle? APA Format with 2 minimum references.

Explain why type ab+ blood may be called universal recipient : Explain why type AB+ blood may be called the "universal recipient" for blood transfusions - Why would they use this as a medication?

Create a table that shows the variances for each category : 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.

Maintain the privacy of medical and financial records : How would you allow people to maintain the privacy of their medical and financial records, while making it possible for companies to advertise products that are interesting and useful to consumers?

The traffic signal for the main street gets highest priority : The traffic signal for the main street gets highest priority because car are continuously present on the main street. Thus, the main street signal remains green by default.

Prepare an accounting software proposal : The company has asked you to prepare an accounting software proposal. Don't worry about the hardware components. The internal information technology department at Smith will work with that component.

Problem regarding the participant in the project : Begin your response by describing your EAI scenario. Be sure to include your role or perspective on this project. Were you a participant in the project, a consumer of the project's result, or both?

User Account

All Pages