Create an regression model of border snacks

Assignment Help Business Economics
Reference no: EM131691719

Border Snacks Inc. produces and sells jars of salsa, nacho chips, and queso dip. The company's marketing department estimated a linear demand function for Border's picante sauce:

QP = a + bPP + cM + dPN + ePQ

where QP is the number of jars of salsa sold per month, PP is the price of a jar of salsa, PN is the price of a bag of nacho chips, PQ is the price of a jar of queso dip, and M is consumer income.

Border Snacks collected data on the demand variables from January 2010 to October 2017. The raw data can be found in the file SalsaSales_data.xls Attached

a. Use the raw data file to create an regression model of Border Snacks' demand for salsa. Write the equation of the estimated regression.

b. Are salsa and nacho chips complements or substitutes?

c. Are salsa and queso dip complements or substitutes?

d. In the market served by Border Snacks, the median income is currently $56,340. If Border Snacks Inc. sets the price of salsa at $4.99 per jar, the price of its nacho chips at $11.99 per bag, and the price of its queso dip at $6.99 per jar, calculate the sales forecast for number of salsa jars sold.

e. At the prices from the question above, if the price of nacho chips increases by 6.5%, by what percentage can Border Sales expect salsa sales to increase or decrease?

Reference no: EM131691719

Questions Cloud

Describe the scales of measurement : Describe the variables implicit in these 11 items as quantitative or qualitative, and describe the scales of measurement.
Import policies on the economy : What are the effects of the Saudi Arab trade and import policies on the economy?
Example of creative destruction : Provide an example of "creative destruction" not already mentioned in the book. Explain how that example promoted economic progress.
Impact on doctor-hospital and doctor-patient relationship : What is it like for patients? Impact on doctor-hospital relationship? Impact on doctor-patient relationship?
Create an regression model of border snacks : Use the raw data file to create an regression model of Border Snacks' demand for salsa. Write the equation of the estimated regression.
Difference between a qualitative and a quantitative variable : A town has 15 neighborhoods. If you interviewed everyone living in one particular neighborhood, would you be interviewing a population or a sample.
Identify the business type and stating your primary vision : Compose a paper that begins by identifying the business type, stating your primary vision and mission for this business.
Is this practice discriminatory : Is this practice discriminatory? Is the BFOQ defense legitimate?
Building partnerships case study : What should the salesperson do at this point? What will be the repercussions of your answer to question 1?

Reviews

Write a Review

Business Economics Questions & Answers

  Assumptions of the theory of comparative advantage

All of the following are assumptions of the theory of comparative advantage, except

  What price-quantity combination would maximize profit

You are the chief economist of the County Regulatory Commission. The local cable TV monopoly franchise is regulated. The consulting firm provides the long run total cost and demand function estimates for the franchise: If the franchise were not regul..

  What is the present discounted value-what is interest rate

If the interest rate is 5%, what is the present discounted value of receiving $100 in two years? If the present discounted value of $100 received 3 years from now is $81.63, what is the interest rate?

  Concluded the subsequent as such sally projected expenses

Imagine which you are presently a college student working at a part time work. You have Concluded the subsequent as such sally projected expenses also revenues.

  In the short-run-firm can experience increasing

In the short-run, a firm can experience increasing, decreasing, or constant returns to scale. Decreasing returns to scale are often due to coordination and communication problems that create operating inefficiencies.

  Decrease the consumer surplus

Imagine that the United States Congress is considering a law that sets a binding quota on the permissible amount of foreign-produced sugar that can be imported into the United States. The quota is expected to increase U.S. sugar prices, which will ha..

  What is the net present value of this investment opportunity

You have an opportunity to invest in a business venture. It requires a $250,000 investment on January 1st. You will receive $70,000 in After-Tax Cash Flows per year on December 31st for 3 years. At the end of 3 years, the project will be terminated, ..

  Obtained via child support

Jennifer is a single mother oered a job at $15/hour. She has $100 of non-labor income per week (obtained via child support). Jennifer's mother watches the baby for free while she works. What is Jennifer's total weekly income if she works 20 hours/wee..

  Assume oligopolistic competition between the two firms

There are two firms in an in an industry. Let q1 and q2 be the two firms in an industry and Q= q1 + q2 be the total output. The inverse demand in the industry if P (Q)= 45 – Q. The cost function for each firm is C(qi) = 9qi. Assume oligopolistic comp..

  Offer one good or service that you think

Offer one good or service that you think would be considered highly price elastic ,one that you think is highly inelastic and Elucidate why.

  Firm decides in the short run or in the long run

Explain whether this firm decides in the short run or in the long run. Calculate optimal level of output if the equilibrium price is €200.

  Value of the option premium to hedge your position

Q1-You decide to hedge your position in the stock and buy options at the fair market value , when strike prices of 60$. a) What is the value of the option premium to hedge your position

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