Apply What You Know #6

Anonymous
timer Asked: Jan 26th, 2021

Question 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

Apply What You Know #6
attachment_1
Apply What You Know #6
attachment_2
Apply What You Know #6
attachment_3
Apply What You Know #6
attachment_4

Unformatted Attachment Preview

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 ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.
Tags: FIU

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors