Capstone assignment( Admin2390- Capstone Experience for APT

kishan1934
PR7-06.xlsx

Quarter 3

Harmony Teas
Sales Projection
July August September Total
Revenue
Black and Green Teas $ 2,800.00 $ 3,080.00 $ 3,388.00 $ 9,268.00
Herbal Teas $ 5,000.00 $ 5,500.00 $ 6,050.00 $ 16,550.00
Total Revenue $ 7,800.00 $ 8,580.00 $ 9,438.00 $ 25,818.00
Expenses
Advertising 1,500.00 1,500.00 1,500.00 4,500.00
Cost of Sales: 60% 4,680.00 5,148.00 5,662.80 15,490.80
Total Expenses $ 6,180.00 $ 6,648.00 $ 7,162.80 $ 19,990.80
Net Revenue $ 1,620.00 $ 1,932.00 $ 2,275.20 $ 5,827.20

Projected Sales

Qtr 1 Qtr 2 Qtr 3 Qtr 4
Geen & Black Teas $ 2,500.00 $ 3,300.00 $ 12,000.00 $ 7,200.00
Herbal Teas $ 2,800.00 $ 4,800.00 $ 17,000.00 $ 11,000.00