The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are looking to forecast their sales for the upcoming year, 2021. Quarter 2018 Q1 Sales $ thousands (y) 15 1 Q2 2 14 Q3 3. 13 Q4 37 2019 Q1 Q2 Q3 Q4 2020 Q1 54 6 34 7 67 73 77 8 9 10 Q2 Q3 Q4 62 11 94 12 101 Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = (Round to 2 decimal places.) b. Determine the specific index for each quarter. 2 decimal places.) (Indexes should be in decimal form (e.g. 1.36 not 136). Rounded to Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for the next four quarters? (Values in $thousands. Round to 2 decimal places.) Quarter Forecasted Sales 2021-1 2021-2 2021-3 2021-3

The following data are the last three years of quarterly sales ($ thousands) for AmeriWeld. They are looking to forecast their sales for the upcoming year, 2021. Quarter 2018 Q1 Sales $ thousands (y) 15 1 Q2 2 14 Q3 3. 13 Q4 37 2019 Q1 Q2 Q3 Q4 2020 Q1 54 6 34 7 67 73 77 8 9 10 Q2 Q3 Q4 62 11 94 12 101 Click here for the Excel Data File. Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = (Round to 2 decimal places.) b. Determine the specific index for each quarter. 2 decimal places.) (Indexes should be in decimal form (e.g. 1.36 not 136). Rounded to Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for the next four quarters? (Values in $thousands. Round to 2 decimal places.) Quarter Forecasted Sales 2021-1 2021-2 2021-3 2021-3

Elementary Algebra

17th Edition

ISBN:9780998625713

Author:Lynn Marecek, MaryAnne Anthony-Smith

Publisher:Lynn Marecek, MaryAnne Anthony-Smith

Chapter1: Foundations

Section1.3: Add And Subtract Integers

Problem 260E: Stock Market During the week of June 22, 2009, the closing numbers of the Dow Jones Industrial...

See similar textbooks

Similar questions

the following table showsthe relationship between your wealth and your utility.
Limpopo company has recorded quarterly maize sales and seasonal ratios from 2015 to 2017 financial year. Table 1 shows quarterly maize production sales with their seasonal ratios (SR). Table 1: Seasonal ratios for maize production sales. Year 2015 2016 Quarter Sales SR Q₁, Q₂, Q3, Q Q₁ ₂ 8, 12, 12, 10 Q₂, Q3, 10, 15, 14, 10 111.63, 87.87 83.33,122.45, 115.42, 84.18 Q4 Use Table 1 to calculate: a) the median seasonal indices (S) and their totals (S). b) the adjusted factor. c) the adjusted seasonal indices (S) and their totals (S.). Q₁ 9 Q₂ 14 2017 " Q3, Q₁ 14, 12 76.60 ,116.67, 113.09, 94.12
JOYFUL Fashion Company is reviewing the monthly sales in year 2021.The monthly sales (in millions) of each month were as below: Jan: $2.2 Feb: $2.5 Mar: $2.0 Apr: $2.8 May: $1.9 Jun: $0.9 Jul: $3.4 Aug: $3.7 Sep: $2.1 Oct: $2.5 Nov: $2.3 Dec: $4.6| The JOYFUL Fashion Company will issue a Gold Membership to customers with accumulated spending in January 2022 over 1% of 2021's average monthly sales and a Platinum Membership to customers with accumulated spending in January 2022 over 1% of the 80th percentile of 2021's monthly sales. (c) Mrs. Robinson has spent $27,450 in January 2022. Will she be qualified for the Gold Membership? Will she be qualified for the Platinum Membership? Explain your answers. (d) It is known that the average monthly sales from Jul 2020 to Dec 2020 were $1.9 millions. Find the average monthly sales from July 2020 to Dec 2021. (e) Are the JOYFUL Fashion Company sales increasing / decreasing? Explain your answer by comparing the half-yearly average monthly sales.…
A company's total sales (in millions of dollars) t months from now are given by S(t) = 0.03³ +0.5t² + 2t +3
Sales Analysis A company's total sales (in millions of dollars) t months from now are given by S(t) = 0.02t³ +0.5t² + 2t +3
c. Predict sales in 15 years.
The following chart shows "living wage" jobs in Rochester per 1000 working age adults over a 5 year period. Year 2016 2017 2018 2019 2020 Jobs 650 695 735 770 800 What is the average rate of change in the number of living wage jobs from 2016 to 2018? Jobs/Year What is the average rate of change in the number of living wage jobs from 2018 to 2020? Jobs/Year > Next Question
What are the predicted total sales 9 months from now? Round to the nearest dollar. $ Thanks!
JOYFUL Fashion Company is reviewing the monthly sales in year 2021. each month were as below:The monthly sales (in millions) of Jan: $2.2 Feb: $2.5 Mar: $2.0 Apr: $2.8 May: $1.9 Jun: $0.9Jul: $3.4 Aug: $3.7 Sep: $2.1 Oct: $2.5 Nov: $2.3 Dec: $4.6(a) Find the mean, mode, standard deviation, and range of the above data.(b) Comment on the skewness of the above data. Explain your answer with the comparison of quartiles.The JOYFUL Fashion Company will issue a Gold Membership to customers with accumulated spending in January 2022 over 1% of 2021’s average monthly sales and a Platinum Membership to customers with accumulated spending in January 2022 over 1% of the 80th percentile of 2021’s monthly sales.(c) Mrs. Robinson has spent $27,450 in January 2022. Will she be qualified for the Gold Membership? Will she be qualified for the Platinum Membership? Explain your answers.(d) It is known that the average monthly sales from Jul 2020 to Dec 2020 were $1.9 millions. Find the average monthly…
JOYFUL Fashion Company is reviewing the monthly sales in year 2021. The monthly sales (in millions) of each month were as below: Jan: $2.2 Jul: $3.4 Feb: $2.5 Aug: $3.7 Mar: $2.0 Sep: $2.1 Apr: $2.8 Oct: $2.5 Мay: $1.9 Nov: $2.3 Jun: $0.9 Dec: $4.6 (d) It is known that the average monthly sales from Jul 2020 to Dec 2020 were $1.9 millions. Find the average monthly sales from July 2020 to Dec 2021. (e) Are the JOYFUL Fashion Company sales increasing / decreasing? Explain your answer by comparing the half-yearly average monthly sales. (i.e. Jul 2020 to Dec 2020; Jan 2021 to Jun 2021; Jul 2021 to Dec 2021)
JOYFUL Fashion Company is reviewing the monthly sales in year 2021. The monthly sales (in millions) of each month were as below: Jan: $2.2 Jul: $3.4 Feb: $2.5 Aug: $3.7 Mar: $2.0 Sep: $2.1 Apr: $2.8 Oct: $2.5 Мay: $1.9 Nov: $2.3 Jun: $0.9 Dec: $4.6 (a) Find the mean, mode, standard deviation, and range of the above data. (b) Comment on the skewness of the above data. Explain your answer with the comparison of quartiles. The JOYFUL Fashion Company will issue a Gold Membership to customers with accumulated spending in January 2022 over 1% of 2021's average monthly sales and a Platinum Membership to customers with accumulated spending in January 2022 over 1% of the 80th percentile of 2021's monthly sales. (c) Mrs. Robinson has spent $27,450 in January 2022. Will she be qualified for the Gold Membership? Will she be qualified for the Platinum Membership? Explain your answers. (d) It is known that the average monthly sales from Jul 2020 to Dec 2020 were $1.9 millions. Find the average…
Suppose the following table shows the approximate price of a certain stock in December of each year from 2005 through 2014, as well as the 4-year moving averages for 2005 through 2007.† Complete the table by computing the remaining 4-year moving averages. (Note the peak in 2007 and the drop in subsequent years.) Round each average to the nearest dollar. (Chart in picture)