D Painted Paradise Resort & Spa Banquet Room Renovations Created by Lesa Martin 1 Projected Quarterly Revenue after Renovations Projected Room Classification Length of Renovations In Days Original Capacity 100 250 25 45 25 New Quarterly Revenue Prior Capacity to Renovations 290,000 475,000 150,000 225.000 75,000 Renovations Started Renovations Completed The Musica Room The Musica Room 27122 7 Thelorado Room 315222 7/15/22 The Pueblo Room 9/10/22 11/30/22 Technology room 1 1/1/22 101/22 10 Technology room 2/1572 4/15/22 11 12 Increase in Capacity 30% 14 increase in Revenue 40N 15 16 Loan Information 17 Amount of loan 225,000 18 Annualidate 6% 19 Terminal 10 Monty Payment 21 22 Room Classification 23 D Bron 24 250,000 Stiver 25 500,000 Gold 26 750,000 Platinum 22 12 You have been asked to determine how long the renovation of each room will take in days. You have decided to use a DATEDIF function to perform this calculation. On the Renovations worksheet, in cell D6, enter a DatedlF function based on the renovations started * and renovations completed dates to determine the length in days of the expected renovation for the Musica Room Copy this formula through cell D10. 10 Using the Name Box, select the named range IncreaseInRevenue. You notice the named range refers to a blank cell. Therefore, you want to correct the named range. Modify the named range Increaseln Revenue to reference cell B14, not cell B15. After renovations, each room will have more capacity. You want to determine the projected capacity after the renovations have been completed. In collG6, enter a formula to determine the new capacity for the Musica Room based on the original capacity in cell F6 and the increase in capacity in cell B13. Copy this formula through coll G10. 6