Scenario: You are the regional manager of the QC Inn, a nationwide chain of affordable motels for vacationing families & business travelers. You will be preparing year end reports for $24$ QC Inn franchises located in Nebraska$/$South Dakota region.

Open QC Inn file & save as QCInn$\_$yourfirstnamelastname: Example: QCInn$\_$JohnDoe. Fill out Documentation Sheet with Your Name & Date. Review the data on the Motels & Terms & Definitions Sheets. On the Motels Sheet: Complete the Occupancy Rates, ADR & Rev Par$($Columns K$,$ M & N$).$

Create PivotTables to answer the following questions:

NOTE: Format ALL Value fields accordingly$-$accounting or currency, $\%,$ commas & NO decimals: For an example: $$134,000,5\%,56,000$

When complete: Submit in Blackboard: HW Assignment # $2($PivotTables$)$

$1.$ Total number of Rooms rented each Year

$2.$ Total Revenue by Motel

$3.$ Total Rooms rented by Region & State

$4.$ Total Motel Rooms & Rooms Rented per City