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 solution
Students have asked these similar questions
GHANA TEXTILES COMPANY Ghana Textiles Company is major retailer of local and imported textiles in Ghana. It sources raw materials from the Northern Regions of Ghana and imports others from East Africa and China. It has various sales points throughout the Country. Its transportation systems are outsourced to 3rd Party operators. The company keeps huge stocks of inventory in its central warehouse for distribution nationwide. The company’s new Sales Director intends to increase sales by 25% and expand business into Togo, Benin and Nigeria before Quarter 2 of 2022. This expansion requires the use of 3rd party Distribution Centres and systems. As the Logistics Manager you are to:
a. Critically analyse 4 key factors that company will consider in selecting locations for its distribution centres Togo, Benin and Nigeria.
b. Select and critically evaluate the appropriate transportation strategy for the company’s distribution operations and discuss 2 key types of risks that may affect this…
A Strategic National Stockpile includes:
a. Non-perishable food and water in the case of a natural or human-made disaster that can be deployed by that National Guard to areas of the US in need
b. Medical supplies, antibiotics, vaccines, and antidotes that can be delivered anywhere in the US within 12 hours
c. Guns, rifles, and ammunition that can be distributed to active military and, if needed, civilians in the case of a foreign attack on US shores
d. Various versions of mRNA vaccines based on predictions of the next COVID-19 viral strain that can be deployed to states when surveillance efforts detect a new strain
A sports apparel company has received an order for a college basketball team’s national championship T-shirt. The company can purchase the T-shirts from textile factories in Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies in the United States that silk-screen the shirts before they are shipped to distribution centers. Following are the production and transportation costs ($/shirt) from the T-shirt factories to the silk-screen companies to the distribution centers, plus the supply of T-shirts at the factories and demand for the shirts at the distribution centers: Determine the optimal shipments to minimize total production and transportation costs for the apparel company.
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
- Pine Valley Furniture In an effort to better serve the various departments at Pine Valley Furniture, the PVF information systems department assigns one of its systems analysts to serve as a liaison to a particular business unit. Chris Martin is currently the liaison to the purchasing department. After graduating from Valley State University, Chris began working at Pine Valley Furniture. He began his career at PVF as a programmer/analyst I. This job assignment required him to code and maintain financial application systems in COBOL. In the six years he has been at PVF, he has been promoted several times; his most recent promotion was to a junior systems analyst position. During his tenure at PVF, Chris has worked on several important projects, including serving as a team member on a project that developed a five-year plan that would renovate the manufacturing information systems. Chris enjoys his work at Pine Valley Furniture and wishes to continue moving up the information systems…arrow_forwardPaul Bergey is in charge of loading cargo ships for International Cargo Company (ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana. An agricultural commodities dealer wants to transport the following products aboard this ship. Commodity A B C D Amount Available (tons)4,8002,5001,2001,700 Volume per Ton (cubic feet) 40256055 Profit per Ton ($)70506080 Paul can elect to load any and/or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions. Cargo Hold Forward Center Read Weight Capacity (tons) 3,000 6,000 4,000 Volume Capacity (cubic feet) 145,000 180,000 155,000 More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10% of the weight in the rear cargo hold, and the center cargo hold must be between 40% and 60% of the total…arrow_forwardDavid Joseph is a supermarket chain manager based in Milwaukee, Wisconsin. He wants to establish business relations with China because China is part of the fastest-growing economies in the world. Through one of his Chinese employees, Wang Xin, David reached an agreement to import green tea from a farm animal products import and export company in Zhejiang Province, China. The goods should be in time to reach the sales peak of Thanksgiving. David himself is also a tea lover, and he is very struck by the quality of this tea, and the packaging is better than he expected. He is looking forward to tea selling in his supermarket and even tirelessly lets Wang Xin write some bilingual advertisements for tea in local mainstream newspapers or broadcast on the radio. Because of the small volume of transactions, the freight for each transaction is relatively high. To make a profit, David's accounting department suggested that the price of Chinese green tea could be set at a slightly higher price…arrow_forward
- A sports apparel company has received an order for a college basketball team’snational championship T-shirt. The company can purchase the T-shirts from textile factoriesin Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies inthe United States that silk-screen the shirts before they are shipped to distribution centers.Following are the production and transportation costs ($/shirt) from the T-shirt factories tothe silk-screen companies to the distribution centers, plus the supply of T-shirts at thefactories and demand for the shirts at the distribution centers (a) Formulate this problem in Excel and (b) determine the optimal shipments to minimize totalproduction and shipping costs for the apparel company.arrow_forwardA sports apparel company has received an order for a college basketball team’snational championship T-shirt. The company can purchase the T-shirts from textile factoriesin Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies inthe United States that silk-screen the shirts before they are shipped to distribution centers.Following are the production and transportation costs ($/shirt) from the T-shirt factories tothe silk-screen companies to the distribution centers, plus the supply of T-shirts at thefactories and demand for the shirts at the distribution centers: Silk-Screen CompanyT-shirt factory T-shirt factory 4. Miami 5. Atlanta 6. Houston Supply(1,000 lbs.)1. Mexico $4 $6 $3 182. Puerto Rico $3 $5 $5 153. Haiti…arrow_forwardTri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows.arrow_forward
- Tri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the counties vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: a. Develop a network representation of this problem. b. Develop a linear programming model that can be used to determine the plan that will minimize total distribution costs. c. Describe the distribution plan and show the total distribution cost. d. Recent residential and industrial growth in Butler County has the potential for increasing demand by as much as 100 units. Which supplier should…arrow_forwardTri-County Utilities, Inc., supplies natural gas to customers in a three-county area. The company purchases natural gas from two companies: Southern Gas and Northwest Gas. Demand forecasts for the coming winter season are as follows: Hamilton County, 400 units; Butler County, 200 units; and Clermont County, 300 units. Contracts to provide the following quantities have been written: Southern Gas, 500 units; and Northwest Gas, 400 units. Distribution costs for the countries vary, depending upon the location of the suppliers. The distribution costs per unit (in thousands of dollars) are as follows: From Hamilton Butler Clermont Southern Gas 10 20 15 Northwest Gas 12 15 18 Develop a network representation of the distribution system. Develop the objective function and the constraints.arrow_forwardCal-Bus Mutual Funds, Inc. located in Pittsburgh. Cal-Bus just obtained $10,000,000 by converting industrial bonds to cash and is now looking for other investment opportunities for these funds. Based on Cal-Bus’s current investments, the firms top financial analyst recommends that all new investments be made in the oil industry, steel industry, or government bonds in US and Europe. The investments, locations and rates of return are shown in the following table. Investment Opportunities for Cal-Bus Mutual Funds Location Investment Projected Rate of Return % Pittsburgh B&E Steel 7.3 Oakland Oil 8.6 Pittsburgh Steel 6.8 New York City Atlantic Oil 8.9 Pacific Oil 10.5 Huber Steel 6.8 Midwest Steel 6.5 Government Bonds 4.5 Europe Buckingham Steel 8.2 Eiffel Oil 7.2 Florence Oil 7.6 EU Government Bonds 5.3 What portfolio recommendations – investments and amounts – should be made for the…arrow_forward
- A city has two high schools. The first school has a maximum enrollment of 900 students and the second school has a maximum enrollment of 550 students. The city is divided into two regions: Inner City and Suburbs. There are at least 500 students in the Inner City region and at least 800 students in the Suburbs region. The annual transportation cost varies by region as shown in the table.arrow_forwardThe Midlands Field Produce Company contracts with potato farmers in Colorado, Minnesota, North Dakota, and Wisconsin for monthly potato shipments. Midlands picks up the potatoes at the farms and ships mostly by truck (and sometimes by rail) to its sorting and distribution centers in Ohio, Missouri, and Iowa. At these centers the potatoes are cleaned, rejects are discarded, and the potatoes are sorted according to size and quality. They are then shipped to combination plants and distribution centers in Virginia, Pennsylvania, Georgia, and Texas, where the company produces a variety of potato products and distributes bags of potatoes to stores. Exceptions are the Ohio distribution center, which will accept potatoes only from farms in Minnesota, North Dakota, and Wisconsin, and the Texas plant, which won’t accept shipments from Ohio because of disagreements over delivery schedules and quality issues. Following are summaries of the shipping costs from the farms to the distribution centers…arrow_forwardTommy Hilfiger is currently considering to source certain textile goods, Tommy Jeans, from Mexico. The estimated shipping time from Mexico to the U.S. for each shipment of Tommy Jeans is 4 days and the estimated freight cost of each shipment is $800. On the other hand, the current average shipping time from Vietnam to the U.S. for each shipment of Tommy Jeans is 23 days and the average freight cost is $2300. Even though the shipping time and freight cost seem to be much lower in case of Mexico, Tommy Hilfiger management is concerned about the production cost of each Jeans shipment. The management anticipates that the production cost of each Jeans shipment will be higher in Mexico compared to Vietnam. However, Tommy Hilfiger management has decided that even if the total cost (sum of production cost, freight cost, and holding cost) remain similar to Vietnam, Tommy Hilfiger will still source Jeans from Mexico because of the reduced shipping time, which, in turn, will result in better…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,