Preview

Variance analysis

Good Essays
Open Document
Open Document
960 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Variance analysis
Variance Analysis: Year 6 In this part of the report, we analyze the variances between our pro-forma statements we had projected and the actual results we received from the BPG game. Looking at the variances, it can be seen that most of the numbers compared are not too far apart from each other when comparing our actual numbers to the projected analysis. This is due to the fact our forecast was successful. It was however not 100% accurate in terms of predicting our future numbers. Looking at the variances for the consolidated income statement for year 6, sales to customers only had a negative 1.3% variance. Since this variance was negative, it indicates that sales were a little less than what was projected, but still very close. For both Cost of Goods Sold and Value added tax a negative 5.8% and 18.9% variance can be seen. This shows that both the costs that go into making the product and the tax were slightly lower than expected. An explanation for this would be that our company only did overtime for one quarter in year 6 instead of the anticipated 3 quarters of overtime. Actual Gross Profit was slightly higher than expected with a positive variance of 2.1%. The resulting percentages are due to the fact that even though sales were slightly lower than what was estimated, the cost of producing them and value added tax were significantly lower. Our selling expenses did not have any large variances, showing that they were all near the projected numbers. Advertising Expense, Sales Salaries, Sales Commissions, and sales office depreciation were near what was expected and showed a barely noticeable variation from the expected forecasted results. The only two mentionable selling expenses are the General Selling expense and transportation expense due to their minor but noticeable variances of positive 6.9% and negative 7.9%. General selling expense was slightly higher than expected because of our continued hiring of salespeople and because of the fact that we a little

