Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Sales Tracking And Decision Making Analyses Add in library

expert-image Maurice France 4.7/5 hire me
224 Download4 Pages 908 Words


Describe the Sales Tracking and Customer Relations Analyses? and to analyse a set of data, and write a brief report, identifying and explaining your insights into the operation of “The FedFone Co.”?



Executive Summary

Businesses evolve around data, now a days, every business process of any organization generates a lot of data. Analysis of those data gives critical insight in the business process, future scopes and strategies etc. FFC or FedFone Co. is such a business in Ballarat area. It sells mobile phones, accessories, mobile phone insurance plans from 3 shops in the Ballarat area. Now the business is planning for expansion. Thus the owner wants to make new business strategies, improve customer relationships. In order to do so, the business needs to analyze the sales data from previous months.


In this section the outcomes of the sales data based on different criteria will be discussed. The total income, expense and profits will be analyzed by different combinations of the shops, staffs, phone models etc.

The company needs to pay $14 for postal charge, whenever, there is a phone repair. The phone manufacturing companies reimburse charge but that may be partially or totally. The income and expense from phone repair will also be analyzed.

1. Following pivot table shows the outcome of the analysis of total income based on different shops, staffs and phone modes. The sub totals of these three categories have been also there.

2. Following pivot table shows the outcome of the analysis of total expense of FFC, based on the shops and staffs. The subtotals of each of the two groups have been also there.

1. Following pivot table shows the outcome of analysis of total profit of FFC based on the shops, staffs and the phone models. The sub totals of each group also have been there.

2. Following pivot table shows the outcome of analysis of the repair income and expenses based on phone models, staffs and shops. The sub totals of each category have been also given.


In this section the outcomes of the analysis of sales information of FFC will be observed to find different best and worst cases. For example, the best and worst selling phone plans, the best and worst performing sales staff in terms of total sales, changes in total profit if the policy of charging for training service is changed etc.

1. Following chart shows the comparison of totals sales of different phone plans. The values will be observed to find out the best and worst selling phone plans. According to the chart, Optrus plan 1 and Vodrfon plan 2 are the best and worst selling phone plans respectively.

The best Worst Selling Phone Plans

2. The following chart compares the number of repairs and the total time for those repairs, for different phone models sold by FFC. According to the observation of the chart, Apel v17 phone is the worst phone that have the most number of repair cases and the most duration for the same.
Number of Phone Repairs and Durations
1. Following chart shows the comparison of the total sales made by the staffs. Based on the information in the chart, the best and worst staffs are Paul and Ringo respectively.
Performance of Sales Staffs
2. Following chart compares the profit with fixed rate training service to the profit with variable rate hourly charged training service. It is observed from the chart that the profit is more in the latter case.
Profits Comparision


In this section the recommendation for FFC will be outlined. The recommendations are based on the current business process of FFC and the results from all calculation and observations carried out so far.

1. For improving the sales activities in future, FFC should take care of the different shops and staffs. All shops and staffs are not performing same and satisfactory levels. Particularly, FFC should focus on the sales activities in the Suburb area, on the sales staff like Ringo, who are not performing well, and on products other than phone models.

2. For improving the decision making activities, FFC should collect more information. Other than sales records it should focus on collecting customers’ demographics. These will help in building better customer relationships in future. The data should be collected in proper format and should be ‘cleaned’ before being used in data analysis.

3. Data validation restricts input to different fields and reduces the scope of erroneous data input, manual data entry errors etc. In the Sales datasheet, column A has dates. But there is no validation on the cells under this column. Thus anything other than a valid date can be entered. Also there may be outdated entry. A validation specifying range of possible inputs and proper format of the data will help in restricting the errors and data entry. In the column B, the valid input will be any mane of the three shops. But, there can be any string without proper validation. The valid input in column M should also be any whole number from 0 to 24. These validations in these columns will help in better record keeping and organizing.



Albright, S., Winston, W., & Zappe, C. (2010). Data Analysis and Decision Making. Cengage Learning.

Gross, D., Akaiwa, F., & Nordquist, K. (2013). Succeeding in Business with Microsoft Excel 2013: A Problem-Solving Approach. Cengage Learning.

Jelen, B. (2010). PowerPivot for the Data Analyst. Pearson .

Jelen, B., & Alexander, M. (2013). Excel 2013 Pivot Table Data Crunching. Que Publishing.

Ralston, B. (2011). PowerPivot for Business Intelligence Using Excel and SharePoint. Apress.

Winston, W. L. (2009). Microsoft® Excel Data Analysis and Business Modeling. Microsoft Press.

OR has become one of the leading assignment help provider in New York City and Boston. We provide top class auditing assignment help. Not only auditing, but we also cover more than 100 subjects and our writers deal with all types of assignments with utmost expertise. To make writing process faster and accurate, we have segmented our assignment experts' teams as per their expertise on writing different types of assignments. We guaranteed that students who buy our assignment online get solutions worth their investment.

Most Downloaded Sample of Management

278 Downloads 1 Pages 48 Words

Toulin Method Of Argumentation

You are required to write a researched argument essay that convinces persuades the reader of your position / stance. This is an academic, researched and referenced do...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
202 Downloads 9 Pages 2,237 Words

Consumer Behavior Assignment

Executive Summary The purpose of this report is to elaborate the factors which are considered by individuals before selecting an occupation. Choosing an occupati...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
368 Downloads 13 Pages 3,112 Words

Internet Marketing Plan For River Island

Introduction With the increase enhancement in the field of technology, it has been considered essential by the businesses to implement such technology in their b...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
328 Downloads 9 Pages 2,203 Words

Strategic Role Of HR In Mergers & Acquisitions

Executive Summary In a merger & acquisition, role of an HR has emerged as a very critical function. At each stage of merger and acquisition process, HR plays a s...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
357 Downloads 7 Pages 1,521 Words

Relationship Between Knowledge Management, Organization Learning And HRM

Introduction In this competitive business environment where every business organization is trying to attract the customers of each other, it becomes essential for ...

Read More Tags: Australia Arlington Management Management University of New South Wales Management 
Free plagiarismFree plagiarism check online on mobile
Have any Query?