mpute the mean absolute deviation (MAD) via Excel and/or POM-QM. b.In the Bayside Fountain Hotel problem, compute an adjusted exponentially smoothed forecast with α = .20 and β = .20. According to the result from Excel and/or POM-QM, the forecast for the year 10 would be c.In the Bayside Fountain Hotel problem, for the adjusted
Q: QUESTION 3 Given the following inventory information, construct an (a) ABC analysis by annual dollar…
A: ABC analysis, also known as ABC classification, is a strategic inventory management technique that…
Q: how to balance this using shortesr-time operation rule? and their efficiency too . Im not too sure…
A: STEP :1 GIVEN DATA NO OF TASKS =30NETWORK DIAGRAM IS DRAWN ACCORDING TO ACTIVITY ON…
Q: In-house training programs are learning opportunities developed by the organization in which they…
A: One of the most important steps in making sure new hires succeed and fit in with the operations and…
Q: Given the Chart 1 below showing the relationship between Crude Oil Price (Dollars per Barrel) and…
A: Let me state the given trendline model, Here, I will determine the resulting increase in diesel…
Q: i. ii. iii. iv. Calculate the slope for the regression line. (show all working) Calculate the…
A: StoreAdvertising (X)Sales (y)114621133155416552415628187221782112926151043201134141295Here…
Q: whole number
A:
Q: The Springfield School Board has made the decision to close one of its middle schools (sixth,…
A: Find the given details below:
Q: Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the…
A: Holt-Winter’s additive method is a forecasting technique that considers both trend and seasonality.…
Q: ohn Elkington coined the term “Triple Bottom Line”. This concept focused on 3Ps of organizational…
A: The concept of the "Triple Bottom Line" (TBL) was introduced by John Elkington in 1994. The TBL…
Q: Which Special Group has less supervision but needs to be motivated to make sales with many…
A: The question is asking to identify the group among the given options that typically operates with…
Q: Prepare a managerial report that addresses the following issues and recommends an order quantity for…
A: Selling price = $24Cost = $16Salvage value = $5
Q: A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual…
A: Find the given details below: Processing time per unitProductAnnual…
Q: QUESTION FOUR Solve the problems below: a) Minimize Z = X1 - 2X2-3X3 s.t -2X1 + X2 + 3X3 2X1 +3X2 +…
A: I have solved the problem using Excel and Here are the Excel formulas:Now go to DATA TAB in Excel…
Q: The reorder point is defined as the lead-time demand for an item. In cases of long lead times, the…
A:
Q: Create a cause-and-effect diagram (fishbone diagram) to identify the potential root cause(s) of…
A: The fishbone diagram, also known as the Ishikawa diagram, is a structured problem-solving technique…
Q: Examine using practical examples what must be considered from the client's perspective for…
A: Supply chain integration implies bringing together entities in the supply chain, especially through…
Q: With reference to the table below, determine the activities that are on the critical path and the…
A: A network diagram shows the link of each task with the duration taken by each activity with respect…
Q: previous evidence of using percentage artificial intelligence in performance appraisal in IT sector…
A: Performance appraisal refers to a methodical and formal approach aiming at the assessment of an…
Q: Your current LIS system will no longer be supported by the company, and you have to select a new…
A: LIS is known as Laboratory Information System. It is a software-based system that is helpful in…
Q: Solve the following transportation problem using Excel. Factory A E K Demand B 6 5 8 35 Warehouse C…
A: The transportation problem is stated below:
Q: Answer 3.17,3.18,3.19,3.20 and 3.29. Construct both xbar chart and R chart for each problem
A: A control chart, also known as a Shewhart chart or process-behavior chart, is a statistical tool…
Q: According to the article: “The extensive upgrades included building an on-site Stamping Plant, a…
A: Manufacturing process strategies include purposeful approaches and techniques used to streamline…
Q: You are Jimmy Cricket, CEO of Mudge Paper Company and Lauren’s boss. You have come into the office…
A: Biases in research refer to systematic errors or deviations from the truth in the processes of data…
Q: Your organization has decided to hire 2 new project managers. As you know when someone is hired…
A: Effective project estimation and planning play pivotal roles in the success of any organizational…
Q: 2. A city is holding an annual marathon event and wants to produce t-shits. Alfonso was able to…
A: sales volume =min(volume prepared, demand)egrow1, column 2sales volume = min(1000,2000)=1000 demand…
Q: Calculate the optimum order quantity of inventory for Playfair Limited over a one-year planning…
A: Storage costs: 3% Insurance = 1% Handling = 1% Obsolescence = 3% Opportunity costs = 10%D = Annual…
Q: A firm uses a fixed time period model to manage a type of bolts they keep in inventory. The average…
A: Periodic review/fixed period Here inventory is checked at pre fixed review intervals and an order is…
Q: Compute Estimate At Completion (EAC) and Variance At Completion (VAC) if both SPI and CPI influence…
A: Find the given details below:
Q: Chapter 16 Assessment 16 eBook References Consultant Charlie Betty Johnny Rick The president of a…
A: The process of figuring out how best to divide up tasks, jobs, or resources in order to minimise…
Q: -M-a-k-e- -a- -T-O-W-S- -a--n-a-l-y-s-i-s- -f-r-o-m- -t-h-e-s-e- -s-w-o-t- -a-n--a-l-y-s-i-s-…
A: The objective of the question is to create a TOWS analysis from the given SWOT analysis. TOWS…
Q: How often should the laboratory verify that the interface between the equipment and the LIS is…
A: The question is asking about the frequency of verification for the interface between laboratory…
Q: Compute the labor productivity for each of the weeks. On the basis of your calculations, what can…
A: WeekCrew size (C )Yards installed (Y)149623723492425053696252
Q: Risk Management at MS Company MS Company is a Trading Company involved in Import and export trade.…
A: The objective of the question is to identify the types of insurance that can help MS Company…
Q: Need a Total productive maintenance total for this problem: The Tack articulation inspection is…
A: To calculate the Total Productive Maintenance (TPM) for the Tack Articulation Inspection problem, we…
Q: E-procurement Module Question 1 Mark is thinking of changing the entire business process by…
A: Operations management enhances customers’ satisfaction by seeing that products get into the market,…
Q: Marine Parts Inc. wants to produce parts in batches of 60 parts. Each part must be processed…
A: Batch Processing:Batch processing refers to the execution of a series of tasks or jobs as a group,…
Q: How often should the laboratory verify that the interface between the equipment and the LIS is…
A: The question is asking about the frequency of verification for the interface between laboratory…
Q: A farmer in Lufyanyama has 2000 acres of land on which he can grow maize, wheat and Soya beans. Each…
A: For Maize:Cost for preparation: K200 per acreMan-days of work: 14 days per acreProfit: K60 per…
Q: Regarding competency assessment, what are the strengths and weaknesses of the different assessments
A: With the help of competency assessment tools, we can specify and measure the skill levels,…
Q: The annual requirement of a part is 360,000 units. The order cost is $120 per order, the holding…
A: Annual requirements (D) = 360,000 unitsOrder cost (S) = $120 per orderUnit cost (C) = $2,500 per…
Q: Hello guys, can you draw the precedence diagram please? I get really confused
A: Critical path method is project management tool (others e.g WBS, PERT). It uses flow chart of…
Q: Westside Auto purchases a component used in the manufacture of automobile generators directly from…
A: First, let me introduce the given data,
Q: Answer the following questions 1. Calculate the slope for the regression line. (show all working)…
A: The simple linear regression model shows the relationship between a dependent variable and one or…
Q: a. Develop and solve an integer programming model for maximizing the net present value. b. Assume…
A: For this question, I will formulate the LP, Then, I will prepare the Spreadsheet model, This model…
Q: Briefly state the Aims and Objectives of this Project: In the academic year 2016/17, nearly a third…
A: The Rental Agent project responds to Chinese students' housing difficulties in England by providing…
Q: The textile company “Designs Sports” is dedicated to the production of sports clothing. In its line…
A: For this question, I will formulate the LP, Then, I will solve using the two phases-simplex methods,…
Q: Why have unions become more accepting of alternative reward systems over the past few years?…
A: The objective of the question is to understand the reasons why unions have become more accepting of…
Q: A company wants to store the following seven SKUS so there is 100% accessibility. Items are stored…
A: SKUNumber of PalletsA14B18C40D32E55F23G35
Q: Fisk Corporation is trying to improve its inventory control system and has installed an online…
A: To find the Economic Order Quantity (EOQ) and related parameters, we can use the Wilson EOQ model.…
Q: A company wants to minimize the cost of shipping a product from 3 different factories to 6 different…
A:
a. In the Bayside Fountain Hotel problem, for the exponentially smoothed
b.In the Bayside Fountain Hotel problem, compute an adjusted exponentially smoothed forecast with α = .20
and β = .20. According to the result from Excel and/or POM-QM, the forecast for the year 10 would be
c.In the Bayside Fountain Hotel problem, for the adjusted
exponentially smoothed forecast with α = .20 and β = .20, compute the mean absolute deviation (MAD) via Excel and/or POM-QM.
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 9 images
- 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?
- 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?Under what conditions might a firm use multiple forecasting methods?
- Small Wonder, an amusement park, experiences seasonalattendance. It has collected two years of quarterly attendancedata and made a forecast of annual attendance for the comingyear. Compute the seasonal indexes for the four quarters andgenerate quarterly forecasts for the coming year, assuming annualattendance for the coming year to be 1525.IN THE MID-1960S, WALT DISNEY’S DREAM was to build a family resort destination like no other. The dream became a reality when Walt Disney World Resort opened in 1971, featuring Magic Kingdom as the centerpiece. Today, millions of guests visit the Walt Disney World Resort each year to experience the world-class theme parks and hotels. Analytics feature prominently in the operations of Walt Disney World. i)Explain using illustrations how forecasting features in this company’s operations. ii)Explain at least four methods of forecasting that can be used for Disney’s purpose. Use made up worked examples.The Oceanside Hotel is adjacent to City Coliseum, a 24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the nine years since the coliseum opened: Year 1 2 3 4 5 6 7 8 9 Occupancy Rate 75% 70% 72% 77% 83% 81% 86% 91% 87% Compute an exponential smoothing forecast with α = 0.20, an adjusted exponential smoothing forecast with α = 0.20 and β = 0.20, and a linear trend line forecast. Compare the three forecasts using MAD and average error (?̅), and indicate which forecast seems to be most accurate.
- John's House of Pancakes uses a weighted moving average method to forecast pancake sales. It assigns a weight of 5 to the previous month's demand, 3 to demand two months ago, and 1 to demand three months ago. If sales amounted to 1000 pancakes in May, 2200 pancakes in June, and 3000 pancakes in July, what should be the forecast for August?24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed forecast with an α value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number only, two decimals) 1 83 2 78 3 75 4 81 5 86 6 85 7 89 8 90 9 86Exotic Wines, Inc. wants to use exponential smoothing with α = 0.35 to forecast demand in bottles sold. The demand the last four months are 3,221, 3,197, 3,645, and 3,912 bottles. The forecast for bottles was 3,221 bottles for the second month. What is the forecast for the fifth month? Round your answer to the nearest whole number. bottles: