Problem 2: The Pirates Cove Inn wants to compare their actual June results to the industry averages they should have achieved based on the calculations you completed for Problem 1. Their actual financial statement for June is in the Excel file provided. Required: . Using the Industry Average calculation for the dollar value of each line item, enter the values into the Excel file on the Problem 2 tab. This is what you will be comparing the Pirates Cove actual results to in this problem. Prepare a variance column between the actual and industry average results. Measure both the dollar variance and the percentage variance that represents. Note: In this variance analysis, you are calculating the differences in the dollar values and the difference in the percentage values.