Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 5, Problem 4.2C
Summary Introduction
Case summary:
Person HL is the VP of purchasing of consumer electronics division of Company M. The company recently introduced a new video camcorder that has taken over the market. Person HL is finding it difficult to keep up with the distributor’s orders of the camcorder. The major distributors are in City PH, City DR, City BE, and City HN. Company M has contracts with companies in Country HK, Country KA, and Country SE. Company M also has a standing contract with a shipping company to transport the products from the suppliers to the ports in City SF and City SD.
To implement: A spreadsheet model for the given problem and solve it.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Bright Company wants to figure out the best way to ship their new product,
Flying Widgets, from their factories through their warehouses to their retail outlets.
They would like to set up a Transhipment table so they can use POM to find the least
cost shipping routes. They have hired you to set up the Transhipment table based on
the information below. You will be paid handsomely if you can come up with the
correct table.
Shipping Costs
Shipping Costs
01
02
03
04
Wi
W2
W3
W1
4.
2
F1
4
W2
4
F2
4
2
W3
4.
3.
4.
Also, Flying Widgets can be shipped from Factory 1 to Factory 2 for $3 per unit.
Factory 1 can produce 300 units and factory 2 can produce 100 units.
Outlet 1 demand is 50 units, Outlet 2 is 150 units, Outlet 3 is 100 units, and
Outlet 4 is 100 units.
Supply chain management (SCM) is a critical component of organizational management that focuses on the efficient coordination of the flow of goods, services, and information from raw material suppliers to end customers. Effective supply chain management involves the strategic planning and execution of processes to optimize the procurement, production, and distribution of products or services. Key aspects of SCM include supplier relationship management, inventory management, logistics, and demand forecasting. By streamlining supply chain processes, organizations can minimize costs, improve operational efficiency, and enhance customer satisfaction. Additionally, SCM plays a vital role in risk management by identifying potential disruptions and implementing contingency plans to mitigate their impact. In today's globalized and interconnected marketplace, effective supply chain management is essential for maintaining competitiveness and resilience. How can organizations leverage technology…
Supply chain management is a critical function within organizations that involves the coordination of activities related to the sourcing, procurement, production, and distnbution of goods and services. Effective supply chain management aims to optimize the flow of materials, information, and finances across the entire supply chain network, from suppliers to end customers. Key components of supply chain management include strategic sourcing, which involves selecting the right suppliers based on factors such as quality, cost, and reliability, inventory management, which seeks to minimize carrying costs while ensuring product availability, and logistics management, which focuses on the efficient transportation and storage of goods. Additionally, supply chain managers must collaborate closely with internal departments as well as external partners to mitigate risks, manage disruptions, and continuously improve the performance of the supply chain. By adopting technologies such as data…
Chapter 5 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 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?arrow_forwardScenario 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?arrow_forwardPhilibert Enterprises Inc is a manufacturing and distribution company that is engaged insupplying exotic Caribbean Food products of high quality for the European and NorthAmerican markets. The Product Quality and consistency of supplies of the product are twocritical success factors. Philibert Enterprises Inc. has been using its website as its principalpoint of contact for its customers It recently won a major contract to supply the Marks&Spencer chain in the UK, where persons of Caribbean origin are a significant group in thepopulation. This is in addition to the growing popularity of Caribbean Cuisineinternationally. High productivity levels are necessary to meet the product quality anddelivery time requirements. The Marketing Manager is expected to work closely with theHuman Resource Manager to develop a reward system that will enable greater reliabilitywith respect to response time and assure quality and compliance with HACCAP1requirements. 1. how can the following criteria…arrow_forward
- Philibert Enterprises Inc is a manufacturing and distribution company that is engaged insupplying exotic Caribbean Food products of high quality for the European and NorthAmerican markets. The Product Quality and consistency of supplies of the product are twocritical success factors. Philibert Enterprises Inc. has been using its website as its principalpoint of contact for its customers It recently won a major contract to supply the Marks&Spencer chain in the UK, where persons of Caribbean origin are a significant group in thepopulation. This is in addition to the growing popularity of Caribbean Cuisineinternationally. High productivity levels are necessary to meet the product quality anddelivery time requirements. The Marketing Manager is expected to work closely with theHuman Resource Manager to develop a reward system that will enable greater reliabilitywith respect to response time and assure quality and compliance with HACCAP1requirements. 1. Outline the factors that…arrow_forwardThe leading private medical clinic organization in Ghana is UPSAIT400 Group. It uses information technology to run hundreds of specialized institutes in addition to 15 hospitals. The need for more servers and storage technology is increasing by 25% annually. Every application was being set up on a separate server by UPSAIT400, and a variety of UNIX and Windows operating systems were being used on the servers and other computers. Many various suppliers' technologies are required to be managed by UPSAIT400, including those from Hewlett-Packard (HP), Sun Microsystems, Microsoft, and IBM. As an astute system administrator, what choices need to be taken into account while creating a solution to this issue?arrow_forwardThird-party logistics (3PL) is a good term for shipping and delivery firms. What are third-party suppliers and why do corporations employ them?arrow_forward
- Philibert Enterprises Inc is a manufacturing and distribution company that is engaged in supplying exotic Caribbean Food products of high quality for the European and North American markets. The Product Quality and consistency of supplies of the product are two critical success factors. Philibert Enterprises Inc. has been using its website as its principal point of contact for its customers, It recently won a major contract to supply the Marks& Spencer chain in the UK, where persons of Caribbean origin are a significant group in the population. This is in addition to the growing popularity of Caribbean Cuisine internationally. High productivity levels are necessary to meet the product quality and delivery time requirements. The Marketing Manager is expected to work closely with the Human Resource Manager to develop a reward system that will enable greater reliability with respect to response time and assure quality and compliance with HACCAP equirements. tline the factors that…arrow_forwardSupply Chain Logistics networks are designed to maximize operational efficiency. Companies attempt to optimize logistics through either a developed network or designing their own network. Discuss when it would be appropriate for a company looking to expand to design their own logistics network or utilize a 3pl or 4pl provider. Specifically address what criteria company would use to make this decision.arrow_forwardAs an expert in supply chain risk management, you have been tasked by Toyota South Africa to aid them in conducting an extensive risk assessment. Your task: Develop a comprehensive risk management plan for Toyota South Africa. Your plan should include a critical analysis of five potential sources of risk that may arise in Toyota’s supply chain. You should also provide recommendations for mitigating each identified risk. Your risk management plan should be well structured and based on theory from the prescribed book. Note: you may refer to the risks that Toyota South Africa encountered as described in the case study. However, it's also important to identify additional risks that are not discussed in the case study but that would be applicable to Toyota South Africa.arrow_forward
- Covid19 has brought many changes in the business strategies and processes. These businesses have learned various newinsights due to their uncertain supply chain disruption. As we learn from our experiences, these firms have learned somelessons and have made specific changes in their strategies, policies, and procedures to cater to such uncertain forthcomingevents.Being a Supply chain operations and logistics expert, you are required to do case study research on a single firm. That firmmust have some global footprints. Meaning, either they are importing more than 50% of material from other countries orexporting more than 50% of finished goods to other countries.You have to conduct at least one interview from their supply chain department of that particular industry to explore thefollowing areas?✓ What are the industry-wide effects of COVID19 lockdown?✓ What are the organization-specific effects of COVID19 lockdown on different supply chains and operationalareas? (provide the detailed…arrow_forwardBrian and Dom have pooled their resources and have started a major logistics company that transports produce such as potatoes, maize meal and carrots. Their depot is based in Midrand, Gauteng. The pair wants to grow the business and has therefore sought your assistance as a supply chain scholar to assist with the following questions that they have for you. Dom and Brian are concerned about the barriers that they may experience within their organisation when developing and implementing supply chain strategies, explain regulatory and political considerations and reluctance to share data as a barrier to the development of supply chain management strategy.Note: you are required to provide a paraphrased understanding of the concepts before you provide an application point for each.arrow_forwardPhilibert Enterprises Inc is a manufacturing and distribution company that is engaged in supplying exotic Caribbean Food products of high quality for the European and North American markets. The Product Quality and consistency of supplies of the product are two critical success factors. Philibert Enterprises Inc. has been using its website as its principal point of contact for its customers It recently won a major contract to supply the Marks& Spencer chain in the UK, where persons of Caribbean origin are a significant group in the population. This is in addition to the growing popularity of Caribbean Cuisine internationally. High productivity levels are necessary to meet the product quality and delivery time requirements. The Marketing Manager is expected to work closely with the Human Resource Manager to develop a reward system that will enable greater reliability with respect to response time and assure quality and compliance with HACCAP¹ requirements. Outline the factors that…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning