Calculate In Hospitality Major

  

I just posted the word document that include the assignment request.
hosp3033_extra_credit_assignment_1.docx

Unformatted Attachment Preview

HOSP3033 Hotel Property Operations
Extra Credit Assignment 1
Due Date: April 17th at 11:59 PM
Point Value = 1 (successful completion will add 1 point to your final grade)
Using an Excel spreadsheet, complete the inventory worksheet listed below.
As the assistant to the executive housekeeper of a Hilton hotel in Austin, Texas, you have been
asked to compile the linen inventory for the month of May, ascertain the loss (shrinkage) for the
month and figure out the number of pieces to be ordered from the vendor to bring up the par to
four for each category.
Beginning inventory
Purchased in May
Sheets
750
100
Physical inventory on 5/30
In guestroom
In laundry room
In floor closets
Under lock and key
Discarded
180
300
50
80
0
Pillowcases
780
200
180
325
75
50
10
Bath towels
1500
50
Hand towels
1450
75
360
525
140
180
15
360
480
225
190
12
The hotel has 102 rooms with one king-size bed each. You supply two bath towels per person,
two pillowcases per bed, and four hand towels per room.
…
Purchase answer to see full
attachment