Problem 2-4 (Algo) A company that makes shopping carts for supermarkets and other stores recently purchased some new equipment that reduces the labor content of the jobs needed to produce the shopping carts. Prior to buying the new equipment, the company used 7 workers, who together produced an average of 80 carts per hour. Workers receive $15 per hour, and machine cost was $40 per hour. With the new equipment, it was possible to transfer one of the workers to another department, and equipment cost increased by $11 per hour, while output increased by 5 carts per hour. a. Compute labor productivity under each system. Use darts per worker per hour as the measure of labor productivity. (Round your answers to 3 decimal places.) Before After carts per worker per hour carts per worker per hour b. Compute the multifactor productivity under each system. Use carts per dollar cost (labor plus equipment) as the measure. (Round your answers to 3 decimal places.) Before 0.552 carts/dollar cost 0.603 carts/dollar cost After Moving average 21.40 thousands (3) A weighted average using 0.60 for August. 0.10 for July, and 0.30 for June. (Round your answer to 2 decimal places.) Weighted average thousands (4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places.) Forecast thousands (5) A linear trend equation (Round your intermediate calculations and final answer to 2 decimal places.) YI thousands Click here for the Excel Data File a. Determine a linear trendline for expected freight car loadings. (Round your intermediate calculations and final answers to 2 decimal places.) 256.01 12.12 b. 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 is 498,41 and for Week 21 is 510.53 C. The manager intends to install new equipment when the volume exceeds 850 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 decimal places.) It should reach 850 loadings in Week Problem 3-20 (Algo) An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the naive approach. The linear trend equation is Ft -125 +2.2t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy if MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) Units Sold 11 12 13 14 15 16 17 18 19 20 148 151 147 154 149 154 156 158 163 Click here for the Excel Data File MAD (Naive) MAD (Linear MSE (Nalive) MSE (Linear) 4.11 6.70 19.22 52 22 provides forecasts with less average error and less average squared error