Table 1: Demand for Dog Ball Launcher 2018-2021 Quarter 2018 Demand 2019 Demand Q1 02 03 Q4 Month January February March April May June July 10 29 26 15 August September October November December Table 2: Demand for Lightweight Dog Lead 2020-2021 2020 Demand 2021 Demand 36 56 75 85 94 101 108 14 31 29 18 105 114 111 110 2020 Demand 20 26 28 30 98 101 97 99 100 95 107 104 98 104 100 102 2021 Demand 30 31 33 35
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: How do organizations use linear regression. Also can you provide some examples
A: First, I would describe the linear regression term, and then, I would explain, how organizations…
Q: Explain how the project's benefits are realized. Explain the five (5) overarching, foundational, and…
A: The benefits of a project are realized through the successful completion of project objectives and…
Q: The activities needed to replace a broken window pane are given below. Activity Duration (in…
A: (a)
Q: Case Study: Anna runs a small cafe that’s really busy at lunchtime but quiet at other times. She…
A: Anna is a cafe owner, who is facing a problem where there are a lot of customers during lunchtime…
Q: Recent study by IBM surveyed 585 mobile application developers and managers, and just one third of…
A: Businesses like FIMC run the risk of the following when they rapidly develop and release mobile…
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: 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: Discuss the key characteristics of a private limited company and a partnership
A: Private limited company: Separate legal entity: It is viewed as a separate entity from its owners…
Q: The production manager is not certain that the contract for preventive maintenance with Simkin is in…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Part of monitoring a project as well as closing a project is to assess the project team's…
A: Project monitoring is the systematic process of tracking and controlling a project's performance,…
Q: How should Ruby approach this briefing? Should she explain each type or should she discuss only the…
A: The executive development training programme includes Ruby Shelton. She has been given a job with…
Q: 6.9: An order for 250 bell ringers is processed on work centers 10 and 20. The setup and run times…
A: Setup on 10 = 50 minutesRun time on 10 = 5 minutes per pieceSetup on 20 = 100 minutesRun time on 20…
Q: Please set up a linear program and solve the problem using the Excel Solver. Thank you very much.
A: Given data is
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: The integration of business applications and Amazon Web Services: how well suited?
A: Amazon Web Services or AWS is an IT subsidiary of Amazon that is into cloud computing services…
Q: 1. Is the Mount Vernon site a suitable location for the pressure vessel plant? Comment on labor…
A: Babcock & Wilcox faced many problems in setting up a nuclear pressure vessel plant in Mount…
Q: A firm cleans chemical tank cars in the Bay St. Louis area. With standard equipment, the firm…
A: As per our guidelines, we can only answer first three subparts, please post them under a different…
Q: per restock What is the minimum sensible storage volume in the fast-pick area for this SKU, measured…
A: To determine the minimum sensible storage volume in the fast-pick area for this SKU, we need to…
Q: Complete the following table by computing the opportunity cost of Ciana's time and the total cost of…
A: To calculate Opportunity Cost, we must first calculate the two way time to travel to each store…
Q: Make a persuasive speech about savings. 500 words. AVOID PLAGIARISM
A: Savings are an important component of one's life. It is a portion of income that is not spent on…
Q: ABC Corporation resells one product to a small isolated community. It has 365 working days. It sells…
A: Reorder Point (ROP) Model: Reorder Point (ROP) is the minimum level of inventory at which a company…
Q: The International Organization for Standardization is the first globally recognized standard related…
A: Risk management is the process of identifying, assessing, and prioritizing potential risks to an…
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: 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: The production planner for a private label soft drink maker is planning the production of two soft…
A: Profit maximization is the inclination of businesses to increase profits over the short or long term…
Q: Listen to CIO Leadership Live with Christine Burns, chief information officer, University of New…
A: 1) a. Name of the podcast: "CIO Leadership Live with Christine Burns, Chief Information Officer,…
Q: Use the information in the table below (image 1): a. Construct the Precedence Diagram. b.The…
A: Given-
Q: c. Rachel knows that she can increase next month's plant capacity by using overtime labor. She can…
A: Decision Variables: Suppose-F be the no. of Family Thrill seekers to be assembled in the next monthC…
Q: Given the following data, use exponential smoothing (a=0.10) to develop a demand forecast. Assume…
A: Exponential smoothing is time series method which uses for forecasting univariate time series data.…
Q: Based on the article given, answer the following questions: 1. Discuss the problem of capacity…
A: ANSWER : The problem of capacity planning faced by Babcock and Wilcox was that they over-estimated…
Q: Question 1: The SCO3001 Company is considering different tools to forecast the demand of its…
A: Answer a= Forecast for week 6= (47+46+32+26)/4 =37.75 Forecast for week 7= (46+32+26+33)/4 =34.25…
Q: Solution of a Transportation Problem Example. Determine an initial basic feasible solution of a…
A: Find the Calculations below:
Q: 1. Is outsourcing a completely negative activity? How does its reputation tie in with insourcing?.
A: The act of allocating a company's business activities to an outside organization in order to improve…
Q: (d) The computer solution for the linear program in part (a) provides the following objective…
A: Linear programming is a mathematical technique that is commonly used in the operations management…
Q: The G&E Company is preparing a bid to build the new 47,000-seat Shoreline baseball stadium. The…
A: 1. During forward pass in case of more than two preceding activities the early start will be…
Q: A client of yours comes to you wondering about overtime. They are working regular 45 hour weeks…
A: As Per Fair labour standards Act (FLSA) overtime rule, employees deserve overtime pay for working…
Q: Based on the x-chart, the wire cutting process has been
A: Based on the X- chart we can see from the below Graph, it appears that the process is not in…
Q: a. What is the setup cost, based on the desired lot size? b. What is the setup time, based on $40…
A: a. To calculate the setup cost based on the desired lot size of Q = 63 units, you would use the…
Q: Decide in which periods ordering should take place (you can choose the calculation method).
A: Dynamic order size refers to the practice of adjusting the order size in response to changes in…
Q: is the search for best practices that will lead to superior performance. Anchoring O a. O b.…
A: In order to achieve superior performance, organizations are constantly searching for the best…
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: Analyze the most pressing issues in the field of risk management. Discussion How important is risk…
A: The field of risk management is constantly evolving and facing new challenges, but some of the most…
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: Find a basic feasible solution with the basic variables as x₁, x2, and x4. Is solution optimal? If…
A: Linear programming is a mathematical technique that is commonly used in the operations management…
Q: What are Effective resource management and good budgeting skills.
A: Forecasting is the process of estimating the future demand based on the past information and data.
Q: 2. How does this forecast differ from that using the 5-year average? 3. Which forecast would you…
A: The average forecasting method, also known as the mean method, is a simple and straightforward…
Q: 1. Solve the following problem by using Solver in your spreadsheet: Steelco | manufactures three…
A: Decision Variables: Suppose-Xij be the tons of steel j produced in plant i Where i=1,2,3 and…
Q: Consider the following from an estate agent business: Month. Houses sold Jan…
A: Note: - Since the exact question that has to be answered is not specified and all the questions are…
Q: In which country is it riskiest to begin international operations: Mexico, Argentina, or Poland?…
A: International Operations protect the nation's borders by conducting international law enforcement…
See attached file need correct excel answer of data thank you.
Step by step
Solved in 4 steps with 7 images
how would you calculate the
- 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?
- Under what conditions might a firm use multiple forecasting methods?Demonstrate the value of forecasting in the supply chain. In practice, how are statistical and judgmental techniques applied.The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: August 31 September 7 September 14 September 21 September 28 October 5 Week Of a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = 370.45 pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) Week Of c) If the forecasted demand for the week of August 31 is 345 and a = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7…
- The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = 373.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.25, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = 373.3 pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) Week Of c) If the forecasted demand for the week of August 31 is 360 and a = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7…The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average 372.33 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12- 371.15) pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) Pints Used 345 389 412 378 368 371Developing joint forecasting with supply chain partners offersthe following benefits:a) Reduce inventory b) Increase salesc) Bring value to the customer d) Share riskse) All of the above
- Case Study 1: ForecastingYour line manager, Ms Lionheart, has collected and scrutinised performance data for thecompany. She was concerned that the inventories were high for certain products which hadresulted in significant price reductions and losses for the company. At the same time, thecompany had run out of stock for other items early in the season resulting in unsatisfiedcustomers and lost sales. Ms Lionheart has concluded that the problem was not with thespecific products carried in the stock, but with the quantities ordered by the procurementdepartment for two popular products; Dog Ball Launcher and Lightweight Dog Lead.Dog Ball Launcher is a product carried by the company for the past four years. Quarterlydemand data for the past four years are shown in table 1. Last year the company seemed toalways be out of stock for this item. The model used by the procurement department toforecast demand for this product over the last two years has been Multiplicative Seasonalmodel based on…Case Study 1: ForecastingYour line manager, Ms Lionheart, has collected and scrutinised performance data for thecompany. She was concerned that the inventories were high for certain products which hadresulted in significant price reductions and losses for the company. At the same time, thecompany had run out of stock for other items early in the season resulting in unsatisfiedcustomers and lost sales. Ms Lionheart has concluded that the problem was not with thespecific products carried in the stock, but with the quantities ordered by the procurementdepartment for two popular products; Dog Ball Launcher and Lightweight Dog Lead.Dog Ball Launcher is a product carried by the company for the past four years. Quarterlydemand data for the past four years are shown in table 1. Last year the company seemed toalways be out of stock for this item. The model used by the procurement department toforecast demand for this product over the last two years has been Multiplicative Seasonalmodel based on…K The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks. Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.35, and 0.45, using 0.45 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) August 31 September 7 September 14. September 21 September 28 October 5 October 12 c) If the forecasted demand for the week of August 31 is 345 and a = 0.20, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your…