The variance between the actual results and flexible budget

Assignment Help Accounting Basics
Reference no: EM131801571

The comparison of an original planning budget for a given accounting period with the actual results can produce misleading conclusions. As you've discovered in this module's reading, variance in activity level creates a need for the planning budget to be altered - resulting in the preparation of a flexible budget. It is this new flexible budget - and not the planning budget - that should be compared with the actual results. The comparison of a flexible budget and actual performance can help managers discover ways to increase revenues and cut expenses. In this activity you will prepare a flexible budget and compare it to the actual results in a performance analysis.

Wolverine Manufacturing's planning budget for the second quarter 20XX is shown below. Note the budget was built based on an activity level of 5 aircraft.

Wolverine Manufacturing
Planning Budget Second Quarter 20XX

Budgeted aircraft sold (a) - 5

Revenue ($150,000a)

$750,000

Expenses:
     Direct Materials ($25,000a)
     Direct Labor ($4,000a)
     Variable Manufacturing Overhead ($1,000a)
     Fixed Manufacturing Overhead ($80,000 per month)
     Variable Selling & Admin. Expenses ($15,000a)
     Fixed Selling & Admin. Expenses ($25,000 per month)
Total Expenses:


125,000
20,000
5,000
240,000
75,000
75,000
540,000

Net Operating Income

210,000

Wolverine's income statement showing the actual results of the second quarter 20XX is shown below.

Wolverine Manufacturing
Income Statement Second Quarter 20XX

Actual aircraft sold - 7

Revenue

$975,000

Expenses:
     Direct Materials 
     Direct Labor 
     Variable Manufacturing Overhead 
     Fixed Manufacturing Overhead 
     Variable Selling & Admin. Expenses 
     Fixed Selling & Admin. Expenses 
Total Expenses:


160,000
37,000
7,500
210,000
95,000
45,000
554,500

Net Operating Income

420,500

Instructions

Do the following to complete this assignment:

  1. Download the flexible budget and performance report template here.Note that the planning budget information and actual results from the income statement have already been entered into the performance report.
  2. Wolverine Manufacturing actually sold 7 aircraft during the second quarter 20XX. Create a flexible budget based on 7 aircraft; then enter the flexible budget data into column 2 of the performance report.
  3. Calculate the variances between the planning budget and the flexible budget and enter the results in column 3 of the performance report.
  4. The actual results from the first quarter income statement have been entered in column 4. Calculate the variance between the actual results and the flexible budget. Enter the variance in column 5 of the performance report.
  5. Determine whether each variance between theactual results and flexible budgetis favorable or unfavorable. In column 6 of the performance report, enter F for favorable and U for unfavorable next to each variance.
  6. Check you work, make sure your name is on the assignment where requested, and submit your assignment using the guidelines below.

Reference no: EM131801571

Questions Cloud

Compare the accuracy of forecast 1 and forecast 2 : Compare the accuracy of Forecast 1 and Forecast 2 by calculating the Mean Absolute Deviation for each one. Which is more accurate?
Find the expected annual retirement benefits of service : Retirement benefits the table gives the approximate benefits for PepsiCo executives who earned an average of $250,000 per year during the last 5 years.
Determining the aggresiveness and assertiveness : As it is aptly said there is a very thin line between aggresiveness and assertiveness. Hence the leader has to tread wisely with a well balanced approach.
What is the net operating income earned by product : What is the net operating income earned by product F275 according to the company's accounting system? Show your work!
The variance between the actual results and flexible budget : Determine whether each variance between the actual results and flexible budget is favorable or unfavorable
Identifying the competitors product and making comparisons : BSBPRO401 Develop Product Knowledge Assignment. In this task you will demonstrate your ability in identifying the competitors' product and making comparisons
Describe the major implications of study on the crime field : Wxplain the degree to which ethics is or is not an important topic as it relates to criminal justice.
Third-largest retailer after walmart and costco : Target is the U.S. third-largest retailer after Walmart and Costco, but in the last decade it has seen its earnings drop from $3.2 billion to $1.5 billion.
Prepare a segmented income statement in the contribution : Prepare a segmented income statement in the contribution format for the company. Omit percentages; show only dollar amounts.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd