Question

In: Statistics and Probability

​​​​​Below is the regression of units sold on the average price of the product. Regression Statistics...

​​​​​Below is the regression of units sold on the average price of the product.

Regression Statistics

Multiple R

0.2461

R Square

0.2000

Adjusted R Square

0.1649

Standard Error

26.128

Observations

20

ANOVA

Df

SS

MS

F

Significance F

Regression

1

3080.89

3080.89

4.51

0.0478

Residual

18

12288.31

682.68

Total

19

15369.20

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

614.9300

51.2343

12.002

0.0000

507.2908

722.5692

X

-109.1120

51.3623

-2.124

0.0478

-217.0202

-1.2038

  1. What is the estimated regression equation?
  2. What is the intercept of the simple linear regression model. Interpret the intercept.
  3. Interpret the slope coefficient.
  4. Test whether the slope coefficient is significant at 1%?
  5. What is the lowest significance level at which the slope coefficient will be significant?
  6. Did your estimated regression equation provide a good fit? How strong is the relationship?
  7. What is your residual when average price is $2.00?
  8. What is the estimated number of units sold if the average price is $2.50?

Solutions

Expert Solution


Related Solutions

Luxvano Co. produced and sold 65,000 units during the year at an average price of $20...
Luxvano Co. produced and sold 65,000 units during the year at an average price of $20 per unit. Variable manufacturing costs were $9 per unit, and variable marketing costs were $3 per unit sold. Fixed costs amounted to $220,000 for manufacturing and $80,000 for marketing. There was no year-end work-in-process inventory. Assume the income tax rate of 40%. REQUIRED: (Show your detailed computations!) a. Compute Luxvano’s break-even point in sales dollars for the year. b. Compute the margin of safety...
Luxvano Co. produced and sold 65,000 units during the year at an average price of $20...
Luxvano Co. produced and sold 65,000 units during the year at an average price of $20 per unit. Variable manufacturing costs were $9 per unit, and variable marketing costs were $3 per unit sold. Fixed costs amounted to $220,000 for manufacturing and $80,000 for marketing. There was no year-end work-in-process inventory. Assume the income tax rate of 40%. (SHOW WORK) a. compute luvano's break-even point in sales dollars for the year b.compute the margin of safety in units c. compute...
ABC Manufacturing expects to sell 1,025 units of product in 2021 at an average price of...
ABC Manufacturing expects to sell 1,025 units of product in 2021 at an average price of $100,000 each based on current demand. The Chief Marketing Officer forecasts growth of 50 units per year through 2025. The $100,000 price will be constant for 5 years. However, ABC cannot produce more than 1,000 units annually. They must update plant or replace it. If replaced, initial working capital of $5 million is required. RRR is 14%. Using excel functions, calculate NPV for both...
ABC Manufacturing expects to sell 1,025 units of product in 2021 at an average price of...
ABC Manufacturing expects to sell 1,025 units of product in 2021 at an average price of $100,000 each based on current demand. The Chief Marketing Officer forecasts growth of 50 units per year through 2025. So, the demand will be 1,025 units in 2021, 1,075 units in 2022, etc. and the $100,000 price will remain consistent for all five years of the investment life. However, ABC cannot produce more than 1,000 units annually based on current capacity. In order to...
ABC Manufacturing expects to sell 1,025 units of product in 2021 at an average price of...
ABC Manufacturing expects to sell 1,025 units of product in 2021 at an average price of $100,000 each based on current demand. The Chief Marketing Officer forecasts growth of 50 units per year through 2025. So, the demand will be 1,025 units in 2021, 1,075 units in 2022, etc. and the $100,000 price will remain consistent for all five years of the investment life. However, ABC cannot produce more than 1,000 units annually based on current capacity. In order to...
Last year, Alpha Company sold 3,600 units of a single product at a price of $100...
Last year, Alpha Company sold 3,600 units of a single product at a price of $100 per unit. The company variable cost per unit was $75, its fixed cost for the year were $40,000. How many units must ALPHA sell to break even? What is ALPHA’s operating leverage? How much will ALPHA need to sell in sales dollars to earn a target profit of $80,000? If ALPHA spends $18,000 and a proposed marketing campaign, it expects that sales would increase...
Last year, Alpha Company sold 3,600 units of a single product at a price of $100...
Last year, Alpha Company sold 3,600 units of a single product at a price of $100 per unit. The company variable cost per unit was $75, its fixed cost for the year were $40,000. A. How many units must ALPHA sell to break even? B. What is ALPHA’s operating leverage? How much will ALPHA need to sell in sales dollars to earn a target profit of $80,000? C. If ALPHA spends $18,000 and a proposed marketing campaign, it expects that...
Garrett Company provided the following information: Product 1 Product 2 Units sold 10,000   20,000   Price $20  ...
Garrett Company provided the following information: Product 1 Product 2 Units sold 10,000   20,000   Price $20   $15   Variable cost per unit $10   $10   Direct fixed cost $35,000   $75,000   Common fixed cost totaled $46,000. Garrett allocates common fixed cost to Product 1 and Product 2 on the basis of sales. If Product 2 is dropped, which of the following is true? a.Sales will increase by $300,000. b.Overall operating income will increase by $2,600. c.Overall operating income will decrease by $25,000. d.Overall...
The regression model below examines factors that impact the DV home sale price among recently sold...
The regression model below examines factors that impact the DV home sale price among recently sold homes in a suburban community. The IV is total rooms within the home, and the EVs include 1) total bedrooms, 2) total bathrooms, 3) whether the home has a basement or not, and 4) the total number of days the home was on the market prior to its sale. Please answer the following regarding the regression output below: A) Identify the variables that are...
The equilibrium price for a product is $58, and the quantity sold of the product is...
The equilibrium price for a product is $58, and the quantity sold of the product is 4060. The price elasticity of demand is -4.6, and the price elasticity of supply is 0.7. Find the demand curve and the supply curve for the product. (Your answer for the demand curve should be in the form Qd = a – bP, with specific numerical values given for a and b. Your answer for the supply curve should be in the form Qs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT