Flexible budgeting case - activity versus spending variances

Assignment Help Case Study
Reference no: EM13882122

Flexible budgeting case - activity versus spending variances

Due to global warming, demand for milk shares was much larger than expected. The amount of large milk shakes actually sold in January were 85,000 (10,000 over budget) while the amount of small milk shakes actually sold in January were 45,000 (5,000 under budget). The budgets prepared above were planned prior to the beginning of the year and are valid for the planned level of sales activity. If the actual level of sales activity differs from the planned level, comparing our budgets above with actual results may lead to incorrect conclusions about performance. Therefore we must prepare a FLEXBLE budget that adjusts revenues and expenses given the actual level of sales activity that occurred.

Please Fill in the Flexible budget based on actual sales for both size milk shakes.

Fill in the activity variance and the spending variance amounts as well as indicate whether they are favorable or unfavorable for both size milk shakes.

Large Milk Shakes - Flexible Budget Performance Report for the Month ended January 31

Planned Budget based on budgeted sales of 75,000 milk shakes

Activity Variances

Flexible budget based on actual sales of 85,000 milk shakes

Spending Variances

Actual results based on actual sales of 85,000 milk shakes

Revenue ($9.00q)

$675,000

$765,000

Less: Cost of goods sold ($2.81q)

$210,750

$220,000

Gross Profit

$464,250

$545,000

Less:  Operating expenses

8,764

10,317

Operating Income

$455,486

$534,683

Income tax expense (tax rate = 35%)

$159,420

$187,139

Net Income

$296,066

$347,544

Small Milk Shakes - Flexible Budget Performance Report for the Month ended January 31

Planned Budget based on budgeted sales of 50,000 milk shakes

Activity

Variances

Flexible budget based on actual sales of 45,000 milk shakes

Spending

Variances

Actual results based on actual sales of 45,000 milk shakes

Revenue ($6.30q)

$315,000

$283,500

Less: Cost of goods sold ($2.18q)

$109,000

$100,500

Gross Profit

$206,000

$183,000

Less:  Operating expenses

5,843

 

5,928

Operating Income

$200,157

$177,072

Income tax expense (tax rate = 35%)

$70,055

$61,975

Net Income

$130,102

$115,097

Reference no: EM13882122

Questions Cloud

Mixture of maleic anhydride and benzoic acid : A mixture of maleic anhydride and benzoic acid containing 10 mol% acid is a product of the manufacture of phthalic anhydride.
Financial intermediaries perform that benefit society : What are the economic functions that financial intermediaries perform that benefit society? In your answer, discuss the relationship of financial intermediaries and financial markets to the savings-investment process within an economy and to each oth..
Liquidity premium is required on any treasury security : Suppose the rate of return on a 10-year T-bond is 6.55%, the expected average rate of inflation over the next 10 years is 2.0%, the MRP on a 10-year T-bond is 0.9%, no MRP is required on a TIPS, and no liquidity premium is required on any Treasury se..
Distillation and membrane separation steps : A mixture of ethanol and benzene is separated in a network of distillation and membrane separation steps. In one intermediate step, a near-azeotropic liquid mixture of 8,000 kg/h of 23 wt% ethanol in benzene is fed to a pervaporation membrane cons..
Flexible budgeting case - activity versus spending variances : Fill in the activity variance and the spending variance amounts as well as indicate whether they are favorable or unfavorable for both size milk shakes.
Calculate expected rate on five year treasury bond purchased : The Wall Street Journal reports that the current rate on 5-year Treasury bonds is 2.85 percent and on 10-year Treasury bonds is 5.35 percent. Assume that the maturity risk premium is zero. Calculate the expected rate on a 5-year Treasury bond purchas..
How would you choose between the two models a priori : To study the relationship between domestic and world prices, you are given the following models: Yt = α1 + α2  Xt + ut  , Yt = β2 Xt + ut - How would you choose between the two models a priori?
What is the benefit cost ratio of the regulation : If it is estimated that there are 90 million households in the United States and that the lower standard can save 50 lives per year valued at $4,000,000 per life, what is the benefit/cost ratio of the regulation?
Partial reboiler-saturated-liquid reflux : A mixture of acetone and isopropanol containing 50 mol% acetone is to be distilled continuously to produce an overhead product containing 80 mol% acetone and a bottoms containing 25 mol% acetone. If a saturated-liquid feed is employed, if the colu..

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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