e01_grader_h1_HotelDisc_YourOffice (solution) Homework | Page 6

13 Calculate the Gross Sales for One Double rooms for
4.000
Saturday night in cell B34 . Multiply the Standard Rate for each room type by the number of rooms rented of that type for Saturday night .
14 Calculate the Paradise Club discount total for One
3.000
Double rooms for Saturday night in cell B35 . To do so , multiply the number of Paradise Club rooms sold Saturday night by the Standard Rate by the Paradise Club Discount .
15 Calculate the group discount total for One Double rooms
4.000 for Saturday night in cell B36 . To do so , multiply the Standard Rate by the number of Group One Double rooms sold Saturday night by the Group Discount .
16 Calculate the Comp discount total for One Double
4.000 rooms for Saturday night in cell B37 . To do so , multiply the Standard Rate by the number of Comp One Double rooms sold Saturday night by the Comp Discount .