A Theater is interested in estimating fixed and variable costs. The following da

A Theater is interested in estimating fixed and variable costs. The following data are available: Total Cost No. of Tickets SoldJanuary $172000 20000February $176000 19500March $180500 25500April $170500 21500May $190000 25000June $188000 26500Use regression analysis to estimate fixed cost per month and variable costs per ticket sold show your output and answer the following questions:REQUIRED:a. How much is the variable cost per ticket?b. How much is total fixed cost?c. What percentage of variance in Total Cost is explained by the number of tickets sold ?d. Write the total cost equation in good form.e. MovieTown Theater is considering an advertising campaign that is expected to increase annual sales by 7000 tickets. Assume that the ticket selling price is $9. What is the expected increase in profit associated with the advertising campaign?