JUST DO NUMBER 5

Vermonts Best Maple Syrup Variance Case- JUST DO NUMBER 5

Vermonts Best Maple Syrup Inc. is a small business selling a single product, pure Vermont maple syrup, since 1939. Their best-seller is the one-pint jug. The companys relevant range of production is between 600,000 and 800,000 jugs a year. Within the relevant range, variable costs per jug and total annual fixed costs remain constant. The company has the following data from its standard cost system.

Standard Costs
Variable costs per jug:
Direct materials (5 gallons at $1.10 per gallon of maple tree sap)	$5.50
Direct labor (0.04 direct labor hour at $15 per hour)	$0.60
Variable mfg. overhead (0.04 direct labor hour at $20 per hour)	$0.80
Selling and administrative expenses	$1.50
Fixed costs per year:
Mfg. overhead	$910,000
Selling and administrative expenses	$650,000

The planning budget income statement is based on the expectation of selling 700,000 jugs of maple syrup. The budgeted selling price is $14 per jug.

For planning and control purposes, the company relies on its standard costs to derive their budgeted costs per jug of maple syrup. For example, the cost of direct materials reported on the planning budget income statement is calculated as $5.50 per jug time 700,000 jugs, which is $3,850,000. Also, the denominator level of activity is calculated as 0.04 direct labor hour per jug times 700,000 jugs, which is 28,000 direct labor hours.

The company actually produced and sold 720,000 jugs at $15 per jug this year. The company does not have a beginning or ending raw materials inventory, because it uses all raw materials purchased. Also, the company does not have a beginning or ending finished goods inventory. Everything produced in the year is sold in that same year.

The actual income statement for the year is provided below.

Vermonts Best Maple Syrup Inc.
Actual Income Statement
Sales (720,000 jugs produced and sold at $15 per jug)	$10,800,000
Less Variable Costs:
Direct materials (3,420,000 gallons at $1.25 per gallon)	4,275,000
Direct labor (36,000 direct labor hours at $16 per hour)	576,000
Variable manufacturing overhead	640,800
Variable selling and administrative costs	1,296,000
Contribution margin	4,012,200
Less Fixed Costs:
Fixed manufacturing overhead costs	888,000
Fixed selling and administrative costs	702,000
Net operating income	$2,422,200

Required:

1. Prepare a detailed income statement variance analysis using the contribution approach income statement for the year (i.e., compare the actual income statement with the flexible budget income statement and compare the flexible budget income statement with the planning budget income statement). Show all the revenue, spending, and activity variances appearing in the income statement analysis. A template for answering this question is given below. All variances should be marked with either an F for favorable or U for unfavorable. (30 points)

Vermonts Best Maple Syrup Inc. Income Statement Variance Analysis

	Actual		Revenue & Spending		Flexible	Activity		Planning
	Results		Variances		Budget	Variances		Budget
Sales	$$$		$$$		$$$	$$$		$$$
Less V.C.
DM	$$$		$$$		$$$	$$$		$$$
DL	$$$		$$$		$$$	$$$		$$$
V-MOH	$$$		$$$		$$$	$$$		$$$
V-S&A	$$$		$$$		$$$	$$$		$$$
CM	$$$		$$$		$$$	$$$		$$$
Less FC
F-MOH	$$$		$$$		$$$	$$$		$$$
F-S&A	$$$		$$$		$$$	$$$		$$$
NOI	$$$		$$$		$$$	$$$		$$$

2. Suppose your boss Mr. Coolidge is in the process of evaluating how well the company performed in terms of generating revenues and controlling costs. Mr. Coolidge would like to compare the actual income statement with the planning budget income statement. Could you use the variance analysis from Part 1 to persuade him, who is kind of stubborn, that the company should compare the actual income statement with the flexible budget income statement instead? Your explanation should not be more than 1/2 page double spaced with a 12 font size. (10 points)

3. Prepare a very detailed manufacturing cost variance analysis (e.g., calculate the material price variance and quantity variance; the labor rate variance and efficiency variance; the variable overhead rate variance and efficiency variance; and the fixed manufacturing overhead budget variance and volume variance). All variances should be marked with either an F for favorable or U for unfavorable. Show your calculations. (40 points)

4. Could you reconcile the spending variances in Part 1 with manufacturing cost variances in Part 3? For example, how is the amount of spending variance for direct labor in Part 1 explained by the amounts of the two direct labor variances in Part 3? Excluding your quantitative analysis if any, your explanation should not be more than 1/2 page double spaced with a 12 font size. (10 points)

5. Could you help Mr. Coolidge evaluate the companys performance in controlling direct labor costs by interpreting relevant variances from Part 1 and Part 3? Excluding your quantitative analysis if any, your explanation should not be more than 1/2 page double spaced with a 12 font size. (10 points)