Holzmann Klein Incs (HK) marketing director is concerned about having the correct number of dealers in the areas where sales are expected to occur for HKs new motor vessels Based on his research, he has forecasted the percentage of sales that will come from each major city in eastern Canada, as follows Toronto 10 Hamilton 15 Kingston 30 Halifax 30 Montreal 15 He has also prepared a list of current dealers by city using Excel (see file Prep COF ASN06 Q6 Power BI Data) Corporate Finance Project 2 4 4 Required Dealer Location AC2100 Halifax, Canada AC2351 Toronto, Canada AD3499 Halifax, Canada AW1559 Hamilton, Canada BB1130 Toronto, Canada BH3490 Kingston, Canada BM2100 Montreal, Canada CD1004 Halifax, Canada CK2111 Toronto, Canada DB2771 Hamilton, Canada DB4567 Hamilton, Canada DE2107 Montreal, Canada DF1922 Montreal, Canada EF2390 Halifax, Canada EM3441 Montreal, Canada EY2991 Toronto, Canada FT2188 Toronto, Canada GQ4671 Montreal, Canada GS1203 Toronto, Canada JS2115 Toronto, Canada KA3913 Montreal, Canada KD2351 Montreal, Canada KT2363 Toronto, Canada KW3159 Kingston, Canada LK4002 Halifax, Canada LL2733 Hamilton, Canada LN1668 Kingston, Canada LP1088 Kingston, Canada LP2905 Toronto, Canada LT3192 Kingston, Canada LV3012 Hamilton, Canada LW1030 Toronto, Canada MC2567 Kingston, Canada MM2333 Toronto, Canada MV3331 Hamilton, Canada NX2950 Kingston, Canada PD1168 Kingston, Canada PS3005 Montreal, Canada QS2611 Toronto, Canada RE2955 Kingston, Canada RE3291 Hamilton, Canada RF2562 Montreal, Canada SP2667 Kingston, Canada SY1232 Toronto, Canada TF3122 Montreal, Canada TY3141 Montreal, Canada WA1258 Toronto, Canada WB2321 Toronto, Canada WQ2961 Toronto, Canada WV1266 Toronto, Canada a) To assist HKs marketing director with his analysis, create a map visualization of the current dealer locations using Power BI (2 marks) b) From the current map, which location has the highest number of dealers Which location has the lowest number of dealers (2 marks) c) Given the information on the sales forecast, is the current number of dealers at each location sufficient to meet the sales forecast demands If not, which cities appear to be underserviced by the current dealers and might require that new dealers be established or relocated (4 marks)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 03, 2024

Holzmann Klein Incs (HK) marketing director is concerned about having the correct number of dealers in the areas where sales are expected to occur for

Holzmann Klein Incs (HK) marketing director is concerned about having the correct number of dealers in the areas where sales are expected to occur for HKs new motor vessels. Based on his research, he has forecasted the percentage of sales that will come from each major city in eastern Canada, as follows: Toronto 10% Hamilton 15% Kingston 30% Halifax 30% Montreal 15% He has also prepared a list of current dealers by city using Excel (see file: Prep-COF-ASN06-Q6-Power BI Data). Corporate Finance Project 2 4 / 4 Required:

Dealer	Location
AC2100	Halifax, Canada
AC2351	Toronto, Canada
AD3499	Halifax, Canada
AW1559	Hamilton, Canada
BB1130	Toronto, Canada
BH3490	Kingston, Canada
BM2100	Montreal, Canada
CD1004	Halifax, Canada
CK2111	Toronto, Canada
DB2771	Hamilton, Canada
DB4567	Hamilton, Canada
DE2107	Montreal, Canada
DF1922	Montreal, Canada
EF2390	Halifax, Canada
EM3441	Montreal, Canada
EY2991	Toronto, Canada
FT2188	Toronto, Canada
GQ4671	Montreal, Canada
GS1203	Toronto, Canada
JS2115	Toronto, Canada
KA3913	Montreal, Canada
KD2351	Montreal, Canada
KT2363	Toronto, Canada
KW3159	Kingston, Canada
LK4002	Halifax, Canada
LL2733	Hamilton, Canada
LN1668	Kingston, Canada
LP1088	Kingston, Canada
LP2905	Toronto, Canada
LT3192	Kingston, Canada
LV3012	Hamilton, Canada
LW1030	Toronto, Canada
MC2567	Kingston, Canada
MM2333	Toronto, Canada
MV3331	Hamilton, Canada
NX2950	Kingston, Canada
PD1168	Kingston, Canada
PS3005	Montreal, Canada
QS2611	Toronto, Canada
RE2955	Kingston, Canada
RE3291	Hamilton, Canada
RF2562	Montreal, Canada
SP2667	Kingston, Canada
SY1232	Toronto, Canada
TF3122	Montreal, Canada
TY3141	Montreal, Canada
WA1258	Toronto, Canada
WB2321	Toronto, Canada
WQ2961	Toronto, Canada
WV1266	Toronto, Canada

a) To assist HKs marketing director with his analysis, create a map visualization of the current dealer locations using Power BI. (2 marks) b) From the current map, which location has the highest number of dealers? Which location has the lowest number of dealers? (2 marks) c) Given the information on the sales forecast, is the current number of dealers at each location sufficient to meet the sales forecast demands? If not, which cities appear to be underserviced by the current dealers and might require that new dealers be established or relocated? (4 marks)