FINANCIAL MODELING

Question 3 a. Below is an activity list for Mokobi Salon and Style. The sheet gives details of work done in the First week of May 2015. (20 marks) Date 5/1/2013 5/2/2013 5/2/2013 5/3/2013 5/4/2013 5/4/2013 5/4/2013 5/5/2013 5/5/2013 5/5/2013 5/5/2013 5/6/2013 5/6/2013 5/6/2013 5/6/2013 5/7/2013 5/7/2013 5/7/2013 5/7/2013 5/7/2013 Summary May 2015 Service Stylist name Payment Shaving Jane cash Shaving Martha credit card Shaving Lucy cash Washing and combing Alex cash Dyeing Alex credit card All service Rachel cash Meeting hairstyles Lucy cash Shaving Ashley cash Shaving Ashley credit card Shaving Sandy credit card Kids Sandy cash Shaving Ashley cash Shaving Lucy cash Shaving Jane credit card Washing and combing Sandy cash Dyeing Rachel cash All service Alex credit card Meeting hairstyles Jane cash Washing and combing Martha cash Shaving Sandy cash Price S 7.00 S 7.00 S 7.00 S 60.00 S 33.00 $ 67.00 s 33.00 S 7.00 S 7.00 s 17.00 s 3.00 S 7.00 s 7.00 S 7.00 s 60.00 S 33.00 67.00 33.00 23.00 S 7.00 lololo a. How many credit card transactions are there for this week (3 marks) b. How many times did Sandy visit the Salon that week (3 marks) c. What was the sales for the week (3 marks) d. With reference to question (c), separate credit card sales from cash sales in value. (4 marks) e. How much did these fellows spend this week on salon beauty? (4 marks) i Alex ii. Jane iii. Sandy iv. Ashley f. What was the sales performance for the following (3 marks) i. Shaving ii. Washing and combing iii. Dyeing