A	B	C	D	E	F	G	H	I	J
1	Waltham Motors Exhibit 1					Year	2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050
2
3		1	5
4		Actual	Budget	Variances		Actual per unit	Budgeted (standard) per unit
5	Units
6	Sales
7
8	Variable manufacturing costs:
9	Direct material
10	Direct labour
11	Indirect labour
12	Idle time
13	Cleanup time
14	Miscellaneous supplies
15	Total variable manufacturing costs
16	Variable shipping costs
17	Total variable costs
18
19	Contribution margin
20
21	Nonvariable manufacturing costs:
22	Supervision
23	Rent
24	Depreciation								divided by	divided by
25	Other
26	Total nonvariable manufacturing costs
27	Selling and adminstrative costs
28	Total nonvariable and programmed costs
29
30	Operating income (loss)
31
32	[The default-data on this screen is adapted from Waltham Motors Division (case no. 184-169, Harvard Business School Publishing), a case study created by Professor William J. Bruns, Jr.
33
34	Waltham Copyright Brian A. Conheady. All rights reserved.
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54