Case Problem 1 Data File needed for this Case Problem. Seminar.xlsx Paget Integrated Solutions Constance Paget is the owner of Paget Integrated Solutions, a Web technology consulting firm based in Seattle, Washington. Paget is planning a seminar on Web applications with a popular guest speaker to take place in Houston, Texas, next spring. She wants your help in generating a budget for the seminar that will incorporate the fixed, variable, and mixed costs to determine under what conditions the seminar will be profitable for her company. Complete the following: 1. Open the Seminar workbook located in the Excel10> Casel foldes included with your Data Files, and then save the workbook as Seminar Budget in the location specified by your instructor 2. In the Documentation worksheet, enter your name and the date. 3. Constance hopes to attract 100 people to the seminar at a cost of $120 per person. In the Budget worksheet, enter these values in the range B5:36. Calculate the total resenue in cell BZ. 4. Each participant will receive training materials worth $35 and a goodie brag worth $15. Enter these values into the range B10 B11. Calculate the total variable costs in cell B12 based on the number of attendees entered in cell 35. 5. There are several fixed costs associated with the seminar. Providing an Internet hotspot for the attendees will cost $50. The seminar ymaker's lee is $200 plus a $500 travel allowance and a $140 lodging stipend. Constante stimulus $350 in miscellaneous expTEtes. Enter these values in the range 315-319. Calculate the total fixed costs in celi B20. h. The company must rent a conference room lange enough to accomxxl le the number of attendees. The lookup table in the range D5 EID contains the room charges for seminars of 0 to 50 people, 50 to 100 pecole, 100 m2 150 people, 150 to 200 people, and beyond 200 people For example, a room that fits 0 to 50 people will cost the compans $400. In cell B23, calculate the room rental cost by looking up the room rental fee bed on the number of attenders to the seminar Irint: Use the VLOOKUP function with an approximate match lookup ] 7. The me people attending the seminar, the less the hotel wil durke per person to cater the seminar deals. In cell 324, cakulate the total catering charge by using the lexkup table in range D316 tockermine the costype and then multiply that value whenumber of attenke 8. The company also needs to pay for the hotel support staff. The larger the smnar the higher the supremut staff feet. The bookup takle in the range D19 123 ceman. the scale femes for group of different sures For example, a seminar of Oto 50 pople will incur a $60 a Roca calculate the support staff change for the number of attendees to the seminar 4. In cod 926 calcolate the total mixed costs from the room rental maleted support Maff In cell B25. culate the balance from the conference by suberacun the sum of the variable, likad, a mes from the me Tu Gaul sekla dat wat numaral atteries will con la conclusion in the merged well, indicating how many attendees av eklene bak even arration fee of $120 Change male in cu 100 Cuone variate at tabe dierent serai wa 5. Inciday who of Biocelli dispan Bob In cele din the other Case Problem 1 Data File needed for this Case Problem. Seminar.xlsx Paget Integrated Solutions Constance Paget is the owner of Paget Integrated Solutions, a Web technology consulting firm based in Seattle, Washington. Paget is planning a seminar on Web applications with a popular guest speaker to take place in Houston, Texas, next spring. She wants your help in generating a budget for the seminar that will incorporate the fixed, variable, and mixed costs to determine under what conditions the seminar will be profitable for her company. Complete the following: 1. Open the Seminar workbook located in the Excel10> Casel foldes included with your Data Files, and then save the workbook as Seminar Budget in the location specified by your instructor 2. In the Documentation worksheet, enter your name and the date. 3. Constance hopes to attract 100 people to the seminar at a cost of $120 per person. In the Budget worksheet, enter these values in the range B5:36. Calculate the total resenue in cell BZ. 4. Each participant will receive training materials worth $35 and a goodie brag worth $15. Enter these values into the range B10 B11. Calculate the total variable costs in cell B12 based on the number of attendees entered in cell 35. 5. There are several fixed costs associated with the seminar. Providing an Internet hotspot for the attendees will cost $50. The seminar ymaker's lee is $200 plus a $500 travel allowance and a $140 lodging stipend. Constante stimulus $350 in miscellaneous expTEtes. Enter these values in the range 315-319. Calculate the total fixed costs in celi B20. h. The company must rent a conference room lange enough to accomxxl le the number of attendees. The lookup table in the range D5 EID contains the room charges for seminars of 0 to 50 people, 50 to 100 pecole, 100 m2 150 people, 150 to 200 people, and beyond 200 people For example, a room that fits 0 to 50 people will cost the compans $400. In cell B23, calculate the room rental cost by looking up the room rental fee bed on the number of attenders to the seminar Irint: Use the VLOOKUP function with an approximate match lookup ] 7. The me people attending the seminar, the less the hotel wil durke per person to cater the seminar deals. In cell 324, cakulate the total catering charge by using the lexkup table in range D316 tockermine the costype and then multiply that value whenumber of attenke 8. The company also needs to pay for the hotel support staff. The larger the smnar the higher the supremut staff feet. The bookup takle in the range D19 123 ceman. the scale femes for group of different sures For example, a seminar of Oto 50 pople will incur a $60 a Roca calculate the support staff change for the number of attendees to the seminar 4. In cod 926 calcolate the total mixed costs from the room rental maleted support Maff In cell B25. culate the balance from the conference by suberacun the sum of the variable, likad, a mes from the me Tu Gaul sekla dat wat numaral atteries will con la conclusion in the merged well, indicating how many attendees av eklene bak even arration fee of $120 Change male in cu 100 Cuone variate at tabe dierent serai wa 5. Inciday who of Biocelli dispan Bob In cele din the other