Budget and Variance Report

In: Business and Management

Submitted By eborgelt
Words 399
Pages 2
Week 6 Problem
Flexible Budget and Variances
NOTE: It is expected that this problem will be completed using an Excel spreadsheet using formulas. Please see the Excel Tutorial that is available under the course home tab.

The Grant Company had developed a Static Budget for 2005 for one of its major departments. By the end of the year, the owner was quite pleased since he knew that sales were running above the projections. He was confident that 2005 was going to be the best year ever for this important part of the company!

When the 2005 financial statements were completed, it was discovered that the gross profit for the department was lower than had been originally projected. But sales were up! What happened?

You have been hired to determine why 2005 was not a "banner year"! You have been supplied with the original Static Budget and the actual results as follows:

Static Budget Actual 2005 Figures
Units Sold 10,000 11,000
Revenue $1,000,000 $1,078,000
Material 300,000 350,900
Labor 250,000 247,500
Variable Overhead 150,000 194,700
Fixed Overhead 200,000 195,000
Gross Profit $100,000 $89,900

You are also provided with the following information regarding standards and actual results:

Standard Actual
Selling price $100 per unit $98 per unit
Cost of materials $15 per foot $14.50 per foot
Materials per unit 2 feet per unit 2.2 feet per unit
Labor rate $25 per hour $30 per hour
Labor usage 1 hour per unit 0.75 hours per unit
Variable overhead rate $30 per machine hour $29.50 per machine hour
Variable overhead usage 0.5 machine hours per unit 0.6 machine hours per unit
Assume purchase quantities equal usage for materials.

Part 1: Prepare a flexible budget for 2005
Part 2: Calculate the following variances
a. Sales volume variance (use CM)
b. Sales price variance
c. Material price variance
d. Material usage variance
e. Labor…...

Similar Documents

Variance Analysis

...HCA 240 April, 29 2012 Moiz Lalani Variance Analysis Variance Analysis is used to promote management action in the earliest stages. It is the process of examining in detail each variance between actual and budgeted costs to conclude the reasons as to why the budgeted amount was not met (Ventureline, 2012). There are several factors that go into a variance report. One is the assumption of the department. The second is the risk of the assumption. And thirdly the actual expense used to portray the budget. The vice president announces the budget that needs to be met monthly. Upon receiving the monthly budget results, the materials budget was not used properly, and the salary was higher than the planned budget. I will be explaining the reasons as to why the salary bases were higher than the given amount, and the reasons why the materials budget were not met, and also what needs to be done in future to prevent from having to exceed the salary amount. When receiving the monthly budget at the beginning of the month, the managers have to assume how to use the budget amount given wisely. Given that the employees need materials to get the job done, there are separate budget amounts for specific areas that need to be dispersed accordingly. For example, working at a health care industry in the materials management department, the supplies that are needed for the department need to be available in order for the department to run such as: computers, handheld inventory scanners, and......

Words: 915 - Pages: 4

Variance Report

...The following Profit and Loss Statement for ‘Nursing Salaries and Supplies’ summarizes the cost variances of price, efficiency, and volume. From these variances a projected total loss of $6,730.00 was calculated; Nursing salaries being the primary cause for budget overage. “The following three major factors influence costs: input prices- evaluate what portion, if any, of that increase was controllable or avoidable, productivity of inputs- measuring productivity has become increasingly important in the healthcare industry as a result of the emphasis on cost containment, and output levels- any increase in the number of services required per unit of output directly affects costs. Cost increases could have resulted from higher prices paid for inputs such as wage and salary” (Cleverley, Song, & Cleverley, p. 384). Supplies came within budget with profit of $1,040. In general, the primary reason for a cost change at the departmental level between two periods can be stated as a function of the following three factors (Cleverley et al., 2011, p. 386): 1. Changes in input prices 2. Changes in input productivity (efficiency) 3. Changes in departmental volume Below is the breakdown of salaries and supplies: Actual Cost for Nursing Unit Actual Month’s Cost Nursing Unit Number 6 Actual Patient Days 600 Resource Quantity Used Unit Cost Total Cost Head nurse 180 $36.00 $6,480 RN 1,800 32.00 57,600 LPN 1,200 16.20 19,440 Aides......

Words: 569 - Pages: 3

Variance Budget

