145) help with this please!! Mark Price, the new productions manager for Speakers and Company, needs to find out which variable most affects the demand fortheir line of company speakers. He is uncertain whether the unit price of the product or the effects of increased marketing are themain drivers in sales and wants to use regression analysis to figure out which factor drives more demand for its particular market.Pertinent information was collected by an extensive marketing project that lasted over the past 12 years and was reduced to the datathat follow:HEERLESENEYEAR129101112UNIT SALES(THOUSANDS)3976978971,2801,1541,1878971,117990y bar:1,333925819PRICE $/UNIT281220207211220208217205Forecasted sales219207220237+ADVERTISING($000)575828a. Perform a regression analysis based on these data using Excel.Note: Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.1,1171,4121,2151,2809061,117707906707684Price+c. Predict average yearly speaker sales for Speakers and Company based on the regression results if the price was $297 per unit andthe amount spent on advertising (in thousands) was $896.Note: Enter your answer in thousands. Round your intermediate calculations and final answer to 2 decimal places.thousand unitsadvertising

Regression Analysis is a statistical method where individuals and corporations can study the…

Mark Price, the new productions manager for Speakers and Company, needs to find out which variable most affects the demand for their line of company speakers. He is uncertain whether the unit price of the product or the effects of increased marketing are the main drivers in sales and wants to use regression analysis to figure out which factor drives more demand for its particular market. Pertinent information was collected by an extensive marketing project that lasted over the past 12 years and was reduced to the data that follow: YEAR 1 2 3 4 5 6 7 UNIT SALES (THOUSANDS) 397 697 897 1,280 1,154 1,187 897 PRICE $/UNIT 281 220 207 211 220 208 217 ADVERTISING ($000) 575 828 1,117 1,412 1,215 1,280 906

Mark Price, the new productions manager for Speakers and Company, needs to find out which variable most affects the demand for their line of company speakers. He is uncertain whether the unit price of the product or the effects of increased marketing are the main drivers in sales and wants to use regression analysis to figure out which factor drives more demand for its particular market. Pertinent information was collected by an extensive marketing project that lasted over the past 12 years and was reduced to the data that follow: YEAR 1 2 3 4 5 6 7 UNIT SALES (THOUSANDS) 397 697 897 1,280 1,154 1,187 897 PRICE $/UNIT 281 220 207 211 220 208 217 ADVERTISING ($000) 575 828 1,117 1,412 1,215 1,280 906

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Q1 need in 10 minutes
{Auditing} 35. From the following options, identify the control system, which may assist the company in safeguarding its resources? a. None of the options b. Internal control system c. Independent control system d. Intercontinental system
Question 4 Cost-benefit-tradeoff problems are linear programming problems involving the allocation of limited resources to activities. O True O False
What is rho in a FOUR server model? 0.156 0.001 O 0.195 0.009 0.237 (Choose the closest answer) 0.130
QUESTION 8 The variable to remove from the current basis is O the variable with the biggest positive ratio value. O the variable with the smallest positive ratio value O the variable with the smallest positive cj - zj value. O the variable with the biggest positive cj - zj value.
Question 2: State whether the following statements are true or false. If the statement is false, write the correct answer: a) Aiming for high quality production leads to low customer satisfaction. b) A service is an intangible asset since it does physically exist and add potential revenue to the organization. c) Operation management leads to a decrease in competition between companies, hence increasing product quality. d) Hotels are an example of organizations offering strictly only services. e) Operations management contribute to a better standard of living by offering high quality products and services.
Q2 need in 10 minutes
12. How and when would an organization use a: Standing plan Single-use plan 13. Why would a food and nutrition organization benefit from bot short- and long-range plans?
Solve corr handwriting thanks
Material Handling Systems Case The MFA Export Company ships sugar to many overseas ports. Over the years the company has stacked large bags of sugar onto pallets for shipping. Because of a lumber shortage, pallets for export have become very difficult to obtain. The management of MFA Export has presented the dock manager with the challenge of reducing the number of pallets used and/or to find a new way to supplement or change the stevedoring system. Question: Can a system be devised to eliminate the shortage of pallets?
Thesis title: System and Digitalization: its effect to the inventory mangement to the construction industry Give the Theoretical paradigm of the thesis title
Practice Question 1 BackgroundKC Mechanic Shop was established by Mr. John, a seasoned mechanic who has over 20 years ofexperience in the automotive repair industry. Sales figures for the last ten months are as follows:-Months Actual Sales1 30,0002 39,0003 42,0004 50,0005 55,0006 61,0007 70,0008 77,0009 81,50010 90,000Spare Parts Use a three-period and a four-period weighted moving average to forecast salesfor the 12th month. (Use weights of 1,2,3 and 1,2,3 4). From the data provided in the case, use MAD to determine which forecastingtechnique is more accurate. If forecast for month 7 is $72,000, with an alpha of 0.4, use exponentialsmoothing to forecast sales for months 8 and 9.