I've attached the excel screenshot below and the same has to be worked on. NO MANUAL or HAND WORK PLEASE

Rembrandt Hotel & Casino is situated on the beautiful Lake Tahoe, in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant. As Rembrandts new controller, you are asked to recommend the basis to be used for allocating fixed overhead costs to the three divisions in 2011. Download the Rembrandt calculations to access the information:

You may choose to allocate indirect costs using 4 different cost allocation bases: sales, segment margins, square feet x number of employees, and equal allocation. Total fixed overheads for 2010 amounted to $14,550,000. The Excel file presents the profitability calculations according to the 4 cost allocation bases aforementioned

1-

Choose one or several options among the following. Would you:

		Shut the hotel
		Shut the restaurant
		Shut de Casino
		Keep all the activities
		We don't have enough information
		None of the above

Do you think there are synergies between the 3 activities?

		Yes
		No
		We don't have enough information

Usually, the overheads in a company are rather:

		variable
		fixed

		Yes
		No
		We don't have enough information

Hotel $16,425,000 Restaurant $5,256,000 Casino $12,340,000 total $34,021,000 sales direct costs $9,819,260 $3,749, 172 $4,248,768 $17,817,200 direct margin or contribution ($) $6,605,740 $1,506,828 $8,091,232 $16,203,800 overheads 14550000 direct margin or contribution (%) 40.22% 28.67% 65.57% 47.63% Hotel Restaurant Casino total Hotel Restaurant Casino total $7,024,595 $2,247,870 $5,277,534 $14,550,000 square feet 80000 16000 64000 160000 indirect costs allocated using sales as a cost allocation base (CAB) allocated using segment margins as a CAB allocated using square feet x employees as a CAB $5,931,542 $1,353,037 $7,265,421 $14,550,000 employees 200 50 250 500 $7,097,561 $354,878 $7,097,561 $14,550,000 square feet x employees 16000000 800000 16000000 32800000 allocated on an equal basis $4,850,000 $4,850,000 $4,850,000 $14,550,000 Hotel Casino total Restaurant $741,042 $418,855 $2,813,698 $1,653,800 $674,198 $153,791 $825,811 $1,653,800 income when using sales as a CAB income when using segment margin as a CAB income when using square feet x employees as a CAB income when allocating indirect cost equally -$491,821 $1,151,950 $993,671 $1,653,800 $1,755,740 $3,343,172 $3,241,232 $1,653,800