You May Also Find These Documents Helpful

  • Good Essays

    Jet task2

    • 854 Words
    • 4 Pages

    Because there is really no way to accurately predict the exact sales and costs within a year, there are bound to be variances, both favorable and unfavorable. Some of these variances are also included…

    • 854 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Accounting Microline Case

    • 1433 Words
    • 6 Pages

    Microline’s profits increased significantly from 2010 to 2011 with the net income of 2011 being over 3 times the amount of 2010. The return on equity also increased, with a 4% ROE in 2010 to 14% in 2011. Their profits are also growing faster than there assets with an increase on their return on assets of 4% between 2010 and 2011. The profit margin rose from 2% in 2010 to 5% in 2011. Sales rose from $7500 between 2010 and 2011, however, this does not account for the substantial increase in their net income. While their sales have increased, their profits have increased at a faster rate. The significant increase in their net income is largely accounted for by gains on sales of land, foreign exchange, income from affiliates and short term equity investments. Combined these account for an increase of $4000 on the income statement between 2010 and 2011. Another point of interest is the large increase in administrative expenses which increased by $5000 dollars from 2010 to 2011. The company did show an increase in sales, however, the amount of the increase brings into question what Microline is writing off as administrative expenses as there is no mention of it in the footnotes. This could be a cause for concern where the majority of the companies net income is being generated from investment opportunities rather than from the sales of…

    • 1433 Words
    • 6 Pages
    Good Essays
  • Good Essays

    JET 2 Task 1

    • 6185 Words
    • 20 Pages

    Due to variable expenses, expenses that increase as production and sales increase, selling expenses for Competition Bikes, Inc. increased. From year 6 to year 7, total selling expenses increased by 33%. General and Admin expenses also increased, by a lesser amount, at 31.1%. Due to a sufficient increase in net sales, the added selling expenses did not come at a deficit to the bike company. Advertising expenses also increased to 37.5% but due to website creation and various maintenance costs staying relatively the same, it did helped balance the expenses and net sales and negative impacts on the company were not made. (WGU, 2014)…

    • 6185 Words
    • 20 Pages
    Good Essays
  • Powerful Essays

    B120 TMA03

    • 1098 Words
    • 4 Pages

    b.) By looking at the statement, there are a few reasons for concern. The first thing I would like to point out is that even if the business is making a profit, the margin from 2011 to 2012 has decreased dramatically. The net profit is £249,200 less than previous year. A decreasing net profit means less money to spend in to the business for next year. Another cause for concern is the cost of goods sold for 2012, a cost of £793,300, compared to the gross profit of £799,000. This is concerning as the business is spending too much money on stock without barely making a profit.…

    • 1098 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    3. It's not an easy life, but it's a good life. Suppose you decide to take the summer off and sign on as a deck hand for a commercial fishing boat in Alaska that specializes in deep-water fishing for ground fish. What kind of fish can you expect to catch? One way to answer this question is to examine the reports on ground fish caught in the Gulf of Alaska. The following list indicates the types of fish caught annually in thousands of metric tons: flatfish, 36.3; Pacific cod, 68.6; sablefish, 16.0; Walleye Pollock, 71.2; rockfish, 18.9. Make a Pareto chart showing the annual harvest for commercial fishing in the Gulf of Alaska.…

    • 641 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    | Quarterly profits were higher than anticipated ($6,000 versus $5,000) and Return on Capital Employed was much lower than anticipated ($1,500 versus $4,000).…

    • 531 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Variance Analysis

    • 390 Words
    • 2 Pages

    I certify that I am the author of this paper and that any assistance I received in its preparation is fully acknowledge and disclosed in the paper. I have also cited any sources from which I used data, ideas of words, whether quoted directly or paraphrased. I also certify that this paper was prepared by me specifically for this course.…

    • 390 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Memo

    • 685 Words
    • 3 Pages

    Over the past year you have sold 4300 books, which look great on the surface. However you have experienced a severe profit loss. From the data that I have gathered from you records, your category D and E books are not doing as well as the other categories of books. You had a total loss of $9000 from those two categories of books. Although your income statement is showing a higher number of book sales in Category D and E, it is costing you more to purchase the books vs selling them.…

    • 685 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    A substantial body of research into the determinants of good sales performance has been accumulated over the last century (Shannahan, Bush & Shannahan,…

    • 3126 Words
    • 13 Pages
    Powerful Essays
  • Good Essays

    Dallas Consulting Group

    • 1025 Words
    • 5 Pages

    Since the company is making $80,000 more profit than expected in year 2009, one of the partners, Dave Lundberg pointed out that there isn’t such a need to analyze the profit variance. However, the other partner Adam Dixon was thinking the opposite and he gathered some data to reflect some points in the reasons of this profit variance.…

    • 1025 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Body Shop Case Analysis

    • 358 Words
    • 2 Pages

    For all the line items that are calculated as a percentage of sales, we used an average for the last three years as our base case assumptions. Our observations led us to use this average because the percentages were fairly consistent over the last three years. Since the company was not operating at full production capacity we concluded that the company could continue growing without incurring an increase in fixed costs. The dividends were unchanged over the period of observation. Since taxes are not calculated as a percentage of sales but rather as a percentage of EBIT, taxes payable remained unchanged.…

    • 358 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Analysis of sale variance reveals that New Look Jackets record 110,000 actual sale volumes greater that sale volume of 100,000 budgeted for the fiscal year. The favorable variance of 10,000 makes the company to record the increase in the sales revenue for the actual budget. The company recorded $5,747,500 as actual revenue compared to $4,075,000 budgeted as sale revenue making the company to record the favorable variance of $1,672,500 in revenue.…

    • 2409 Words
    • 27 Pages
    Good Essays
  • Powerful Essays

    In order to derive this forecast, ‘percent-of-sales’ forecasting was used, which involves initially forecasting sales and then forecasting other financial statement accounts based on their direct relationship with sales. This method of forecasting was used due to the lack of information available (only the last three years of financial statements). As a result, every account in the pro forma financial statements are based on one or more key assumptions about their relationship with sales:…

    • 2954 Words
    • 12 Pages
    Powerful Essays
  • Good Essays

    Mean Variance Analysis

    • 698 Words
    • 3 Pages

    Harry W. Markowitz, the father of “Modern Portfolio theory”, developed the mean-variance analysis, which focuses on creating portfolios of assets that minimizes the variance of returns i.e. risk, given a level of desired return, or maximizes the returns given a level of risk tolerance. This theory aids the process of portfolio construction by providing a quantitative take on it. It integrates the field of quantitative analysis with portfolio management. Mean variance analysis has found wide applications both inside and outside financial economics. However it is based on certain assumptions which do not hold good in practice. Hence there have been certain revisions to it, so as to make it a more useful tool in portfolio management.…

    • 698 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Terms: Forecast vs Forecast Error We clarify the terms used in the practice problems and the final exam problems. Some statisticians speak of the standard deviation or variance of the forecast. The forecast here is the distribution of future values. It is a random variable, which has a standard error (standard deviation and variance). Other statisticians use the term forecast for the mean of the distribution of future values. The forecast error (the error term in the forecast) is the distribution of future values minus its mean. Using these terms: ! The forecast is a scalar with a non-zero value (unless the forecasted value is zero). ! The forecast error is a random variable with a mean of zero and a non-zero standard error. The final exam problems may use either view. The meaning is clear from the context.…

    • 4080 Words
    • 17 Pages
    Good Essays