Question

In: Statistics and Probability

A statistical program is recommended. A certain company produces and sells frozen pizzas to public schools...

A statistical program is recommended.

A certain company produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy, they have been able to increase their annual revenue by approximately $10 million over the past 10 years. But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous 10 years is shown.

Year Revenue
1 8.53
2 10.94
3 12.88
4 14.11
5 16.41
6 17.21
7 18.27
8 18.55
9 18.50
10 18.33

(b)

Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast revenue (in millions of dollars). (Round your numerical values to three decimal places.)

Tt =

  

(c)

Using the trend equation developed in part (b), forecast revenue (in millions of dollars) in year 11. (Round your answer to two decimal places.)

$  million

Solutions

Expert Solution

Trend line using MINITAB:

(b) Regression Analysis: Revenue(Y) versus Years (X), X^2

The regression equation is
Revenue(Y) = 5.70 + 2.90 Years (X) - 0.163 X^2


Predictor Coef SE Coef T P
Constant 5.6972 0.3228 17.65 0.000
Years (X) 2.8997 0.1348 21.51 0.000
X^2 -0.16292 0.01195 -13.64 0.000


S = 0.274482 R-Sq = 99.5% R-Sq(adj) = 99.4%

Years

Obs (X) Revenue(Y) Fit SE Fit Residual St Resid
4 4.0 14.1100 14.6891 0.1213 -0.5791 -2.35R

R denotes an observation with a large standardized residual.

(c) FOR X=11
Y= 5.70+2.90 *11-0.163* 11^2
Y= 17.877

Revenue for 11 years = 17.88

STEPS OF MINITAB FOR QUADRATIC LINE:

  1. Add an x2 column.
    • Name Column C3 by clicking the blank column label and typing "x^2"
    • Select "Calc --> Calculator."
    • Fill out the resulting dialog box as follows:
      Input Type Label Value
      Store result in variable: 'x^2'
      Expression: 'x'**2
    • Click "OK."
  2. Compute a quadratic fit and display summary information.
    • Select "Stat --> Regression --> Regression."
    • Fill out the resulting dialog box as follows:
      Input Type Label Value
      Response: y
      Predictors: x 'x^2'
    • Before closing the dialog box, click "Results."
    • In the dialog box that follows, click the radio button next to the label, "In addition, the full table of fits and residuals.
    • Click "OK" to close the "Results" dialog box.
    • Click "OK" in the "Regression" dialog box.

Related Solutions

More images for certain company produces and sells frozen pizzas to public schools throughout the eastern...
More images for certain company produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very aggressive marketing strategy, they have been able to increase their annual revenue by approximately $10 million over the past 10 years. But increased competition has slowed their growth rate in the past few years. The annual revenue, in millions of dollars, for the previous 10 years is shown. Year Revenue 1. 8.43 2. 10.94 3. 13.08 4. 14.11 5....
The Ace Pizza Company makes and sells frozen pizzas. The company pays $2500 to rent the...
The Ace Pizza Company makes and sells frozen pizzas. The company pays $2500 to rent the building it uses and pays $500 to rent the equipment it uses. These are the firm’s fixed costs. The company’s variable costs are listed in the following table. Quantity of Pizzas Variable Costs 0 $0 200 $400 400 $1,000 600 $1,800 800 $3,600 1000 $7,000 a) Calculate the firm’s total cost, average cost, and marginal cost for each quantity of output. Fill in the...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 52,900 units will...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 52,900 units will be produced, with the following total costs: Direct materials ? Direct labor 54,000 Variable overhead 20,000 Fixed overhead 245,000 Next year, Pietro expects to purchase $121,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $7,000 $12,900 Ending $6,900 $14,900 Next year, Pietro expects to produce 52,900 units and...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,300 units will...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,300 units will be produced, with the following total costs: Direct materials ? Direct labor 59,000 Variable overhead 21,000 Fixed overhead 190,000 Next year, Pietro expects to purchase $120,500 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $5,000 $12,200 Ending $4,900 $14,200 Pietro expects to produce 49,300 units and sell 48,600...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 50,000 units will...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 50,000 units will be produced, with the following total costs: Direct materials ? Direct labor $54,000 Variable overhead 29,000 Fixed overhead 205,000 Next year, Pietro expects to purchase $129,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $5,000 $15,000 Ending $4,900 $17,000 Required: 1. Prepare a statement of cost of goods...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 50,000 units will...
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 50,000 units will be produced, with the following total costs: Direct materials $120,000 Direct labor 70,000 Variable overhead 35,000 Fixed overhead 220,000 Required: If required, round your answers to the nearest cent. 1. Calculate the prime cost per unit. $ per unit 2. Calculate the conversion cost per unit. $ per unit 3. Calculate the total variable cost per unit. $ per unit 4. Calculate the total...
A statistical program is recommended. The owner of a movie theater company would like to predict...
A statistical program is recommended. The owner of a movie theater company would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Revenue ($1,000s) Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 96 5 1.5 91 2 2 95 4 1.5 93 2.5 2.5 95 3 3.2 94 3.5 2.2 94 2.5 4.1 94 3 2.5 (a) Use α = 0.01 to test the hypotheses H0: β1 =...
A statistical program is recommended. The owner of a movie theater company would like to predict...
A statistical program is recommended. The owner of a movie theater company would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Revenue ($1,000s) Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 96 5 1.5 91 2 2 95 4 1.5 93 2.5 2.5 95 3 3.2 94 3.5 2.3 94 2.5 4.2 94 3 2.5 (a) Use α = 0.01 to test the hypotheses H0: β1 =...
Cornerstone Exercise 2.3 (Algorithmic) Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For...
Cornerstone Exercise 2.3 (Algorithmic) Cost of Goods Sold Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 47,700 units will be produced, with the following total costs: Direct materials ? Direct labor 69,000 Variable overhead 22,000 Fixed overhead 205,000 Next year, Pietro expects to purchase $119,500 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $7,000 $13,600 Ending $6,900 $15,600 Pietro...
Income Statement Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,500...
Income Statement Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 49,500 units will be produced, with the following total costs: Direct materials ? Direct labor 61,000 Variable overhead 20,000 Fixed overhead 225,000 Next year, Pietro expects to purchase $115,000 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows: Direct materials Inventory Work-in-Process Inventory Beginning $4,000 $13,900 Ending $3,900 $15,900 Next year, Pietro expects to produce 49,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT