Dog boarding

	A	B	C	D	E	F	G	H	I
1	Boarding
2	Days	4
3			Rates		Day 1	Days 2 & 3	Days 4-7	Days 8-14	Add’l days
4			Rates		$22.00	$20.00	$17.00	$14.00	$12.00
5			Number of days by rate		1	2	1
6	Total	$79.00	Totals by rate		$22.00	$40.00	$17.00
7	Add’l Dogs
8	# of Add’l	2
9	Totals by dog	$47.40	first @	60%	$13.20	$12.00	$10.20	$8.40	$7.20
10		$47.40	first @	$47.40	$13.20	$24.00	$10.20
11		$39.50	second @	50%	$11.00	$10.00	$8.50	$7.00	$6.00
12		$39.50	second @	$39.50	$11.00	$20.00	$8.50
13			third @	40%	$8.80	$8.00	$6.80	$5.60	$4.80
14			third @	$0.00
15	Total	$86.90	Totals by rate		$24.20	$44.00	$18.70
16	Total
17	Grand Total	$165.90	All dogs – totals by rate		46.2	84	35.7
18	Day Care
19	Consecutive	y	Discounts
20			Standard	10%	41.58	75.6	32.13
21			Consecutive	10%	37.42	68.04	28.92
22	Std -10%	$149.31
23	Grand Total	$134.38
24
25	Other Services
26			(description)
27			(description)
28			(description)
29	Total	n/a
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