Question: I'm stuck. Please show formulas used. Create a workbook to determine which gym to join. Assume that you have narrowed it down to five different

 I'm stuck. Please show formulas used. Create a workbook to determinewhich gym to join. Assume that you have narrowed it down to

I'm stuck. Please show formulas used.

Create a workbook to determine which gym to join. Assume that you have narrowed it down to five different gyms and the only difference between them is the price you will have to pay. Assume that you like the facilities at each gym. The worksheet should be flexible enough so that the person using the worksheet can enter input parameters that will change the calculations. The input parameters are: the number of visits to the gym each month, the number of months' membership, the number of personal training hours per month, the number of massage sessions per visit, and the state in which the membership will primarily be used. The calculations on the worksheet should change based on changes in the input parameters. Each gym that you are considering differs based on: the sign-up fee, the monthly charge, the discounted hourly charge for personal training, the half-hourly charge for massage sessions, and the per visit charge You only have to pay the sign-up fee once; it is a non-recurring fee. The rest of the fees are based on use or time. Gyms charging monthly fees charge that fee whether or not you use the gym. Gyms charging per visit fees only charge that fee when you use the gym. One of the gyms, Phenomenal Fitness, charges a small monthly charge and a per visit charge. The fee information has been summarized into a table already to help make it easier to understand the fee structures for the different gyms. Here is that table: Pump It Up Gym Shape Shifters Muscle Madness Big Lift File Edit Format View Help State Phenomenal Fitness 19 130 40 126 127 AL 16 131 129 132 134 131 132 126 135 134 134 131 128 128 129 128 m335wHMHmzAw WMWMWMWWMMMumm 125 127 135 132 128 %9B%9WWW99%WWW99999999999WW99 13 382 5 521a4e112151a13ea2 3 25a5e3 25 54 3 21424 128 129 138 129 138 135 135 127 138 133 131 132 127 138 127 13138 Create a workbook to determine which gym to join. Assume that you have narrowed it down to five different gyms and the only difference between them is the price you will have to pay. Assume that you like the facilities at each gym. The worksheet should be flexible enough so that the person using the worksheet can enter input parameters that will change the calculations. The input parameters are: the number of visits to the gym each month, the number of months' membership, the number of personal training hours per month, the number of massage sessions per visit, and the state in which the membership will primarily be used. The calculations on the worksheet should change based on changes in the input parameters. Each gym that you are considering differs based on: the sign-up fee, the monthly charge, the discounted hourly charge for personal training, the half-hourly charge for massage sessions, and the per visit charge You only have to pay the sign-up fee once; it is a non-recurring fee. The rest of the fees are based on use or time. Gyms charging monthly fees charge that fee whether or not you use the gym. Gyms charging per visit fees only charge that fee when you use the gym. One of the gyms, Phenomenal Fitness, charges a small monthly charge and a per visit charge. The fee information has been summarized into a table already to help make it easier to understand the fee structures for the different gyms. Here is that table: Pump It Up Gym Shape Shifters Muscle Madness Big Lift File Edit Format View Help State Phenomenal Fitness 19 130 40 126 127 AL 16 131 129 132 134 131 132 126 135 134 134 131 128 128 129 128 m335wHMHmzAw WMWMWMWWMMMumm 125 127 135 132 128 %9B%9WWW99%WWW99999999999WW99 13 382 5 521a4e112151a13ea2 3 25a5e3 25 54 3 21424 128 129 138 129 138 135 135 127 138 133 131 132 127 138 127 13138

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!