See attached file need correct excel answer of data thank you. 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 indin 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 seasonal indices developed using data from 2018-2019 with predictedannual demand increase of 6 units per year since 2019.Lightweight Dog Lead is a new product that the company has been selling for the past twoyears. When the product was introduced in 2020, it was expected to have a large increasingdemand trend. The procurement team has been using Trend Projection with least-squaresmethod developed using data from 2020 to forecast the demand for this item. However,they now seem to have too much inventory for this product. Monthly demand data for thepast two years for this item is shown in table 2.Ms Lionheart now wonders if right forecasting models were being applied to these twoproducts. She wants you to analyse the available data and produce a short report (1,000words ±10%) with all relevant tables and figures, to address the highlighted issues.In your report you need to consider the following for both sets of data:1. Analyse and explain the data.2. Is appropriate forecasting model being applied? Explain.3. What forecasting model would you use? Explain why you selected your approach.4. Generate the forecast for each period in 2020 and 2021 using the current model andthe model you selected. Analyse the results.5. Determine the forecast error for the current model and the model you selected.Explain your method and findings6. Provide three key recommendations for the company.Table 1: Demand for Dog Ball Launcher 2018-2021Quarter 2018 Demand 2019 Demand 2020 Demand 2021 DemandQ102Q304MarchAprilMayJuneJuly10292615Table 2: Demand for Lightweight Dog Lead 2020-2021MonthJanuary2020 Demand 2021 Demand3698February421015697991009510710498104AugustSeptemberOctoberNouembNovemberDecember758514312918941011081051141111102026283010010230313335

Given Background:- Line manager, Ms Lionheart, has collected and scrutinized performance data for…

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

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

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SD: Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling...

See similar textbooks

