Excel Chapter 4 Prepare Case - Spa Sales

profileabparsley
Parsley_Excel_Ch04_Prepare_SpaSales.xlsx
Home>Business & Finance homework help>Excel Chapter 4 Prepare Case - Spa Sales

TableUse

Portable Table Use
Employee Times Used
Christy 15
Kendra 9
Jason 16
Pat 5

Massage Distribution

Times Used Christy Kendra Jason Pat 15 9 16 5

ProductData

Massage Totals
Type of Massage Total Number of Massages
Pregnancy 15
Shiatsu 21
Thai 24
Hot Stone 34
Sports 41
Reflexology 47
Deep Tissue 81
Swedish 91
Back 84
Aromatherapy 87
Massages over 8 week period
Type of Massage Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8
Pregnancy 2 3 4 2 1 1 1 1
Shiatsu 3 4 4 1 1 3 2 3
Thai 4 2 2 2 5 4 3 2
Hot Stone 1 1 2 5 6 6 7 6
Sports 6 5 5 7 8 3 3 4
Reflexology 5 7 10 8 4 4 5 4
Deep Tissue 15 5 7 9 8 11 12 14
Swedish 9 7 15 14 11 10 13 12
Back 12 15 6 5 13 11 10 12
Aromatherapy 10 15 7 8 12 14 10 11

Revenue

Sports Hot Stone Deep Tissue Back
Total Revenue $ 11,264.00 $ 5,606.00 $ 14,606.00 $ 13,618.00
Date Sports Hot Stone Deep Tissue Back
6/1/22 498 238 523 546
6/2/22 468 275 567 572
6/3/22 466 184 501 505
6/4/22 215 78 462 438
6/5/22 254 231 523 295
6/6/22 325 25 524 257
6/7/22 412 238 487 345
6/8/22 422 184 498 617
6/9/22 396 256 567 665
6/10/22 321 88 420 321
6/11/22 286 140 479 372
6/12/22 327 134 582 358
6/13/22 325 123 511 368
6/14/22 415 207 468 459
6/15/22 468 199 566 621
6/16/22 467 236 526 676
6/17/22 434 195 534 536
6/18/22 215 34 367 412
6/19/22 245 134 419 501
6/20/22 400 89 426 370
6/21/22 326 242 479 401
6/22/22 452 297 564 485
6/23/22 500 176 560 443
6/24/22 457 242 524 451
6/25/22 368 239 343 471
6/26/22 265 162 365 413
6/27/22 319 125 384 421
6/28/22 389 192 438 390
6/29/22 417 279 523 423
6/30/22 412 364 476 486

RedesignProject

Massage Room Redesign Project
Hours
Manager Completed Remaining
Project Planning Irene 75 15
Gathering Bids Irene 73 29
Design Meda 98 11
Installation Irene 45 20
Painting & Decorating Meda 23 32

Survey

Client Survey Data
Age Temp
Author: Temperature Requested by the Client 		Rating Massage Type
40 70 52 Hot Stone
61 70 81 Back
42 72 62 Sports
44 72 64 Sports
50 73 98 Reflexology
33 73 68 Pregnancy
65 75 98 Hot Stone
62 73 96 Aromatherapy
46 74 99 Sports
43 75 79 Sports
60 75 84 Reflexology
36 76 89 Swedish
26 74 76 Pregnancy
69 77 94 Shiatsu
63 77 65 Reflexology
71 80 75 Back
71 76 82 Deep Tissue
64 79 65 Swedish
66 80 83 Thai
30 71 93 Swedish
34 75 77 Deep Tissue
32 72 65 Pregnancy
67 79 94 Back
26 73 82 Back
44 71 86 Reflexology
39 71 75 Thai
45 72 98 Aromatherapy
76 78 83 Deep Tissue
45 74 67 Deep Tissue
30 72 88 Aromatherapy
29 74 83 Deep Tissue
55 78 95 Shiatsu
59 81 93 Back
76 85 89 Sports
63 79 91 Thai
22 73 89 Aromatherapy
31 75 94 Back
37 73 90 Back
48 76 85 Sports
81 77 92 Shiatsu
63 76 81 Deep Tissue
42 75 80 Sports
45 76 94 Back
75 78 90 Shiatsu
53 75 90 Reflexology
44 75 75 Deep Tissue
60 76 79 Thai
26 72 87 Sports
42 74 86 Reflexology
33 74 97 Aromatherapy
36 74 96 Back

SpaSales

2021 Product Sales
Month Quantity Profit
January 190 $ 1,405
February 150 $ 1,450
March 111 $ 1,500
April 95 $ 1,700
May 109 $ 1,689
June 120 $ 1,842
July 123 $ 1,835
August 98 $ 1,450
September 101 $ 1,500
October 115 $ 1,700
November 156 $ 1,652

HairProducts

Hair Products Sold Over the Last 12 Months
Units Sold January February March April May June July August September October November December
Shampoo 25 23 23 41 20 17 30 27 34 19 10 14
Conditioner 14 24 44 48 46 38 42 39 22 26 34 25
Treatment 38 31 39 67 50 44 47 35 54 21 45 44
Styling 20 50 14 19 18 22 15 24 33 11 25 45
For Men 25 26 26 25 14 13 40 35 12 10 50 14
Profit
Shampoo $ 1,090.50
Conditioner $ 1,786.50
Treatment $ 1,236.00
Styling $ 651.20
For Men $ 551.00

Hair Product Sales

January Shampoo Conditioner Treatment Styling For Men 25 14 38 20 25 February Shampoo Conditioner Treatment Styling For Men 23 24 31 50 26 March Shampoo Conditioner Treatment Styling For Men 23 44 39 14 26 April Shampoo Conditioner Treatment Styling For Men 41 48 67 19 25 May Shampoo Conditioner Treatment Styling For Men 20 46 50 18 14 June Shampoo Conditioner Treatment Styling For Men 17 38 44 22 13 July Shampoo Conditioner Treatment Styling For Men 30 42 47 15 40 August Shampoo Conditioner Treatment Styling For Men 27 39 35 24 35 September Shampoo Conditioner Treatment Styling For Men 34 22 54 33 12 October Shampoo Conditioner Treatment Styling For Men 19 26 21 11 10 November Shampoo Conditioner Treatment Styling For Men 10 34 45 25 50 December Shampoo Conditioner Treatment Styling For Men 14 25 44 45 14