Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average and exponential smoothing methods to forecast the demand for Week 17. Assume the following: Simple moving average method: two-week moving average Single exponential smoothing method: assume the 1st week forecast is 333 and α=0.65. Include the MSE, MAD and MAPE in your calculations. Based on your results, recommend which method should be used and give reasons to support your recommendation. Week Demand (Number of calls) 1 300 2 360 3 410 4 289 5 279 6 302 7 376 8 329 9 248 10 322 11 503 12 511 13 399 14 402 15 380 16 469
Q: 5. Construct an activity-on-arrow precedence diagram for each of the following cases. Note that each…
A: The project network is the visual representation of the project activities and their durations to…
Q: What is meant by bounded rationality and its relevance to the decision making in the organisation
A: To be determined: What is meant by bounded rationality and its relevance to the decision-making in…
Q: QUESTION 15 Sustainability in the supply chain can be improved by picking high return projects…
A: 15) Supply chain sustainability would refer to the efforts and the procedures deployed by the…
Q: The $5 T-shirt is readily available today, and it's existence has profound implications for the type…
A: A business-level strategy is described as a strategy that includes the incorporation of the…
Q: Why should there be a minimum and maximum level of raw material maintained at the warehouse
A: Warehouse is not just limited to storing of materials. There are other process happening in the…
Q: A production assembly line of 7 seven activities designed to produce 120 units per hour and you have…
A: A line balancing is a process which helps to allot the right activities to the right workstation…
Q: Why financial planning should always be anchored to the company's vision and mission?
A: A financial planning is important in every small or large businesses . It helps to achieve…
Q: A. When the required labor skill is high, it is generally best to pursue which aggregate planning…
A: Chase's strategy is to match the demand as per the capacity as per the period. This may result in…
Q: A company has an annual demand for a product of 2000 units, a carrying cost of $20 per unit per…
A:
Q: eed asap... please Is there a significant relationship between unemployment and SNAP Benefits in…
A: SNAP is a Supplemental Nutrition Assistance Program in USA where Millions of Americans have…
Q: What is The impact of the Corona pandemic on Petroleum Development Oman Company?
A: Petroleum Development Oman (PDO) is joint venture of government of Oman, Royal Dutch Shell, Total,…
Q: why acceptance sampling is the basis for statistical control of the quality management process.…
A: Quality control is the process of maintaining and improving the quality of the products and services…
Q: The national Safety Council (NSC) estimates that off-the-job accidents cost U.S. businesses almost…
A: Given, Number of employees that average the off-the-job accidents per year = 3 So, Expected number…
Q: How the Supply Chain Manager is making a difference in today’s global markets? What are the pros and…
A: Global supply chain management is described as the process of distribution of commercial goods and…
Q: Describe the importance of demand forecasting for effective logistics management
A: Logistics management is the management in which the procurement and movement of raw materials and…
Q: Determine the most advantageous assignment of broker to a district
A: There are two types of assignment problems: minimization and maximization. The minimization problem…
Q: Explain Modern Dynamic Concept of Productivity
A: Productivity refers to the physical relationship between the output i.e quantity produced or use of…
Q: Given the following network, with activity times in months, determine the earliest and latest activ…
A: A network diagram is a visual representation of a project which helps to identify critical paths and…
Q: Lean Six Sigma is used for facilitating the improvement processes in manufacturing operations,…
A: Lean Six Sigma is a combined Lean and Six Sigma management philosophy. Six Sigma focuses on…
Q: Research with cross-functional sourcing teams revealed that teams that included suppliers as active…
A: Concept Introduction Supplier are considered to an important stakeholder for a company. They act as…
Q: Consider the data below which includes sales data and the forecasts that would have been made using…
A: Given data is
Q: 1.)Consider a four-component system of which the components are independent and identically…
A: MTTF is the mean time to failure which state the average time of running a part before its breakage.
Q: Answer the following questions in short: Define the following terms: • Operations Management • Goods…
A: Operations are the outcome of managing the internal workings of the company so it operates as…
Q: What are the three factors to consider while selecting an internet package?
A: Internet has become the necessity of everyday life. However, every individual or household has a…
Q: What are examples of single stories that you have experienced? What are examples of single stories…
A: Single stories are one sided view on something or someone. It is not right view, but it is popular…
Q: Brendan and Maeve were considered about the reliability of some of their kitchen staff. They…
A: Work schedule refers to days per week, hours per day an employee should work. Work schedule is all…
Q: How does your organization support and design processes for effective teamwork
A: Team building in an organization involves a various activities which are designed for improving the…
Q: ANT Infra orders two kinds of precast items: A and B for use in its projects from two different…
A: Q system EOQ = sqrt(2DS/H) Annual holding cost = (EOQ/2)xH Annual ordering cost = (D/EOQ)xS…
Q: Frito-Lay, the multi-billion-dollar snack f0od giant, produces billions of pounds of product every…
A: Given: The upper and lower control limits for one checkpoint, salt content in Lay's chips is 2.22%…
Q: What are the advantages and disadvantages of Frito-Lay drivers stocking their customers' shelves?
A: Quality management is all about managing the quality of the products or services so that good…
Q: Which of the following are the main parts of a linear programming? maximization and minimization…
A: Linear programming is a mathematical approach for determining the best feasible result or solution…
Q: a. Predict the sales for Jasmine Slush using the following forecasting methods: - naïve (use simple…
A: Forecasting is to predict the uncertain future of demand and sales. There are various methods to do…
Q: 10IVE VI ES BEL C XXXX XXXXX0X18a baiv 130A DVIENITME ISYOLSOS Tstotdu2 101 Diecoru Xsl AMOHA JHO…
A: A level plan means same production every period. The optimal production level is determined by…
Q: Why is one of the first narrative films, The Birth of a Nation, both celebrated and vilified by film…
A: The Birth of a Nation is released in 1915, was a silent film that become was the first blockbuster…
Q: ABC Industry operates 6 days a week. There are two 8-hours shifts each day, with a half-hour break…
A: Takt time is described as the rate at which one needs to complete the manufacture of a product to…
Q: Brendan Quinlan and Maeve Lynch are a couple. They decided to open an Irish restaurant in Changchun,…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: What are the advantages and disadvantages of Frito-Lay drivers stocking their customers' shelves?
A: Quality control is the process of reviewing the all the features of the products or services…
Q: 1. Define Micromotion study 2. Give at least five (5) advantages of Micro motion study 3. Give at…
A: Note- Hi! Thank you for the question, As per the honour code, we are allowed to answer three…
Q: c) ZANJI Ltd does heat-treating jobs for customers. The company wants decide the job sequence for…
A: Find the Given details below: Given details: Jobs That Follow Jobs that Precede A B C D E A…
Q: Michelle Go began employment with Luxor tours Company when shewas hired as probationary employee as…
A: Human resource management is described as a process through which employees are trained,…
Q: a) What are the critical activities?
A: The expected activity time is the time taken by the particular activity to complete the project…
Q: Samsung implements a Continuous Inventory System for an electronic component. The inventory manager…
A: A safety stock item is a product that is held in excess amount in the warehouse to avoid running out…
Q: On October 25 2015, one Euro traded for 1.106 US dollars, and thus one Us dollar traded for 0.942…
A: Globalization is described as the connectedness of the technology and trade that have made the world…
Q: How can a company ensure that its supply chain is resilient to unexpected events?
A: Unexpected events refers to the events which arises due to uncertainities which may have greater…
Q: EWMA? What does it mean if the CUSUM didn't detect any shifts in mean but the EWMA did?
A: The CUSUM and exponentially weighted moving averages may be used in place of the Xbar image if…
Q: Under what circumstances might an employer need to maintain an OSHA injury/illness log for persons…
A: OSHA is occupational health and safety act developed by the government and it is implemented in…
Q: topic: bakery store draw a sample floorplan and label all the necessary components needed in this…
A: A bakery is a company that bakes and sells flour-based items such bread, cookies, cakes, pastries,…
Q: Think of an industry or company other than automotive that relies heavily on forecasting accuracy.…
A: Forecasting is completely based on past data, unlike predictions that are based on instinct, or…
Q: Brendan Quinlan and Maeve Lynch are a couple. They decided to open an Irish restaurant in Changchun,…
A: max 16 BM + 12 FM subject to BM + FM <= 60 meals 30 BM + 15 FM <= 20 x 60 minutes…
Q: What is your overall evaluation of the potential for Jordano Foods in this new relationship with…
A: Jordano has a solid potential for development with this new relationship with SAB, any progression…
Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average and exponential smoothing methods to
Assume the following:
Simple moving average method: two-week moving average
Single exponential smoothing method: assume the 1st week forecast is 333 and α=0.65.
Include the MSE, MAD and MAPE in your calculations. Based on your results, recommend which method should be used and give reasons to support your recommendation.
Week | Demand (Number of calls) |
1 | 300 |
2 | 360 |
3 | 410 |
4 | 289 |
5 | 279 |
6 | 302 |
7 | 376 |
8 | 329 |
9 | 248 |
10 | 322 |
11 | 503 |
12 | 511 |
13 | 399 |
14 | 402 |
15 | 380 |
16 | 469 |
Step by step
Solved in 4 steps with 4 images
- Under what conditions might a firm use multiple forecasting methods?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?
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?
- The following data shows sales forecast of Axis Dealer for motorbikes. Month Demand 1 650 2 700 3 810 4 800 900 700 i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? ii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1. Show the formula and working method when necessary.Explain what are the benefits of exponential smoothing over moving average forecasting ?Forecasting Historical records show the past ten Hood Lacrosse games having the following attendance:5348, 7814, 6515, 5785, 5984, 6522, 6286, 5581, 6714, 7347Assuming no seasonal component, what should the concessions staff use as an estimate for thenext game? Please use a four-period moving average for this forecast. please use excel for solving
- The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 2 6 7 10 3 4 5 6 7 8 9 a. Calculate the single exponential smoothing forecast for these data using an a of 30 and an initial forecast (F of 31. (Round your answers to 2 decimal places) Month 50 Month 31 4 5 6 7 b. Calculate the exponential smoothing with trend forecast for these data using and of 0:30, a 5 of 0.30, an initial trend forecast (Tof 1, and an initial exponentially smoothed forecast (F3 of 30. (Round your answers to 2 decimal places) B 9 Exponential Smoothing 10 31 34 33 35 FITI 37 36 38 40 40 41 e-2. Which is best? c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts (Round your answers to 2 decimal places) MAD Single exponential smoothing forecast Exponential amoothing with trend forecast Single exponential smoothing forecast O Exponential smoothing with trend forecastPrepare a forecast for period 6 using each of the following approaches: Period 1 2 3 4 5 Demand 60 65 55 58 64 A three-period moving average. A weighted average using weights of .50 (most recent), .20 and .30. Exponential smoothing with a smoothing constant of .40.Apply the moving average with base m=4 forecasting technique of the data to estimate the demand in week 13.