兰州皇冠假日酒店财务报表(估计)MA

Breakeven BE Unit = fixed / (price - variable cost per unit) Undistributed Exp Allocation rate to room Total Fixed cost of Room BE Unit of Room BE Occupancy Allcation Rate to F&B Toital Fixed Cost of F&B BE Unit of F&B BE Seat Turnover 77,436,615 66% 51,108,166 74,829 47% 34% 26,328,449 147,086 0.74
6,642,277 3,985,366 18,673,566 3,985,366 4,649,594 74,752,673
7,012,761 4,207,656 18,673,566 4,207,656 4,908,932 76,234,609
udget 2,016 1 798 440 88,398,721 38,434,227 23,979,355 150,812,303 6,032,492 2,262,185 29,510,000 7,540,615 4,524,369 18,673,566 4,524,369 4,524,369 77,591,966 2,017 1 814 440 87,553,168 38,066,595 19,183,484 144,803,247 5,792,130 2,172,049 29,510,000 7,240,162 4,344,097 18,673,566 4,344,097 4,344,097 76,420,200
Initial Investment Land Building Decoration Equipment Initial Franchise fee Others Initial Investment 43,600,000 110,000,000 77,000,000 100,300,000 1,000,000 36,800,000 368,700,000 Fixed Cost Sales and marketing fee(4% of Sales Revenue) General and administrative(1.5% of Sales Revenue) Depreciation 2,012 4,994,766 1,873,037 29,510,000
istrative Expense
No.of Room Occupancy rate ADR Sales Revenue of Room
Room Revenue 2,012 440 1 703 73,849,067 Restaurant Revenue 2,012 89 195,108 17,352,906 300 40,080 12,005,563 120 1,740 208,800 42 22,368 930,061 84 19,524 1,636,697 204,252 32,338,279 18,681,796 124,869,142
6,243,457 3,746,074 18,673,566 3,746,074 4,370,420 73,157,395 20/room/day 10/seat/day
Sales Budget 2,015 Occupancy 1 ADR 782 Room Available 440 Room Revenue 85,409,393 F&B Revenue 37,134,519 Other Revenue 21,799,414 Total Sales Revenue 144,343,325 Selling and Administrative Expense Sales and marketing fee(4% of Sales Revenue) 5,773,733 General and administrative(1.5% of Sales Revenue) 2,165,150 Depreciation 29,510,000 Royalty fee(5% of Sales Revenue) 7,217,166 Maintance(3% of Sales Revenue) 4,330,300 Payroll 18,673,566 Management fee(3% of the Revenue) 4,330,300 Public Utilites 4,330,300 Total Selling and Administrative Expenses 76,330,515
River Café Average check Cover Restaurant Revenue Chinese Restaurant Average check Cover Restaurant Revenue Persia Average check Cover Restaurant Revenue Lobby Lounge Average check Cover Restaurant Revenue Room Service Average check Cover Restaurant Revneue Mini Bar Restaurant Revenue Total F&B Revenue Revenue from other departments Total Sale Revenue
Royalty fee(5% of Sales Revenue) Maintance(3% of Sales Revenue) Payroll Management fee(3% of Sales Revenue) Public Utilites Total fixed cost Variable cost of room Variable cost of F&B
evenue 2,013 440 1 721 78,113,688 Revenue 2,013 92 204,863 18,949,373 312 42,084 13,110,075 125 1,827 228,010 43 23,486 1,015,627 87 20,500 1,787,273 212,422 35,302,780 19,429,068 132,845,535 2,014 96 208,961 19,966,196 322 42,926 13,813,562 129 1,864 240,245 45 23,956 1,070,126 90 20,910 1,883,178 216,671 37,189,977 19,817,649 140,255,214 36,973,306 298,616 124 2,014 440 1 752 83,247,588
397,969,891
0
Life Period Salvage value of Building Land Depreciation
ຫໍສະໝຸດ Baidu
10 years 30,000,000 43,600,000 29,510,000
Salvage value
73,600,000
Cost 2,013 5,313,821 1,992,683 29,510,000 2,014 5,610,209 2,103,828 29,510,000