...Variance Analysis HCA-240 Variance Analysis The many reasons as to why the budget for this month has gone over have many factors involved. For a $5,000 favorable variance on staffing, the department head can state that the company was able to obtain a 25 % discount from a new supplier, which resulted in a savings for the department. Another example would be when you have a $25,000 unfavorable variance in sick time for many employees, the department head would state there was an outbreak earlier in the season and this was not expected, resulting in hourly and sick time expenses that were not anticipated. What we can do, would be to analyze variances by the month, quarter or year. Having budget variances in place can allow at least two sources the things that can be controlled and things that cannot. This time I know that the reason the salaries were higher, we because of the recent storm we had and it cause some staff not to show up for work and other to do overtime. Going forward what we can implement would be an emergency team for weather related issues or natural disaster to ensure that we don’t go over our budget and if we see that we are approaching that then we can implement another plan or process, to help balance it back out like giving comp time or early leave. When uncontrollable factors occur many are often external which then result from occurrences outside of the company such as a natural disasters, which can then throw the budget into a......

Words: 810 - Pages: 4

Variance Analysis

...Variance Analysis A manager of a variable hospital department has many responsibilities. The manager is accountable for budgeting and to protect profits. The financial manager is responsible for guarding overspending and generating profits. They are active in the budgeting process throughout the fiscal year. The budget department manager communicates with other managers, and accounting departments concerning budget issues, financing, and concerns in the organizations departments. Sometimes situations occur whereas payroll salaries are high and supplies are lower than planned and budgeted. The budget manager is responsible for providing feedback about finances, revenue, and any potential variances in the budgeted costs. This essay will be based on a scenario of salaries that were higher and supplies lower than initially budgeted. This paper will explore variances in the scenario mentioned earlier, and explain the relationship between variance reporting, interpreting variance reporting results, and the results of performance within a health care organization. The hospital variable department has experience a case in which employee salaries are higher than budgeted, while the supplies are lower than initially budgeted. This is the result of an epidemic of asthma patients who were admitted to the hospital over the last three months. The hospital approved overtime to assist in the growing number of patients and to accommodate their needs. In the process of caring for patients......

Words: 866 - Pages: 4

Budget Report

...Budget Report We were offered the following data to complete a budget for a hospital. The data contained the following: The hospital had a total of 35 beds of which 10 beds were on a discount, either 50 % discount or full discount. Three different capacities were given to us, 100%, 90% and 75%. The total number of patient days at 100% capacity is 12775 days, 11497.5 days at 90% capacity and 9581.25 days at 75% capacity. The hospital’s fixed costs amounted to $10,100 per month and the variable costs were $179.45 per day. The first step in the preparation of the budget was finding the contribution margin (CM) for the hospital under the assumptions that 10 beds are at 50% discount and under every capacity, and that 10 beds are at full discount under every capacity. The CM of 100% capacity was higher than those at 90% and 75% capacity. Not to forget that the 10 beds discount had a fixed CM since the number of patient days and capacity don’t affect the number of beds discounted. As expected the total CM of 50% discount was higher than that at 100% discount. This is due to the zero revenues generated from the fully discounted beds. The next step was to calculate the gross profit when operating at 90% capacity under 50% and 100% discount. The gross profit of 50% discount came out to be higher and almost double the gross profit of that at 100% discount. The effect of the 100% discount on the CM mentioned in the previous paragraph is carried forward to the gross profit causing...

Words: 516 - Pages: 3

Investigating My First Variable Variance Report:

...Variable Variance Report: Beginning the Road to Precision in Variable Planning Oh, bemusing variance report! However will I explain to Bob Schuler, Hahnemann Hospitals’ vice president, the ineffectiveness of my plan, how my supplies came in under budget and salaries were overextended during my first thirty days in the department?! I had hoped the variance percentages would be consistent with the unexpected revenue created by the increased patient volumes we experienced last month - but that could only explain the salary end of things because supplies and procedures didn’t increase. Furthermore, since patient volumes increased, it would make sense that more supplies would be used and more staff would be on-site, prepared for higher volumes - just as the busy times of the hospital were predicted in prior flexible budgets and analyses. (But supplies were reported as lower than expected which doesn’t match up) If I know Mr. Schuler, he is going to be very angry about quality control if I cannot figure out why my supplies were less than estimated and even more livid if we were detrimentally overstaffed; my job may even be in jeopardy! Calm down! Breathe. As I type, I am beginning to believe these variances are not my fault at all. But, I had never imagined switching from the fixed to variable expense department would include such a string of headaches. I must rise to this challenge and pull out every stop in my detection-correction plan while investigating these variances.......

Words: 1082 - Pages: 5


...Variance Analysis Health care is in itself an extraordinarily intricate business. Health care executives now have to find ways to transform a broken and out of date health cares system by focusing on reducing pointless surgeries and diagnostic test and removing disproportionate health care costs. When the annual budget presents itself and shows that salaries are steadily increasing with supplies decreasing several factors have to be considered when presenting the variance analysis report. Factors that should be considered are the number of staffing, patient bed occupancy, specialist care and supplies. In order to control cost the executive must be able to recognize the problem and its cause and have a solution in place to correct it. Evaluating the current costs against the previous costs of the hospital should suggest to executives which factors have contributed to the change. (Cleverley, Cleverley, Song 2011). In this situation it is the salaries increasing and supplies decreasing. These two factors have to be heavily investigated prior to the analysis report. The first factor to consider will be the increase in salaries that were more than what were budgeted for. The most important and largest asset of the hospital are the people that are employed. In regards to the variance report the first consideration to the employment would be to consider those that are employed under a contract. These costs cannot be controlled, however renegotiating the contract can......

