310 likes | 613 Views
Hotel Room Inventory System. Mason Frazee, Pam Murphy, Keynan Kohen , and Cecily Hooper. Introduction. A pen and paper system that will be replaced by more efficient technology Rising use of tablets into the workplace Need for more precise inventory tracking Relatively inexpensive .
E N D
Hotel Room Inventory System Mason Frazee, Pam Murphy, KeynanKohen, and Cecily Hooper
Introduction • A pen and paper system that will be replaced by more efficient technology • Rising use of tablets into the workplace • Need for more precise inventory tracking • Relatively inexpensive
Hard Data • Essential Components to System: • Housekeeping needs an easy system, most can’t speak English • General Manager has experience with excel based applications • There are 74 rooms in the hotel, 36 double queen beds, the rest king • Each room gets 2 soaps, 1 shampoo, 2 bath towels, 2 wash cloths, 1 hand towel • Each room has 1 fitted sheet, 1 regular sheet, 1 comforter, 1 blanket, 4 pillows per bed • Storage capacity is ~150 for each item