Need help with writing the correct formulas given the following info/parameters, please.
It is your task to write the formula to figure out how to compare these gym prices. The worksheet should produce at least four different comparative result formulas: - the cost per visit, - the cost per visit (monthly), - the cost per month, and - the total cost of membership for the total number of months based on the number of months' membership parameter. Those four different formulas should be auto-fillable for the five different gyms - you should not have to create a different formula for each gym. To help you figure out which gym is the least expensive, the worksheet should use conditional formatting to identify which gym has the highest and lowest values for all four calculations. Some information about the comparison calculations: - The cost per visit is the price that must be paid every time a member attends the gym and is based on the per visit charge and the number of massages received per visit. - The cost per visit (monthly) is the cost per visit multiplied by the number of visits per month - The cost per month consists of the monthly charge and any personal training costs. - The cost per visit and the cost per month should not include the sign-up fee in their calculation. - The total cost of membership must include everything, including the sign-up fee. Please enter these input parameters on the workbook you submit for grading: - You plan to go to the gym 10 times/month. - You think that your initial gym membership time period will last 12 months. - You anticipate having two 30-minute massages every time you visit the gym. - You also anticipate having 6 hours of personal training time each month. - The membership will primarily be used in the state of NV. It is your task to write the formula to figure out how to compare these gym prices. The worksheet should produce at least four different comparative result formulas: - the cost per visit, - the cost per visit (monthly), - the cost per month, and - the total cost of membership for the total number of months based on the number of months' membership parameter. Those four different formulas should be auto-fillable for the five different gyms - you should not have to create a different formula for each gym. To help you figure out which gym is the least expensive, the worksheet should use conditional formatting to identify which gym has the highest and lowest values for all four calculations. Some information about the comparison calculations: - The cost per visit is the price that must be paid every time a member attends the gym and is based on the per visit charge and the number of massages received per visit. - The cost per visit (monthly) is the cost per visit multiplied by the number of visits per month - The cost per month consists of the monthly charge and any personal training costs. - The cost per visit and the cost per month should not include the sign-up fee in their calculation. - The total cost of membership must include everything, including the sign-up fee. Please enter these input parameters on the workbook you submit for grading: - You plan to go to the gym 10 times/month. - You think that your initial gym membership time period will last 12 months. - You anticipate having two 30-minute massages every time you visit the gym. - You also anticipate having 6 hours of personal training time each month. - The membership will primarily be used in the state of NV
