A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project.

A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project.

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.2SA

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. 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?
PROBLEM-3) The Sales&Operations (S&OP) process is designed to produce a plan that all departmentswithin the organization, as well as suppliers to the organization, can work. The process is also sometimes referred toas sales, inventory, and operations planning (SIOP) to emphasize the important role that inventory can play as abuffer between sales planning and operations planning. The S&OP department of the XYZ company, that producesKLM products, estimates the sales over the next six years in thousands of packages will be as follows: Assume that each worker stays on the job for at least one year and XYZ currently has eight workers. XYZ estimatesthat they will have 600000 packages on hand at the end of the current year. Assume that, on average, eachworker is paid TL 60000 per year and is responsible for producing 80000 packages. Inventory costs have beenestimated to be 20 KRS per package per year, and shortages are not allowed. XYZ estimates that it costs TL 2500for each…
What are quality standards and how to guarantee your company has reached them? QUESTION 2:What are the four flows within the corporate environment, which are tried to optimize through logistics? QUESTION 3:Describe supplier selection and evaluation process. QUESTION 4:What are the differences between local and global sourcing? Explain also in which situations either of the options are preferable. QUESTION 5:What is demand forecasting and why it’s vital to the company’s operations? QUESTION 6:Explain the purpose, methods and the outcome of good customer service process. Your answer must be at least 1-2 pages.
Article: Planning for Holiday Shipping at FedEx FedEx started as Federal Express in 1971 and made its first delivery in 1973 with 14 aircrafts and 389 employees, successfully delivering 186 packages.50 The company was founded by Frederick W. Smith who first presented his idea for the shipping company in a term paper for a business class at Yale University in 1964. Smith did not do well on the paper as his professor did not see the need for overnight package deliveries. But more than 45 years later, Smith has clearly proved his professor wrong. FedEx now employs more than 325,000 employees and uses its 652 aircraft and more than 100,000 trucks to ship on average 10.5 million packages a day in over 220 countries. Managing such a large enterprise with so much complexity clearly requires effective planning. Similar to other shipping companies, FedEx engages in significant planning to prepare for Christmastime deliveries, the company’s peak season. FedEx typically meets with major…
Case Exercise 3: Demand Forecasting for an Insurance Company
Problem 1. During your first month as an employee at Greenfield Industries (a large drill- bit manufacturer), you are asked to evaluate alternatives for producing a newly designed drill bit on a turning machine. Your boss' memorandum to you has practically no information about what the alternatives are and what criteria should be used. The same task was posed to a previous employee who could not finish the analysis, but she has given you the following information: An old turning machine valued at $350,000 exists (in the warehouse) that can be modified for the new drill bit. The in-house technicians have given an estimate of $40,000 to modify this machine, and they assure you that they will have the machine ready before the projected start date (although they have never done any modifications of this type). It is hoped that the old turning machine will be able to meet production requirements at full capacity. An outside company, McDonald Inc., made the machine seven years ago and can…
what is the difference between customer statement and problem statement?
Regression, activity-based costing, choosing cost drivers. Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection. Mary Adams, the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs. Mary gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows: Week Room Inspected Inspection Labor-Hours Inspection Costs 1 254 66…
CASE STUDY You are working as an inventory clerk in Shop Smart Centre. The company specializes in selling all types of gifts, ornaments, clothes and home design items. Due to high turnover of sales, the company orders items in bulk and keeps them in their storage until it is required by the sales department. Sometimes the staffs spend a lot of time looking for a particular item in the storage required by the customer which causes frustration and the customer eventually leaves the premises without even looking at the item. The owner of the business is really disappointed about this. Someone recently mentioned to him about having an ‘efficient warehouse system’. He was unsure what the key features of an efficient warehouse contained. He has come to know that you are doing a course in inventory management and has approached you for advice. Questions: Explain the key features of an efficient warehouse Explain how the inventories should be placed so that it can be found easily by the…