Authentic Assessment Module 13: Variance Analysis

Open your Excel Workbook and name a new tab Variance Analysis. Modeling your analysis on the template I have provided in the workbook in Resources, use the information below on the Green River Fertilizer Company to compute standard costs, variances, and journal entries. I would strongly suggest you re-create the Standard Cost Card on your Excel spreadsheet to use in calculating the variances (which need to be done in the three-prong method). As always, the model should be well formatted and have formulas and linked cells where possible. Your variances must be in absolute terms (no parentheses, red ink, or negatives) and include a U or F. Please use cell highlighting so I can find your numbers easily (in other words, fill the background with a light shade). Dont forget that we are using standard costing in our journal entries! Please place your journal entries to the right of the variance charts.

Green River Fertilizer Company

At the beginning of the year, GRFC had the following standard cost sheet:

Standard Cost Sheet for Green River Fertilizer Company
Direct materials (5 lbs. @ $2.60/lb.)	$13.00
Direct labor (0.75 hr. @ $18.00/hr.)	13.50
Fixed overhead (0.75 hr. @ $4.00)	3.00
Variable overhead (0.75 hr. @ $3.00)	2.25
Standard cost per unit	$31.75

GRFC computes its overhead rates using practical volume, which is 54,000 units. Sales price per unit is $32 and the company budgeted for sales of 54,000 units. The actual results for the year are as follows:

1. Units produced: 53,000
2. Direct materials purchased: 274,000 pounds at $2.50 per pound
3. Direct materials used: 270,300 pounds
4. Direct labor: 40,100 hours at $17.95 per hour
5. Fixed overhead: $161,700
6. Variable overhead: $122,000
7. Actual Revenue: $1,700,000

Required

1. Construct a model to calculate:
   1. Total Variance
   2. Sales Volume Variance
   3. Sales Price Variance
   4. Flexible Budget Variance