As the new manager of a local fitness club, Kid ds Gymm, you have been studying the club's financial data You would lke to determine how the club's costs behave in onder to make accurate next year Here is indormation fros the last six months BE (Click on the icon to viow the information) Read the teatement predctions Tor Requirement 1. By looking at the Total Operating Couts and the Average Costs per Member,can you tel whether the club's operating costs are variable, fixed or mixed? Explan your we can see that the opersting oosts repurely varabie, otherwise, the per membe cont woud Requirement 2. Use the high-low method to determine the clubis monthly operating cost eqation Frst, onemone tho krm4a and calculate the variable cost per un' me 0pe one mied cosnw) (Round you answer to constant. Therefore, the club's operating costs are vanable nearest cent) Variable cost per un 175 Next, wr's determine the formula and calouliale the fixed cost oomponent using the highest volume of acivity (cund your answors to the nearest whoie doilar) Average operating cost per member Total xed costs 700 6125 . [ 3575 Determine the club's monthly operating oost equation (Enter the valiable cost per une to he nearest cent and tve total fixed costs to the nearest dola) Choose from any lst or enter any number in the input felds and then consinue to the next question s the new manager of a locai teness club. Kids Gym, you have been sudying the olub's fnancial data You would l ke to determine how the club's costs behave in onder to make accurate predictions for nest year Here is information from the last six months EEl (Cick on the icon to visew the information) Read the teasments Requirement 3. Using your answer tom Requirement 2, predict total monthly operating costs if the club has 570 members Determ the formula and caulatere predcted operatig costs , the dub has sro menters Tolal predcled operating costsVeratio ost pern 3550 Requirement 4. Can you predidt total monthly operating conts t the cub has 3,000 menters? Exglain your anw ters usirg te moy operating cost equation The total montly operating costs would be 55.07s O B. Our curent data and cont equation are based on 300 to 530 membiers t menbershp eaches3 OC. We have to exclude the variable operating cous ce wo don't know what the varubie opeating oo 000 operating costs coudd behave mch difity That voume fals outsuide our curent ne feed operatng costs wouid be at hat eval The tols morthly operating costs would be $52 500 income stalament for the morth of July Assume that your oosl equation t rom Requirement 2 accurately Requirement &.Prepare the club's radfional inome statemont and ts cortibution desorbes the clut's cost behavior The club charges members 530 per month for unimted access to its First prepare the dub's traational income stabement faclites Kids Gym Choose from any ist or enter any rumber in the input felds and then continue to the next t Gym, you have teen stutying the chub's fnancial data. You would lke to determine how the club's costs behave in order to make accurate predictions fo As the new manager of a local finess club, Kids next year Here is information from the last sx months (Cick on the icon to view the nt rmation ) Read the pquirements Requirement S. Prepare the club's radtonal income statement and t describes the dlub's cost behavior The club charges members $30 per month for untimted access to its faclities ts contrbution margin income statement for the month of July Assume that your cost equation from Requirement 2 accurabely Frst, prepare the clut's traditional inoome statement Kids Gym Income Statement For the Month Ended July 31 Now prepare the club's contreution margin income stalement (Round al amounts to the nearest dollaer) Kids Gym Contribution Margin Income Statement For the Month Ended July 31 As the new manager of a local fitness club, Kids Gym you have been studying the clut's financial nexd year Here is information from the last six morehs data You would like to determine how the club's costs beharve in order to make accurate predictions for (Cck on the cr, to viow the ntr nation ) Read the teauroments Less Requirement &.Perform regression analysis using Microsfh Excel What is is the morthly operating cost equation? What is the R-square? Why is the cost equation different from that in Requirement 2 is the monthily operating cost equation? (Enter the vaniable cost per unt to the nearest cent and the total fixoed oosts to the nearest dollar ) What is the R-square? (Round the R-squere to 4 decimal places, X Xx.) The R-squar is Why is the cost equation different from that in Roqrement 27 A The regessen ana yus cost equation uses just "o etata from Noverroe' and July bd Ence" is more accurate ran cata. tors you perfurmed i, Reqaenentz B. The regrosson analysis cost equation uses au oren data ports, not past re data from Norentornd Anr Therefore, n betur represents al of the data OC The regression analysis cost equation uses all of he data poirnts, except the data from November and JMy Therefore, does not reprosent the data ans wol as in Rqueent 2 D. The rogesson analysis cost equator, uses al creo aata ports, eoept he databom Novanto nady Therefore, it better represents all of the data As the new manager of a local fitness club, Kid ds Gymm, you have been studying the club's financial data You would lke to determine how the club's costs behave in onder to make accurate next year Here is indormation fros the last six months BE (Click on the icon to viow the information) Read the teatement predctions Tor Requirement 1. By looking at the Total Operating Couts and the Average Costs per Member,can you tel whether the club's operating costs are variable, fixed or mixed? Explan your we can see that the opersting oosts repurely varabie, otherwise, the per membe cont woud Requirement 2. Use the high-low method to determine the clubis monthly operating cost eqation Frst, onemone tho krm4a and calculate the variable cost per un' me 0pe one mied cosnw) (Round you answer to constant. Therefore, the club's operating costs are vanable nearest cent) Variable cost per un 175 Next, wr's determine the formula and calouliale the fixed cost oomponent using the highest volume of acivity (cund your answors to the nearest whoie doilar) Average operating cost per member Total xed costs 700 6125 . [ 3575 Determine the club's monthly operating oost equation (Enter the valiable cost per une to he nearest cent and tve total fixed costs to the nearest dola) Choose from any lst or enter any number in the input felds and then consinue to the next question s the new manager of a locai teness club. Kids Gym, you have been sudying the olub's fnancial data You would l ke to determine how the club's costs behave in onder to make accurate predictions for nest year Here is information from the last six months EEl (Cick on the icon to visew the information) Read the teasments Requirement 3. Using your answer tom Requirement 2, predict total monthly operating costs if the club has 570 members Determ the formula and caulatere predcted operatig costs , the dub has sro menters Tolal predcled operating costsVeratio ost pern 3550 Requirement 4. Can you predidt total monthly operating conts t the cub has 3,000 menters? Exglain your anw ters usirg te moy operating cost equation The total montly operating costs would be 55.07s O B. Our curent data and cont equation are based on 300 to 530 membiers t menbershp eaches3 OC. We have to exclude the variable operating cous ce wo don't know what the varubie opeating oo 000 operating costs coudd behave mch difity That voume fals outsuide our curent ne feed operatng costs wouid be at hat eval The tols morthly operating costs would be $52 500 income stalament for the morth of July Assume that your oosl equation t rom Requirement 2 accurately Requirement &.Prepare the club's radfional inome statemont and ts cortibution desorbes the clut's cost behavior The club charges members 530 per month for unimted access to its First prepare the dub's traational income stabement faclites Kids Gym Choose from any ist or enter any rumber in the input felds and then continue to the next t Gym, you have teen stutying the chub's fnancial data. You would lke to determine how the club's costs behave in order to make accurate predictions fo As the new manager of a local finess club, Kids next year Here is information from the last sx months (Cick on the icon to view the nt rmation ) Read the pquirements Requirement S. Prepare the club's radtonal income statement and t describes the dlub's cost behavior The club charges members $30 per month for untimted access to its faclities ts contrbution margin income statement for the month of July Assume that your cost equation from Requirement 2 accurabely Frst, prepare the clut's traditional inoome statement Kids Gym Income Statement For the Month Ended July 31 Now prepare the club's contreution margin income stalement (Round al amounts to the nearest dollaer) Kids Gym Contribution Margin Income Statement For the Month Ended July 31 As the new manager of a local fitness club, Kids Gym you have been studying the clut's financial nexd year Here is information from the last six morehs data You would like to determine how the club's costs beharve in order to make accurate predictions for (Cck on the cr, to viow the ntr nation ) Read the teauroments Less Requirement &.Perform regression analysis using Microsfh Excel What is is the morthly operating cost equation? What is the R-square? Why is the cost equation different from that in Requirement 2 is the monthily operating cost equation? (Enter the vaniable cost per unt to the nearest cent and the total fixoed oosts to the nearest dollar ) What is the R-square? (Round the R-squere to 4 decimal places, X Xx.) The R-squar is Why is the cost equation different from that in Roqrement 27 A The regessen ana yus cost equation uses just "o etata from Noverroe' and July bd Ence" is more accurate ran cata. tors you perfurmed i, Reqaenentz B. The regrosson analysis cost equation uses au oren data ports, not past re data from Norentornd Anr Therefore, n betur represents al of the data OC The regression analysis cost equation uses all of he data poirnts, except the data from November and JMy Therefore, does not reprosent the data ans wol as in Rqueent 2 D. The rogesson analysis cost equator, uses al creo aata ports, eoept he databom Novanto nady Therefore, it better represents all of the data