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

  Explain the rationale behind adoption of normative theories

Explain the rationale behind adoption of normative theories and professional codes of conduct - Discuss the relation between justice, ethics and economic theories.

  Describe all assumptions seen in any of documents provided

prepare a report for the ceo of acuscan about the situation described in the gen 480 critical thinking case study. your

  Tourism describe various factors that are analyzed to study

describe various factors that are analyzed to study demographic profiles and their importance in tourism

  How the symptoms impact on his activities of daily living

What community assistance would be available for Mrs Barber whilst Mr Barber remains in hospital? Give an example of an allied health care worker who would make these arrangements prior to Mr Barbers discharge - What actions should you take now tha..

  Case study on it planning at modmeters

Discussion Question Develop an IT planning process for ModMeters to accomplish the demands as set out above.

  Consider array size 20 populated with random integer values

Write a recursive methodnmbDigitswhich takes an integer value as parameter and returns the number of digits of the parameter value (for examplenmbDigits(2054) is 4).

  Why you think configuration management change are difficult

Why do you think configuration management and project change control are difficult to perform in the middle of a complex software development project

  What are some of the accounting issues

Member contributions in the amount of $ 460,000 were received in cash, the city's General Fund also contributed $ 700,000 in cash.

  Explain the meaning of the introduction and preamble

Write a summary giving three examples of common violations of the DTPA by real estate professionals - Explain what is meant by an "assumptive close" - Explain the meaning of the Introduction and Preamble.

  Case stydy on case 22 - ebay

case stydy on Case 22 - eBay

  Are they most important criteria to be met by any university

Explain why you have chosen these criteria. Are they the most important criteria to be met by any University web site? If not which are?

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