Solved by verified expert:Here is a copy of all the work sheets I need help with thank you for your help
copy_of_a01ch02_grader_pc_puttsgolf.xlsx
copy_of_johnson_iii_e01_grader_h1_roomservice.xlsx
copy_of_johnson_iii_e02_grader_hw_b_trendz.xlsx
copy_of_johnson_iii_e02ch04_grader_pc_spasales.xlsx
copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
Unformatted Attachment Preview
ParticipantID
50
51
52
53
54
55
56
57
LastName
Druplet
Maestas
Marquardt
Nelson
Nelson
Romero
Thomas
Thomas
FirstName
Brenda
Marcus
Keith
Kris
Rodney
Maria
Joe
Lois
StreetAddress
1522 Watson Ln
83 Vuelta Rancho
228 E Alejo Rd
915 Somerset Ln
915 Somerset Ln
819 Calle Don Roberto
4355 Celsior St
4355 Celsior St
City
Las Cruces
Santa Fe
Palm Springs
Las Cruces
Las Cruces
Santa Fe
Brougham
Brougham
State
NM
NM
CA
NM
NM
NM
CA
CA
ZipCode
88001
87508
92262
88018
88018
87502
92267
92267
ContactPhoneN
umber
(505) 555-1835
(505) 555-2525
(760) 555-4836
(505) 555-4103
(505) 555-3237
(505) 555-3242
(209) 555-3227
(209) 555-3227
CorporatePhoneNu
mber
(505) 555-1800
(505) 555-1800
Room Service Charge Analysis
Week of
12/15/2018 to 12/21/2018
Day/Room Type One Double
Two Doubles Two Kings Suite
Super Suite Grand Villa Suite
Total
Sunday
314.65
419.65
699.65 524.65
874.65
1049.65
Monday
244.65
349.65
804.65 699.65
1189.65
874.65
Tuesday
0
244.65
419.65 314.65
699.65
874.65
Wednsday
104.65
0
489.65 314.65
629.65
699.65
Thursday
209.65
244.65
629.65 419.65
769.65
944.65
Friday
349.65
559.65
1049.65 804.65
1224.65
1371.65
Saturday
419.65
769.65
1224.65 944.65
1574.65
2274.65
Total
Average
Minimum
Maximum
Daily Target
Weekly Target
# of Rooms
Avg. Sale/Room
244.65
1712.55
384.65
2692.55
759.65
3917.55
999.65
4897.6
1129
6122.55
1300
7837.55
105
210
175
140
42
28
Create Date
By Whom
12/15/2018 William Mattingly
Mod. Date
By Whom
Description
Workbook Name
Mod. Description
Last Version Backup Name
Create Date
Sheet Name
12/15/2018 RoomServiceAnalysis
Creator
William Mattingly
Purpose
Analysis of weekly room serice charges
20180219012316copy_of_johnson_iii_e01_grader_h1_roomservice.xlsx
_grader_h1_roomservice.xlsx
B-Trendz, Inc.
2018 Quarterly Sales
Quarter 1
Women’s Clothing
Activeware
Casual shirts
Graphic Tees
Jackets
Jeans
Outerwear
Pants
Shorts
Sleepwear
Socks
Sweaters
Swimsuits
Total
734,765
245,198
457,000
312,789
423,465
182,746
293,476
192,782
283,927
124,587
239,847
234,987
Quarter 1
Men’s Clothing
Activeware
Casual shirts
Graphic Tees
Jackets
Jeans
Outerwear
Pants
Shorts
Sleepwear
Socks
Sweaters
Swimsuits
Total
445,321
324,987
267,210
392,876
283,746
182,649
294,517
222,036
99,254
122,475
101,345
75,978
Quarter 1
Grand Total
Women’s % of Sales
Men’s % of Sales
Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance
745,777
256,789
478,123
311,987
413,726
201,725
291,234
197,315
281,334
125,079
242,703
310,719
732,937
255,936
477,229
312,892
414,756
200,273
293,745
198,295
280,687
126,213
245,666
306,827
740,375
251,529
472,721
315,837
419,202
194,768
297,312
193,800
285,111
121,510
247,897
245,321
Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance
446,123
325,968
269,432
394,836
284,998
184,316
301,512
226,897
97,312
122,978
94,968
79,196
449,154
331,825
272,045
395,185
293,199
186,978
310,936
229,465
98,251
126,253
90,156
83,926
451,876
337,345
274,123
395,987
300,154
185,285
312,123
232,000
97,945
127,423
98,127
76,293
Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales Goal Met?
Product
Line
Ranking
Online
Product
Product
Line
Ranking
Online
Product
Product Line Rank
0
E
500,000
D
1,000,000
C
1,250,000
B
1,500,000
A
Sales Goal Increase
for 2019
5%
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Year Sales
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Yearly Sales
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Yearly Sales Sales Goal Met?
Women’s Clothing
Activeware
Casual shirts
Graphic Tees
Jackets
Jeans
Outerwear
Pants
Shorts
Sleepwear
Socks
Sweaters
Swimsuits
Total
Men’s Clothing
Activeware
Casual shirts
Graphic Tees
Jackets
Jeans
Outerwear
Pants
Shorts
Sleepwear
Socks
Sweaters
Swimsuits
Total
2018 Predicted Total
Company Options
Service/Product
Maintains website
Cost
Loan Options
Term in Years
Interest
Monthly Payment
Total Loan Payment
Total Interest
Best Option
Online Solutions
Online For You
Creative Development
Designs website for
Designs website for
Designs website for
online product sales
online product sales
online product sales
1
2
3
$
100,000.00 $
110,000.00 $
120,000.00
5
5.05%
5
5.05%
5
5.05%
Portable Table Use
Employee
Christy
Kendra
Jason
Pat
Times Used
15
9
16
5
Massage Distribution
Christy
Kendra
Jason
Pat
Massage Totals
Type of Massage
Pregnancy
Shiatsu
Thai
Hot Stone
Sports
Reflexology
Deep Tissue
Swedish
Back
Aromatherapy
Total
Number of
Massages
14
19
24
32
41
47
74
91
84
87
Massages over 8 week period
Type of Massage
Week 1
Week 2
Pregnancy
2
Shiatsu
1
Thai
4
Hot Stone
1
Sports
6
Reflexology
5
Deep Tissue
15
Swedish
9
Back
12
Aromatherapy
10
Week 3
3
4
2
1
5
7
3
7
15
15
Week 4
4
4
2
2
5
10
2
15
6
7
Week 5
1
1
2
5
7
8
9
14
5
8
Week 6
1
1
5
6
8
4
8
11
13
12
1
3
4
6
3
4
11
10
11
14
Week 7
Week 8
1
2
3
5
3
5
12
13
10
10
1
3
2
6
4
4
14
12
12
11
Total Revenue
Sports
Hot Stone Deep Tissue Back
$ 11,264.00 $ 5,606.00 $ 14,606.00 $ 13,618.00
Date
Sports
6/1/2018
6/2/2018
6/3/2018
6/4/2018
6/5/2018
6/6/2018
6/7/2018
6/8/2018
6/9/2018
6/10/2018
6/11/2018
6/12/2018
6/13/2018
6/14/2018
6/15/2018
6/16/2018
6/17/2018
6/18/2018
6/19/2018
6/20/2018
6/21/2018
6/22/2018
6/23/2018
6/24/2018
6/25/2018
6/26/2018
6/27/2018
6/28/2018
6/29/2018
6/30/2018
498
468
466
215
254
325
412
422
396
321
286
327
325
415
468
467
434
215
245
400
326
452
500
457
368
265
319
389
417
412
Hot Stone Deep Tissue Back
238
523
275
567
184
501
78
462
231
523
25
524
238
487
184
498
256
567
88
420
140
479
134
582
123
511
207
468
199
566
236
526
195
534
34
367
134
419
89
426
242
479
297
564
176
560
242
524
239
343
162
365
125
384
192
438
279
523
364
476
546
572
505
438
295
257
345
617
665
321
372
358
368
459
621
676
536
412
501
370
401
485
443
451
471
413
421
390
423
486
Massage Room Redesign Project
Project Planning
Gathering Bids
Design
Installation
Painting & Decorating
Manager
Irene
Irene
Meda
Irene
Meda
Hours
Completed Remaining
75
15
73
29
98
11
45
20
23
32
Client Survey Data
Age Temp 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
44
60
26
42
33
36
75
75
76
72
74
74
74
90
75
79
87
86
97
96
Reflexology
Deep Tissue
Thai
Sports
Reflexology
Aromatherapy
Back
2017 Product Sales
Month
January
February
March
April
May
June
July
August
September
October
November
Quantity
90
50
80
95
98
120
90
50
101
115
156
Profit
$ 405
$ 450
$ 500
$ 700
$ 689
$ 842
$ 835
$ 450
$ 500
$ 700
$ 1,652
Hair Products Sold Over the Last 12 Month
Units Sold
Shampoo
Conditioner
Treatment
Styling
For Men
Profit
Shampoo
Conditioner
Treatment
Styling
For Men
January
25
14
38
20
25
$ 1,090.50
$ 1,786.50
$ 1,236.00
$ 651.20
$ 551.00
February March
April
23
23
24
44
31
39
50
14
26
26
May
41
48
67
19
25
June
20
46
50
18
14
July
17
38
44
22
13
30
42
47
15
40
Hair Product Sales
For Men
Styling
Treatment
Conditioner
Shampoo
0
10
20
30
40
e Last 12 Months
August
27
39
35
24
35
September October
November December
34
19
10
14
22
26
34
25
54
21
45
44
33
11
25
45
12
10
50
14
Hair Product Sales
December
November
October
September
August
July
June
May
April
40
50
60
70
80
March
Massage
Item
A9
A10
A11
A12
Item
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13
A14
A15
A16
A17
A18
A19
A20
Description
Healthy Trail Mix
Resort Polo
Healthy Energy Bar
Spirits Lifted Through Yoga
Golf Tees
Golf
Item
A16
A17
A18
A19
Projection
4
5
6
6
Max_On_Hand
45
35
25
15
50
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
WholeSell Price
$
15,99
$
29,48
$
3,90
$
6,90
$
1,30
Sale Price
$ 21,99
$ 45,34
$
9,95
$ 14,95
$
2,59
Projection
5
5
5
5
Category
Food
Clothing
Food
Reading
Golf
Food
Item
A1
A3
A20
Projection
4
4
4
Delivery Time Current Inventory ReOrder_Point RushReOrderPoint
10
23
20
10
14
15
17
10
4
5
15
10
7
5
15
10
11
27
20
10
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
Novelty
Item
A13
A14
A15
Discontinue
N
N
N
Y
N
Reading
Item
Projection
A5
A6
A7
A8
Projection
5
6
7
ReorderStatus
Clothing
Item
A2
A4
Vendor
Vendor 1
Vendor 2
Vendor 1
Vendor 4
Vendor 5
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
Projection
Massage
Category
Category Item
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Projection
Actual
Categories
Massage
Golf
Food
Novelty
Reading
Clothing
Mon
Tues
Wed
Thur
Fri
Item
Beginning
inventory
Total out
Total in
Ending
Actual
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13
A14
35
33
48
10
52
10
22
15
20
30
22
10
23
25
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
A15
A16
A17
A18
A19
A20
12
14
16
33
27
15
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
Sat
Sun
Max Stock
Inventory
Discrepancy
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
On Target
25
20
15
10
30
30
30
30
30
30
30
30
30
30
Turnover
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
Description
Healthy Trail Mix
Resort Polo
Healthy Energy Bar
Spirits Lifted Through Yoga
Golf Tees
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
30
30
30
30
30
30
On Target
On Target
On Target
On Target
On Target
On Target
0,00%
0,00%
0,00%
0,00%
0,00%
0,00%
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
Transaction
Trans_Item
Trans_Qty
Trans_Category
WeekDay
Trans_Sold
Trans_Category
Food
Food
Golf
Food
Massage
Food
Food
Clothing
Clothing
Golf
Food
Massage
Food
Clothing
Clothing
Food
Food
Clothing
Golf
Novelty
Reading
Golf
Golf
Clothing
Novelty
Golf
Novelty
Novelty
Reading
Clothing
WeekDay
Mon
Mon
Wed
Thur
Fri
Fri
Fri
Fri
Sat
Sun
Thur
Mon
Wed
Thur
Fri
Fri
Sat
Sat
Mon
Mon
Mon
Tues
Wed
Wed
Thur
Thur
Thur
Fri
Fri
Sat
Trans_Sold
Trans_Sold
Sum
Average
Transaction
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Trans_Item
A1
A3
A5
A3
A6
A3
A1
A2
A7
A19
A1
A10
A1
A8
A2
A1
A3
A15
A13
A14
A4
A9
A5
A15
A17
A9
A14
A17
A18
A7
Trans_Qty
-14
5
-7
-14
-15
-16
-7
-10
-4
-2
15
-18
-6
-6
-13
-2
-17
-8
5
-11
-4
0
-18
-6
-4
-18
-13
-15
-14
-9
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
Trans_Delivered
Trans_Delivered
20180219012317copy_of_johnson_iii_e03_grader_h1_inventory.xlsx
…
Purchase answer to see full
attachment
