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 firm 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 find total revenue, total fixed cost, variable cost, mixed costs and

balance. $($Hint: Vlookup function is required to find the mixed costs$)$

b$.$ Use goal seek to determine what number of attendees will result in a balance of $$0.$

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:

attendees $=600e^{-(\frac{\text{r}\text{e}\text{g}\text{i}\text{s}\text{t}\text{r}\text{a}\text{t}\text{i}\text{o}\text{n}\text{f}\text{e}\text{e}}{75})}$

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.