Executive summary
In summary, the Sum of Tax Amount for Shu is 6436047 whereas the Sum of Unit Price Discount Pct on Specialty Bike Shop, Value Added Reseller, and Warehouse is approximated to be 343. Shu Ito Sum of Product Standard Cost is 26693830 as shown in the pivot table. The main business problem is the inadequate number of employees. The number of employees addressing the Five W's is not the same, and this affects the business income generation activities. For instance, there are only nine employees who are responsible for Weekend Tours, (see Pivot Table). This number is small compared with the number of tourists who visit the place during weekends. As a result, some of the tourists may not prefer the site due to the inadequate number of employees who in one way or the other attend to tourist’s queries. The main KPIs are the Specialty Bike Shop, Value Added Reseller, and Warehouse. This means that the main business activities are surrounding the three identified KPIs. Therefore, there is a need to invest more capital resources and human personnel towards these KPIs to make the substantial business returns. There is a need to monitor and evaluate the performance of the business continuously . These analysis entails both descriptive and inferential statistics while presenting the results. The inferential results are likely to help when concluding the general market. Therefore, in business, there is a need to have an analyst who will continuously update the entire business activities on the progress as far as the market competition is concerned. In the process, the results can be used to predict future occurrences within the market especially during SWOT analysis. This will make the business to be in a better position while keeping alert on the market trends.
1. The business history of Shu Ito of AWC
According to the pivot table results, Sum of the Minimum Payment Amount for Shu is 114200 while the sum of Freight is 2011266. Shu’s Sum of Order Quantity is 214378 while the Sum of Day Number of Week 5841. Again, the Sum of Tax Amount for Shu is 6436047 whereas the Sum of Unit Price Discount Pct on Specialty Bike Shop, Value Added Reseller, and Warehouse is approximated to be 343. Shu Ito Sum of Product Standard Cost is 26693830 as shown in the pivot table. Finally, Shu’s Sum of Pay Frequency is 2.
Delegate your assignment to our experts and they will do the rest.
2. Defining the business problem statement and addressing the Five W's.
The main business problem is the inadequate number of employees. The number of employees addressing the Five W's is not the same, and this affects the business income generation activities. For instance, there are only nine employees who are responsible for Weekend Tours, (see Pivot Table). This number is small compared with the number of tourists who visit the place during weekends. As a result, some of the tourists may not prefer the site due to the inadequate number of employees who in one way or the other attend to tourist’s queries.
Similarly, only 48 and 90 employees are responsible for the distribution of the Western Bike Supplies and Wheel gallery. These number of employees are still inadequate compared with the magnitude of the task hence calls for the need to add more staff. Furthermore, only 27 and 64 employees are responsible for the wholesale of bikes and wholesale of parts respectively. Due to this inadequate number of employees, there is a high chance that the organization is not maximizing on the returns, (Kerzner, & Kerzner, 2017).
3. Frame the analytics problem statement and define KPIs.
According to the pivot table, the main KPIs are the Specialty Bike Shop, Value Added Reseller, and Warehouse. This means that the main business activities are surrounding the three identified KPIs. Therefore, there is a need to invest more capital resources and human personnel towards these KPIs to make significant business returns, (Marchington, Kynighou, Wilkinson, & Donnelly, 2016).
4: General expectations from the elements of the business analytics process (data sources, descriptive analytics, predictive analytics, prescriptive analytics)
Usually , for any successful business to be realized , then there is a need to continuously monitor and evaluate the performance of the market , (Doppelt, 2017). On this note, I expect that the business personnel should be in the forefront to collect and store business data which can be analyzed and help in the decision-making process. These analysis entails both descriptive and inferential statistics while presenting the results. The inferential results are likely to help when concluding the general market. Therefore, in business, there is a need to have an analyst who will continuously update the entire business activities on the progress as far as the market competition is concerned. In the process, the results can be used to predict future occurrences within the market especially during SWOT analysis. This will make the business to be in a better position while keeping alert on the market trends. Finally, through the prescriptive analytics, the business can be narrowed down to specific items that are doing well in the market. Through this, capital increase for such issues is expected to be initiated within the market.
References
Doppelt, B. (2017). Leading change toward sustainability: A change-management guide for business, government, and civil society . Routledge.
Kerzner, H., & Kerzner, H. R. (2017). Project management: a systems approach to planning, scheduling, and controlling . John Wiley & Sons.
Marchington, M., Kynighou, A., Wilkinson, A., & Donnelly, R. (2016). Human resource management at work . Kogan Page Publishers.
