Question

1. The president of a small manufacturing firm is concerned about the continual growth in manufacturing...

1.

The president of a small manufacturing firm is concerned about the continual growth in manufacturing costs in the past several years. The data series of the cost per unit for the firm’s leading product over the past 8 years is as follows:

Year Cost/Unit ($) Year Cost/Unit ($)
1 18.00 5 27.00
2 22.50 6 28.00
3 30.00 7 36.00
4 26.00 8 35.00

Develop a simple linear regression model for these data. What average cost increase has the firm been realizing per year? Do not round intermediate calculations. Round your answers to four decimal places.

The regression equation is Unit Cost = ___ + ___ Year

The average cost increase per year is $

2. The historical sales for a certain model of a single serve coffee maker at a specialty cookware store in units is: January, 28; February, 18; March, 19; April, 23; May, 20, and June, 25. Use single exponential smoothing with α = 0.2, and compute the exponential smoothing forecasts for February through June. Do not round intermediate calculations. Round your answers to two decimal places.

Month Observation Forecast
January 28 28
February 18
March 19
April 23
May 20 24.28
June 25 23.42
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

Linear regression equation is determined using least square method as follows:

The regression equation is Unit Cost = __18.0894__ + __2.1607__ * Year

The average cost increase per year is = slope = $ 2.1607

Add a comment
Know the answer?
Add Answer to:
1. The president of a small manufacturing firm is concerned about the continual growth in manufacturing...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs...

    The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm's leading product over the past eight years. Click on the datafile logo to reference the data. DATA Year Cost/Unit () Year Cost/Unit (s) 20.00 24.50 28.20 27.50 26.60 30.00 31.00 36.00 (a) Choose the correct time series plot. Plot (ii) What type of pattern...

  • AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12...

    AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...

  • Maintenance costs at Seaside Manufacturing over the past six months are listed in the following table....

    Maintenance costs at Seaside Manufacturing over the past six months are listed in the following table. Month January February March April Maintenance cost $13,600 $14,720 $13,000 $14,480 $17,000 $13,200 Machine hours 15,500 16,900 13,000 16,600 18,000 15,000 May June Using the high-low method, what would the total maintenance costs be if 17,500 machine hours were used? (Round any intermediary calculations to the nearest cent.) O A. $16,600 OB. $3,000 OC. $14,000 OD. $32,000 Maintenance costs at Seaside Manufacturing over the...

  • The Central Valley Company is a manufacturing firm that produces and sells a single product. The...

    The Central Valley Company is a manufacturing firm that produces and sells a single product. The company's revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March 5,800 $742,400 392,200 April 5,300 $678,400 366,336 Мay 6,450 $825,600 429,312 June Sales in units 7,600 $972,800 496,128 Sales revenue Less: Cost of goods sold Gross margin Less: Operating Expenses Shipping expense Advertising expense Salaries and commissions $312,064 $396,288 $476,672 $350,200 $ 63,100 82,000 163,200...

  • The Central Valley Company is a manufacturing firm that produces and sells a single product. The...

    The Central Valley Company is a manufacturing firm that produces and sells a single product. The company's revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April 6,200 5,700 $762,600 $701,100 402,800 378,594 Sales in units Sales revenue Less: Cost of goods sold May 7,050 $867,150 450,918 June 8,400 $1,033,200 526,932 $359,800 $322,506 $416,232 $ 506,268 $ Gross margin Less: Operating Expenses Shipping expense Advertising expense Salaries and commissions Insurance expense...

  • The Central Valley Company is a manufacturing firm that produces and sells a single product. The...

    The Central Valley Company is a manufacturing firm that produces and sells a single product. The company's revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April 5,700 5,200 $735,300 $670,800 389,550 362,232 on Sales in units Sales revenue Less: Cost of goods sold May 6,300 $812,700 422,604 June 7,400 $954,600 486,846 $345,750 $308,568 $390,096 $467,754 Gross margin Less: Operating Expenses Shipping expense Advertising expense Salaries and commissions Insurance expense Amortization...

  • The Central Valley Company is a manufacturing firm that produces and sells a single product. The...

    The Central Valley Company is a manufacturing firm that produces and sells a single product. The company's revenues and expenses for the last four months are given below. Central Valley Company Comparative Income Statement March April 6,300 5,800 $762,300 $701,800 405,450 378,972 Sales in units Sales revenue Less: Cost of goods sold May 7,200 $871,200 453,024 June 8,600 $1,040,600 530,706 $356,850 $322,828 $418,176 $ 509,894 $ Gross margin Less: Operating Expenses Shipping expense Advertising expense Salaries and commissions Insurance expense...

  • Question 1 12 pts Imani is the controller for Extreme Enterprises, a manufacturing firm that makes...

    Question 1 12 pts Imani is the controller for Extreme Enterprises, a manufacturing firm that makes processing chips for phones and computers. Each order is considered a "job" for the firm. Imani has direct costs related to Job 45344 as follows: • 12 hours of labor @ $19 per hour and $2,098 of materials In addition, Extreme estimates its overhead related to the manufacture of chips to be $141,185 for the year. The company expects to do 72,178 jobs for...

  • Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped...

    Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number Total of Units Shipping Cost Month Shipped 3500 2.500 February 75 March 45 June July 80 4.000 50 3,450 Required: 1. Prepare a scattergraph of Odessa's shipping cost and draw the line you believe best fits the data. Instructions: 1. Use the point tool (7 points) to plot each Units Shipped / Total cost combination. 2. To enter exact...

  • Thus, r_ (.9014) .8125, meaning that about 81% of the variability in sales can be explained...

    Thus, r_ (.9014) .8125, meaning that about 81% of the variability in sales can be explained by the regression model with advertising as the independent varia ble. Problems Nde ΡΧ mere te problem may be sch od with POM for Wrndows ardor Exco. 4.1 The following gives the number of pints of type B t wook of October 12 b) Use a 3-week weighted moving average, with weights of. 1, 3, and 6, using .6 for the most recent week....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT