OPERATINGPER MEMBEROPERATING COSTJAN$450|8,900\mathrm{.}0019\mathrm{.}78$FEB$4809,800\mathrm{.}0020\mathrm{.}42$MAR$500$ $$10,100\mathrm{.}0020\mathrm{.}20$APR$550$ $$10,150\mathrm{.}0018\mathrm{.}45$MAY$560$$$10,500\mathrm{.}0018\mathrm{.}75$JUN$525$ $$10,200\mathrm{.}0019\mathrm{.}43$Jyoti Kaushal$1-=$ ASSIGNMENT CHAPTER $3-$ COST BEHAVIOUR $-$ Protected View Saved to this PC vCommentsAutoSaveViewHelpAcrobatDataReviewHomeInsertPage LayoutFormulasFilePROTECTED VIEW Be careful$-$files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.Enable EditingCan you predict total monthly operating costs if the club has $3,000$ members? Explain your answer.MB$14$As the new manager of a gym club$(24/7$ fitness$),$ you have been studying the club's financial data. You would like to determine how the club's costs behave in order to make accurate predictions for next year. Here is information from the past six months:CALCULATE:By looking at the Total Operating Costs and the Average Operating Costs per Member, can you tell whether the club's operating costs are variable, fixed, or mixed? Explain your $1$ answer$\mathrm{.}2$ Use the high$-$low method to determine the club's monthly operating cost equation$\mathrm{.}3$ Using your answer from Requirement $2,$ predict total monthly operating costs if the club has $600$ members$\mathrm{.}4$ Can you predict total monthly operating costs if the club has $3,000$ members? Explain your answer$\mathrm{.}5$ Perform regression analysis using Microsoft Excel. What is the monthly operating cost equation? What is the R$-$square? Why is the cost equation different from that in$17$SheetiENG$9$:$54$