4. Terry Ray manages a large hotel in an urban Midwestern city. He wants to use vertical analysis and a slightly modified version of the USALI income statement (P\&L) for his property to assess its financial performance last year. Complete the spreadsheet to help him evaluate his effectiveness as a manager. a. The owner gave Terry a goal of 65% for total operated department income. Did Terry perform better or worse than this goal? By how much? b. The owner also gave Terry a goal of 22% total undistributed operating expenses. Did Terry perform better or worse than this goal? By how much? c. The owner gave Terry a goal of 20% net income for the year. Did Terry perform better or worse than this goal? d. If you answered that Terry did not meet his goal in Question c, what could he do to get his P\&L in line with the Terty's P\&L (Cinfinuad