Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, β= 0.3, and let the initial trend value be 12 and the initial forecast be 200. Period Actual Demand 1 200 2 212 3 214 4 222 5 236 6 221 7 240 8 244 9 250 10 266
Q: Discuss the stages of evaluation for a goods procurement highlighting some common criteria at each…
A: Evaluation:- A subject's validity, worth, and relevance are methodically assessed through the use of…
Q: Discuss a situation where constrained optimization is used?
A: Constrained optimization has long been recognized as a potent method for addressing a wide range of…
Q: Maggie Moylan Motorcycle Corp. uses kanbans to support its transmission assembly line. Determine the…
A: Given data: Setup cost (S) = $20 Annual holding cost of main shaft (H) = $400 per unit Daily…
Q: The LP model and output below represent a problem whose solution will tell a specialty retailer how…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: benefit of ultilising indoors space management
A: Space management is the practise of controlling & managing the various physical workspaces a…
Q: A B C D − 480 500 50 350 − 175 0 0 0 − 750 0 0 0 −…
A: Work centers is a common word used in operations management where people are employed for performing…
Q: Janelle Heinke, the owner of Ha'Peppas!, is considering a new oven in which to bake the firm's…
A: From the above given information, Break even for oven A = Fixed costs÷Selling price per unit-…
Q: Determine the reliability from the attached figure.
A: Reliability is the ability to perform consistently and trustworthly throughout the process.
Q: Assess the impact of economies of scale on project costs
A: Effect of economies of scale on project costs The term "economies of scale" refers to a cost…
Q: Question 10: Discuss a strategy which can be used for providing ongoing internal feedback on service…
A: Strategy: There are many strategies that are used in organizations for long-term…
Q: What is the value at the optimal solution?
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Rick Wing has a repetitive manufacturing plant producing automobile steering wheels. Use the…
A: The expenses spent to set up a machine for a production run are referred to as Setup costs. This…
Q: A new hospital is in the process of developing bylaws. Included in the document will be a…
A: Whether hospices are for-profit / non-profit, BODs must show a return on the investment for…
Q: Demand is Normally distributed with mean of 6 per week and a weekly variance of 11. The ordering…
A: Mean demand = 6 variance = 11 ordering cost = 40.29 shortage cost = 2.35 lead time = 2 service level…
Q: What is the Expected Value with Perfect Information?
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: locations while accounting for small local variations. Which strategy is your organization following…
A: Nowadays, globalization in combination with a greater degree of interconnections between persons…
Q: A car rental agency uses 96 boxes of staples a The boxes cost $4 each. It costs $10 to order…
A: Given, Annual demand, d =96 boxes Unit cost, u =$4 per box Ordering cost, o =$10 Carrying costs, h…
Q: Recognizing today's endless globalization and internalization, companies are required to improve…
A: Processes through which the demands of the customer are met remain of critical importance to any…
Q: Analytics Solution Implementation Process Flow: Identify Risks and Contingencies Identify Business…
A: Here are the following matches provided for every part given in the question: Identify risks and…
Q: Experience the Tour de France (ETF) is a specialty travel agent. It arranges vacations for amateur…
A: Given data: Number of servers m= 5 Service time = 25 minutes Standard Deviation of service time =…
Q: Assume you are the manager of Assembly Inc., you have just received an order for 40 units of an…
A: Net requirements = Gross requirements - (Beginnning inventory + current period Scheduled receipts)…
Q: Create a line graph for this set of monthly sales numbers. Run a regression analysis. What is…
A: Given data, For the above table data, we would construct a line graph, we would also run the…
Q: C&A Printing takes 10 seconds to print a page in color, but after 500 pages, the printer must be…
A: Find the given details below: Given details: Time taken for a page 10 Sec Waiting time 15…
Q: Subject: Logistic Management Q#6) What is Porters Power Model explain with example?
A: There are two different questions, as per the guideline, the first question is taken to answer, The…
Q: Use the technique developed in this section to solve the minimization problem. Minimize C = 10x + y…
A: Objective Functions: Minimize C= 10 x+ y Constraints: Subject to- 4x+y≥24 (Constraint 1)…
Q: 1. In deciding on where to locate their next grocery store, Publix narrowed it down to 3 locations…
A: Find the given details below: Given details: Criteria Weight Locations St. Augustine JAX…
Q: 1
A:
Q: The mythical Own Distributors has an annual demand of 2,000 units for its handheld security wands.…
A: Given data Annual demand (D) = 2000 units Average cost of handled security wand = $140 Holding or…
Q: An overhead crane of ABC Ltd. moves jobs from one machine to another and must be used every time a…
A: From the above information, Arrival rate, λ =60 ÷24 =2.5 calls every hour Service rate, μ=60÷8 =7.5…
Q: The pull/push view in a supply chain advocates that: ( ) The processes in a supply chain are…
A: In a push based supply chain, the production and distribution decisions are purely based on long…
Q: What are some of the approaches of positioning products and services ?
A: Positioning: A product that is well-positioned stands out from the competition and convinces…
Q: QUESTION 2 a) b) Ferrero Candy Company makes three types of candy, which are solid, fruit and cream-…
A: Note: - As both the questions are not related to each other, we will answer the first question here.…
Q: Determine the total inventory-related costs associated with the optimal ordering policy (do not…
A: Given data Annual demand (D) =5 tonnes × 12 converters ×360 days per year =21600 tons per years…
Q: Sleek Sdn. Bhd. is planning on introducing 2 new stool designs (Deni & Arni) for their 2022…
A:
Q: Explain in your own words at least 3 important reasons why need to study Productions and Operations…
A: Operations management can be broadly defined as an approach the involves the understanding of nature…
Q: Identify strategic control principles and evaluate them using appropriate case studies and relevant…
A: Strategic control can be broadly defined as the methodology in order to manage the proper execution…
Q: If “Availability Rate “ is 80 % , “Performance Rate” is 70 % and “Quality Rate” is 80 %,then what is…
A: Overall equipment effectiveness (OEE) can be broadly defined as a key performance indicator that…
Q: A real estate investor has the opportunity to purchase land currently zoned residential. If the…
A:
Q: A major benefit of contingency planning is for a strategic leader and/or manager to be in a position…
A: A contingency plan can be stated as the course of action or approach framed or designed to help a…
Q: Subject: Logistic Management Q1): What is logistic and what is difference between supply chain…
A: Supply chain management is based on the management of the flow of products & services between…
Q: What is JIT (Just in time) in logistic managemet & its pre-requisite explain with examples?
A: There are two different questions, as per the guideline, the first question is taken to answer,…
Q: a) The cycle time for the production of a PDA = enter your response here
A: Project schedule helps in calculating different values all related to the production cycle like the…
Q: A manufacturer produces two types of fruit juice for filling and distributing, the X-S fruit juice…
A: Given data is Type of fruit juice Cost Processing time Testing time Material required X-S $375…
Q: Determine if project management software might help you better manage project costs.
A: Project management software is a computer tool that is used to plan, manage, and control several…
Q: The economic purchase lot is an important tool for companies that want to minimize the total cost of…
A: Economic purchase lot or economic order quantity is a mathematical concept used in operations to…
Q: Nasrin drinks a Cappuccino from Kashundi before attending her MGT 314 class every RA morning. Today,…
A: Queuing theory manages the difficulties that implicate queuing (or waiting). The Queuing theory…
Q: A company operates 8 hours per shift, two shifts per day, five days a week with 12 hours maintenance…
A: Operating hour(h) = 8 Number of per day shift(s) = 2 Days per week (d) = 5 Maintenance hour(M) = 12…
Q: 1. Cathy is launching a new model of their cars, It is known as the Cathy model X. Their production…
A: Facility layout is an array of distinct factors of manufacturing in an applicable manner to reach…
Q: Explain the statement. Manufacturers locate near their resources, retailers locate near their…
A: Proximity to the market stay as an important criterion in selecting a particular location for the…
Q: Many have claimed that outsourcing by American companies is costing American jobs. However,…
A: Outsourcing can be stated as the approach of recruiting or hiring a third party to provide products…
Use exponential smoothing with trend adjustment to
|
Period |
Actual Demand |
|
1 |
200 |
|
2 |
212 |
|
3 |
214 |
|
4 |
222 |
|
5 |
236 |
|
6 |
221 |
|
7 |
240 |
|
8 |
244 |
|
9 |
250 |
|
10 |
266 |
Step by step
Solved in 4 steps
- 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.Under what conditions might a firm use multiple forecasting methods?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_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 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_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_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?Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.
