Sales Tracking and Customer Relations Analyses

Aims

To analyse a set of data (in Microsoft Excel), and write a brief report (in Microsoft Word), identifying and explaining your insights into the operation of “The FedFone Co.”.

Learning Objectives

In the process of this assessment task you will:

Introduction

The FedFone Co. (FFC) sells mobile phones and accessories at three shops in the Ballarat area (i.e. High Street, Mall, Suburb) seven (7) days a week. The company also organises repairs for phones they sold but which have been damaged or become faulty. These activities are co-ordinated by five (5) FFC Sales Representatives (John, Paul, Ringo, George, Stuart). The company’s founder, Ms Georgie Martyn, like all small business owners, is always interested in finding ways to increase revenues and decrease expenses.

Ms Martyn has hired you as a business analyst and poses some operational-level questions about the performance of her business. She is also eager to hear your thoughts and ideas on how to improve the business and requires you to make several recommendations on how to improve the company’s performance, especially in relation to the following business objectives:

Ms Martyn has provided you with last year’s sales information in the “itech1005-5005 2014-27 assignment data.xlsx” file. The data needs to be analysed and visualised to help observations related to the business operation and its shortcomings.

The data worksheet “Sales” contains collected information of the consultancy’s operations in the first three months of the year. These details included: