Reference no: EM131380606
You work for OJ's Orange Juice. Currently there are 10 million customers, and each week a customer buys 1 gallon of orange juice from OJ or a competitor. The current profi t margin is $2 per gallon. Last week six million customers bought from you, and four million bought from the competition. The fi le OJdata.xlsx gives the purchase history for a year for several customers.
For example, in week three, Person 5 did not buy from you (0 = bought from competition, 1 = bought from you). The data is scrambled so you need to manipulate it. From this data you should figure out the chance customers will buy from you next week if they bought from you last week and the chance customers will buy from you next week if they bought from a competitor last week.
Solve the following situations:
a. Evaluate the profitability of the status quo (for 52 weeks including the current week). No need for discounting!
b. OJ Orange Juice is considering a quality improvement. This improvement will reduce per-gallon profitability by 30 cents. This will increase customer loyalty, but you are not sure by how much. Assume it is equally likely that the customer retention rate will increase by between 0 percent and 10 percent.
Use 10,000 iterations of a Monte Carlo simulation to determine whether OJ should make the quality improvement. Use a single RANDBETWEEN random variable to model the average improvement in customer loyalty created by the quality improvement.
|
Expansionary monetary policy would consist
: Expansionary monetary policy would consist of. Which would shift the short run aggregate supply curve to the? left? Which would NOT shift the long run aggregate supply curve? outwards? In the aggregate supply and demand? model, in long run equilibriu..
|
|
Determine the value of a customer who last purchased product
: Determine the value of a customer who last purchased the product last month, two months ago or three months ago. Assume profi ts are discounted at 1 percent per month.
|
|
How should fiscal and monetary policy be coordinated
: Should macroeconomic policy rely principally on monetary policy or fiscal policy? How should fiscal and monetary policy be coordinated
|
|
Congress votes to decrease corporate income tax rates
: Suppose Congress votes to decrease corporate income tax rates. Use the AD/AS model to analyze the likely impact of the tax cuts on the macroeconomy. Show graphically and explain your reasoning. What exactly causes AD and/or AS to shift? What happens ..
|
|
Model the average improvement in customer loyalty
: Use a single RANDBETWEEN random variable to model the average improvement in customer loyalty created by the quality improvement.
|
|
Research methodologies
: The assignment writing process should involve the followings: Introduction, Explain what is research methodologies, - What issue(s)/problem(s) chosen? Justify the choice, - Scope of research e.g. examine xx, followed by yyy, then ending with recommen..
|
|
Analyse and research an area related to your degree subject
: For this assignment, you are required to work with your Academic Advisor and complete a piece of independent research. You will analyse and research an area related to your degree subject.
|
|
An inflationary gap occurs when
: An inflationary gap occurs when. Which is true in the aggregate supply? / aggregate demand? model? Contractionary fiscal policy would consist of
|
|
Develop a branding strategy and marketing communication plan
: This assignment is designed to help students understand the interrelationships between brand strategy and the communication message to the target audience. It is a continuation of the marketing plan and students should review the Week 3 Learning T..
|