1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
GuDViN [60]
2 years ago
15

Giovanni Food Products produces and sells frozen pizzas to public schools throughout the eastern United States. Using a very agg

ressive 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 contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
Year Revenue
1 8.53
2 10.84
3 12.98
4 14.11
5 16.31
6 17.21
7 18.37
8 18.45
9 18.40
10 18.43
a. Construct a time series plot. Comment on the appropriateness of a linear trend.
b. Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast revenue.
c. Using the trend equation developed in part (b), forecast revenue in year 11.
Mathematics
1 answer:
scoray [572]2 years ago
5 0

Answer:

a-1. See part a-1 of the attached excel file for the time series plot.

a-2. The linear trend is not appropriate

b. The quadratic trend equation is y = -0.1618x^2 + 2.889x + 5.7022

c. Revenue in year 11 is 17.90.

Step-by-step explanation:

a-1. Construct a time series plot. Comment on the appropriateness of a linear trend.

Note: See part a-1 of the attached excel file for the time series plot.

a-2. Comment on the appropriateness of a linear trend.

Note: See part a-2 of the attached excel file for the time series plot with a linear trend.

From the time series plot with a linear trend, it can be seen that the movements of the time series plot and the linear trend are not the same. This implies that the linear trend is not appropriate

b. Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast revenue.

Note: See part b of the attached excel file for the quadratic equation trend.

From the quadratic equation trend, we obtained the following quadratic trend equation that can be used to forecast revenue:

y = -0.1618x^2 + 2.889x + 5.7022 ……………. (1)

Where;

y = Revenue

x = Year

c. Using the trend equation developed in part (b), forecast revenue in year 11.

Substituting x = 11 into equation (1), we have:

y = (-0.1618 * 11^2) + (2.889 * 11) + 5.7022 = 17.90

Therefore, revenue in year 11 is 17.90.

Download xlsx
You might be interested in
A storekeeper has two kinds of flour, one selling for 65 cents per pound, and the other selling for 95 cents per pound. How many
Murrr4er [49]

Answer:

The amount of 65 cents per pound flour to use is 40 pounds and the amount of 95 cents per pound flour to use is 60 pounds

Step-by-step explanation:

Let

x ----> amount of 65 cents per pound flour to use

y----> amount of 95 cents per pound flour to use

we know that

x+y=100 ----> y=100-x ----> equation A

0.65x+0.95y=0.83(100) ----> equation B

substitute equation A in equation B

0.65x+0.95(100-x)=0.83(100)

Solve for x

0.65x+95-0.95x=83

0.95-0.65x=95-83

0.30x=12

x=40\ lb

Find the value of y

y=100-40=60\ lb

therefore

The amount of 65 cents per pound flour to use is 40 pounds and the amount of 95 cents per pound flour to use is 60 pounds

4 0
3 years ago
Read 2 more answers
7x + (9x + 8) = (7x + 9x) + 8 is what property
bonufazy [111]
Nensjsjdjejdjejejejejejsj &2828388338484738388338383838 sksksksjsnsksnenenenendnjdjfjffjdjrjdjdjdjdjdjdjdjdidjdjdiddijjJj$&2383884845$ fififitogosoenrndidjfnncifmrki938474859499494
6 0
3 years ago
Choose a method . Then find the product 10x15
34kurt

Answer:

150

Step-by-step explanation:

15*10

Lets get rid of the 0 for now

15*1

That is 15 added to itself 0 times so it is 15

Now lets put the 0 back

and we will get

150

5 0
3 years ago
Read 2 more answers
The subject of the formula below is y.<br>a=4x/t - p<br>Rearrange the f make x the subject.​
Crazy boy [7]

Answer:

x = t(a+p)/4

Step-by-step explanation

Given the expression

​a=4x/t - p

We are to make x the subject of the formula

a=4x/t - p

Add p to both sides

a+p = 4x/t - p+p

a+p = 4x/t

Cross multiply

t(a+p) = 4x

Rearrange

4x = t(a+p)

Divide both sides by 4

4x/4 = t(a+p)/4

x = t(a+p)/4

4 0
2 years ago
PQRS is a rectangle.
Anuta_ua [19.1K]

Answer:

diagram pls

then I can answer this question

8 0
2 years ago
Other questions:
  • Tina sells homemade crafts online. Her online
    6·2 answers
  • On a map, 1 cm represents 30 km. Two cities on the map are 2.3 cm apart.
    9·1 answer
  • Jasmine has a gross pay of $754.80. By how much will Jasmine’s gross pay be reduced if she has the following items withheld? fed
    12·2 answers
  • How do you find the average of a group of numbers
    7·1 answer
  • To go on the class trip, Chang needs at least $125. He has saved $45, and he makes $7 an hour at his job. What is the minimum nu
    9·1 answer
  • Please please help me with this question please
    5·1 answer
  • Help find the missing number for x
    15·1 answer
  • Find the volume <br><br> A. 150 cm3<br><br> B. 180 cm3<br><br> C. 90 cm3<br><br> D. 90 cm2
    13·1 answer
  • Edward deposited ​$5,500 into a savings account 3 years ago. The simple interest rate is 3​%. How much money did Edward earn in​
    13·2 answers
  • Which number below is an integer but not a natural number?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!