Gulham_Exp19_Excel_Ch02_Cap_Appliances.xlsx

	A	B	C	D	E	F	G	H
1	W.C. Hicks Appliances
2	Date Prepared:
3
4	Client Name	SKU	Item Name	Delivery	Price	Total Due	Years	Monthly Payment
5	Garten	294211		Yes			3
6	Leggett	327064		Yes			5
7	Vong	446741		No			3
8	Ranger	643081		No			5
9	Williams	294211		No			3
10	Davis	446741		No			3
11	Jackson	306862		Yes			4
12	Garcia	643081		No			4
13	Broadnax	446741		Yes			5
14	Totals
15
16	Inventory Information
17	SKU	Description	Price			Summary Statistics
18	294211	Refrigerator	$1,399.00			Number of Orders
19	306862	Dishwasher	$809.99			Lowest Monthly Payment
20	327064	Microwave	$379.99			Average Monthly Payment
21	446229	Oven	$1,099.99			Maximum Monthly Payment
22	446741	Washer	$467.99			Median Monthly Payment
23	643081	Dryer	$599.99
24
25	Delivery Fee	$75.00
26	Interest Rate	3.25%
27	Months Per Year	12
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100