Question
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).
Required:
- To assist HKs marketing director with his analysis, create a map visualization of the current dealer locations using Power BI. (2 marks)
- From the current map, which location has the highest number of dealers? Which location has the lowest number of dealers? (2 marks)
- 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)
| 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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
College Accounting Chapters 1-30
Authors: David Haddock, John Price, Michael Farina
16th Edition
1260247902, 978-1260247909
