1.You have been assigned to conduct a budget for the next month sales for the Space Mountain roller coaster at Disney World, Florida.

A. Management believes that the number of seats will most likelyincreaseby 15% due to the high tourism season for the following 3 weeks.

Using the information provided above and the first week of actual sales in the example below, conduct and createa short-term budget spreadsheet for the next 3 weeks.(Round-up the number of occupied seats to the nearest seat/person)

View the budgeting spreadsheet below:

Sales Budget Week1 Week2 Week3 Week4

Number of Occupied Seats. 75

Cost Per Seat. $25

Total $1,875

B. You are provided with the first week of actual sales. The followingmonth will be back to school time and management believes that the number of seats will most likelydecreaseby 10% since everyone will be back to school.

Using the information provided above and the first week of actual sales in the example below, conduct and construct a short-term budget spreadsheet for the next 3 weeks.(Round-up the number of occupied seats to the nearest seat/person)

View the budgeting spreadsheet below:

Sales Budget Week 1 Week 2 Week 3 Week4

Number of Occupied Seats. 65

Cost Per Seat. $25

Total $1,625

Hint:Similar examples are provided in the Week 3 Budgeting Excel worksheet.

2.Welcome to the Hotel California. You are assigned to budget for the next quarter operation. We are in September and the hotel needs to budget for the 4th quarter; for October, November, and December. The expected occupancy is estimated to be 2000 rooms. Each room will require 5 hours of room service. The hourly rate is $17 per hour. Your cost of food is $17 for breakfast; currently, your food purchase's total amount is $6000 and you would like to keep on hand $9000 for the New Year beginning inventory.Room rate is estimated to be $250.

1. Construct a sales budget.
2. Construct a direct labor budget for the upcoming quarter.
3. Construct direct material/purchases budget for the upcomingquarter.