Words: 985 - Pages: 4

Kelsey Budget Report

...Kelsey Budget Report September 24, 2012 Kelsey Budget Report Kelsey is located in the Northwest valley and has a population of over 600,000 residents. Kelsey’s budget plays an important role in the City of Kelsey Government. Kelsey has an extensive budget and financial report because of the size of the city and the number of residents that live in the city. Recently the mayor of Kelsey has put in a request to Kerry, the budget director. The request asks that the budget director needs to revamp the City of Kelsey budget for the upcoming year. Because of an increase in population in the City of Kelsey, statistics show an increase in crime in the City of Kelsey that is above the norm. This brings about a need for more police officers (University of Phoenix, 2011). Another issue is the recent reduction in federal pass-through funds, which will have a negative impact the budget for the City of Kelsey. At the federal level, a budget reform has put pressure on the City of Kelsey and other policing agencies to implement the use of federal funds within the allotted period. The mayor of Kelsey does not believe that state aid is an option for the City of Kelsey to make up the budget deficit, and increasing taxes does not appear to be an option because the state and local government does not want to increase taxes as this time. A final issue is a local club; the Sierra Club does not want more police officers and instead wants the City of Kelsey and the state to build......

Words: 1494 - Pages: 6

Variance Reporting

...Variance Reporting As a manager for a variable department within a hospital, it sounds like I will certainly endure many challenges as it relates to budgeting. But mostly, because I'm faced with the challenge of not having a fixed budget for the department I'm managing. For this purpose I will be the manager of this department with a flexible budget or a variable budget. First we would need to understand what a a variable budget is. Most variable departments run based on luck, because the budget isn't a standard fixed budget its a chance taken each month that expenses will cover each other based on what portions of the budget or under and/or over budget. This sometimes how a variable department operates. We will also examine a variance report. In terms of the budget, a variable budget means that there is no determined dollar amount to allot for certain items in the budget. It is the examination of the deviation of an actual observation from the standard. Of course, in this scenario I don't have to opportunity to have a budget that remains constant, instead I am faced with a flexible budget as it relates to payroll. If I were to receive my monthly budget report and it has imbalanced findings because it is off budget, it would be bit concerning for me. The goal of a financial manager is to provide accurate budgets based on their reporting. Part of my duties include the financial success of the department. Presenting anything that falls short of the projections made by......

Words: 769 - Pages: 4


...costing is not allowed. ▪ Drives inappropriate activities. A number of the variances reported under a standard costing system will drive management to take incorrect actions to create favorable variances. For example, they may buy raw materials in larger quantities in order to improve the purchase price variance, even though this increases the investment in inventory. Similarly, management may schedule longer production runs in order to improve the labor efficiency variance, even though it is better to produce in smaller quantities and accept less labor efficiency in exchange. ▪ Fast-paced environment. A standard costing system assumes that costs do not change much in the near term, so that you can rely on standards for a number of months or even a year, before updating the costs. However, in an environment where product lives are short or continuous improvement is driving down costs, a standard cost may become out-of-date within a month or two. ▪ Slow feedback. A complex system of variance calculations are an integral part of a standard costing system, which the accounting staff completes at the end of each reporting period. If the production department is focused on immediate feedback of problems for instant correction, the reporting of these variances is much too late to be useful. ▪ Unit-level information. The variance calculations that typically accompany a standard costing report are accumulated in aggregate for a company’s entire production......

Words: 2842 - Pages: 12


...Advanced Variance Analysis: Calculation and Interpretation Subject: Professional 1 Strategic Management Accounting. Variance analysis is examinable both at Formation 2 (Management Accounting) and at Professional 1 (Strategic Management Accounting) levels. One main difference in syllabus between the two papers is that the Professional 1 (Strategic Management Accounting) syllabus includes ‘advanced’ variances, as follows: • • • • Materials mix & materials yield variances; Sales mix & sales quantity variances; Planning & operational variances; Market share & market size variances. Two issues which students need to master in order to score well in a question on advanced variance analysis are: 1. Accurate knowledge of the formulas. In my experience, examination candidates are much more likely to remember the formulas correctly if they understand the relationship between ‘advanced’ variances and ‘basic’ variances. Therefore, this will guide my approach to the examples in this article. 2. Ability to write a good quality narrative interpretation of the causes of the variances. The golden rule here is that it is not adequate to explain each variance in isolation. Thus, it is not enough to write (for example) ‘this company had an unfavourable market size variance because its actual market share was less than its budgeted market share’. You need to explain the apparent reasons why their actual market share was less than their budget market share,......

