The Crystal Coast Ocean Resort (CCOR) is a large, family-owned resort located on one of the finest beaches in North Carolina. The Resort is locally called the Ramada Inn: Crystal Coast Ocean Resort, because it has a contractual relationship with Ramada Inn, Inc which requires Ramada to provide reservation services and certain marketing services. In turn CCOR pays an annual fee to Ramada and displays the Ramada Inn sign. Ramada has the right, under contract, to require CCOR to meet Ramada standards for resort services, cleanliness, etc, and regularly visits CCOR to make sure that these standards are being met. CCORs main building has a T-configuration, where the top of the T is road-side and the bottom of the T is at the beach. This allows all rooms to have at least a partial view of the beach. There are five types of rooms for guests, oceanfront (actually facing the ocean, at the bottom of the T), ocean view (along the sides of the T), pool side (first floor, with patios having direct access to the pool), and one and two-bedroom suites that are located at the top of the T.

Analyses the information you have completed and write a two-page paper that describes what insights management gains from this analysis.

AutoSave ) HD Crystal Coast Ocean Resort Workbook.XLS Compatibility Mode Excel Search Thu H. Nguy H. File Home Insert Draw . Page Layout Formulas Data Review View Developer Help Share Comments O AutoSum X La Arial 10 -AA Wrap Text General 2 IT NI 28 O 4 FI O Peste BUw , Insert Delete Format Ideas Sensitivity YA Merge & Center $ -% 78-8 Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Coils Editing Ideas Sensitivity H24 G H J L M N B Utilities 210,000 C D Other Facilities General and Administrative 1,900,000 400.000 Operatione 1,920,000 Total assigned 4,430,000 Poolside Total 350 1 Room 161 0.5 2,920 92.820 Ocean front 50 0.8 14,600 3 43.800 300 15,000 Oceanview 250 0.75 68,437.5 3 3 205,3125 300 75,000 18 0.6 3,942 3 11,825 300 5,400 2 Room 161 0.5 2,920.0 6 1/ 520 900 14,400 290 139 11 680 500 8,000 117,800 A 1 2 3 4 5 6 7 Number of rooms 8 Average occupancy 9 Total Room nights available 10 Av Persons/rm night 11 Total occupants 12 Room size 13 Tolal sq.ft 14 15 18 17 18 Activities 19 Housekeeping 20 Laundry 21 Grounds and Pool 22 Registration 23 Breakfast room 24 Administration 25 Security 26 Room repair and maintenance 27 Utilities 28 Total 29 30 Activities 31 Housekeeping 32 Laundry 33 Grounds & Pool 34 Registration Data Calc + Accessibility: Linavailable Resources Gen and Adm Utilities Other Facilities 59% 10% 20% 10% 4094 15% 10% 596 590 1096 0 100% 15% 20% 10% 20% 0% 100% Operations 2016 10% 10% 20% 10 094 1096 2016 0% 100% 100% 100% Utilities Gen& Admn Other Facilities 95,000 190,000 750,000 285,000 20,400 40,000 81,600 Operations 384,000 192.000 192,000 384,000 Total 499,100 422,800 1 033 600 669,000 4:44 PM 11/20/2020 1 + 1024 AutoSave ) HD Crystal Coast Ocean Resort Workbook.XLS Compatibility Mode Excel Search Thu H. Nguy H. File Home Insert Draw . Page Layout Formulas Data Review View Developer Help Share Comments O AutoSum X La Arial 10 -AA Wrap Text General 2 IT NI 28 O 4 FI O Peste HI Insert Delete Format BUw Ideas Sensitivity A Merge & Center $ -% 78-8 Conditional Formatas Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Stvies Editing Ideas Sensitivity H24 > F G | J L M N Operations 384000 192,000 192,000 304,000 192 CXCII Total 499 400 422,800 1,033,000 669,000 443 2001 176,600 327,800 655,600 210 000 4,438,000 192.000 384,000 1,920,000 Total B C D 29 30 Activities Utilities Other Facilities Gen& Admn 31 Housekeeping 95 ODO 20,400 32 Laundry 190,000 40,800 33 Grounds & Pool 760,000 81,600 34 Registration 285,000 35 Breakfast Room 190 000 61 200 36 Administration 95,000 81,000 37 Security 95,000 40,800 38 Room rep. & Maint. 190,000 81 600 39 Utilities 210 000 10 Total 210,000 1,900,000 408,000 41 42 43 44 Second Stage Allocation: Allocate Activity Costs to Room Type 45 Cast Driver Percentage of Total for each Room Type 16 Total Occupants 15.10% 70.76% 4.08% 47 Room size, al rooms (sq ft) 12.73% 63.67% 4.58% 48 Total Room nights 15.73% 73.73% 4.25% 49 Total number of rooms 14.29% 71.43% 5.14% 50 51 Second: Allocate Activity Costs to Room Type 53 ACTIVITIES Oceanfront Oceanview Pool Side 54 Housekeeping 63,591 317,954 22,893 55 Laundry 63,027 299 189 17,233 56 Grounds and Pool 147,657 738,285 53 157 57 Registration 105,230 493,266 28,412 58 Breakfast room 68,907 313,624 18,065 59 Administration 27,778 130,210 50 Security 46 829 234 143 16 858 61 Room repair and maintenance 83.480 417,402 30,053 82 Lilities 28 740 132 701 GAR Data Calc Arreshitty: Lavailable 4.03% 6.79% 3.15% 4.57% 6.04% 12.22% 3.15% 100.00% 100.00% 100.00% 100.00% Total 1 Room Surte 33,915 17,021 47 250 21,046 17,842 5,556 14985 44,523 14 281 2 Room Suite 61,017 25,531 47250 21,046 26,763 5,556 14 985 80,141 25 871 499,400 square foot 422,800 number of occupants 1,033,600 number of rooms 669,000 number of occupied rooms 443,200 number of occupants 176,600 number of occupied rooms 327 800 number of rooms 655,600 square feet 210.000 TR fant 7,500 4:45 PM 11/20/2020 PT + 102 AutoSave ) HD Crystal Coast Ocean Resort Workbook.XLS Compatibility Mode Excel Search Thu H. Nguy H. File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments O AutoSum X La Arial 10 - AA = Wrap Text General 2 IT NI 47 0 4 FI O Peste BUw HI Insert Delete Format Ideas Sensitivity YA Merge & Center $ -% 78-8 Conditional Formatas Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Stvies Coils Eciting Ideas Sensitivity H24 X D E G H J L M N B 52 Second: Allocate Activity Costs to Room Type 53 ACTIVITIES Oceanfront Ocearview 54 Housekeeping 53,591 317 954 55 Laundry 63,827 299,189 58 Grounds and Pool 147,657 738,286 57 Rogistration 105,230 493,286 58 Breakfast room 66,907 313 624 59 Administration 27,778 130,210 60 Security 46,829 234,143 61 Room repair and maintenance 83,480 417,402 62 Uhlites 28.740 133 701 63 TOTAL $ 632,039 $ 3,077,775 $ 54 Cost per occupied room $ 43 29 $ 44 97 S Pool Side 1 Room Suilo 22 893 33,915 17,233 17,021 53,157 47,250 28,412 21.046 18 065 17 842 7,500 5,566 16,858 14.985 30.053 44.523 9.626 14 261 203,797 $ 216,399 $ 51 70 S 74 11 4 $ 2 Room Suite Tolal 61,047 25,531 47.250 21,046 26,763 5,566 14.985 80,141 25 671 307,990 $ 105 48 499 400 square feet 422,800 number of occupants 1,033,600 number of rooms 669,000 number of occupied rooms 443 200 number of occupants 176,600 number of occupied rooms 327,800 number of rooms 655,600 square feet 210 000 square feet 4,438,000 Oceanview Poolside 1 Room 2 Room 0 Ocean front 0 2 3 0 2 3 2 3 5 3 4 2 3 8 67 68 69 Plus: Direct costs per Room Night 70 Kitchenware Repl/rep 71 Complementary tioctrics 12 Complementary cottees ton 73 74 75 Kitchenware Repl/rep 76 Complementary fioletries 77 Complementary coffee& tea 78 Tolal direct costs 79 80 81 Total cost for each room type Tolal 29,200 43,800 73,000 138 875 205,313 342,188 7.884 11,826 19.710 5.840 8,760 14,800 29,200 8.760 11,680 23,360 43,800 507,898 705 039 3.419.983 223,507 245,599 351.790 $ 18.29 $ 19.97 S 56.70 $ 81.11 $ 120.18 4:45 PM 11/20/2020 83 Total cost per occupied room 84 DE Data Calc + Arreshtity Unavailable + 102 AutoSave ) HD Crystal Coast Ocean Resort Workbook.XLS Compatibility Mode Excel Search Thu H. Nguy H. File Home Insert Draw . Page Layout Formulas Data Review View Developer Help Share Comments O AutoSum X La Arial 10 -AA Wrap Text General 2 IT NI 28 O 4 FI O Peste BUw , Insert Delete Format Ideas Sensitivity YA Merge & Center $ -% 78-8 Clear Conditional Formatas Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Coils Editing Ideas Sensitivity H24 G H J L M N B Utilities 210,000 C D Other Facilities General and Administrative 1,900,000 400.000 Operatione 1,920,000 Total assigned 4,430,000 Poolside Total 350 1 Room 161 0.5 2,920 92.820 Ocean front 50 0.8 14,600 3 43.800 300 15,000 Oceanview 250 0.75 68,437.5 3 3 205,3125 300 75,000 18 0.6 3,942 3 11,825 300 5,400 2 Room 161 0.5 2,920.0 6 1/ 520 900 14,400 290 139 11 680 500 8,000 117,800 A 1 2 3 4 5 6 7 Number of rooms 8 Average occupancy 9 Total Room nights available 10 Av Persons/rm night 11 Total occupants 12 Room size 13 Tolal sq.ft 14 15 18 17 18 Activities 19 Housekeeping 20 Laundry 21 Grounds and Pool 22 Registration 23 Breakfast room 24 Administration 25 Security 26 Room repair and maintenance 27 Utilities 28 Total 29 30 Activities 31 Housekeeping 32 Laundry 33 Grounds & Pool 34 Registration Data Calc + Accessibility: Linavailable Resources Gen and Adm Utilities Other Facilities 59% 10% 20% 10% 4094 15% 10% 596 590 1096 0 100% 15% 20% 10% 20% 0% 100% Operations 2016 10% 10% 20% 10 094 1096 2016 0% 100% 100% 100% Utilities Gen& Admn Other Facilities 95,000 190,000 750,000 285,000 20,400 40,000 81,600 Operations 384,000 192.000 192,000 384,000 Total 499,100 422,800 1 033 600 669,000 4:44 PM 11/20/2020 1 + 1024 AutoSave ) HD Crystal Coast Ocean Resort Workbook.XLS Compatibility Mode Excel Search Thu H. Nguy H. File Home Insert Draw . Page Layout Formulas Data Review View Developer Help Share Comments O AutoSum X La Arial 10 -AA Wrap Text General 2 IT NI 28 O 4 FI O Peste HI Insert Delete Format BUw Ideas Sensitivity A Merge & Center $ -% 78-8 Conditional Formatas Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Stvies Editing Ideas Sensitivity H24 > F G | J L M N Operations 384000 192,000 192,000 304,000 192 CXCII Total 499 400 422,800 1,033,000 669,000 443 2001 176,600 327,800 655,600 210 000 4,438,000 192.000 384,000 1,920,000 Total B C D 29 30 Activities Utilities Other Facilities Gen& Admn 31 Housekeeping 95 ODO 20,400 32 Laundry 190,000 40,800 33 Grounds & Pool 760,000 81,600 34 Registration 285,000 35 Breakfast Room 190 000 61 200 36 Administration 95,000 81,000 37 Security 95,000 40,800 38 Room rep. & Maint. 190,000 81 600 39 Utilities 210 000 10 Total 210,000 1,900,000 408,000 41 42 43 44 Second Stage Allocation: Allocate Activity Costs to Room Type 45 Cast Driver Percentage of Total for each Room Type 16 Total Occupants 15.10% 70.76% 4.08% 47 Room size, al rooms (sq ft) 12.73% 63.67% 4.58% 48 Total Room nights 15.73% 73.73% 4.25% 49 Total number of rooms 14.29% 71.43% 5.14% 50 51 Second: Allocate Activity Costs to Room Type 53 ACTIVITIES Oceanfront Oceanview Pool Side 54 Housekeeping 63,591 317,954 22,893 55 Laundry 63,027 299 189 17,233 56 Grounds and Pool 147,657 738,285 53 157 57 Registration 105,230 493,266 28,412 58 Breakfast room 68,907 313,624 18,065 59 Administration 27,778 130,210 50 Security 46 829 234 143 16 858 61 Room repair and maintenance 83.480 417,402 30,053 82 Lilities 28 740 132 701 GAR Data Calc Arreshitty: Lavailable 4.03% 6.79% 3.15% 4.57% 6.04% 12.22% 3.15% 100.00% 100.00% 100.00% 100.00% Total 1 Room Surte 33,915 17,021 47 250 21,046 17,842 5,556 14985 44,523 14 281 2 Room Suite 61,017 25,531 47250 21,046 26,763 5,556 14 985 80,141 25 871 499,400 square foot 422,800 number of occupants 1,033,600 number of rooms 669,000 number of occupied rooms 443,200 number of occupants 176,600 number of occupied rooms 327 800 number of rooms 655,600 square feet 210.000 TR fant 7,500 4:45 PM 11/20/2020 PT + 102 AutoSave ) HD Crystal Coast Ocean Resort Workbook.XLS Compatibility Mode Excel Search Thu H. Nguy H. File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments O AutoSum X La Arial 10 - AA = Wrap Text General 2 IT NI 47 0 4 FI O Peste BUw HI Insert Delete Format Ideas Sensitivity YA Merge & Center $ -% 78-8 Conditional Formatas Cell Formatting Table Styles Clear Sort & Find & Filter Select Clipboard Font Alignment Number Stvies Coils Eciting Ideas Sensitivity H24 X D E G H J L M N B 52 Second: Allocate Activity Costs to Room Type 53 ACTIVITIES Oceanfront Ocearview 54 Housekeeping 53,591 317 954 55 Laundry 63,827 299,189 58 Grounds and Pool 147,657 738,286 57 Rogistration 105,230 493,286 58 Breakfast room 66,907 313 624 59 Administration 27,778 130,210 60 Security 46,829 234,143 61 Room repair and maintenance 83,480 417,402 62 Uhlites 28.740 133 701 63 TOTAL $ 632,039 $ 3,077,775 $ 54 Cost per occupied room $ 43 29 $ 44 97 S Pool Side 1 Room Suilo 22 893 33,915 17,233 17,021 53,157 47,250 28,412 21.046 18 065 17 842 7,500 5,566 16,858 14.985 30.053 44.523 9.626 14 261 203,797 $ 216,399 $ 51 70 S 74 11 4 $ 2 Room Suite Tolal 61,047 25,531 47.250 21,046 26,763 5,566 14.985 80,141 25 671 307,990 $ 105 48 499 400 square feet 422,800 number of occupants 1,033,600 number of rooms 669,000 number of occupied rooms 443 200 number of occupants 176,600 number of occupied rooms 327,800 number of rooms 655,600 square feet 210 000 square feet 4,438,000 Oceanview Poolside 1 Room 2 Room 0 Ocean front 0 2 3 0 2 3 2 3 5 3 4 2 3 8 67 68 69 Plus: Direct costs per Room Night 70 Kitchenware Repl/rep 71 Complementary tioctrics 12 Complementary cottees ton 73 74 75 Kitchenware Repl/rep 76 Complementary fioletries 77 Complementary coffee& tea 78 Tolal direct costs 79 80 81 Total cost for each room type Tolal 29,200 43,800 73,000 138 875 205,313 342,188 7.884 11,826 19.710 5.840 8,760 14,800 29,200 8.760 11,680 23,360 43,800 507,898 705 039 3.419.983 223,507 245,599 351.790 $ 18.29 $ 19.97 S 56.70 $ 81.11 $ 120.18 4:45 PM 11/20/2020 83 Total cost per occupied room 84 DE Data Calc + Arreshtity Unavailable + 102