Avanade Avanade is a global professional services company providing IT consulting and services focused on the Microsoft platform with artificial intelligence, business analytics, cloud, application services, digital transformation, modern workplace, security services, technology and managed services offerings a Web technology consulting rm based in Seattle, Washington. Avanade is planning a seminar on Web applications with a popular guest speaker to take place in Houston, Texas, next spring. The company hired you and 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. a. Use formulas to nd total revenue, total xed cost, variable cost, mixed costs and balance. (Hint: Vlookup function is required to nd the mixed costs) (10 points) b. Use goal seek to determine what number of attendees will result in a balance of $0. (10 points) c. Constance know that the registration fee for the seminar increases, the number of attendees willing to pay decreases. Change the number of attendees from a constant value to the following formula: (7 points) attendees = 600 x Elms"argon fee) d. Use Solver to determine the registration fee that will maximize the balance value with the constraint that the registration fee should be an integer. (15 points) AutoSave . OFF 0 E (7" K5 [2' EH AvanadeCase Q V Home Insert Draw Page Layout Formulas Data Review View 8 Share D Comments Ell-i: v If: ln' A\" Av % v E Conditional Formatting v E v p v ; V 6 v @ Format as Table v Paste i I g V _ v ('A v A v A Number Cells Editing Ideas Sensitivity A2 7 t Seminar Budget Projections v Cell Styles v B C D E F G H | J K L M N O 2 Seminar Budget Projections 3 4 Revenue 5 Number of Attendees Persons Charge 6 Registration Fee $125 0 $400 7 Total Revenue 50 $600 8 100 $750 9 Variable Costs 150 $900 10 Training Material Cost (per person) 535 200 $1,000 Goodie Bag Oust (per person) 515 Total Variable Caste Persons Charge (per person)_ Fixed Costs 0 $25 lntemet Hotspot 50 $20 Speaker Fee $900 100 $17 Speaker Travel $500 Miscellaneous $350 Persons Charge Total Fixed Costs 0 $60 50 $80 100 $100 200 $120 Mixed Costs Room Rental Meal Catering Support Staff Total Mixed Costs Balance { } Avanade + -LEJ _l -O+ 100%