Problem Description: Consider the following information provided to you by Sandy Hill Motel that provides short-term - Number of Rooms available (maximum occupancy): 25 - Typical Room Rent per day: $75 - Daily Fixed Costs for Motel (wages, mortgage etc.): $850 - Variable Cost per room per day (cleaning, 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 Sana 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 ($75) to break e 2) At maximum occupancy, how much should the motel charge to make a profit of $1000 per da 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" Excel OneDrive Book . Saved to OneDrive Go Premium Faisal ahmed Sign out File Home Insert Formulas Data Review View Help Tell me what you want to do Open in Desktop App Share Comments 5 Xat Copy 3 EXP Insert Delete Format 47 O D E Conditional Cell Format Formatting Styles Table Autosun Clear Paste BIUDA - Ideas Sort Filter Editing Find & Select 3 Format Painter Clipboard Undo Alignment Number Tables Cells Ideas A B C D E F G H I J K L M N O P Q R S T U V