Words: 2719 - Pages: 11

Budget Variance

...Lawsuit in the Hospital It is an indisputable fact that health care business inherently carries a unique set of risks as a business organization; lawsuits by patients are common. What is not common is the fact that a trained professional who has sworn by the Hippocratic Oath to “do no harm,” would seek to file a lawsuit against a hospital because his service is no longer needed because of the new direction that the hospital is going (Grand Canyon University, 2011). To be fair, this physician is claiming an “injury.” It is also fair and true to say that this claim was made after this physician was notified that the relationship will be severed after four months. Due to the sequence of events and the circumstances of this case, any logical, objective, and fair-minded observer would question the underlying motive of this claim and, subsequently, its validity. However, since cases like this are not usually adjudicated in the moral court or court of public opinions, this facility is prepared to explore its options and seek resolution either through a formal arrangement, a formal institution, or a legal entity such as the following: Court of law, arbitration, mediation, and / or settlement. In order to make an informed and appropriate decision, it is not only necessary to analyze and fully understand each choice conceptually and practically, but it is also important to assess the pros and cons as well. ......

Words: 1490 - Pages: 6


...Sharp Hospital: Variance Report Dominic C. Flores Grand Canyon University April 20, 2016 Sharp Hospital is growing tremendously. As an organization, it is important to quantify and identify the differences that the organization has with expenditures and revenues every quarter and at every fiscal year. In this case, variance is calculated by comparing Sharp Hospital’s financial budget. The purpose of tracking budgets for the organization is to identify the planned financial outcomes and the actual financial outcomes. As a growing industry, it is highly important to have a financial framework to help make decisions in financial budgeting for the organization. As most managers are aware, the operating budgeting process comprises two parts—budget setting, in which budgets are established prior to the beginning of each fiscal year, and budget management, in which budgets should be monitored and controlled (Clark, 2005). After acquiring Sharp Hospital’s monthly budget results, it stated that employees’ salaries were higher than the supplies available. The possibilities could be various of reasons. Variance Reporting The heading above would be used if you want to have your paper divided into sections based on content. This is the first level of heading, and it is centered and bolded with each word of four letters or more capitalized. The heading should be a short descriptor of the section. Note that not all papers will have headings or subheadings in them. First......

Words: 750 - Pages: 3

Budget Variance

...Budget Variance Every hospital faces many challenges, but one of the most difficult challenges is knowing how to manage expenses. When a hospital is planning their budget not only do they have to plan a budget that is beneficial for their staff but also high level care for their patients. With so much in society changing such as technology, increase health care cost, and government restrictions it makes planning the budget very challenging. In order to analyze how expenses are being spent compared to the budget that is allotted for them, budget variances have to be made (accountingtools.com, 2013). These variances have to be extremely well detailed in order to make an accurate budget for the following year. Things that should be taken into consideration when doing a budget variance are variance reports, interpreting the results of variance reports and analyzing these reports based on actual performance, and developing a way to better the budget based on these results. The purpose of this paper is to fully analyze all factors that should be considered for a budget variance for a hospital. The very first step for a budget variance is to develop a variance report (accountingtool.com, 2013). There are various factors that should be analyzed to produce a proper variance report such as how many beds are available, how many patients are seen daily, how much staff is available or working in a specific day, how many supplies will be used, and how much utilities such as......

Words: 1018 - Pages: 5

Biden Reports Progress on Budget Deal

...This article is about the budget deal that’s currently being debated about that would cut federal spending by as much as 33 billion dollars and dodge a government shutdown. As of right now, there is a difference in what should be included in it and not included in the budget. If the deal were to be approved, the deal would be the largest single year budget cut in U.S. history. The government would be funded through the current fiscal year, which ends in September, and then end stopgap resolutions. The senate and the house have agreed on 10 billion dollars in budget cuts, but they are now searching for another 23 billion dollars in cuts according to lawmakers and aides from both sides. House leaders said they will vote March 31st to make their bill for 61 billion dollars in budget cuts if the senate fails to act by April 8th. How it would pass constitutionally is not likely, as the Senate has rejected that bill and President Obama has vowed to veto it. House Republicans are very frustrated because the Senate Democrats haven't submitted their proposal yet. This bill will most likely die and not become a budget in my opinion. This article relates to American government because it involves the House of Representatives, the Senate and the President in proposing bills and budgets. It basically relates to how a bill becomes a law. The House of Representatives seem to be the only ones who appear to favor the budget while the Senate and President do not. In order for a bill like......

Words: 478 - Pages: 2