Question: Please show formula and show HOW TO CALCULATE FROM STEP BY STEP! I have to follow the structure and put into excel THANK YOU! You

Please show formula and show HOW TO CALCULATE FROM STEP BY STEP! I have to follow the structure and put into excel THANK YOU!

You are the manager of new 25 room-hotels and you would like to set the selling price per room. The following items are estimated expenses:

Human resources 1,200,000 Baht per year

Selling expenses 800,000 Baht per year

Administrative expenses 610,000 Baht per year

Direct expenses Baht 300 per room sold

Occupancy Rate 80%

Tax rate 20%

If you would like to have Net Income (after tax) 2,000,000 Bath per year, how much do you set the price per room?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!