2. Calculate the exponential smoothing forecast for week eight using a=0.2. Week Sales Forecast 1 39 2 44 3 40 4 45 5 38 6 43 7 39 a. 41.63 b. 39.98 c. 40.54 d. 40.03
Q: "High reliability can be achieved in a product without having high reliability in the component…
A: Total quality management is described as a system of management through which an organization can be…
Q: You are the marketing director for a minor league baseball team, and (not unlike a certain major…
A: As per the given information, attendance in a number depends on the competitiveness of the team,…
Q: A swim lane flowchart is an appropriate tool to use when: Question content area bottom Part 1…
A: Swimlanes are geometric objects that you may drag onto your design and arrange in any way. To design…
Q: 3. Each coffee table produced by Kevin Watson Designers nets the firm a profit of $9. Each…
A: Decision variables: Suppose-X = No. of coffee tables produced per weekY = No. of bookcases…
Q: The inner diameter of piston rings follows a normal distribution with mean 75mm and variance =9. The…
A: Given data: Mean = 75mmVariance =9The sample size is = 5. If an X-bar chart is established L =2,UCL…
Q: Sec 4.7 1. Consider the following problem. Maximize Z = x₁ + 2x₂, subject to x₁ + 3x₂ ≤ 8 (resource…
A: Given LP- Maximize Z = x1+2x2Subject to-x1+3x2≤8 (Resource 1)x1+x2≤4 (Resource 2)x1, x2≥0…
Q: Graph all constraints. Label each constraint line to identify which it represents. 1.What are the…
A: Note: - As we can answer only up to three subparts we will answer the first three here. If an answer…
Q: Determine: a) The cycle time in minutes; b) the minimum number of workstations for this contract; c)…
A: Project schedule helps in calculating different values all related to the production cycle like the…
Q: Define the concept of a percentage
A: Percentage us the number of ratio that represented in the form of fraction of 100. It is indicate…
Q: By assuming the business problem, Identify a business, social or environmental problem that has…
A: Here, in the question, I have identified a business problem which is related to operations…
Q: Consider the following all-integer linear program. Max 1x1 + 1x2 s.t. 5x1 + 7x2 ≤ 42…
A: MAX zx = x1 + x2 subject to 5 x1 + 7 x2 ≤ 42 x1 + 5 x2 ≤ 20 2 x1 +…
Q: Dave Fletcher was able to determine the activity times for constructing his laser scanning machine.…
A: Activity Immediate Predecessors Duration A - 5 B - 8 C A 2 D A 1 E B 3 F B 5 G…
Q: The Bayside Art Gallery is considering installing a video camera security system to reduce its…
A: Decision Variables: Suppose-xi be the 0-1 which is 1 if a camera is installed at opening i, and 0…
Q: Formulate but do not solve the problem. A manufacturer of women's blouses makes three types of…
A: Decision Variables:x, y, and z denote the amount of sleeveless, short-sleeve, and long-sleeve…
Q: Rent’R Cars is a multisite car rental company in Huntsville/Madison area. It is trying out a new…
A: Find the Given details below: Transportation table From To D E F G Supply A $…
Q: All claims of the same type are processed together. Is 40 hours enough capacity? If not, what…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Use the Big M method, work through the simplex method step by step to solve the following problem.…
A: The Big M technique is a modified version of the simplex approach used in linear programming (LP),…
Q: In the first week after Apple’s iTunes raised the price on its most popular songs from 99¢ to $1.29,…
A: The detailed solution is given in Step 2.
Q: a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1…
A: The exponential smoothing forecast can be seen as an extension of the simple moving average…
Q: Asia Furnishing is a retailer of modular toilet products. Currently, the lead time for one of the…
A: Lead time for 1st supplier = L1 = 5 weeks Average demand = d = 200 per week Std. Deviation of demand…
Q: For each of the following constraints, draw a separate graph to show the nonnegative solutions that…
A: The graph for subpart question A is shown below. As shown in the graph, (0,2) and (6,0) are the…
Q: What distinguishes the agile project management approach from the waterfall approach?
A: Both the Waterfall approach & the Agile approach are - identified by their project management…
Q: Mr. Stone has recently installed a vending machine outside a local supermarket to sell a new brand…
A: Replenishment rule = every P time period, order T-IP units. T (Target inventory level) = Average…
Q: In 2017, Aurecon was appointed by the City of Ekurhuleni to design and construct rail line…
A: In project management, a project constraint is anything that puts limits on the work that can be…
Q: TQM stresses three principles for achieving high levels of process performance and quality. Which of…
A: Error detection, reduction, or elimination are continual processes in total quality management…
Q: Suppose the due date of the project is 24 months and expected time of completion is 28 months, while…
A: Let, td=24 months te =28 months Probability of completion = 90% Probability can be calculated by…
Q: You are thinking about opening an oil change shop. Your fixed costs will be $14,500 per month. You…
A: Breakeven analysis is tool which helps to identify the minimum number of product required to…
Q: A Lady (L) bought an item of Rs 100 from the Shopkeeper (C). She paid him through a 500 Rs Note.…
A: Given scenario-A lady has given the shopkeeper (c) = Rs 500 (to return back Rs 100)Shopkeeper (c)…
Q: $7.17 Sroufe Manufacturing intends to increase capacity by overcoming a bottleneck operation by…
A: Given data is Fixed cost for proposal A = $50000 Fixed cost for proposal B = $70000 Variable cost…
Q: Discuss the main factors likely to be considered by a project manager when considering time– cost…
A: Time, cost, and quality are three important factors for any project and so it is necessary to…
Q: Sales of Cool-Man air conditioners have grown steadily during the past 5 years: Year 1 2 3 4 5 6 7 8…
A: Given data is
Q: 8.- The Donna Mosier clothing store has plants in three cities (W, Y and Z), which they distribute…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Is employee turnover good orbad for an organization?
A: Employee turnover is bad for the Organization. The total number of employees that leave a firm over…
Q: method is NOT helpful in developing Just-in-Time (JIT) production scheduling? O a Production…
A: Suppliers may make orders for raw materials that perfectly match production schedules using a…
Q: Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile…
A: Decision Variables:Suppose-x4 = No. of 4-cylinder connecting rods produced next weekx6 = No. of…
Q: Consider the following all-integer linear program. Max 1x1 + 1x2 s.t. 5x1 + 7x2 ≤ 42…
A: Linear programming, a mathematical technique used to help management decide how to make the most…
Q: X2= ______ (round your response to two decimal places).
A: The optimum point obtained in Step 3 of the previously solved question = (33.33, 33.33) where the X1…
Q: 1-What is the difference between qualitative forecasting techniques and quantitative forecasting…
A: Forecasting is the process of identifying trends in order to predict future outcomes. Forecasting is…
Q: he Apex Television Company has to decide on the number of 27- and 20-inch sets to be produced at one…
A:
Q: a. What is the actual average time for this task? b. What is the normal time for this task if the…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: a production company that sells two types of gasoline, G1 and G2, from two types of crude oil, C1…
A: Two types of gasoline are prepared from two types of crude oils. Hence, the decision variables must…
Q: Problem 7-12 (Algo) How many work cycles should be timed to estimate the average cycle time to…
A: Given that samples are = 4.1 , 4.6 , 5.1 , 4.9 , 5.9 , 4.4 Mean of all the above samples = (4.1 +…
Q: An operations manager is deciding on the level of automation for a new process. The fixed cost for…
A: Formula to be used : Break even point = Fixed cost / Contribution margin per unit
Q: Which of the following is a process consideration in the implementation of a lean system?…
A: A company or business unit is said to have a lean system if it applies lean concepts to all aspects…
Q: a. A loan processing operation that processes an average of 7 loans per day. The operation has a…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Which is the highest rated of the four European cities under consideration, using the table? Why…
A: The given case is related to location analysis where the vice president of a company has identified…
Q: The following table describes project XYZ Duration Predecessor Variance A 5 2 B 3…
A: Given data:
Q: A company incurs an ordering cost of $232 each time it places an order, regardless of the order…
A: The EOQ formula's objective is to determine the ideal quantity of product units to order. If…
Q: A coffee manufacturer blends four component coffee beans into three final blends of coffee. The…
A:
2. Calculate the exponential smoothing
|
Week |
Sales |
Forecast |
|
1 |
39 |
|
|
2 |
44 |
|
|
3 |
40 |
|
|
4 |
45 |
|
|
5 |
38 |
|
|
6 |
43 |
|
|
7 |
39 |
|
a. 41.63
b. 39.98
c. 40.54
d. 40.03
Instruction: This is consists of one (1) multiple choice question. The question requires deep analysis. Choose the appropriate response for the question. A detailed working out should accompany the responses.
Step by step
Solved in 2 steps with 3 images
- 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_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?
- 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_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. 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? Is it guaranteed to produce better forecasts for the future?
- A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with α = .1 would be the best method. Henry argued that the shop would get a better forecast with α = .3.a. Using F1 = 100 and the data from problem 3, which of the two managers is right?b. Graph the two forecasts and the original data using Excel. What does the graph reveal?c. Maybe forecast accuracy could be improved. Try additional values of α = .2, .4, and .5 to see if better accuracy is achieved.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 493
