The brand your hotel franchises has determined that they need to change the specifications for the sheets, pillows, towels and other terry products in order to “enhance” the guest perception of the brand. The requirement is that each hotel must be in full compliance by “X” date, which is rapidly approaching. Your ownership has given you approval to order the new products to a level that is consistent with your current approved par inventory.
For the first part of the assignment:
Using the spreadsheet provided, prepare the inventory order you will need in order to convert to the new standard, and have a complete par inventory – based on your current par inventory standards.
Order quantities are determined by the manufacturer, so you will need to place an order which gets you as close to the par inventory level as you can.
Using the prices provided, determine how much this purchase will cost.
For the second part of the assignment:
Assume it is now one month after your initially put your new inventory into service. Your housekeeping supervisor/manager has completed a physical inventory at the end of the month. You need to place an order for more inventory in order to bring your hotel back to the established par level.
Using the excel spreadsheet provided, calculate how much you will need to purchase.
Order quantities are determined by the manufacturer, so you will need to place an order which gets you as close to the par inventory level as you can.
Using the prices provided, determine how much this purchase will cost.
Write a professionally formatted memo to your General Manager which first describes what you’ve done in the first part of the assignment, and then what you needed to do at the end of the month as a part of your normal month end inventory and purchase procedure.