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

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

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