Q2 Forecasts

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 2

April

Products
Candy - Bonjour
Biscuit - Munchy's
Soft Drink - Pokka
Baby Napkin - Bao Bao
Shower Cream - HavyCare
Instant Coffee - MacCoffee
Detergent - VClean
Cigarette - Gillman
Total

Amount Margin
(USD)
(%)
0
12,000
8,000
2,000
2,000
6,000
6,000
4,000
40,000

8%
15%
13%
13%
13%
8%
15%
25%
14%

May
Margin
(USD)

Amount Margin Margin


(USD)
(%)
(USD)

0 10,000
1,800 30,000
1,040 15,000
260
5,000
260
5,000
480 15,000
900 15,000
1,000
5,000
5,740 100,000

8%
800
15%
4,500
13%
1,950
13%
650
13%
650
8%
1,200
15%
2,250
25%
1,250
14% 13,250

June
Amount Margin
(USD)
(%)
16,000
40,000
24,000
12,000
12,000
24,000
24,000
8,000
160,000

8%
15%
13%
13%
13%
8%
15%
25%
14%

June
Margin
(USD)
1,280
6,000
3,120
1,560
1,560
1,920
3,600
2,000
21,040

You might also like