Problem Description: Consider the following information provided to you by Sandy Hill Motel that provides short-term room rentals for students at Ottawa Number of Rooms available (maximum occupancy): 25 Typical Room Rent per day: $75 Daily Fored Costs for Motel (wages, mortgage etc.): $850 Variable Cost per room per day (deaning, supplies etc.): $15 Tasks: Create a new worksheet called "Profit Analysis, and complete the following tasks: Based on the information above, setup a mathematical model to calculate the profit for the Sandy Hill Motel. Use the Goal Seek tool to answer the following questions: 1) How many rooms would Sandy Hill Motel need to rent out at the current rent (575) to break even? 2) At maximum occupancy, how much should the motel charge to make a profit of $1000 per day? Provide screenshots of your models in (1) and (2) showing the final values in your model. Paste these screenshots in separate worksheets called "Screenshot-1" and "Screenshot-2" Instructions Problem Description: Consider the following information provided to you by Sandy Hill Motel that provides short-term room rentals for students at Ottawa Number of Rooms available (maximum occupancy): 25 Typical Room Rent per day: $75 Daily Fored Costs for Motel (wages, mortgage etc.): $850 Variable Cost per room per day (deaning, supplies etc.): $15 Tasks: Create a new worksheet called "Profit Analysis, and complete the following tasks: Based on the information above, setup a mathematical model to calculate the profit for the Sandy Hill Motel. Use the Goal Seek tool to answer the following questions: 1) How many rooms would Sandy Hill Motel need to rent out at the current rent (575) to break even? 2) At maximum occupancy, how much should the motel charge to make a profit of $1000 per day? Provide screenshots of your models in (1) and (2) showing the final values in your model. Paste these screenshots in separate worksheets called "Screenshot-1" and "Screenshot-2" Instructions