Home Insert Page Layout Formulas Data A Performance Report, June 2017 Actual Static Budget 447,000 2 Results 3 Units (pounds) 4 Revenues 5 Variable manufacturing costs 6 Contribution margin 460,000 $2,626,600 1,651,400 $ 975,200 $2,592,600 1,564,500 $1,028,100 Jeff Geller, the business manager for ice-cream products, is pleased that more pounds of ice cream were sold than budgeted and that revenues were up. Unfortunately, variable manufacturing costs went up, too. The bottom line is that contribution margin declined by $52,900, which is just over 2% of the budgeted rev- enues of $2,592,600. Overall, Geller feels that the business is running fine. 1. Calculate the static-budget variance in units, revenues, variable manufacturing costs, and contribu- tion margin. What percentage is each static-budget variance relative to its static-budget amount? 2. Break down each static-budget variance into a flexible-budget variance and a sales-volume variance. 3. Calculate the selling-price variance. 4. Assume the role of management accountant at Cascade. How would you present the results to Jeff Geller? Should he be more concerned? If so, why? Required

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 4R
icon
Related questions
Topic Video
Question

Flexible-budget and sales volume variances. Cascade, Inc., produces the basic llings used in many popular frozen desserts and treats—vanilla and chocolate ice creams, puddings, meringues, and fudge. Cascade uses standard costing
and carries over no inventory from one month to the next. The icecream product group’s results for June 2017 were as follows:

Home
Insert
Page Layout
Formulas
Data
A
Performance Report, June 2017
Actual
Static Budget
447,000
2
Results
3 Units (pounds)
4 Revenues
5 Variable manufacturing costs
6 Contribution margin
460,000
$2,626,600
1,651,400
$ 975,200
$2,592,600
1,564,500
$1,028,100
Jeff Geller, the business manager for ice-cream products, is pleased that more pounds of ice cream were
sold than budgeted and that revenues were up. Unfortunately, variable manufacturing costs went up, too.
The bottom line is that contribution margin declined by $52,900, which is just over 2% of the budgeted rev-
enues of $2,592,600. Overall, Geller feels that the business is running fine.
1. Calculate the static-budget variance in units, revenues, variable manufacturing costs, and contribu-
tion margin. What percentage is each static-budget variance relative to its static-budget amount?
2. Break down each static-budget variance into a flexible-budget variance and a sales-volume variance.
3. Calculate the selling-price variance.
4. Assume the role of management accountant at Cascade. How would you present the results to Jeff
Geller? Should he be more concerned? If so, why?
Required
Transcribed Image Text:Home Insert Page Layout Formulas Data A Performance Report, June 2017 Actual Static Budget 447,000 2 Results 3 Units (pounds) 4 Revenues 5 Variable manufacturing costs 6 Contribution margin 460,000 $2,626,600 1,651,400 $ 975,200 $2,592,600 1,564,500 $1,028,100 Jeff Geller, the business manager for ice-cream products, is pleased that more pounds of ice cream were sold than budgeted and that revenues were up. Unfortunately, variable manufacturing costs went up, too. The bottom line is that contribution margin declined by $52,900, which is just over 2% of the budgeted rev- enues of $2,592,600. Overall, Geller feels that the business is running fine. 1. Calculate the static-budget variance in units, revenues, variable manufacturing costs, and contribu- tion margin. What percentage is each static-budget variance relative to its static-budget amount? 2. Break down each static-budget variance into a flexible-budget variance and a sales-volume variance. 3. Calculate the selling-price variance. 4. Assume the role of management accountant at Cascade. How would you present the results to Jeff Geller? Should he be more concerned? If so, why? Required
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 15 images

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub