Show transcribed image text

Use solver to determine the registration fee in cell B6 that will maximize the balance value in cell B28 with the constraint that the registration fee should be an integer. Run solver with an initial registration fee of $100

56 - X =500*EXP(-16/75) Paget Integrated Solutions 2 Seminar Budget Projections Balance Analysis Effect of the Registrat on fee on Attendance s Number of Attendees 6 Registration Fee 7 Total Revenue Total Revenue 12 000 $2400 54800 Total Costs $ 8 9001 55 400 15 500 535 S1 380 10 Training Material Cost per person) 11 Goodie Dng Cost (per person 12 Total Variable Costs $5 000 $9 490 $10 830 $12170 Persons Charge per person) Registration Fee $2510 $75 $100 $125 $1501 201 152 405190051 4001 159001 401 152.4005 1 400 54000 5600 601152.8205920 S680S2280 80S2.2201 (S220) S1,780 S 780 100 $2.990) $500 $3.000 $5 510 120 $1,930) $1 170 $4170 $7270 1401 $1 670) $1 830 $5 330 $ 830 1601 151660) $2.340 $6340 $10 340 1801151.500 53.000 57 500 $12.000 2001 151.460) $3.540 58.540 S13 540 220 5.300154200 59.700 515200 2401 $.140 $4,550 $10 950 $15 860 250 $950 $5 520 $12020 $15 520 280 $920) SE 150 $13 180 $20 190 3001 5660) $6,840 514 340 521 840 $200 S9 600 $12 000 $14400 $16 800 510200 521600 S24 000 S25 400 $25 800 $31200 $35 600 585 000 14 Fixed Costs 15 temet Hotspot 16 Speaker Fee 17 Speaker Travel 5900 $500 1001 52540 S250 S15000 S16460 517 800 $19 240 $20 490 $219201 $225 $300 $150 19 Miscellaneous 20 Total Fixed Costs Per Se En $10720 S11 790 $12 340 $1 940 22 Mixed CSS 23 Room Rental 24 Men Catering 200 5750 $1,700 $200 $2 550 26 Total Mbred Costs 25 Balance $2,510 30 52.4 Number of Attendees 150 300 350 50 - 100 To 200 250 Toalcons of Albance $100 5 125 - 5150 56 - X =500*EXP(-16/75) Paget Integrated Solutions 2 Seminar Budget Projections Balance Analysis Effect of the Registrat on fee on Attendance s Number of Attendees 6 Registration Fee 7 Total Revenue Total Revenue 12 000 $2400 54800 Total Costs $ 8 9001 55 400 15 500 535 S1 380 10 Training Material Cost per person) 11 Goodie Dng Cost (per person 12 Total Variable Costs $5 000 $9 490 $10 830 $12170 Persons Charge per person) Registration Fee $2510 $75 $100 $125 $1501 201 152 405190051 4001 159001 401 152.4005 1 400 54000 5600 601152.8205920 S680S2280 80S2.2201 (S220) S1,780 S 780 100 $2.990) $500 $3.000 $5 510 120 $1,930) $1 170 $4170 $7270 1401 $1 670) $1 830 $5 330 $ 830 1601 151660) $2.340 $6340 $10 340 1801151.500 53.000 57 500 $12.000 2001 151.460) $3.540 58.540 S13 540 220 5.300154200 59.700 515200 2401 $.140 $4,550 $10 950 $15 860 250 $950 $5 520 $12020 $15 520 280 $920) SE 150 $13 180 $20 190 3001 5660) $6,840 514 340 521 840 $200 S9 600 $12 000 $14400 $16 800 510200 521600 S24 000 S25 400 $25 800 $31200 $35 600 585 000 14 Fixed Costs 15 temet Hotspot 16 Speaker Fee 17 Speaker Travel 5900 $500 1001 52540 S250 S15000 S16460 517 800 $19 240 $20 490 $219201 $225 $300 $150 19 Miscellaneous 20 Total Fixed Costs Per Se En $10720 S11 790 $12 340 $1 940 22 Mixed CSS 23 Room Rental 24 Men Catering 200 5750 $1,700 $200 $2 550 26 Total Mbred Costs 25 Balance $2,510 30 52.4 Number of Attendees 150 300 350 50 - 100 To 200 250 Toalcons of Albance $100 5 125 - 5150