Sales Tracking and Customer Relation Analyses

Questions: The FedFone Co. (FFC) sells cell phones and frill at three shops in the Ballarat zone (for example High Street, Mall, Suburb) seven (7) days per week. The organization likewise composes fixes for telephones they sold yet which have been harmed or get flawed. These exercises are co-ordinated by five (5) FFC Sales Representatives (John, Paul, Ringo, George, Stuart). The companys author, Ms Georgie Martyn, similar to all entrepreneurs, is constantly keen on discovering approaches to build incomes and lessening costs. Ms Martyn has recruited you as a business expert and suggests some operational-level conversation starters about the exhibition of her business. She is likewise anxious to hear your considerations and thoughts on the most proficient method to improve the business and expects you to make a few suggestions on the most proficient method to improve the companys execution, particularly comparable to the accompanying industry targets: improving the business technique; improving inward efficiencies and adequacy; and building solid enduring associations with its clients. Ms Martyn has furnished you with a years ago deals data in the itech1005-5005 2014-27 task data.xlsx document. The information should be broke down and imagined to help perceptions identified with the business activity and its weaknesses. The information worksheet Sales contains gathered data of the consultancys activities in the initial three months of the year. These subtleties included: Date (of offer) Shop (where deal finished) Staff (for example Agent name) Telephone Model Telephone Plan Telephone Cover (adornment sold) Save Battery (adornment sold) Charger Pack (adornment sold) Fix Details (sort of issue with telephone returned for fix) Fix (date got from client for fix) Return (date came back to client after fix) Programming Update (administration charge pay) Preparing Time (hours spent preparing clients in telephone use administration charge pay) Protection (administration charge pay) FFC must purchase all the stock (for example cell phones and extras) they at that point offer to clients. Telephone/Accessory: Cost Price ($A) Deals Price ($A) HTS model 1 98 150 HTS model 2 185 200 HTS model 3 199 350 HTS general telephone spread 15 27 HTS save battery 67 100 Sansumg 300 telephone 152 300 Sansumg 250 telephone 187 210 Sansumg 300 spread 16 25 Sansumg 250 spread 13 25 Sansumg save battery 90 100 Apel v17 telephone 655 690 Apel spread 22 45 Apel charger pack 45 80 Motorolar razzr telephone 199 220 Motorolar newstyle telephone 245 270 Motorolar telephone spread 16 25 Nokkia telephone 1111 99 140 Nokkia telephone 2222 129 165 Nokkia telephone spread 14 25 Nokkia save battery 80 110 General charger pack 27 40 FFC sell a scope of cell phone plans to clients that originate from various broadcast communications organizations. FFC are paid a commission by every media transmission organization for selling the various plans as the table underneath demonstrates: Telephone Plans: Commission Income Received ($A) Telstrar plan 1 10 Telstrar plan 2 8 Optrus plan 1 8 Optrus plan 2 6 Raldi plan 3 Vodrfon plan 1 5 Vodrfon plan 2 8 At the point when telephones are returned for fix, FFC should likewise pay $14 postage expenses to mail the telephone to the approved help place this expense is completely or incompletely repaid by the telephone producer as indicated by a size of charges: Telephone Company: Fix Postage Reimbursement Amount Received ($A) HTS 18 Sansumg 8 Apel 5 Motorolar 10 Nokkia 15 FFC likewise offers extra types of assistance for which it charges clients expenses for administration. The extra level (for example once) expenses charged by FFC to clients for their extra administrations (for example as charge salary) are: Extra Service: Administration Fee Income Received ($A) Telephone set-up or programming update 5 Telephone use preparing 40 Telephone protection financier charge 5 All Sales Representatives are paid fixed wages and no extra commissions are paid for deals or administrations. Wages are a fixed expense to the business and as such are not required in the investigation/revealing of the deals and consumption for Ms Martyn. Assessable Tasks Ms Martyn needs to have a synopsis report of activities that will incorporate the accompanying data: 1. Telephone. Use Pivot Table(s) to sum up these estimations. Calculationsa. All out salary for the multi month time frame, sub-totalled by each (a) Shop, (b) Sales Representative, and (c) Phone. Use Pivot Table(s) to sum up these calculations.b. Complete costs for the multi month time frame, sub-totalled by each (a) Shop, and (b) Sales Representative. Use Pivot Table(s) and suitable graph(s)/chart(s) to sum up these calculations.c. Complete benefit for the multi month time span, sub-totalled by each (a) Shop, (b) Sales Representative, and (c) Phone. Use Pivot Table(s) to sum up these calculations.d. Complete telephone fix costs and pay for the multi month time frame, sub-totalled by each (a) Phone, (b) Sales Representative and (c) Shop. Utilize fitting Table(s) to sum up these calculations.Observationse. Which telephone plans gave the (a) most and (b) least salary, for the multi month time frame? Utilize a suitable table and diagram/graph to sum up these observations.f. Which are the most exceedingly terrible telephones sold by FFC, by (a) com plete number of fixes required and (b) time taken for fix, for the multi month duration? Utilize a fitting table and diagram/graph to sum up these observations.g. What are FFCs best and most noticeably terrible Sales Representatives by all out deals? Utilize a proper table and diagram/graph to sum up these perceptions. Answers: Count a. According to the gave data set of the Fed Fone Co. (FFC's) offering convenient or phone and moreover their additional items in its assumed shop in Ballarat go. The Fed Fone Co. (FFC) is organized in three better places in Ballarat zone like High Street, Mall and Suburb. The three shops of Fed Fone Co. (FFC) are 7 days open, in this manner they learn the total pay, expenses and advantage for each expansion of association. They furthermore need to upgrade the proposals of the association, internal efficiencies, sufficiency of clients or customers and they moreover need to fabricate a respectable connection between each customer or clients of the shop by the help of a couple of various examinations of compensation, expenses and advantage (Beynon-Davies, Galliers Sauer, 2009). Thusly, the total compensations of the shop according to its augmentations are demonstrated in underneath. The total compensation or all out pay of Fed Fone Co. (FFC) is 445017 $ Besides, the compensation or all out pay of various augmentations of Fed Fone Co. (FFC) like High Street is 208837 $ The compensation of various appendages of or absolute salary Fed Fone Co. (FFC) like Mall is 174036 $ The compensation of various appendages of or absolute pay Fed Fone Co. (FFC) like Suburb is 62144 $ In over all the information are examination results of the giving informational index of Fed Fone Co. (FFC). All the information are giving in table structure, which are ascertaining by the assistance of, exceed expectations advance investigation. b. As indicated by gave informational index of the Fed Fone Co. (FFC), the total expense or absolute costs of plan of action or Fed Fone Co. (FFC) are estimating by the assistance of exceed expectations advance examination. The total expense or complete costs of plan of action or Fed Fone Co. (FFC) are plate in underneath. The total expense or all out costs of Fed Fone Co. (FFC) is 316105 $ Likewise, the expense or absolute costs of various expansions of Bolstered Fone Co. (FFC) like High Street is 160204 $ The expense or complete costs of various appendages of Encouraged Fone Co. (FFC) like Mall is 115115 $ The expense or all out costs of various appendages of Encouraged Fone Co. (FFC) like Suburb is 40786 $ c. The advantage or benefit is the most significant term just as important information for each plan of action. The advantage or benefit of the plan of action is computing or estimating by the assistance of all out salary of the plan of action and all out costs of the plan of action in same period (Moutot Bascoul, 2008). As per the gave informational collection of Fed Fone Co. (FFC), the benefit or advantage is investigation or figuring. The benefit estimations of the plan of action or Fed Fone Co. (FFC) are appeared in underneath. Along these lines, the total advantage/benefit of Fed Fone Co. (FFC) = (absolute pay or salary total expense or all out costs) = 128912 $ Correspondingly, the advantage/benefit of various appendages of Fed Fone Co. (FFC) like High Street is 48633 $ The advantage/benefit of various appendages of Fed Fone Co. (FFC) like Mall is 58921 $ The advantage/benefit of various appendages of Fed Fone Co. (FFC) like Suburb is 21358 $ d. As indicated by the gave informational collection of the Fed Fone Co. (FFC), All out pay rates or pay through fix = 720 $ Total expenses by means of fix = 14* 50 = 700 $ Consequently, the absolute advantage or benefit through fixing the old handsets or telephone is (720 700) $ = 20 $ Perception e. The Fed Fone Co. (FFC) is given different telephone plans to customers or clients of the shop. As per the gave informational index of Fed Fone Co. (FFC) are shown in underneath. Plan No Telstrar plan 1 249 Telstrar plan 2 140 Optrus plan 1 442 Optrus plan 2 327 Raldi plan 225 Vodrfon plan 1 17 Vodrfon plan 2 8 The fundamental graphical layout of the telephone plans are exhibited in underneath as indicated by their utilizations and pl