The current solution listed is incomplete and some of the answers improperly answered.....

If someone can breakdown how to create the spreadsheet for C like is was for A that would really help......

File Edit View History Bookmarks Iools Help x C Solved: Round Tree Man x C The Current Solution Liste X f Facebook https://www. 1st-edition-chapter-8-problem -5p-solution-97 egg-co Most visited 3 Getting Started Payment Confirmation College Textbook Rev. Citation Machine: AP E Chegg Study TEXTBOOK SOLUTIONS EXPERT Q&A Chapter ProblemTOP Problem 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 Room Super Saver Deluxe Business Type I S30 $35 $20 S30 Type II S40 Type l rooms do not have wireless Internet access and are not available for the Business rental class. 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 rentals in the Deluxe class, and 50 rentals in the Business class. Round Tree has 100 Type I rooms and 120 Type ll rooms a. Use linear programming to determine how many reservations to accept in each rental class and how the reservations should be allocated to room types. Is the demand by any rental class not satisfied? Explain b. How many reservations can be accommodated in each rental class? C. Management is considering offering a free breakfast to anyone upgrading from a Super Saver reservation to Deluxe class. If the cost of the breakfast to Round Tree is $5, should this incentive be offered? d. With a little work. an unused office area could be converted to a rental room. lfthe conversion cost is the same for both types of rooms, would you recommend converting the office to a Type l or a Type Il room? Why? e. Could the linear programming model be modified to plan for the allocation of rental demand for the next night? What information would be needed and how would the model change? Search