please use excel and display formulas, thank you

Problem 2_This is a new one where we have two rows in the Model instead of 1. See the solution. Specifically note the profit sumproduct formula). Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Rental Class Deluxe Room Super Saver Business Type I (Mountain View) $30 $35 Type II (Street View) $20 $30 $40 Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 130 rentals in the Super Saver class, 60 in the Deluxe class, and 50 in the Business class. Since these are the forecasted demands, Round Tree will take no more than these amounts of each reservation for each rental class. Round Tree has a limited number of each type of room. There are 100 Type I rooms and 120 Type II rooms. Objective: Determine how many reservations to accept in each rental class and how the reservations should be allocated to room types. Problem 2_This is a new one where we have two rows in the Model instead of 1. See the solution. Specifically note the profit sumproduct formula). Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental class is as follows: Rental Class Deluxe Room Super Saver Business Type I (Mountain View) $30 $35 Type II (Street View) $20 $30 $40 Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 130 rentals in the Super Saver class, 60 in the Deluxe class, and 50 in the Business class. Since these are the forecasted demands, Round Tree will take no more than these amounts of each reservation for each rental class. Round Tree has a limited number of each type of room. There are 100 Type I rooms and 120 Type II rooms. Objective: Determine how many reservations to accept in each rental class and how the reservations should be allocated to room types