A	B	C	D	E	F	G	H	I	J
1	TABLE 1: SOLARTRONICS VARIABLE COSTING		Actual for January (assumes a $0 sales price variance)	Flexible budget variances (the expense variances below pertain to January's actual production of 208.33 units and sale of 275.00 units.)	Flexible budget for January's sales	Sales volume variance	(Static) Average monthly budget	(Static) Annual budget	Budgeted (standard) cost/price per unit
2	Units sold
3	Revenue
4	Variable expenses
5	Direct labour
6	Direct material
7	Factory overhead
8	Sales commission
9	Total variable expenses
10	Contribution margin
11	Fixed expenses
12	Factory overhead
13	Selling
14	General corporate
15	Total fixed expenses
16	Profit/(loss) before tax
19
21
22	TABLE 2: Determination of Solartronic's January's actual unit production
23	Remember: production volume variance = [std fixed factory overhead rate per unit x (actual unit volume - budgeted unit volume)]							INSTRUCTIONS: You can input data into the yellow-shaded cells only. All other cells on this and other screens are generated automatically.
24	Annual budgeted fixed factory overhead			Data provided by the case study
25	Annual budgeted unit volume			Data provided by the case study
26	Standard fixed factory overhead rate per unit
27	Average monthly budgeted unit volume
28	January's budgeted fixed factory overhead
29	January's production volume variance			Data provided by the case study
30	January's production volume variance in units
31	January's actual production volume in units						Note: = 50.00% of the 416.67 average monthly budgeted unit volume.
32	January's actual sales in units (from Cell C2 in Table 1)			Data provided by the case study (Cell C2 in Table 1)
33	Increase/(decrease) in unit inventory during January
34
35	Amount of previous months' budgeted fixed factory/production overhead released into January's Absorption Costing Income Statement. [($5,600) = $84 x -66.67 units.]
36	Difference identified in the TABLE 1's variable costing analysis (see Cells D19:F19 above).
37	Difference between January's budgeted and actual absorption costing profit amounts
38
39	[The default-data on this screen is adapted from Solartronic, Inc (pages 444/5, Management Control Systems, Twelfth Edition, Robert N. Anthony & Vijay Govindarajan, 2007, McGraw-Hill Irwin), a case study written by Professor M. Edgar Barrett.]
40
41	Copyright (c) Brian A. Conheady. All Rights Reserved.
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63