Câu 1: Calculate workload of sales person
Time to serve Time trying to
Current
Sales person Account (per customer Prospects convert (per
per month) contract)
An 56 15 16 8
Binh 60 15 22 8
Linh 40 15 18 8
Câu 2: 2. Calculate Sale goal for each sales person in 2023, give that the Foreca
Buying power
Contact with Active
Sales person clients accounts (on average) mil Expenses
VND
An 352 150 1 10 mil. VND
Binh 260 180 1.5 12 mil. VND
Linh 220 120 0.8 8 mil. VND
Câu 3: 3. Report sales force effectiveness ratio of the best sales person
Buying power
Contact with Active Expenses Mil
Sales person clients accounts (on average) mil VND
VND
An 352 150 1 10
Binh 260 180 1.5 12
Linh 220 120 0.8 8
Câu 4: 4. Calculate Compensation for each sales person and Break-even numbe
Buying power
Sales person Contact with Active (on average) mil Expenses
clients accounts
VND
An 352 150 1 10
Binh 260 180 1.5 12
Linh 220 120 0.8 8
Câu 5: Calculate numeric distribution
Homiee currently distributes its products only through 3 supermarket chains inc
Numeric distribution = 3/5 = 60%
Câu 6: Calculate ACV
Sales of
Sales of Sales of Homiee
Sales of all toilet bedroom toilet
products perfume perfume (bil. perfume
Retailers (bil. VND) (bil. VND) VND) (mil VND)
Big C 450 1.2 1 325
Winmart 300 0.8 0.6 400
CoopMart 280 0.5 0.4 268
LoteMart 360 0.4 0.2 0
UniMart 120 1 0.5 0
Câu 7: 7. Calculate and compare PCV and Category performance ratio of toilet a
Sales of
Sales of Sales of Homiee
Sales of all toilet bedroom toilet
products perfume perfume (bil. perfume
Retailers (bil. VND) (bil. VND) VND) (bil VND)
Big C 450 1.2 1 0.325
Winmart 300 0.8 0.6 0.4
CoopMart 280 0.5 0.4 0.268
LoteMart 360 0.4 0.2 0
UniMart 120 1 0.5 0
Câu 8: 8. Given that revenue comes from only two sources: business customers
Buying power Business
Contact with Active
Sales person clients accounts revenue
(on average) mil (Mil)
VND
An 352 150 1
Binh 260 180 1.5 516
Linh 220 120 0.8
Sales of
Sales of Sales of Homiee
Sales of all toilet bedroom toilet
products perfume perfume (bil. perfume
Retailers (bil. VND) (bil. VND) VND) (bil VND)
Big C 450 1.2 1 0.325
Winmart 300 0.8 0.6 0.4
CoopMart 280 0.5 0.4 0.268
LoteMart 360 0.4 0.2 0
UniMart 120 1 0.5 0
Câu 9: 9. Given that the total Production cost in 2022 is 600 mil. VND and Inven
gross margin = Sales -
cost 1.254 GMROII (%) 6.27
câu 10: Calculate the Direct Profitability given that Warehouse direct cost, trans
Direct profitability 1.064
câu 11: 11. Calculate Out-of-stock (%)
On January of 2023, due to high demand yet disrupted supply of inputs, there is
Out of stock % 0.33333333333
Câu 12: 12. Calculate PCV Net Out-of-stock for January 2023, given that PCV is a
PCV Net Out of stock
Toilet perfumes 0.42735042735
Bedroom perfumes 0.49382716049
Câu 13: 13. Calculate Percentage on time delivery
Although there are 145 orders delivered in January, due to the difficulities in inp
Percentage on time delivery (%) 0.53793103448
Workload
968
1076
744
23, give that the Forecasted sales in 2023 for business customers is 800 mil. VND
Commission Year-end bonus Sales prior-year (sales potential)
2% 5 mil
150
2% 5 mil
270
2% 5 mil.
96
Total 516
st sales person
Commission expense/sales (%)
2% 0.0666666666667
2% 0.0444444444444
2% 0.0833333333333
and Break-even number of employees. Given than monthly salary is 10 mil. VND for ea
Compensation = Salary +
Commission Year-end bonus bonus +
(commission*sales) - 12
moths
2% 5 128
2% 5 130.4
2% 5 126.92
supermarket chains including BigC, Winmart, and CoopMart while there are 5 major sup
ACV
Sales of Homiee
bedroom perfume (mil
VND)
170 TỬ SỐ MẪU SỐ
100
75
1030 1510
0
0
ormance ratio of toilet and bedrom perfume
Sales of Homiee
bedroom perfume (bil
VND) PCV toilet perfumes
0.17 Tử số Mẫu số
0.1 2.5 3.9
0.75 PCV bedroom perfumes
0 Tử số Mẫu số
0 2 2.7
es: business customers and retailers and the Average Inventory is 100 mil. VND per mo
Retailers
Sales of Homiee revenue (bil)
bedroom perfume (bil
VND)
0.17
0.1
0.075 1.338
0
0
600 mil. VND and Inventory Value at Cost for the whole year of 2022 is 200 mil. VND . C
house direct cost, transportation direct cost are 100 mil. VND and 90 mil. VND correspo
upply of inputs, there is no Homiee products available at Big C though it is still listed
023, given that PCV is assumed to be unchanged as compared to previous year
to the difficulities in input sourcing, only 78 orders delivered within time frame as prom
800 mil. VND
Sales share Sales goal
0.2906977 232558139.53
0.5232558 418604651.16
0.1860465 148837209.3
s 10 mil. VND for each sales person and margin of 30%
Break-even number of employee
Tử số Mẫu số Index
144.48 135 1.0702222
here are 5 major supermarket chains in Hanoi city.
Index %
0.6821192
Category
performance
ratio (Toilet)
es
Index %
0.9397560368
0.6410256
Category
performance
ratio
mes (Bedroom)
Index %
1.0859403092
0.7407407
00 mil. VND per month. Calculate Inventory Turns and Inventory Days in 2022
Inventory turns
18.54
Inventory days
19.6871628910464
2 is 200 mil. VND . Calculate the GMROII
0 mil. VND correspondingly.
gh it is still listed
revious year
time frame as promised.
ory Days in 2022