Please help me with step by step solution. Where have we used the dataset in this question $?$ The problem statement for this HW: You are producing beverage mugs and are trying kjjjto identify the best price$-$feature$-$vector. Assume the following attributes and attribute levels: Price: $$30,$ $$10,$ $$5$ Time Insulated: $0\mathrm{.}5$ hrs$,1$ hrs$,3$ hrs Capacity: $12$ oz$,20$ oz$,32$ oz Cleanability: Difficult $(7$ min$),$ Fair $(5$ min$),$ Easy $(2$ min$)$ Containment: Slosh resistant, Spill resistant, Leak resistant Brand: A$,$ B$,$ C Assume the following as the "proposed market scenario", ie the scenario with the current competitors and our proposed candidate. Incumbents $1$: $$30,3$ hrs$,20$ oz$,$ Clean Easy, Leak Resistant, Brand A $2$: $$10,1$ hrs$,20$ oz$,$ Clean Fair, Spill Resistant, Brand B Our proposed candidate $3$: $ $30,1$ hrs$,20$ oz$,$ Clean Easy, Leak Resistant, Brand C Assume the following cost structure: Time Insulated: $0\mathrm{.}5$ hrs costs $$0\mathrm{.}5,1$ hrs costs $$1,3$ hrs costs $$3$ Capacity: $12$ oz costs $$1\mathrm{.}00,20$ oz costs $$2\mathrm{.}6,32$ oz costs $$2\mathrm{.}8$ Cleanability: Difficult $(7$ min$)$ costs $$1,$ Fair $(5$ min$)$ costs $$2\mathrm{.}2,$ Easy $(2$ min$)$ costs $$3\mathrm{.}0$ Containment: Slosh resistant costs $$0\mathrm{.}5,$ Spill resistant costs $$0\mathrm{.}8,$ Leak resistant costs $$1$ You are given data on the preference parameters of $311$ consumers in this file: mugs$-$ preference$-$parameters$-$full.xlsx$.$ The CSV version of this file is here: mugs$-$preferenceparameters$-$full.csv Questions: $1.$ Using the compensatory rule with logit adjustment: Compute and report our candidate's share, cost, margin and expected profit per person under the "proposed market scenario" given above. This question is a strict subset of the next question. If you have done the next question successfully, then all you need to do for this question is report the numbers for Product Candidate $45$ which corresponds to our proposed candidate in the "proposed market scenario" given above. Even though this question is a strict subset of the next question, I am asking for it separately. This is because not all students may be able to do the next question successfully as it is a larger and more general computation. Hint to check your answer: The number you should get for expected profit per person is between $4$ and $4\mathrm{.}5.$