Similar questions

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?
CASE STUDY Siti is the associate director of a nonprofit agency that provides assistance to children and families. She is the head of a department that focuses on evaluating the skill-building programs the agency provides to families. She reports directly to the agency leadership. As a whole, the agency has been cautious in hiring this year because of increased competition for federal grant funding. However, they have also suffered high staff turnover. Two directors, three key research staff, and one staff person from the finance department have left. Siti has a demanding schedule that requires frequent travel; however, she supervises two managers who in turn are responsible for five staff members each. Both managers have been appointed within the last six months. Manager 1: Husna has a specific background in research. She manages staff who provide research support to another department that delivers behavioral health services to youth. Kelly supports her staff and is very organized;…
Case Study In 2009, Detroit Michigan experienced an aggressive recession compared to the rest of country. With unemployment rates topping 15%, the city was faced many challenges financially, economically and socially. In addition to the financial challenges, the city was also experiencing political instability and corruption. The major and various city officials were being investigated for fraud, bribery and other criminal charges. Spirit Electric, operating as a natural monopoly, was the only company in the area to provide electric serves to the households. Like many other companies, it was experiencing financial difficulties and could no longer continue without some intervention. This was mainly due to high operating costs, foreclosures in the area and the fact that many households were not paying their bills. As a result, Spirit Electric came to a standstill in the latter part of 2009. Matt Green, Spirit electric CEO gathered the Board of Directors and determined that the company…
Sub- Management Case Study: ABC Corporation is a medium-sized manufacturing company that specializes in producing automobile components. The company has been in business for over 20 years and has experienced steady growth. Recently, however, the company has faced a number of challenges, including increased competition and rising costs. In response, the management team has decided to implement a new strategic plan to help the company remain competitive and profitable. The new strategic plan includes several key initiatives, such as improving operational efficiency, expanding into new markets, and investing in research and development. The management team believes that these initiatives will help the company achieve its goals and maintain its market position. As a management consultant, you have been hired by ABC Corporation to evaluate the effectiveness of its new strategic plan and make recommendations for improvement. Question: What are the key components of ABC Corporation's new…
Case Study: Tropical Leisure Limited Tropical Leisure Limited has been making high quality Caribbean leisure wears for over twenty-five years, in old rented premises located in the heart of the Barbadian capital of Bridgetown. The company has a flexible labour force of about twenty employees and three directors, only one of whom, namely Mr. Grant, the managing director, is fully active in the business. The company specializes in leisure and swim wear garments. Their current range consists of tee shirts, shorts, skirts and bath suits in rich vibrant Caribbean colours and styles for men, women and children. The company capacity is 400-500 garments per week, depending on style and continuity of the production run, but additional floor space and machines could be brought in quickly to raise production levels to a maximum of 1000 garments weekly if required. Trade sources estimated that the Barbadian market was valued at US$ 1.5 billion in 2010 but since then inflation and recession has…
Research Methodology, Design, and Analyses: How can I Explain the research methodology, design, and analyses? In the Quality Improvement Project to Determine the Knowledge, Attitudes, and Beliefs of Healthcare Providers Regarding the Treatment of Patients with Obesity. Research Article Van Stiphout, C., Alex, R., Turner, K., Twyman, K., Brown, J., Bowes, B., Charlebois, A., & Quinlan, B. (2022). A Quality Improvement Project to Determine the Knowledge, Attitudes, and Beliefs of Healthcare Providers Regarding the Treatment of Patients with Obesity. Canadian Journal of Cardiovascular Nursing, 32(2), 11–17.
CASE STUDY: Food Lover's Market which was launched 25 years ago has evolved from a pure fresh fruit and vegetable store known as Fruit and Veg City into several brands, the latest of which serves meals. The first Johannesburg-based Food Lover's Eatery opened in Sandton last month (August 2018) at the Marc on Rivonia Road, a new shopping centre. There are 3 other Food Lover's Eateries in the Cape Town CBD selling 10 000 to 15 000 meals a day between them. With its design 2 years in the making, the Rivonia store feels like a sophisticated food deli or food hall in a major capital along the lines of Eataly, the popular open-plan food hall concept in the US. Mike Coppin, co-founded the Food Lover's Market group with his brother Brian said the quality and variety were unrivalled. He expects it will become a regular lunch destination for local businesses. "It has a strong focus on convenience in both the store design and service and is dedicated to offering a fast lunch service. We find it's…
Case Study - TD Bank Several years ago, TD Bank became concerned about the growing number of robberies at its branches. It was clear that something had to be done to protect employees and customers. The first thing they did was conduct a need analysis that included focus groups, interviews, and surveys. The needs analysis revealed the need to design a training program that would focus not just on robbery prevention but also on what happens afterwards. An outline was developed for a training program that centered on three areas: the most common types of robberies, what happens during robbery attempts, and what processes and behaviours are considered best practices in the financial sector. The objectives of the training program were to reduce the number of robberies, enhance risk-management practices, improve robbery prevention, and reduce financial losses. The instructional designers worked with external subject-matter experts and networks to determine learning objectives. They also…
Case Study - TD Bank Several years ago, TD Bank became concerned about the growing number of robberies at its branches. It was clear that something had to be done to protect employees and customers. The first thing they did was conduct a need analysis that included focus groups, interviews, and surveys. The needs analysis revealed the need to design a training program that would focus not just on robbery prevention but also on what happens afterwards. An outline was developed for a training program that centered on three areas: the most common types of robberies, what happens during robbery attempts, and what processes and behaviours are considered best practices in the financial sector. The objectives of the training program were to reduce the number of robberies, enhance risk-management practices, improve robbery prevention, and reduce financial losses. The instructional designers worked with external subject-matter experts and networks to determine learning objectives. They also…
1. Read the following case study and answer the questions: London Elevator Repair London Elevator Repair (LER) provides a maintenance and repair service for a variety of elevator systems. Its customers include department stores and other business organizations throughout the London. The elevator systems include conventional lifts, paternosters, and escalators. Customers can take out a maintenance contract with LER, for which they pay on an annual basis. One maintenance contract can cover several elevators (for example, all of the escalators in a department store). Due to their nature, some elevators are covered by an individual contract (for example, a paternoster would have its own contract rather than be included in a contract for the maintenance of conventional lifts). Hence each customer can have more than one maintenance contract. The hourly rate to be charged for engineers’ time is agreed as part of the contract negotiations. In addition to the work carried out under…