Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

Hotel Management System in Excel (card 2 of 2)

Revision card 2 for Hotel Management System in Excel: Balance after advance: =N5-O5 gives ₹3,880.00; Total with GST and extras: =J5+L5+M5 gives ₹5,880.00; Occupancy %: =B6/$B$3 gives 37.5%.

Revision card 2 for Hotel Management System in Excel: Balance after advance: =N5-O5 gives ₹3,880.00; Total with GST and extras: =J5+L5+M5 gives ₹5,880.00; Occupancy %: =B6/$B$3 gives 37.5%.
Card 2 of 2: Hotel Management System in Excel · Download PNG
Read card text

What this card says

2 for Hotel Management System in Excel: Balance after advance: =N5-O5 gives ₹3,880.00

Total with GST and extras: =J5+L5+M5 gives ₹5,880.00

Occupancy %: =B6/$B$3 gives 37.5%.

Learn this in the lesson: Hotel Management System in Excel: Room Bookings, Daily Occupancy, ADR, RevPAR, GST Room Bill and Dashboard

See all Excel revision cards