Car-B-Clean Accessories						
Profit Analysis						
Item	Unit Cost	Unit Profit	Units Sold	Total  Sales	Total Profit	% Total Profit
Brush	5.84	3.15	36751	=D4 * (B4+C4)	=D4 * C4	=F4 / E4
Bucket	7.14	2.75	57758	=D5 * (B5+C5)	=D5 * C5	=F5 / E5
Drying Cloth	3.52	1.17	42555	=D6 * (B6+C6)	=D6 * C6	=F6 / E6
Duster	2.55	1.04	78816	=D7 * (B7+C7)	=D7 * C7	=F7 / E7
Polish	7.19	7.8	57758	=D8 * (B8+C8)	=D8 * C8	=F8 / E8
Soap	8.52	4.09	50646	=D9 * (B9+C9)	=D9 * C9	=F9 / E9
Sponge	2.05	1.84	23154	=D10 * (B10+C10)	=D10 * C10	=F10 / E10
Wax	10.15	7.44	53099	=D11 * (B11+C11)	=D11 * C11	=F11 / E11
Vacuum	43.91	33.09	17780	=D12 * (B12+C12)	=D12 * C12	=F12 / E12
Totals			=SUM(D4:D12)	=SUM(E4:E12)	=SUM(F4:F12)	=F13 / E13
Lowest	=MIN(B4:B12)	=MIN(C4:C12)	=MIN(D4:D12)	=MIN(E4:E12)	=MIN(F4:F12)	=MIN(G4:G12)
Highest	=MAX(B3:B12)	=MAX(C3:C12)	=MAX(D3:D12)	=MAX(E3:E12)	=MAX(F3:F12)	=MAX(G3:G12)
Average	=AVERAGE(B4:B12)	=AVERAGE(C4:C12)	=AVERAGE(D4:D12)	=AVERAGE(E4:E12)	=AVERAGE(F4:F12)