Description
The goal of these assignments are to relate back to the chapter and to show a proficiency in your understanding of the formulas that are discussed. The Apply What you know assignments are to be completed in Microsoft Excel or equivalent but must be uploaded in Excel format. Each of these assignments use the tables generated from the book as well as changes done by the professor to make them more user friendly. If you do not have a strong profiecency in Excel it is my advice that you use Youtube videos to help with this. Some weeks I will go into deep explanation about the assignments and what information should go into which cells. Other weeks I will assume that you should understand based on previous weeks assignments and because of the self-explanation of the assignment. The majority of the spreadsheets will have Red Cells that will convert to white when correct answers are achieved. This does not always work depending on the version of MS Excel you are using. Also the answer has to be exactly correct using Excel formulas. If you do not use formulas sometimes the cells will turn, other times they will not. Remember computers deal in absolutes 1’s and 0’s, right or wrong. The computer reads that 99.1% is different than 99.085648624% which you might get sometimes on an answer. Also there will be a counter in the upper Right hand corner, this counter will react also to correct and incorrect answers. There were some issues last semester with a couple of these exercises based on the fact that they take a lot of coding to make work. I think I have worked out the bugs but I am not certain.
Grading: The grading of these assignments will be based on the counter on the upper right hand corner and divided by the number of cells that the students had to fill in.
Deadlines: These assignments are due in the week that they are assigned. They will not be accepted as late. Please double check that you have uploaded the assignment. There have been rare occasions that Blackboard does not complete the upload when the user signs out and their assignment does not get entered. I will trust Blackboard 100% if there is no grade, the assignment is counted as a 0.
Weekly assignments should take no longer than 2 hours to complete. Take advantage of online tutorials provided by Microsoft or watch YouTube video how-tos.
Click the image to download this weeks template. The information can be found in your book on pages 201-205
Requirements: Fill in all cells in red
Chapter 6 Apply What You Know-Student Worksheet
H
ist
o
Ni rica
gh l T
tP h
er urs
fo da
rm y
an
ce
6.1
Thursday
Occ %
ADR
Weeks 2-5
Weeks 3-6
Weeks 4-7
Week 2
69.5%
$151.50
73.5%
$145.95
Rooms Sold
Revenue Sold
Occ%
Weeks 1-4
Week 1
ADR
RevPAR
Week 3
Week 4
Week 5
Week 6
Week 7
66.5%
72.0%
72.5%
69.0%
77.0%
$161.50
$178.50
$179.95
$129.95
$159.95
Correct
Answers
0
Cells to Assignme
Fill-in
nt %
90
0%
6.2
Occupancy Report: The Doubletree Hotel
For Dates May 1–14
Run Date: Today
Date
Day
5/1
5/2
5/3
5/4
5/5
5/6
5/7
5/8
5/9
5/10
5/11
5/12
5/13
5/14
Rooms
Available
Mon
Tues
Wed
Thur
Fri
Sat
Sun
Mon
Tues
Wed
Thur
Fri
Sat
Sun
Reserved
500
500
500
500
500
500
500
500
500
500
500
450
450
450
Blocked
210
175
200
90
220
100
275
100
60
210
175
200
Total Held
Current Occ.
%
60
420
50.00%
110
300
75.00%
25
350
250
210
175
60
90.00%
420
420
Total
For Dates May 1–14
Availability Report: The Doubletree Hotel
Run Date: Today
Date
Day
5/1
5/2
5/3
5/4
5/5
5/6
5/7
5/8
5/9
5/10
5/11
5/12
5/13
5/14
Total
Mon
Tues
Wed
Thur
Fri
Sat
Sun
Mon
Tues
Wed
Thur
Fri
Sat
Sun
Rooms
Available
Reserved
500
500
500
500
500
500
500
500
500
500
500
450
450
450
Blocked
210
175
200
90
220
100
275
100
60
210
175
200
Total Held
Available for
Sale
60
420
250
110
300
125
25
350
250
210
175
60
420
420
225
12:49
Not Secure-utntyh.com
219 of 530
APPLY WHAT YOU KNOW
Lle
Cand she washer
DES
3 Work Wk Work
770
SIS
Occupancy Report The Doubletree Matal For Dames Bay 3-36
Rue Date Today
Bay
DES FORECASTING
Occupancy Report The Doubletree Metal For Duties May 3-14
Run Date: Today Card)
Current
Day
SI
12:49
Not Secure-utntyh.com
220 of 530
DES FORECASTING
Occupancy Raport: The Doubletree Metal For Duties May 3-14
Run Date: Today Card)
Care
Day
SU
BRDO
ASE
Availability Report The Doubletree Hotel For Bates May 2-24
Run Date: Today
DE
SSSSSSSS
8
DE
copa
cand
September This Year Gr Room Sales
12:49
Not Secure-utntyh.com
5.10
alla
th
221 of 530
200
.
Series
September This Year: Gra Room Sales
–
Hawthorne Suites
Group Room Pace Report for Jane New
Rome et
ORBA
204 DERFOR
Hawthorne Suites Hotel
Group Room Pace Report for decente Continued
Torce
Room Dec
III.
TOTAL
12:49
Not Secure-utntyh.com
BA
222 of 530
BASEBE
20
Hawthorne Sulher Martel
Group Rooms Past Report FerenBec Heater Continued
TO
Hawthorne Sulhes um
Group Room Pace Report Fornectar
Roman-Dec
DER
come Todas
.
Rooms Forecast
Tuesday
Day Today
Purchase answer to see full
attachment
