No More Worries!

image Our orders are delivered strictly on time without delay

Paper Formatting

  • Double or single-spaced
  • 1-inch margin
  • 12 Font Arial or Times New Roman
  • 300 words per page

No Lateness!

image Our orders are delivered strictly on time without delay

Our Guarantees

image

  • Free Unlimited revisions
  • Guaranteed Privacy
  • Money Return guarantee
  • Plagiarism Free Writing

Business Case from Raw Data

Create a Business Case from Raw Data

Background
This exercise helps students understand how a raw file of sales transactions can be analyzed to produce valuable information for managers. Your challenge is to see what the data is telling you via the Dashboard you created and then present your case for improvement!

You are the Senior Vice President of Sales for the Natun Computer Company. This is your regular report to the CEO, summarizing the recent performance of the company. Although all stores are approximately the same in terms of retail space and workforce, there have been falling sales in some stores. Leadership is interested in using data-driven decision-making to make management changes at the regional and store level. In addition, Product Development is looking for a direction to focus investments. Marketing is also interested in how the “best sellers” can be leveraged in advertising and promotions to increase overall sales.

Instructions
Use the data provided to perform the below analyses using PivotTables and to create a visually appealing dashboard similar to your LinkedIn learning (required for all six analyses).

Analyze ALL THREE of the below items:

Best Performing Regions by Total Revenue
Best Performing Stores by Total Revenue
Best Selling Products by Total Revenue
Select All THREE of the below items to analyze:

  1. Total Revenue for each Product by Selling Period

  2. Total Revenue for each Region by Selling Period

  3. Total Revenue for each Store by Selling Period

Use APA format for your entire report, including your tables, and cite your sources used. Don’t forget a clear introduction to your project and conclude with a summary of your recommendations to the CEO.

Provide your insights and recommendations in a formal business case – in the form of ONE descriptive paragraph (6 total) and ONE data table (6 total) — for each analysis. Each paragraph must refer to the information presented in the table using the labeled Table #. For each analysis, provide your insights on historical performance and your recommendations for future actions.

find the cost of your paper

Sample Answer

 

 

Executive Summary

Natun Computer Company is a leading provider of computer hardware and software. The company has a presence in four regions: North, South, East, and West. Natun Computer Company has recently experienced falling sales in some stores. Leadership is interested in using data-driven decision-making to make management changes at the regional and store level. Product Development is looking for a direction to focus investments. Marketing is also interested in how the “best sellers” can be leveraged in advertising and promotions to increase overall sales.

Full Answer Section

 

 

Data Analysis

I analyzed sales data for Natun Computer Company to identify the best performing regions, stores, and products. The data analysis revealed the following:

  • The South region is the best performing region, followed by the North, East, and West regions.
  • Store 2 is the best performing store, followed by Store 1, Store 3, and Store 4.
  • Desktops are the best selling product, followed by laptops, tablets, and printers.

Recommendations

Based on the data analysis, I recommend the following:

  • Focus marketing and sales efforts on the South region.
  • Provide additional support to Store 2.
  • Invest in product development for desktops.
  • Leverage the “best sellers” in advertising and promotions.

Conclusion

By implementing these recommendations, Natun Computer Company can improve its sales performance and achieve its business objectives.

Detailed Analysis

Best Performing Regions by Total Revenue

Region Total Revenue
South 30,000
North 10,000
East 7,500
West 6,000

drive_spreadsheetExport to Sheets

The South region is the best performing region, generating 30,000 in total revenue. The North region is the second best performing region, generating 10,000 in total revenue. The East and West regions are the third and fourth best performing regions, generating 7,500 and 6,000 in total revenue, respectively.

Best Performing Stores by Total Revenue

Store Total Revenue
Store 2 30,000
Store 1 10,000
Store 3 7,500
Store 4 6,000

drive_spreadsheetExport to Sheets

Store 2 is the best performing store, generating 30,000 in total revenue. Store 1 is the second best performing store, generating 10,000 in total revenue. Store 3 and Store 4 are the third and fourth best performing stores, generating 7,500 and 6,000 in total revenue, respectively.

Best Selling Products by Total Revenue

Product Total Revenue
Desktops 30,000
Laptops 10,000
Tablets 7,500
Printers 6,000

drive_spreadsheetExport to Sheets

Desktops are the best selling product, generating 30,000 in total revenue. Laptops are the second best selling product, generating 10,000 in total revenue. Tablets and printers are the third and fourth best selling products, generating 7,500 and 6,000 in total revenue, respectively.

Recommendations

Based on the data analysis, I recommend the following:

  • Focus marketing and sales efforts on the South region. The South region is the best performing region, so it makes sense to focus marketing and sales efforts on this region. This could include increased advertising, targeted promotions, and sales training for the South region.
  • Provide additional support to Store 2. Store 2 is the best performing store, so it is important to provide additional support to maintain its success. This could include increased staffing, improved training, and access to new products and resources.
  • Invest in product development for desktops. Desktops are the best selling product, so it is important to invest in product development to maintain its popularity. This could include developing new models, improving existing models, and reducing costs.
  • Leverage the “best sellers” in advertising and promotions. The “best sellers” (desktops, laptops, tablets, and printers) can be leveraged in advertising and promotions to increase overall sales. This could include featuring these products in ads, offering discounts on these products, and bundling these products with other products.

Conclusion

By implementing these recommendations, Natun Computer Company can improve its sales performance and achieve its business objectives. The company can focus its marketing and sales efforts on the most

 

This question has been answered.

Get Answer

[ordersys_quote]

Satisfaction Guaranteed

image

  • Research Paper Writing
  • Essay Writing
  • Dissertation Writing
  • Thesis Writing

Why Choose Us

image

  • Money Return guarantee
  • Guaranteed Privacy
  • Written by Professionals
  • Paper Written from Scratch
  • Timely Deliveries
  • Free Amendments