For the data set Download data set, perform exponential smoothing with alpha = 0.1 to determine the forecast for week 20 (click on the arrow to download the file). Be sure to label the forecasted value for week 20.
Q: Construct this problem. Draw a network diagram, determine the early start, early finish, late start,…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: A petrol station in the capital Kingstown has a single pump manned by one attendant. Vehicles arrive…
A: Find the Calculation methods below: Probability of no customers in the system: ρ0 = 1[∑n = 0n =…
Q: Briefly elaborate the importance of Quality Assurance department for the national and international…
A: Quality assurance is an important part of the organization. Accreditation is the process of…
Q: 6. The Childfair Company has three plants producing child push chairs that are to be shipped to four…
A:
Q: Need help please show formula how to solve please. Thanks A newly formed company must decide on a…
A: Choosing the best location based on the expected profit is the most suitable solution for given…
Q: Given the following due dates and processing times (in days) for 3 jobs. Each job must go through 3…
A: Job sequencing is the process of assigning jobs to people or machines in the most efficient way.…
Q: The results of inspection of DNA samples taken over the past 10 days are given below. Sample size is…
A: Find the Calculation methods below: Fraction Defectives (p) = Number of Defectives (np)Sample Size…
Q: Sells 360,000 tennis balls per year. The tennis balls cost Dennis Sport World RM15 per dozen. Annual…
A: As per our policy, we are supposed to answer only three sub-parts if multiples sub-parts are asked.…
Q: why organizations maintain raw material inventory
A: Companies that produce things for a profit must endeavor to ensure effective raw material management…
Q: What is the mean arrival rate in jobs per hour? (Round your answer to four decimal places.) per hour…
A: Note: We are allowed to do the first three sub-parts only. The queueing theory is a branch of…
Q: Can we use CPFR in SMEs?
A: CPFR stands for Collaborative Planning Forecasting and Replenishment. Participants in a supply chain…
Q: Solve the following linear programming problem using simplex method. A diet for a sick person must…
A: Let Food A = x1 and Food B = x2
Q: onstraints and apply each to a simulation/assumption of a constraint impacting Jag
A: The idea of constraints is a technique for figuring out what's preventing your project from moving…
Q: Why International Supply Chains are much more complex than simple domestic supply chains? List four…
A: International Supply are more complex than domestic supply chains because the risks of domestic…
Q: Table 4.1 shows his list of the various activities needed for replacing an existing boiler with an…
A: Path with the longest duration is the critical path. Activities which have 0 slack value denotes the…
Q: “To cut the number of projects, the steering committee used a weighting scheme that reflected the…
A: Weighted score model is a mdoel which helps to compare different options based on certain score…
Q: Dundas Bike Components Inc. of Wheelville, Illinois, manufactures bicycle wheels in two different…
A: a. It will be possoible for David to develop just one aggregate plan if time taken on both the…
Q: a) b) c) Draw a Gantt chart from the above information Name all the paths available in the Gantt…
A: A network diagram related to the project shows the sequence of the task that is performed to…
Q: Given an actual demand this period of 100, a forecast value for this period of 110, and an alpha of…
A: Given: Actual demand (A) = 100 Forecasted demand (F) = 110 Alpha (a) = 0.84
Q: ) Max Z = 2X1 + 3X2 Sub to X1 + 2X2 ≥ 50 10X1 + 20X2 ≤ 175 And X1, X2 ≥ 0 (SOLVE MANUALLY…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Failures in social responsibility of the mining companies and its implications
A: The mining sector has historically operated in places devoid of social legitimacy, wreaking…
Q: Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in…
A: i) Total Cost (Location A) = 60000+30x Total Cost (Location B) = 80000+20x Total Cost (Location C) =…
Q: QUESTION 1 The table below shows the sales figures for a brand of shoe over the last 12 months.…
A: *As per guidelines of multiple questions, the first one is answerable, repost the remaining…
Q: A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of…
A: Given, Quantity ( stones ) Price <400 $9.4 400 to 599 $8.9 >= 600 $8.5 Operating…
Q: Colonial Furniture produces hand-crafted colonial style furniture. Plans are now being made for the…
A: Based on the given question, the following model can be built in excel. The model will be as…
Q: Which of these statements about reverse logistics is best? O Reverse logistics systems are usually…
A: Reverse Logistics: Reverse Logistics is defined as products are travel from one…
Q: b) What percentage improvement is needed in a sales strategy for profit to improve to $40,800? What…
A: Profit = Sales - Cost of supply chain purchases - Other Production costs - Fixed Costs Given, Profit…
Q: What would be the product life cycle of iphone 6s in operation managent
A: The term Product Life Cycle usually refers to the various kinds of phases or levels that a…
Q: What are the importance of Quality control department for the national and international…
A: The quality control department is the one who is responsible for the quality of products and…
Q: b. The following table shows the number of televisions sold over the last ten years at a local…
A: First we need to arrange the given data and arrange extra calculation columns: Year (x) Sales (y)…
Q: Develop a simple application of two- variable linear programming problem to find an optimal product…
A:
Q: Compute the labor time required to produce 8 and 16 units. b. Assume that labor time costs $125 per…
A: In operations management, the learning rate is used to measure the efficiency of inventory…
Q: there are numerous methods of gathering evidence of a students or candidates performance ,…
A: Performance is the act of establishing an output/outcome by utilizing the power of all available and…
Q: a) What is the economic order quantity? 306 units (round your response to the nearest whole number).…
A: EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…
Q: In 2017, Aurecon was appointed by the City of Ekurhuleni to design and construct rail line…
A: Project: Project is defined as “A project is an activity to meet the creation of a unique product or…
Q: What kind of effects does it have on availability as the mean time between failures (MTTR) becomes…
A: The availability of a system is the percentage of time that the system is operational. MTTR is the…
Q: Projects are different from operations, state any Five (5) project attributes.
A: Projects are one of the most important aspects of any organization. They are temporary, and they…
Q: Should tipping in restaurants be mandatory?
A: In the United States, almost every restaurant expects a tip after a meal, despite the fact that it…
Q: The table shows the values found in the error analysis. What method of forecasting would be best to…
A: Here, given the data stated below For each method, I have been given the MSE value and forecast…
Q: Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all…
A: Slope (b) =(n∑xy-∑ x∑y)/(n∑x 2-(∑ x)2) Intercept (a)=(∑ y-b∑ x)/n trend equation y = a+bx
Q: K Southeastern Bell stocks a certain switch connector at its central warehouse for supplying field…
A: Economic order quantity is essential for businesses for buying and holding inventory for productiin…
Q: Pivot Charts support nearly all of the Excel chart types. O True O False
A: Pivot chart in excel A pivot chart is an in-built tool in Excel that is used for data presentation…
Q: Potatoes are sliced into thin sections and fried to take up a lot more space. The industrial process…
A: Value addition means adding value to the product/service being offered to the customers. For…
Q: South Beach University is conducting an online exam. There are 1,200 students taking this exam.…
A: Little’s Law: Little’s Law is defined as the long-term average number of customers…
Q: Your startup company is considering manufacturing 5,000 units annually of a simple but important…
A: Given, Annual production = 5000 units Own system: Fixed Cost = $1000 Variable cost = $1.5…
Q: Parking tickets will be issued to any vehicles without parking permit on campus. The parking office…
A: Find the Calculation methods below: Given details: Day Sample size(No.of Vehicles)(n) Number of…
Q: You are employed as a quality manager at Mr Price in Durban. Critically analyse how you would…
A: Total quality management (TQM) is a method of management that focuses on long-term success through…
Q: Max Z = 6X1 + 18X2+20X3 Sub to X1 + X2 +X3 = 60 10X1 +15X2 +20X3 = 900 2X1 + 3X2 +3X3≤100…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Which of the measure(s) of central location can be used for both numerical and categorical…
A: The value that appears the most frequently in a data collection when it is unique is known as the…
Q: 6. The defect rate for your product has historically been about 4.50%. For a sample size of 500,…
A: Given data Defect rate P = 4.50 %=4.50100 = 0.045Sample size (n) = 500
For the data set Download data set, perform exponential smoothing with alpha = 0.1 to determine the
Gasoline data set | |
week | Sales (1000s of gallons) |
1 | 17 |
2 | 21 |
3 | 19 |
4 | 23 |
5 | 18 |
6 | 16 |
7 | 20 |
8 | 18 |
9 | 22 |
10 | 20 |
11 | 15 |
12 | 22 |
13 | 31 |
14 | 34 |
15 | 31 |
16 | 33 |
17 | 28 |
18 | 32 |
19 | 30 |
Trending now
This is a popular solution!
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 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 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 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_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?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?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?
- Under what conditions might a firm use multiple forecasting methods?The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. 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. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?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?