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)

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 06, 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).

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)