(answered) – 1) Freight car loadings over an 18-week period at a busy port areDescriptionSolution downloadThe Questionoperations and supply chain management H.w due in 3 hours. File attached1) Freight car loadings over an 18-week period at a busy port are as follows:Week123456Number380385390385390400Week789101112Number Week Number450136555001466555015715545167205951772564518730a Determine a linear trend line for expected freight car loadings. (Round. your intermediate calculations and final answers to 2 decimalplaces.)=+tb. Use the above trend equation to predict expected loadings for Weeks 20 &21. (Round your final answers to 2 decimal places.)The forecasted demand for Week 20 isand for Week 21 is.c. The manager intends to install new equipment when the volume exceeds 960loadings per week. Assuming the current trend continues, in which week (at theearliest) should the loading volume reach that level? (Use the roundedanswers, as required, from any previous part of this problem. Do not roundany other intermediate calculations. Round your final answer to 2 decimalplaces.)It should reach 960 loadings in Week.2) A manager of a store that sells and installs spas wants to prepare a forecastfor January, February, and March of next year. Her forecasts are acombination of trend and seasonality. She uses the following equation toestimate the trend component of monthly demand: Ft = 70 + 4t, where t = 0in June of last year. Seasonal relatives are 1.10 for January, .89 forFebruary, and .95 for March. What demands should she predict? (Roundyour answers to 2 decimal places.)MonthForecastJanuary of the next yearFebruary of the next yearMarch of the next year3) The following data were collected during a study of consumer buying patterns:Observation1234567x11223629535130y73758186979979Observation8910111213x211616261935b. Obtain a linear regression line for the data.(Round your intermediatecalculations and final answers to 3 decimal places.)y=+xc. What percentage of the variation is explained by the regression line?round intermediate calculations. Round your answer to the nearest wholepercent. Omit the “%” sign in your response.)Approximately% of the variation in the dependent variable isexplained by the independent variable.d. Use the equation determined in part b to predict the expected value of49. (Round your intermediate calculations and finalplaces.)y=4) National Scan, Inc., sells radio frequency inventory tags. Monthly salesfor a seven-month period were as follows:MonthFeb.Mar.Apr.May.Jun.Jul.Aug.Sales(000)Units18181421162229b. Forecast September sales volume using each of the following:(1) A linear trend equation.(Round your intermediate calculations and finalanswer to 2 decimal places.)Ytthousands(2) A five-month moving average. (Round your answer to 2 decimal places.)Movingaveragethousands(3) Exponential smoothing with a smoothing constant equal to .30, assuming aMarch forecast of 18(000). (Round your intermediate forecast values andfinal answer to 2 decimal places)Forecastthousands(4) The naive approach.Naiveapproachthousands(5) A weighted average using .60 for August, .10 for July, and .30 forJune. (Round your answer to 2 decimal places.)Weightedaveragethousands
AcademicPaperExperts.com is a platform where students from all over the globe can get assignment assistance. It is our endeavor to provide customized assignments which are authentic for students in the United States, United Kingdom, New Zealand, Australia and other countries around the globe. Our team undergoes thorough training to handle all the inquiries in a professional manner. We do not set the bar in custom essay writing, we are the bar. All the custom papers and essays you order are written by our writers in tandem with your requirements.