Part A Using Excel, begin by filling in the spreadsheet provided with all of the relevant information from the case study. Include the zeros where no value is applied. (14 Marks) (Fill in lines: 3, 4, 6, 7, 9, 10, 12, 13, 31, 32, 33, 34, 36, 37, 38, 39) Part B Showing all of the required formulas, fill in the rest of the cells on the spreadsheet. (46 Marks) Part C Which group, if any, should the Diamond Peak Hotel accept? Explain your answer based on: (8 Marks) a. Total Revenue b. RevPAR C. Total Contribution d. TRevPAR Based purely on information that is not a part of your financial analysis, which group do you feel the General Manager should choose. Indicate a least three reasons for your decision that is evidenced in the narrative. (7 Marks) On an overall basis what would your decision be if you were the General Manager? Explain your thinking in detail. (10 Marks)