Note: This question has three parts: 1. As the Sales Manager of a global company

Question

Note: This question has three parts:

1. As the Sales Manager of a global company, you would like to use MS Excel to analyze the sales data for the entire company. The first challenge is that, the Sales Data System cannot export its data as a MS Excel Workbook. It can however, generate a TXT file. Please explain how you would get the data into Excel for analysis

2. As the Sales Manager, decide two things you would like to know from the sales data (data available: country, product, price per product, date product was sold, quantity sold, sales person). Then select two features you would use to analyze the data to provide you with the information you desire. Please be clear on what two things you would like to know and how you will use the selected feature to provide that information.

3. With the information now known, please describe how you would present this information to senior management. Please be specific and be sure to consider the audience.

Explanation / Answer

To conver Txt to Excel

Part- 2

The two data columns to select are Price per product and Country

The two colums are most important to determine how the price of the product changes from one location to the other.

Part-3

With the information I would identifty the quantum of change in the price for each country and identify the reasons for pricing the product differently in different country and identify what are the measures to fix a price for a particular region and country.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.