Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
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 solutionStudents 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…
The AB e-commerce company has started operating by using a 3PL partner and benefits from saving time and money with a more streamlined order fulfillment process and inventory management. By outsourcing fulfillment, the 3PL is automatically notified when an order is placed.Also, partnering with a 3PL helps reduce logistics costs in the long run. Unlike hiring an internal team to manage inventory and shipping, 3PLs store the inventory and their team of fulfillment experts are trained to keep overall logistics costs down. Furthermore, 3PL arrangement helps split inventory across locations so the company can eliminate shipping to the highest, most expensive shipping zones and keep inventory closer to more customers.To have a more integrated distribution process, would reducing dependency on 3PL be a viable option in the long term for the AB company for cost management and control? Justify with your understanding of supply chain management concepts. also, using your knowledge of other open…
Chapter 5 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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_forwardYou are a logistics manager of Medical Device Depot, Inc., located in Ellicott City, MD. Your job is to develop logistics solutions for your international customers. Now you receive an order about one unit of SR-130 Portable X-Ray System Based on the information of company webpage, this equipment has the value of $16,000 and its storage dimension is 26"W x 53" Lx 28"H. This customer is located in Shanghai, China. You may need to google or contact service providers to get quotes. You need to propose two transportation options including transit time and total costs. The two options are: 1) Air shipping: from Ellicott City, MD (BWI airport) to Shanghai, China (SHA airport); 2) Ocean shipping: from Ellicott City, MD (Port of Baltimore) to Shanghai, China (Port of Shanghai).arrow_forward
- 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…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. Note: 1HACCAP, Hazard Analysis…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. Outline the factors that…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. how can the following criteria…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.Outline the factors that Philibert…arrow_forwardThe air cargo product is an important source of revenue and differentiator for cargo airlines. Regardless of whether these are combination carriers of all-cargo specialists, airlines compete intensely for the airport to airport cargo service. Singapore Airlines Cargo (SIA Cargo) competes intensely for market share in a highly competitive air cargo sector. SIA Cargo is a division that sits within Singapore Airlines. It operates a dedicated freighter fleet which the division complements with belly capacity on passenger flights that are operated by Singapore Airlines and its subsidiaries. (a) Discuss how SIA Cargo distinguishes itself from competition in the current COVID-19 environment for the following market segments that it serves: E-commerce logistics Perishables Pharmaceuticals It is important that you contextualise your answer to SIA Cargo and not give generic answers. (b) Why do you think that it is essential for SIA Cargo to offer differentiated products and services? Give…arrow_forward
- 9. How do air carriers price their services? Is the weight or density of the shipment a factor? Explain this factor as part of your answer. How does air carrier pricing relate to the value of the goods being transported? 10. What are the current issues facing the air industry? Discuss how each impacts the industry, its customers and employees? 11. What is the cost structure of the air industry? How does it compare with others modes? How does this affect pricing, particularly passengers? Be sure your answer includes examples from either advertising or the Internet.arrow_forwardMGMT Bakehouse Inc (MBI), supplies bread, cakes, and other specialty products, to a large percentage of the country; to the following customer types. Retailers e.g. supermarkets, who sell baked goods to the public, and MGMT Bakehouse Inc delivers to the retailers. Wholesalers also sell to the public but come to MGMT Bakehouse Inc directly to collect their baked goods. Finally, institutions like hotels and hospitals, to whom MGMT Bakehouse Inc delivers directly, buy baked goods to incorporate into offering for their clients e.g. guests menus and patient meal plans. From the ordering of flour and other ingredients to the processing of cash, receivables, and payables, the company uses an integrated ERP with a common database for all of its business processes. Internally MGMT Bakehouse Inc is organized into the following departments: Production which bakes the bread; Distribution that delivers the bread; Sales Department where customer orders and wholesale pickups are managed; Marketing…arrow_forwardExplain the following sentence "In reality, it can be difficult for managers to achieve logistics management goals when designing logistical procedures because they may face heavy stresses on the supply chain such as rising overall costs"??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