PLEASE USE EXCEL TO ANSWER THE FOLLOWING QUESTIONS, THANK YOU!!

ALL of the answers to this question already post on Chegg are wrong. Please do not just copy and paste.

Reservation Scheduling: Roth Auto Rentals, a car rental company specializing in SUVs, is making up a schedule for the next weekends demands. The peak demand period occurs on the weekend, when Roth may not have enough SUVs to meat demand. The customer demands that have been logged in are listed below.

Days	Customers
Friday Monday	1
Friday Saturday	4
Friday Sunday	5
Saturday Sunday	4
Saturday Monday	3
Sunday - Sunday	2

The rental cost depends on which days the contract covers, as shown in the next table.

Days	FSSM	FS	FSS	SS	SSM	Sunday
Rate	119.95	69.95	99.95	74.95	89.95	39.95

Roth Auto Rentals carries only one type of vehicle and expects to have 10 SUVs available for rent over the weekend.

1. Provide the complete integer linear programing formulation. Clearly specify decision variables, objective function and constraints.
2. Build a model in Excel and paste a screenshot here. Use FORMULATEXT in your model to show calculations.
3. What is the maximum revenue that can be generated from the list of orders?
4. In the optimal solution of (a), what percentage of customer demand is satisfied?
5. In the optimal solution of (a), what percentage of dollar demand is satisfied?
6. Answer the set of three questions above for fleet sizes of 11-16. You might want to adjust your model so you can use SolverTable and create a table to report your answers concisely.