Develop a quadratic trend equation that can be used

Reference no: EM13918222

Giovanni Food Products 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 below.

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 Excel Solver or LINGO, 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.

Reference no: EM13918222

Questions Cloud

Conception that defines an individual or a society : Worldview is a conception that defines an individual or a society. It is characterized by the society's beliefs, practices and their interaction with other members of divergent societies and dialects.

Should audiocables buy the new equipment : Audio Cables, Inc. is currently manufacturing an adapter that has a variable cost of $0.50 and a selling price of $1.00 per unit. Fixed costs are $14000. Current sales volume is 30,000. The form can substantially improve the product quality by add..

Significant difference between two groups on the variable : The following research questions can be answered using 1 of the 5 tests you have learned so far: single-sample t-test, paired-samples t-test, independent-samples t-test, one-way ANOVA, or two-way ANOVA. Use the information in the tables to constru..

Spontaneous liabilities : Spontaneous assets are 60% of sales, and spontaneous liabilities are 40% of sales. BHS has an 8% profit margin and a 40% dividend payout ratio.

Develop a quadratic trend equation that can be used : Using Excel Solver or LINGO, develop a quadratic trend equation that can be used to forecast revenue. Using the trend equation developed in part (b), forecast revenue in year 11.

The repayment of bond liabilities assuming that the bonds : On January 1, 2013, DIBA Company had a balance of $450,000 in its Bonds Payable account. During 2013, DIBA issued bonds with a $200,000 face value.

Evaluate the incremental net income from each offer : Evaluate the incremental net income from each offer. What other factors should Fan Diego consider in deciding which offer to accept?

Calculate the amount of bond discount or premium : calculate the amount of bond discount or premium, if any. (Do not round your intermediate calculations and round your final answers to whole dollar amount. Omit the "$" sign in your response.)

Physical placed called nirvana : 1. The Hindu heaven is a physical placed called Nirvana. 2. Since the fall of humanity (Genesis Chapter 3) mankind has sought to declare independence from God.

User Account

All Pages