Preview

Pamd Sue

Better Essays
Open Document
Open Document
1852 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Pamd Sue
Pam & Sue Regression Analysis

Multiple Regression Project:

Forecasting Sales for Proposed New

Sites of Pam and Susan’s Stores

I. Introduction

Pam and Susan’s is a discount department store that currently has 250 stores, most of which are located throughout the southern United States. As the company has grown, it has become increasingly more important to identify profitable locations. Using census and existing store data, a multiple regression equation will be used to forecast potential sales, and therefore which proposed new site location will be more profitable.

II. Data

The data set has 37 independent variables. This includes 7 categorical variables for competitive type and 30 numerical categories. There are 250 stores, meaning the sample size is 250. As the sales are given in $1,000’s of dollars it is best to remember that a unit change in x will correspond to that coefficient of x multiplied by 1,000.

III. Results and Discussion

Building a multiple regression model requires a step-by-step approach. Failure to follow such methodology could ultimately lead to incorrect and inaccurate forecasting for the dependent variable of interest. Below I will outline the process and findings used to obtain a multiple regression equation to forecast potential sales at newly proposed site of Pam and Susan’s discount department stores.

The initial step in building a multiple regression model is to look for outliers and non-linear relationships between your dependent (predicated sales) and independent variables. In order for multiple regression to be an accurate forecasting tool, each x-variable should have a slightly linear relationship with the y-variable. Below in Table (i) is a list of the 10 quantitative x-variables that have the highest correlation with sales. These 10 variables will be used to obtain the final multiple regression equation. Additionally, the problem of multicollinearity can result if the correlation

You May Also Find These Documents Helpful

  • Good Essays

    Wgu Financial Task 5

    • 4785 Words
    • 20 Pages

    The historical trend analysis shows that every other year, there is a decrease in net sales. In Year 12, Net Sales were $6,601,000. Net Sales rose .5% in Year 13, declined 3.4% in Year 14, rose 3% in Year 15, declined 1% in Year 16, and rose 1.7% in Year 17, with $6,647,452 in Net Sales. This rollercoaster effect may be impacted by the quality of snowboards. There are several things to consider such as evaluating if the increase in sales are the same consumers upgrading their snowboards or is the increase of sales due to weather patterns? To minimize this impact and continue with future growth, additional product offering may need to be…

    • 4785 Words
    • 20 Pages
    Good Essays
  • Satisfactory Essays

    Mini-Assignment #1

    • 321 Words
    • 2 Pages

    3) A small retain chain posts impressive percentage growth figures, moving from $58 million to $107 million in sales from one year to the next. Despite this dynamic growth, however, analysts cast doubt on the firm’s business model, warning that its existing stores’ growth measure suggests that its concept is failing. Based on the chart below, and assuming that stores were opened on the first day of Years 1 and 2: What is the retail chain’s year-over-year sales growth rate? What is the year-over-year sales growth or decrease for each store, as appropriate? What is the same store (existing and not expansion) year-over-year growth?…

    • 321 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acc/531 Week 4

    • 646 Words
    • 3 Pages

    Use the estimated regression equation to predict annual sales for a salesperson with nine years of experience.…

    • 646 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Math203

    • 385 Words
    • 2 Pages

    Model 1: Run a full model for profit that includes both tenure and site location related variables. Tenure related variables are MTenure and CTenure. Site location related variables are population, number of competitors, street level visibility, pedestrian access, type of neighborhood, and whether a store staysDefinitions of the different variables in the data are provided in the case itself. Briefly discuss the summary statistics presented in Exhibit 3 in Store24A and Exhibit 2 in Store24B. Use a maximum of 2 slides for this discussion. In your opinion, what do the summary statistics tell us about Store24?…

    • 385 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    One hundred people were randomly selected, and their sales were measured. Their sales were observed between $23.00 and $64.00. The average sales were $42.84, with a standard deviation of $9.07. Approximately half or more of the data values are above $42.84. There is enough evidence to say that the population sales amount lies between $41.06 and $44.62 with 95% confidence.…

    • 357 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Natasha

    • 1843 Words
    • 8 Pages

    1. (TCOs 2, 3, 7, and 9) You currently work for a home improvement store. Your company continues to grow, and is considering expansion scenarios. The company currently has three locations (East, West, and Central) in one state, and wants to consider expanding within the same state. Your boss has presented you with the sales figures for the last three years for each of the locations. Based on this information, you have been tasked with analyzing current sales and providing recommendations.…

    • 1843 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    For comparison purposes, we separated our stores into quartiles, and ranked them from highest to lowest, by profit. (Table 2) This method enabled us to demonstrate clear correlation between those stores that were most profitable and those that were least profitable in relation to the factors of monthly advertising, store size, and store population. (We noted that the coefficient of variation for the fourth quartile is extremely high, and that this data should be used with caution. We believe that at least part of this high variation is attributed to the fact that some stores did not make a profit, and actually lost revenue.)…

    • 1222 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Acc 561 Week 4 Guillermo

    • 1305 Words
    • 6 Pages

    References: Chase, C. W. Jr. (1993, June). Ways to improve sales forecasts. The Journal of Business…

    • 1305 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    Mktg 301

    • 4364 Words
    • 18 Pages

    7) Data from a small bookstore are shown in the accompanying table. The manager wants to predict Sales from Number of Sales People Working.…

    • 4364 Words
    • 18 Pages
    Satisfactory Essays
  • Better Essays

    Upon opening a business, a company must decide where to place the business and how to market the company. This is not an easy task if several businesses of the same industry are located in the same neighborhood. Before the company can open, a new business must choose what market they want to reach and the best way to reach them. The company must also determine the psychographic and behavioral characteristics of each market the company is trying to reach. The following is information on how Walmart Corporation chooses their geographic, demographic, psychographic, and behavioral segments when the company places a new store in a specific neighborhood.…

    • 1193 Words
    • 4 Pages
    Better Essays
  • Best Essays

    Time to Practice Week 1

    • 1891 Words
    • 12 Pages

    3. You are the manager of a fast food store. Part of your job is to report which special is selling best to the boss at the end of each day. Use your knowledge of descriptive statistics and write one paragraph to let the boss know what happened today. Use the following data. Do not use IBM® SPSS® software to compute the statistics needed; rather, do it by hand. Include a copy of your work. PLEASE REFER TO APPENDIX FOR WORK.…

    • 1891 Words
    • 12 Pages
    Best Essays
  • Satisfactory Essays

    Company’s rapid and successful expansion led to increasing number of stores. Evaluation is needed to decide…

    • 335 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Appendix

    • 1088 Words
    • 5 Pages

    Appendix Appendix Contents Table 1. Computed values for Demand 41 Figure 1. Graph for Demand 42 Table 2. Moving Average Technique 43 Table 3. Linear Regression Analysis 43 Table 4.…

    • 1088 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    term project

    • 639 Words
    • 7 Pages

    Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided.…

    • 639 Words
    • 7 Pages
    Satisfactory Essays
  • Satisfactory Essays

    In conducting the previous analysis, we used different assumptions mentioned in the case. For example, to forecast sales at the store level by year, old, and new, we used the arithmetic mean of corresponding historical growth rates in sales adjusted by the total furniture sales' growth rate in the same year in order to account for the industry shocks. We applied the same process to forecast costs such as COGS, SG&A, and Advertising but without the adjustment for total furniture sales' growth rate since it was taken into account with calculating sales. Corporate expenses as a 5% of the same year sales as…

    • 593 Words
    • 3 Pages
    Satisfactory Essays

Related Topics