HomeApplicationOffice informationPractice practicing hotel expense index in Excel

Practice practicing hotel expense index in Excel

The following article gives detailed instructions for you to practice on how to calculate the values ​​in the hotel cost list in Excel 2013.

The example has the following data table:

Practice practicing hotel expense index in Excel Picture 1

Calculate the amount the tenant will pay at the current dollar rate.

To calculate the amount the tenant must pay: The number of tenants, the type of room the tenant uses to calculate the unit price, the number of holidays and the unit price on a single day the tenant.

Step 1: Calculate the number of tenants the week -> Enter the formula: = INT ((F5-E5) / 7) -> press Enter the number of tenants the week is:

Practice practicing hotel expense index in Excel Picture 2

Step 2: Similarly copy the remaining values ​​to result:

Practice practicing hotel expense index in Excel Picture 3

Step 3: Calculate weekly unit prices based on the notes below -> enter the formula: = IF (D5 = "A", $ F $ 13, IF (D5 = "B", $ F $ 14, IF (D5 = "C", $ F $ 15, IF (D5 = "D", $ F $ 16, $ F $ 17))))

Practice practicing hotel expense index in Excel Picture 4

Step 4: Press Enter -> weekly unit price and room type are:

Practice practicing hotel expense index in Excel Picture 5

Step 5: Similarly copying the formula to the remaining values ​​results:

Practice practicing hotel expense index in Excel Picture 6

Step 6: To calculate the number of holidays enter the formula: = MOD (F5-E5,7) press Enter -> number of holidays is:

Practice practicing hotel expense index in Excel Picture 7

Similarly copy for the remaining values.

Step 7: Calculate daily price based on room type -> enter the formula: = IF (D5 = "A", $ H $ 13, IF (D5 = "B", $ H $ 14, IF (D5 = "C" , $ H $ 15, IF (D5 = "D", $ H $ 16, $ H $ 17))))

Practice practicing hotel expense index in Excel Picture 8

Step 8: Press Enter and make a copy for the remaining values:

Practice practicing hotel expense index in Excel Picture 9

Step 9: Calculate the total amount payable by the customer -> enter the formula: = MIN (H5, ((I5 * J5) + (G5 * H5))) * $ F $ 12 -> press Enter -> total payment was:

Practice practicing hotel expense index in Excel Picture 10

Step 10: Similarly copying the formula to the remaining values ​​results:

Practice practicing hotel expense index in Excel Picture 11

The above is a detailed guide on how to declare hotel microcomputer rent in Excel 2013.

Good luck!

4.3 ★ | 3 Vote

You should read it

May be interested

  • Practical exercises on Notebook price list in ExcelPhoto of Practical exercises on Notebook price list in Excel
    the following article gives detailed instructions for you to practice on how to calculate values ​​in notebook price list in excel 2013. for example, there is the following data table: calculating the total amount payable by customers including vat 5%. to calculate the amount the tenant must
  • Practical exercise on computer rental list in ExcelPhoto of Practical exercise on computer rental list in Excel
    the following article provides detailed instructions for you to practice on how to calculate the values ​​in the computer rental list in excel 2013. for example, the following data table: calculating the amount of computer tenants must pay, calculate the total number of hours rent and the total amount t
  • Practical exercise on production statistics table in ExcelPhoto of Practical exercise on production statistics table in Excel
    the following article guides you in detail practical exercises on production statistics table in excel 2013. for example, the following data table: making production statistics table. first calculate the total value of the items. use live data statistics chart
  • Practice exercises on payroll in ExcelPhoto of Practice exercises on payroll in Excel
    the following article gives detailed instructions to you practice exercises on payroll in excel. for example, there is the following data table: calculating employee's gross salary, calculating the maximum value of salary, advance and remaining, average and minimum value
  • Hide and show gridlines in ExcelPhoto of Hide and show gridlines in Excel
    the following article gives you a detailed guide on how to show gridlines in charts in excel 2013. for example, creating a chart without grid lines: to display gridlines in a chart, do the following:
  • Hide and show chart labels in ExcelPhoto of Hide and show chart labels in Excel
    the following article will guide you in detail how to show / hide chart labels in excel. for example, the following chart is created: 1. want to add revenue details for employees displayed on the chart do the following.

Office information