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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
