Sales Tracking and Customer Relation Analyses

Questions: The FedFone Co. (FFC) sells cell phones and extras at three shops in the Ballarat territory (for example High Street, Mall, Suburb) seven (7) days per week. The organization likewise sorts out fixes for telephones they sold however which have been harmed or get defective. 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 expand incomes and decline costs. Ms Martyn has recruited you as a business examiner and offers some operational-level conversation starters about the exhibition of her business. She is likewise anxious to hear your musings and thoughts on the most proficient method to improve the business and expects you to make a few proposals on the best way to improve the companys execution, particularly comparable to the accompanying industry destinations: improving the business methodology; improving inward efficiencies and viability; and building solid enduring associations with its clients. Ms Martyn has given you a years ago deals data in the itech1005-5005 2014-27 task data.xlsx document. The information should be examined and pictured to help perceptions identified with the business activity and its deficiencies. 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 Salesperson name) Telephone Model Telephone Plan Telephone Cover (embellishment sold) Save Battery (embellishment sold) Charger Pack (embellishment sold) Fix Details (kind 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 expense pay) Preparing Time (hours spent preparing clients in telephone use administration charge salary) Protection (administration expense pay) FFC must purchase all the stock (for example cell phones and embellishments) 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 All inclusive 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 assistance place this expense is entirely or incompletely repaid by the telephone maker 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 pay) 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 use for Ms Martyn. Assessable Tasks Ms Martyn needs to have a rundown report of tasks that will incorporate the accompanying data: 1. Telephone. Use Pivot Table(s) to sum up these estimations. Calculationsa. Complete pay 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.b. All out costs for the multi month time span, sub-totalled by each (a) Shop, and (b) Sales Representative. Use Pivot Table(s) and fitting graph(s)/chart(s) to sum up these calculations.c. Complete benefit 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.d. Absolute telephone fix costs and pay for the multi month time frame, sub-totalled by each (a) Phone, (b) Sales Representative and (c) Shop. Utilize suitable Table(s) to sum up these calculations.Observationse. Which telephone plans gave the (a) most and (b) least pay, for the multi month time frame? Utilize a proper table and diagram/graph to sum up these observations.f. Which are the most exceedingly terrible telephones sold by FFC, by (a) complete num ber of fixes required and (b) time taken for fix, for the multi month term? Utilize a fitting table and diagram/outline to sum up these observations.g. What are FFCs best and most noticeably terrible Sales Representatives by all out deals? Utilize a fitting table and diagram/outline 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 also 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, subsequently they discover the total pay, expenses and advantage for each augmentation of association. They moreover need to improve the proposals of the association, internal efficiencies, sufficiency of clients or customers and they in like manner need to produce a not too bad connection between each customer or clients of the shop by the help of a couple of various examinations of pay, expenses and advantage (Beynon-Davies, Galliers Sauer, 2009). Thusly, the total pay rates of the shop according to its expansions are demonstrated in underneath. The total compensation or complete salary of Fed Fone Co. (FFC) is 445017 $ Moreover, the compensation or complete salary of various augmentations of Fed Fone Co. (FFC) like High Street is 208837 $ The compensation of various appendages of or complete pay Fed Fone Co. (FFC) like Mall is 174036 $ The compensation of various appendages of or absolute salary Fed Fone Co. (FFC) like Suburb is 62144 $ In over all the information are investigation results of the giving informational collection of Fed Fone Co. (FFC). All the information are giving in table structure, which are figuring by the assistance of, exceed expectations advance investigation. b. As per gave informational collection 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 investigation. The total expense or all out costs of plan of action or Fed Fone Co. (FFC) are plate in underneath. The total expense or absolute costs of Fed Fone Co. (FFC) is 316105 $ Likewise, the expense or complete costs of various augmentations 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 figuring or estimating by the assistance of absolute pay of the plan of action and complete costs of the plan of action in same period (Moutot Bascoul, 2008). As indicated by the gave informational collection of Fed Fone Co. (FFC), the benefit or advantage is examination or computing. 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 by means of fix = 720 $ Total expenses through fix = 14* 50 = 700 $ In this manner, the complete advantage or benefit by means of 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 indicated by the gave informational index of Fed Fone Co. (FFC) are exhibited 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 framework of the telephone plans are shown in underneath as per their utilizations and pl