Estimate House Paints Demand for Sherwin-Williams Table: Sherwin-Williams Company new Data Observations Sales Promotional Expenditures Selling...

Estimate House Paints Demand for Sherwin-Williams

Table: Sherwin-Williams Company new Data

Observations	Sales	Promotional Expenditures	Selling Price	Disposable Income
i	y	A	P	M
1	160	100	15	19
2	200	160	14	17.5
3	140	50	16.5	14
4	190	190	14.5	20
5	130	90	17	15.5
6	160	70	16	14.5
7	200	140	15	21.5
8	150	110	18	18
9	210	200	12	18.5
10	190	100	15.5	20

Total	1730	1210	153.5	178.5
Mean	173	121	15.35	17.85

1) What is regression equation for paint sales using multiple linear regression model? Please include regression results using Excel?)

2) If A=180, P=$14, and M=20, what is an approximate 95 percent prediction interval for paint sales?

Expert Solution

Rahul Sunny answered 1 year ago

Chapter 5 Question 5.1 Sherwin-Williams Company aims to develop a demand model for its line of...

Chapter 5 Question 5.1 Sherwin-Williams Company aims to develop a demand model for its line of exterior house paints. The most important variables affecting paint sales (Y) (measured in gallons) are: Promotional expenditures (A): expenditures on advertising Selling price (P) The chief manager decides to collect data on the variables in a sample of 10 company sales regions that are roughly equal in population. Data on paint sales, promotional expenditures are shown in Table 5.1. The company is interested in...

Using the data in the table below, estimate the demand function for cod. Price, dollars...

Using the data in the table below, estimate the demand function for cod. Price, dollars per pound Quantity, thousand pounds per day 1.90 1.5 1.35 2.2 1.25 4.4 1.20 5.9 0.95 6.5 0.85 7.0 0.73 8.8 Using the Excel trendline option to estimate a linear demand function, the linear demand function is Qequals=12.53 minus 6.25 p12.53−6.25p. Suppose the quantity in the first row of the table were 22 instead of 1.5. The linear demand function would now be Qequals=nothingminus−nothingp....

Explain how your your company utilizes or implements the promotional mix(Advertising,sales promotion,publicity,personal selling) to reach target...

Explain how your your company utilizes or implements the promotional mix(Advertising,sales promotion,publicity,personal selling) to reach target market(s).You are only required to discuss one promotional mix item or a even a fraction of a promo.mix. help me with that paper please can you add citation plaese.thanks

Kirby Company plans to begin selling a new product line. The company projectws sales for the...

Kirby Company plans to begin selling a new product line. The company projectws sales for the next four years of $100,000, $230,000, $180,000 and $245,000. In order to meet these sales goals, Kirby Company needs to have 30% of the following year's sales on hand as inventory prior to the start of the year. How will these inventory purchases be reflected in the capital budgeting analysis for Kriby Company?

Oaktree Company purchased new equipment and made the following expenditures: Purchase price $ 50,000 Sales tax...

Oaktree Company purchased new equipment and made the following expenditures: Purchase price $ 50,000 Sales tax 2,700 Freight charges for shipment of equipment 750 Insurance on the equipment for the first year 950 Installation of equipment 1,500 The equipment, including sales tax, was purchased on open account, with payment due in 30 days. The other expenditures listed above were paid in cash. Required: Prepare the necessary journal entries to record the above expenditures. (If no entry is required for a...

Data Manufactured in-house Fixed cost $50,000 Unit variable cost $125 Payoff Table Demand Purchased from supplier...

Data Manufactured in-house Fixed cost $50,000 Unit variable cost $125 Payoff Table Demand Purchased from supplier 800 1,000 1,200 1,400 Unit cost $175 Manufacture $150,000 $175,000 $200,000 $225,000 Outsource $140,000 $175,000 $210,000 $245,000 Production volume 1500 Model ANSWER Manufacture/Outsource Value Average Payoff Total manufacturing cost $237,500 Aggressive Total purchased cost $262,500 Conservative Cost difference (Manufacture - Purchase) -$25,000 Best Decision Manufacture Problem 16A Payoff Tables Based on the cost model and payoff table provided, determine the...

The following data relate to KATZEN Sales Inc., a new company:

The following data relate to KATZEN Sales Inc., a new company: Planned and actual production 200,000 units Sales at $45 per unit 180,000 units Manufacturing costs: Variable $18 per unit Fixed $800,000 Selling and administrative costs: Variable $6 per unit Fixed $925,000 Required: A. Determine the number of units in the ending finished-goods inventory B. Calculate the cost of the ending finished-goods inventory using variable costing C. Calculate the cost of the ending finished-goods inventory using absorption costing...

The table shows the numbers of new-vehicle sales (in thousands) in the United States for Company...

The table shows the numbers of new-vehicle sales (in thousands) in the United States for Company A and Company B for 10 years. The equation of the regression line is ModifyingAbove y with caret equals 0.975 x plus 1 comma 259.19. Complete parts (a) and (b) below. New-vehicle sales left parenthesis Company Upper A right parenthesis comma x 4 comma 144 3 comma 880 3 comma 595 3 comma 443 3 comma 295 3 comma 110 2 comma 849 2...

how can a company use statistical demand analysis to forecast sales when launching a new product?...

how can a company use statistical demand analysis to forecast sales when launching a new product? * forecasting sales would be based on different factors such as population, disposable income, the prices of the products, advertising.

12-A2 Customer Profitability The following table gives sales, product cost, and cost-to-serve data for a company...

12-A2 Customer Profitability The following table gives sales, product cost, and cost-to-serve data for a company that makes three product lines: A, B, and C. The company has two customer types. PRODUCT A PRODUCT B PRODUCT C Sales $5,000 $6,000 $25,000 Cost of Sales 4,500 4,800 15,000 Customer Type 1 Customer Type 2 Customer Type 3 Product A Sales $500 $4,500 $5,000 Product B Sales 1,000 5,000 6,000 Product C Sales 13,000 12,000 25,000 Manager Visits 4 16 20 The...

Question