$1)$ After renovations, each room will have more capacity. You want to determine the projected capacity after the renovations have been completed.

In cell G$6,$ enter a formula to determine the new capacity for the Musica Room based on the original capacity in cell F$6$ and the increase in capacity in cell B$13.$

Copy this formula through cell G$10.$

After renovations, each room will have more capacity. You want to determine the projected revenue after the renovations have been completed.

$2)$ In cell I$6,$ using the named range in cell B$14,$ enter a formula to determine the projected increase in revenue for the Musica Room based on the revenue figure in cell H$6$ and the increase in revenue percentage in cell B$14.$

Copy this formula through cell I$10.$