Variance Analysis: A Practical Guide with Exercises - Prof. Susan M. Curtis, Assignments of Management Accounting

A comprehensive guide to variance analysis, a crucial tool in cost accounting. It covers the calculation of various variances, including flexible budget variance, activity variance, and master budget variance. The document also includes practical exercises to reinforce understanding and application of the concepts. It is particularly useful for students studying cost accounting and financial management.

Typology: Assignments

2023/2024

Uploaded on 12/09/2024

h0ray
h0ray 🇺🇸

1 document

1 / 6

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Exhibit 1. Current Quarter Actual and Budgeted Results
Current Quarter
Actual Results Master Budget
Number of Cases Sold 99,000 100,000
Sales Revenue $2,663,100 $2,690,000
Less: Variable Costs
Direct Materials-Block Cheese 2,156,220 $1,890,000
Direct Labor 181,170 $150,000
Variable Overhead 354,420 $300,000
Contribution Margin $ (28,710) $ 350,000
Less: Fixed Costs - Selling & Administrative $152,500 $150,000
Operating Income $ (181,210) $ 200,000
Exhibit 2. Select Product Data
Actual Budget
Sales Revenue
Number of Cases Sold 99,000 100,000
Selling Price per Case $26.90 $26.90
Direct Materials
Block Cheese
Cost per Pound of Block Cheese $3.30 $3.00
Pounds of Cheese per Case 6.6 6.3
Pounds of Block Cheese Purchased & Used 653,400 600,000
Direct Labor
Hourly Rate $15.25 $15.00
Production Labor Hours per Case 0.12 0.10
Variable Manufacturing Overhead
Rate per Case $3.58 $3.00
Fixed Costs - Selling & Administrative $152,500 $150,000
pf3
pf4
pf5

Partial preview of the text

Download Variance Analysis: A Practical Guide with Exercises - Prof. Susan M. Curtis and more Assignments Management Accounting in PDF only on Docsity!

Exhibit 1. Current Quarter Actual and Budgeted Results

Current Quarter

Actual Results Master Budget Number of Cases Sold 99,000 100, Sales Revenue $2,663,100 $2,690, Less: Variable Costs Direct Materials-Block Cheese 2,156,220 $1,890, Direct Labor 181,170 $150, Variable Overhead 354,420 $300, Contribution Margin $ (28,710) $ 350, Less: Fixed Costs - Selling & Administrative $152,500 $150, Operating Income $ (181,210) $ 200,

Exhibit 2. Select Product Data

Actual Budget Sales Revenue Number of Cases Sold 99,000 100, Selling Price per Case $26.90 $26. Direct Materials Block Cheese Cost per Pound of Block Cheese $3.30 $3. Pounds of Cheese per Case 6.6 6. Pounds of Block Cheese Purchased & Used 653,400 600, Direct Labor Hourly Rate $15.25 $15. Production Labor Hours per Case 0.12 0. Variable Manufacturing Overhead Rate per Case $3.58 $3. Fixed Costs - Selling & Administrative $152,500 $150,

Ratio of the variance Price

-0.

$0 U + (1,000) F =

Variable Costs Direct Materials-Block Cheese 285,120 U + (18,900) F = Direct Labor 32,670 U + (1,500) F = Variable Overhead 57,420 U + (3,000) F = Fixed Costs + = (c) For sales revenues, reverse the sign used for favorable/unfavorable classifications applied to costs. In other wo

5. Reconcile the flexible budget variance from Q4 with price and quantity variance.

Correctly rate the variance as either Favorable or Unfavorable using the dropdown menus in Colu

Price Quantity Variance Variance Variable Costs Direct Materials-Block Cheese 196,020 U + 89,100 U = Direct Labor 2,970 U + 29,700 U = Variable Overhead (1,980) F + 59,400 U =

6. The controller, Terry, will investigate the causes of price and quantity variances if they are deem

A variance is considered significant if it meets one of the following conditions:

1.Variance in dollar amount > $10,000, OR

2.The ratio of the variance to the standard costs allowed for actual sales/production volumes (

Use the "IF" function in Excel to identify significant variances. For [value_if_true], enter "Signific

Price Quantity Ratio of the variance Variance Variance Quantity Variable Costs 4.76 Direct Materials-Block Cheese Significant Significant 20.00 Direct Labor Significant 20.00 Variable Overhead Significant Sales Revenue (c)

nd standard cost per unit.

hours. Correctly indicate input units in Columns N and S.

Standard input Standard cost

per unit

$3.00 /lb = $18.90 /unit

$15.00 /lb = $1.50 /unit

$30.00 /lb = $3.00 /unit

ual cost per unit.

hours. Correctly indicate input units in Columns N and S.

Actual input Actual cost

per unit

$3.30 = $21.78 /unit

$15.25 = $1.83 /unit

$29.83 = $3.58 /unit

mpany produces exactly to meet the demand (i.e., sales volume equals production volume).

Flexible Master

Budget Budget

ided into price and quantity variances as with variable costs, assume the same values as those in the flexible budget. to price and quantity variances as with variable costs, assume the same values as those in the flexible budget.

er budget variance.

using the dropdown menus in Columns L, O, and R.

Master Budget Variance

Use cell references in all your answers.

price (SPinput)

price (APinput)