Please fill in this chart using the values included. Drop down choices are included in the photos below.

Here are the drop downs for first 3 rows

And these are the variables for the bottom half, Please fill in values according to the information

Grand Garden is a luxury hotel with 155 suites. Its regular suite rate is $210 per night per suite. The hotel's cost per night is $135 per suite and consists of the following. Variable direct labor and materials cost Fixed cost [(S5,870,000/155 suites) 365 days] Total cost per night per suite S 31 104 $ 135 e local Bikers' Club The hotel manager received an offer to which is the hotel's low season with an occupancy rate of under 60%. The Bikers' Club would reserve 45 suites for three nights if the hotel could offer a 60% discount, or a rate of $84 per night. The hotel manager is inclined to reject the offer because the cost per suite per night is $135. The manager believes that if 45 suites are offered at the rate of $6,885 per night for three nights, the hotel would lose $6,885, computed as ($84-$135) x 45 suites x 3 nights. Required: Prepare an analysis of this offer for the hotel manager. Contribution margin analysis