An analyst must decide between two different forecasting techniques for weekly sales of roller blades. Based on the following data, answer the below questions. time Units sold 1 147 2 148 3 151 4 145 5 155 6 152 7 155 8 157 9 160 10 165 What's the MAD if the exponential smoothing technique with alpha 0.4 is used?
Q: What techniques do you use to distribute jobs effectively?
A: As the lead of a high-performing software team, how you assign & balance work across the team…
Q: (c) Use sensitivity analysis to determine how much the production and/or shipping cost per unit (in…
A: Decision variables: P1 = No. of PT-100 products produced at the Philippines plantP2 = No. of…
Q: Using simplex method.
A: The Decision Variables are: Let, x1 represent the number of acres of crop A x2 the number of acres…
Q: Given the following original forecast and actual data: Month Actual Jan Feb Mar Apr May Jun Jul 600…
A: Ft = (Ft-1) + a {(At-1) - (Ft-1)} Ft = Forcast for period t Ft-1 = Forcast for prior period…
Q: Briefly discuss how organisations can plan risk responses and what can be used in setting up a risk…
A: Whenever any risk event is identified and assessed, decisions needed to be taken to deal with the…
Q: Ethics are crucial in project management
A: Honesty, accountability, respect, and fairness are characteristics that are essential to the project…
Q: State what would be more difficult to forecast 10 years from now, the no. of 60 years olds or their…
A: To be determined: which would be difficult to forecast, the number of 60 years old or their average…
Q: Problem 3-5 (Algo) A cosmetics manufacturer's marketing department has developed a linear trend…
A: Ft = 100,000 + 16,000t where Ft = Annual Sales and t = Years
Q: How are Cp and Cpk calculated and process capabilities explained?
A: Process capability is defined as the spread of any process. If the standard deviation of any process…
Q: A company is reviewing its policy of putting each sub-assembly bought in from outside through a…
A: Effective policies and procedures, including the handbook as a whole, are live documents that must…
Q: Would standardization be advantageous for businesses?
A: Standards are widely used in a particular industry because it allows services and goods to be…
Q: The break-even quantity in units for the manual process = ______ bags (round your response to the…
A: Note: We are allowed to do first three sub-parts only. Break-even quantity= fixed cost/ (selling…
Q: List the specific weaknesses of each of the following approaches to developing a forecast. a.…
A: Weaknesses: a) Consumer Surveys: The consumer surveys does not prove to be valid, in case they are…
Q: What is the bottleneck of the process is which worker ?
A: The worker with the lowest capacity or highest processing time will be the bottleneck of the…
Q: Understanding the distinctions between project management and software project management is…
A: In order to provide people with something of value, project management makes use of particular…
Q: Ethics are crucial in project management.
A: When managing projects, project management ethics are a crucial component. Making the most ethical…
Q: The optimal solution to any linear programming problem is the same as the optimal solution to the…
A: Linear programming is defined as a mathematical modelling technique where the linear function is…
Q: 7. Component Manufacturing. Vollmer Manufacturing makes three components for sale to refrigeration…
A: Decision Variables: Suppose-A be the units of component 1 manufacturedB be the units of component…
Q: A jewelry firms buys semiprecious stones to make bracelets and rings. The supplier quotes a price of…
A: From the above given information, Number of operating days, d= 200 days Unit price, u =RM 32 per…
Q: How does asking "why" five times for each of these bones work in the overall use of this tool? what…
A: Here, I have been given a cause-and-effect diagram or fishbone diagram, This diagram is a…
Q: Ten samples of 15 parts each were taken from an ongoing process to establish a p-chart for control.…
A: Given data:
Q: Explain how the capacity analysis reacts when several processes are running simultaneously
A: Capacity analysis is a method of analyzing the needs of a system. It is used to determine how much…
Q: b. What is the critical path?
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: Jerusalem Medical Ltd., an Israeli producer of portable kidney dialysis units and other medical…
A:
Q: 5. If the business strategy is to offer innovative products for consumer care, what operations…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Compute labor productivity under each system. Use carts per worker per hour as the measure of labor…
A: Productivity is the relationship between the volume of the input and output that is calculated in…
Q: (a) Formulate and solve a linear programming model for this make-or-buy application. (Let FM =…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: 3. Solve the LP using corner point method.
A: Linear programming is a mathematical technique that is also used in operations management…
Q: What is the total crashing cost? $ week(s) (Enter your response as a whole number.)
A:
Q: 7. Based on a recent forecast shared by a customer, the demand for product A is likely to increase…
A: In an organization different functions are interrelated, so if one function is impacted, the effect…
Q: urce their information systems while others prefer to retain them in-house What are some of the…
A: Although there are substantial dangers and difficulties when negotiating and maintaining outsourcing…
Q: a. What is the break-even quantity? Round your answer to the nearest whole number. units b. Should…
A: Demand = 8600 unitsIn-house:Fixed Cost = $ 340,000Variable cost = $ 40 per unit Outsource: Total…
Q: The Montemar Company is considering contracting with a market research firm to do a survey to…
A: Find the Given details below: Given details: Market Conditions Product Favorable (0.2)…
Q: The manager of a bulk foods establishment sells a trail mix for $9 per pound and premium cashews for…
A: The question is related to the linear programming. The details are given regarding the same. Let the…
Q: O A.2 B. 3 G. 2 C, 1 D. 3 H. 5 E, 4 F. 3 I, 3 C Given the diagram above, please answer the…
A: Note: - As we can answer up to three subparts, we will answer the first three (1, 2, and 3) here. If…
Q: A company is planning to manufacture snowboards. The fixed costs are $128 per day and the total…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: 4. A manufacturing firm maintains one product assembly line to produce generators. The demand for…
A: Given, Demand = 85 units per week Production run = 8 hours per day and operates 5.5 days per week…
Q: PERT and CPM methods are used to establish the "critical route" for completing a set of interrelated…
A: The PERT method is based on three key factors: probability, time, and cost. It is a good tool for…
Q: How the quality of the Product can be improved? Discuss its cycle.
A: Production is the process of transforming the raw materials into the finished product for the…
Q: Our company has recently received a few customer complaints that its candles are not lasting the…
A:
Q: Find solution using simplex method. Maximize z = 4x₁ + 3x₂ Subject to the constraints 2x₁ + x₂ ≤…
A: Linear Programming is a mathematical and statistical technique used in operations that help…
Q: A study of the Department of Transportation on driving speed and miles per gallon for midsized…
A: The Formula for Finding sx, Sy,Sxy are: and
Q: Draw BOTH the arrow and node networks for the project given in the table. Activity IPA H C, D I D J…
A: The path with the longest duration is the critical path.
Q: Wheat, corn and rice are to be planted on 10800 acres of farmland. Each acre can produce 35 bushels…
A: Let, W = Acres of land to produce wheat C = Acres of land to produce corn R = Acres of land to…
Q: Determine the gross quantities needed of each item if you are to assemble 150 brackets. 150 units…
A: Ans) Formula: Gross Requirements of child = Multiply the gross requirements of parent* Number of…
Q: A manufacturer has several identical machines that can be used to produce a product. Each unit…
A: Each unit take time(T) = 28 minutes Each machine take time per day(D) = 13 min Number of working day…
Q: Describe 5 essential elements of JIT system.
A: Just-in-time is a system of inventory management in which supplies of labor, materials, and finished…
Q: What is the total crashing cost? $ (Enter your response as a whole number.) LL
A:
Q: Assume that the average price for a 2,000-square-foot house in the city is $360,000 and the average…
A: NOTE: We are allowed to solve the first question only. The average price of a 2000-sq ft house in a…
Q: If a strategy hasn't been attempted, it isn't a good one. Give examples of the many testing…
A: Strategy is simply an idea of a person whose successful implementation can result in some benefits.…
q 1
An analyst must decide between two different
time | Units sold |
1 | 147 |
2 | 148 |
3 | 151 |
4 | 145 |
5 | 155 |
6 | 152 |
7 | 155 |
8 | 157 |
9 | 160 |
10 | 165 |
What's the MAD if the exponential smoothing technique with alpha 0.4 is used?
Step by step
Solved in 3 steps
- Under what conditions might a firm use multiple forecasting methods?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
- The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?
- Accuracy of forecasts. The manager of a large manufacturer of industrial pumps must choose betweentwo alternative forecasting techniques. Both techniques have been used to prepare forecasts for a sixmonth period. Using MAD as a criterion, which technique has the better performance record?FORECASTMonth Demand Technique 1 Technique 21 492 488 4952 470 484 4823 485 480 4784 493 490 4885 498 497 4926 492 493 49333- Judgmental forecasts have the following strengths, except___________. a. Can include “inside” and “soft” information difficult to quantify b. Difficulty in understanding causal relationships c. Can compensate for “one-time” or unusual events d. Highly responsive to latest changes in environment16- Statistical forecasting models have the following weaknesses, except __________. a. Can be costly and time consuming to model “soft” information b. Can process large amounts of data c. Slow to react to changing environments d. Only as good as the model formulation and the data it is based upon