Forecast of monthly profit for store

Assignment Help Finance Basics
Reference no: EM131856563

Unfortunately, our text is pretty crappy at explaining this. Can someone please help me out with this and maybe show me a few examples of this part of the assignment? Thank you!

Key Objective: Crusty Pizza executives are considering opening several new stores and they would like a forecast of monthly profit for each store.

a) Use the data in worksheet "Descriptive". Perform simple linear regression on the key variables to address the key objective for this case.

b) Comment on goodness of fit (R2) and statistical significance of the model (p-value of the F-test) to choose which variables would be good indicators of profit, and explain why.

c) Use the model that you selected in step "b" along with data in Worksheet "Regression". Predict monthly profit for each of the 20 stores in that worksheet (i.e., stores A through T).

d) Rank order stores A to T according to predicted profit (that you computed in step C, so you may identify the top 5 and bottom 5 locations to recommend to Crusty Pizza Company to open.

Reference no: EM131856563

Questions Cloud

Find the probability that a person buys : Using the exponential distribution, find the probability that a person buys more than one lottery ticket per week.
What is the probability that x : A random variable X is exponentially distributed with a mean of 25. What is the probability that X is between 25 and 30?
What is the probability of observing : Elderly patients arrive at the clinic at the mean rate of 5 per hour. 1.) What is the probability of observing 2 or fewer elderly patients in an hour?
Roughly sketch distributions that correspond : Roughly sketch distributions that correspond to each of the following parameters: a) median=20 , mean=20; b), median=10 , mean=20 ; c). median=20
Forecast of monthly profit for store : Crusty Pizza executives are considering opening several new stores and they would like a forecast of monthly profit for each store.
Future monthly stock return will fall in minimum and maximum : There is a 68% chance that future monthly stock returns will fall between a minimum of _____% and a maximum of _______%.
Explain replication process for an active directory domain : Explain the replication process for an Active Directory domain and create a list of troubleshooting steps that can be performed if replication does not occur.
Why trust will be an important factor for yahoo as a company : Explain whether the ousting of former CEO and COO as well as the employees standards reform, have been functional or dysfunctional conflict for yahoo.
What will share of stock sell for today : If the required return on Storico stock is 11 percent, what will a share of stock sell for today?

Reviews

Write a Review

Finance Basics Questions & Answers

  Why should rubber bandits be classified as a creative idea

In what way might having studied both business and engineering helped Adrian Chernoff become an inventor?

  What is roeb - roea

Your company has tax loss carry-forwards that will cause its tax rate to be zero for the life of the project, so T = 0. How much higher or lower will the project's ROE be if you select the machine that produces the higher ROE, i.e., what is ROEB -..

  Calculating irr

Consider two streams of cash flows, A and B. Stream A's first cash flow is $8,900 and is received three years from today. Future cash flows in Stream A grow by 4 percent in perpetuity. Stream B's first cash flow is -$10,000, is received two years fro..

  What is the current value of api''s common stock

what is the current value of API's common stock?  This problem requires a three-part calculation, involving the CAPM & constant growth models, to solve it - FYI, all of these concepts were also covered in the prerequisite BUSI 320 course - Corporate ..

  Capital asset pricing model

Assume the expected return on the market portfolio is 13.8 percent and the risk-free rate is 6.4 percent. Solomon Inc. stock has a beta of 1.2. Suppose the capital-asset-pricing model holds.

  Contests threatening to the current management of a firm

What are both tender offers and proxy contests threatening to the current management of a firm?

  Develop a static option replication strategy

Consider a down-and-out call option on a foreign currency. - Use DerivaGem to develop a static option replication strategy involving five options.

  Which selection of µ would make e-rt xt a martingale

This exercise deals with obtaining martingales. Suppose Xt is a geometric process with drift μ and diffusion parameter σ.(a) When would the e-rt Xt be a martingale? That is, when would the following equality hold. (b) More precisely, remember from th..

  Describe the relationship between finance and accounting

Write a paper (750-1,000 words) that explains the relationship between finance and accounting, and how they operate to determine financial viability within a health care organization.

  Genaro needs to capture a return of 40 percent for his

1.genaro needs to capture a return of 40 percent for his one-year investment in a property. he believes that he can

  What will happen to the share price now

What will happen to the share price now and how much will the share price grow each year?

  Calculate the total horizontal load per unit width

Calculate the total horizontal load per unit width and the location of the center of pressure measured from the bottom.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd