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