rendered paste bodyCar-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)