Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What-if analysis - the question is: Tropicana is interested to run a display for their regular 64oz item and lower price to $1.60. They are

What-if analysis - the question is: Tropicana is interested to run a display for their regular 64oz item and lower price to $1.60.
They are offering a discount which results in a gross margin of .27. What is the expected
profitability (holding all other prices constant, i.e., set to average values and assuming that no
other feature or display is held). (please use the data given in the picture) (this is marketing analytics)
image text in transcribed
MKT 382 - Marketing Research only make changes to red cells Estimates regression parameters SKUDescriptionConstantdisp1feat1Log(price1)Log(price2)Log(price3)Log(price4)TropPrem643.4105764730.017867450.680325312.536822190.0384467850.553951850.0535414280.0404122951TropPrem965.2359709090.0217874130.3034774090.3290718631.5685837590.0491747950.0311828290.112558232TropReg645.6609929960.3171607460.9767395041.1698513431.0340315644.2771244561.4488099820.04856943MinMaid646.2959410650.1988232690.8998540690.5131702120.2423837070.6017687532.6912232680.56128691Dom640.5951496840.2817939960.6590307940.0985261151.6636743881.0508255511.1025402463.24161236 MKT 382 - Marketing Research only make changes to red cells Estimates regression parameters SKUDescriptionConstantdisp1feat1Log(price1)Log(price2)Log(price3)Log(price4)TropPrem643.4105764730.017867450.680325312.536822190.0384467850.553951850.0535414280.0404122951TropPrem965.2359709090.0217874130.3034774090.3290718631.5685837590.0491747950.0311828290.112558232TropReg645.6609929960.3171607460.9767395041.1698513431.0340315644.2771244561.4488099820.04856943MinMaid646.2959410650.1988232690.8998540690.5131702120.2423837070.6017687532.6912232680.56128691Dom640.5951496840.2817939960.6590307940.0985261151.6636743881.0508255511.1025402463.24161236

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes

8th Edition

007322359X, 9780073223599

More Books

Students also viewed these Finance questions

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago

Question

How organized or ready for action on this issue is this public?

Answered: 1 week ago

Question

What does this public know about your organization?

Answered: 1 week ago

Question

What does this public expect from your organization?

Answered: 1 week ago