Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 220 7 350 13 460 2 245 8 360 14 475 280 9 400 15 500 4 275 10 380 16 510 300 11 420 17 525 6. 310 12 450 18 541 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 3 decimal places.) Y = 19.19 + 213.53 t b. Use the trend equation to predict expected loadings for weeks 20 and 21. (Round your intermediate calculations and final answers to 3 decimal places.) The forecasted demand for week 20 and 21 is 597.33 and 616.52 respectively. c. The manager intends to install new equipment when the volume exceeds 800 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately how many more weeks? (Round your intermediate calculations to 3 decimal places and final answer to the nearest whole number.) It would take approximately 12 more weeks.

Freight car loadings over an 18-week period at a busy port are as follows: Week Number Week Number Week Number 1 220 7 350 13 460 2 245 8 360 14 475 280 9 400 15 500 4 275 10 380 16 510 300 11 420 17 525 6. 310 12 450 18 541 a. Determine a linear trend line for expected freight car loadings. (Round your intermediate calculations and final answers to 3 decimal places.) Y = 19.19 + 213.53 t b. Use the trend equation to predict expected loadings for weeks 20 and 21. (Round your intermediate calculations and final answers to 3 decimal places.) The forecasted demand for week 20 and 21 is 597.33 and 616.52 respectively. c. The manager intends to install new equipment when the volume exceeds 800 loadings per week. Assuming the current trend continues, the loading volume will reach that level in approximately how many more weeks? (Round your intermediate calculations to 3 decimal places and final answer to the nearest whole number.) It would take approximately 12 more weeks.

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015

1st Edition

ISBN:9781680331141

Author:HOUGHTON MIFFLIN HARCOURT

Publisher:HOUGHTON MIFFLIN HARCOURT

Chapter4: Writing Linear Equations

Section: Chapter Questions

Problem 14CR

See similar textbooks

Similar questions

Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table: YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a trend line for the demand for fertilizer using any computer software? b) For these three forecasts, 3-year moving average, a weighted moving average, and a trend line, which one would you use? Explain your answer?
The following time series shows the sales of supermarket chain over the last six months. Month Sales ($ 000) August 2021 250 Sep 2021 280 Oct 2021 295 Nov 2021 320 Dec 2021 380 Jan 2022 360 Develop a linear trend equation that can be used to forecast sales in Feb 2022. Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.
The table given below indicates Small Holding Ltd.’s quarterly profits in 2019 and2020.Time Period Profit (Thousands Of Rands)2019 Q12019 Q22019 Q32019 Q42020 Q12020 Q22020 Q32020 Q4250210165195265218178204Q.6.3.1 Determine the trend regression function for this data set. In order toobtain full marks for this question, you must complete the relevanttable (template provided below) and then apply the appropriate timeseries formulae in the formulae sheet.
What would we call March 2020’s data point? What happened at that point in time to cause this?
The table given below indicates Small Holding Ltd.’s quarterly profits in 2019 and 2020.Time Period Profit (Thousands Of Rands)2019 Q1 2502019 Q2 2102019 Q3 1652019 Q4 1952020 Q1 2652020 Q2 2182020 Q3 1782020 Q4 204Q.6.3.1 Determine the trend regression function for this data set. In order to obtain full marks for this question, you must complete the relevanttable (template provided below) and then apply the appropriate timeseries formulae in the formulae sheet.Q.6.3.2 Given that the typical seasonal index for Q3 is 87.3, use this informationand the trend regression function obtained in Q.6.3.1 to determine theseasonally adjusted trend estimate for profits in Q3 of 2022.
In a study conducted recently, the body weight of youth wresting team in Mongolia are found to be as follows: Body weight Class(kg) Frequency (Wrestlers) 70 < X ≤ 80 5 80 < X ≤ 90 14 90 < X ≤ 100 21 100 < X ≤ 110 26 110 < X ≤ 120 35 120 < X ≤ 130 23 130 < X ≤ 140 18 140 < X ≤ 150 15 150 < X ≤ 160 7 Construct an Ogive curve reflecting the above data. Approximately what percentage of the wrestlers weigh less than 130kg? Approximately what percentage of the wrestlers weigh between 85kg and 145kg Approximately what is the body weight of the top 30% youth wrestlers?
Amex PLC has gathered following information on the sales of face mask from April 2020 to September 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 August 21,000 September 23,000 You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving average designed with the following weights: July 0.2, August 0.3 and September 0.5. Note: You need to show all the steps in your calculation. No excel files will be graded.
The report “Daily Cigarette Use: Indicators on Children and Youth" (Child Trends Data Bank, childtrends.org/wp-content/uploads/2012/11/03 _Smoking_new.pdf, retrieved April 17, 2017) included the accompanying data on the percentage of students who report smoking cigarettes daily, for students in grades 8, 10, and 12. Construct a time series plot for students in grade 12, and comment on any trend over time. Construct a time series plot that shows trends over time for each of the three grade levels. Graph each of the three-time series on the same set of axes, using different colors to distinguish the different grade levels. Either label the time series in the plot or include a legend to indicate which time series corresponds to which grade level. Write a paragraph based on the plot from Part (b). Discuss the similarities and differences for the three grade levels
Based on the given sales volume of AZ’s sanitizer product for 16 weeks, construct the trend projection using graphs, 3 weeks moving average, and exponential smoothing methods. Weeks Sanitizer sales 1 5600 2 5200 3 4570 4 4305 5 5465 6 8900 7 15680 8 24680 9 35040 10 36500 11 38575 12 35300 13 35200 14 35150 15 34950 16 34500
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000sof gallons) 1 17 2 21 3 19 4 24 5 18 6 16 7 21 8 19 9 22 10 21 11 16 12 23 *PLEASE REFER TO ATTACHED IMAGE FOR DATA! PART 1.Compute four-week and five-week moving averages for the time series. PART 2. Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) PART 3.Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.)
hudson Marine has been an authorized dealer for c&d marine radios for the past sevenyears. the following table reports the number of radios sold each year.Year 1 2 3 4 5 6 7Number Sold 35 50 75 90 105 110 130a. construct a time series plot. does a linear trend appear to be present?b. Using Minitab or excel, develop a linear trend equation for this time series.c. Use the linear trend equation developed in part (b) to develop a forecast for annualsales in year 8.
Which of the following time series forecasting methods would not be used to forecast seasonal data?