After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units. Use a = .5 and 3 = .4, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10. Period 1 2 3 4 5 Actual 210 224 229 240 255 Period 6 7 8 9 10 Actual 265 272 285 294
Q: 1. Simulate a 12-day inventory management scenario, assuming that there is an outstanding order of 6…
A: Given a) 12 days simulation:- Formulas:-
Q: Subject: Procurement & Sourcing Q): How contract is establish? Q) What are the main terms of…
A: The fact that sourcing must be completed before any procurement can begin is one of the critical…
Q: a) Which station is the bottleneck? (b) What is the process capacity in units per day (round to the…
A: Given Calculations:- Formulas Used:-
Q: 6-19 Work-in-Process Inventory, June 1 ? Work-in-Process Inventory, June 30 55,000 gallons Units…
A: Given- Work in process inventory, June 30 = 55,000 gallonsUnits started during June= 75,000…
Q: In an FMEA, we determined Severity, Occurrence and Detection numbers for two types of failure, as…
A: In an FMEA, we could see that there are two types of failure- Missed deposits and Billing errors,…
Q: The System Development Life Cycle consists of these stages: Sequentially Repeatedly applying the…
A: The System Development Life Cycle (SDLC) is a series of stages that are used to guide the…
Q: help. VOCABULARY LIST ordinary amorously concise dismiss below. Use each word once. The to help you…
A: 1. in a manner filled with love : amorously 2. to send away : dismiss 3. pertaining to the everyday…
Q: Which of the following is a common strategy to reduce taxes for business founders? Form partnerships…
A: A sole proprietorship is a type of business entity which is owned by a single individual unlike a…
Q: What precisely is the purpose of doing a technical analysis? Explain not just how and why it is used…
A: Meaning of Technical Analysis Technical analysis is a device or technique, used to foresee the…
Q: A project consists of seven activities. The following table shows the estimated time of the…
A: By identifying the actions that are essential to the project schedule, the critical route technique…
Q: A company makes 110-inch wide rolls of thin sheet metal and slices them in smaller rolls of 12, 15,…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Discuss the role of the Literature Review in a scholarly article. What is it? Why are writing…
A: The literature review in a scholarly article serves as a comprehensive overview of previous research…
Q: how is a time series module and a causal model used in a business?
A: Time series module is used to measure, analyze and forecast patterns in data. It is used for changes…
Q: a) b) c) State the two (2) shopping habits of the Mexicans that were different. Explain how Walmart…
A: a) The two shopping habits of Mexicans that were different from the United States are: Most people…
Q: TUTORIAL I DECISION ANALYSIS 1. Even though independent gasoline stations have been having a…
A: Note: - Since the exact question that has to be answered is not specified we will answer the first…
Q: Risks associated with managing IT projects, top ten?
A: An IT project often involves computer technology, information systems, or IT infrastructure. Web…
Q: Do you agree that the Internet has affected consumer and supplier relationship? Discuss how…
A: The supplier is responsible for giving the quality that will satisfy the customer and submitting…
Q: Introduction The Protective Equipment Company (PEC) is a medium-sized enterprise in the private…
A: (a) Three different sourcing approaches that could be used by the purchaser at PEC to all the more…
Q: In project management describe FIVE techniques for estimating project activities in situations of…
A: Estimating a project is challenging. Because one can really truly figure out what lengthy a job…
Q: 1) How can lean for the new car to reduce waste on the assembly line? manufacturing be incorporated…
A: As per this question, I would describe the processes that could be performed to implement lean…
Q: Supplier XYZ is a reputable organization which plays a crucial role in the manufacturing of a…
A: Productivity is a trick all term portraying the measures of work done in an organization, whether by…
Q: Company Z has the following historical sales information for one of its hydraulic pump models for…
A: Answer: Given Data : Company Z has the following historical sales information for one of its…
Q: Consider the following: Activity ABCO с Normal time D 4 9 4 A E с What is the project's completion…
A: The PERT approach states that a project's completion time is normally distributed, with something…
Q: Based on 3.10 problem 3: James Beerd bakes cheese cakes and Black Forest cakes. During any month he…
A: Decision variables: Suppose-xij be the number of cakes (i) produced in the month (j), where i = 1,2…
Q: In a harbour, there are 2 landing places. Ships arrive at a rate of 8 per day (exponentially…
A: A) Calculate the average queue length for the current system
Q: Increasing the order size and reducing the ordering frequency can _____ the total fixed ordering…
A: Companies determine their optimal order size by performing a calculation known as the economic order…
Q: What is time management? What are some ways to manage time? Why is time management important. Please…
A: Here, as per this question, I would discuss the concept of time management, I would also include…
Q: Embassy Motorcycles (EM) manufactures two lightweight motorcycles designed for easy handling and…
A: Given, Let the Ez rider model be E and sports model be L Profit is 2400 for E and 1800 for L…
Q: Which of the following is NOT a valid purpose for managerial communication? Group of answer choices…
A: Managerial communication alludes to cooperation among managers and their subordinates inside an…
Q: On December 31, 2019, the unadjusted trial balance of Tarzwell Services showed the following…
A: Date Account Titles & Explanation Debit ($) Credit ($) December 31,2019…
Q: A production process at Kenneth Day Manufacturing is shown in the figure. The drilling operation…
A: Given- The capacity of the sawing station is 2.4 units per hourThe capacity of the sanding station…
Q: If a very talented Software Engineer on your team keeps questioning your decisions, what would you…
A: Introduction- Generally questioning authority turns into an issue when there is a character struggle…
Q: Housing type Flat Two-bedroom house Three-bedroom house Shop Average number of inhabitants Ground…
A: Defining variables : Let a number of flats, two-bedroom houses, three-bedroom houses and shops in…
Q: Kuantan ATV, Inc. assembles five different models of all-terrain vehicles (ATVs) from various…
A: The supplier with lowest cost will be chosen. The value might change wrt the number of days…
Q: Formulate an LP in general form to determine the amount to be sold and bought each day to maximize…
A: The LP formulation to maximize total profit for the warehouse problem is as follows: Maximize: Z =…
Q: Consider your current organization or an organization with which you were once affiliated. Is there…
A: Change management is an essential part of the organization and as every organization needs change,…
Q: What is the importance of resources schedule in project management? Explain with one specific…
A: Resource scheduling is a vital stage of project management for sure. At the point when resource…
Q: Define agency law and explain how agency by ratification can it arise?
A: Agency law refers to the legal relationship between a principal and an agent, where the agent acts…
Q: For the given data, the R = enter your response here inches (round your response to four…
A: Given-
Q: he producers at Real Play Theatre believe it’s never too early to start teaching kids about the…
A: Student Name : The Characters :
Q: Comparing two threads inside the same process to two distinct processes. What is the optimal course…
A: The optimal course of action depends on the specific circumstances and objectives of the system. If…
Q: Lower Control Limit (LCLx) = enter your response here inches (round your response to three…
A: As found in the previous part of the question, X¯= 3.027916667 R = 1.025416667 A2 = 0.729 , D3 = 0…
Q: A _____ must be achieved to fulfill a company’s mission. a. critical success factor b. vision…
A: NOTE: We are allowed to do one question only at a time. A company's mission defines the purpose of…
Q: a) Design a reorder point system using the 99% probability of being in stock and (i) state the…
A: Since there are more than 10 questions, we will answer only first 3. For others please submit as…
Q: Supplier Evatuation and selection. Explain supplier evaluation and selection and how it is used in…
A: *As per the question, not specified any industry, giving general solution.Companies operate supplier…
Q: At Quick Car Wash, the wash process is advertised to take less than 7 minutes. Consequently,…
A: Formulae used: Control limit of the X bar: UCLx = X-double bar + A2×R bar LCLx = X-double bar -…
Q: Six new staff have been appointed by ABC store as sales people. Below is a table showing the number…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: what are the similarities of a research proposal and a research report?
A: The document created by the researcher to explain the study program in any project is known as a…
Q: There are several decisions that influence the design of global supply chain. Define global supply…
A: A process chain that begins with sourcing raw materials and ends with delivering the final product…
Q: Separate the major players in AWS's global infrastructure from the minor players.
A: AWS (Amazon Web Services) is a cloud computing platform that is made up of a global network of data…
After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units. Use α = .5 and β = .4, and TAF of 250 for period 5. Obtain
See the screen shot and help me create this forecast.
Period | Actual |
1 | 210 |
2 | 224 |
3 | 229 |
4 | 240 |
5 | 255 |
6 | 265 |
7 | 272 |
8 | 285 |
9 | 294 |
10 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
I came up with a different answer. I cannot see where we have differences except I don't understand why you have T1's which are different.
- 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_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_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_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 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?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.
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.