![Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics](https://www.bartleby.com/isbn_cover_images/9781285418681/9781285418681_largeCoverImage.gif)
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 34QP
a)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
b)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Trending nowThis is a popular solution!
![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
Suppliers A, B, and C supply components to three plants -- F, G, and H via two transshipment facilities -- T1 and T2. It costs $4 to ship from T1 regardless of final destination and $3 to ship to T2 regardless of supplier. Shipping to T1 from A, B, and C costs $3, $4, and $5, respectively, and shipping from T2 to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. The Logistics Manager has come to you for help.
Answer the following question:
Which of these is not an element of the objective function?
Group of answer choices
4D-T1
600T1
9T2-G
3C-T2
Plz do fast asap
A supplier ships goods from Richmond, VA to three market places in 3 cities (Chicago, IL; Athens, GA;
St. Luis, MO). The supplier can ship every day, every other day, or every third day.
There is a penalty of $0.30/cwt for each day delayed.
Consolidating shipments allows for lower transportation costs from larger loads, but incurs penalty
costs due to the delay.
Transportation Rate
(S/cwt)
Shipment
City
Weight/day
LTL
50,000 lb
50000 lb
Chicago, IL
18,000 lb (180 cwt)
1.50
1.25
Athens, GA
15,000 lb (150 cwt)
1.35
1.00
St. Luis, MO
12,000 lb (120 cwt)
2.00
1.50
Total
45,000 Ib = 450 cwt
Find what is the cost for the following:
Shipping Every Day
Shipping on the alternate Day (every two days)
Shipping every three Day
A supplier ships goods from Richmond, VA to three market places in 3 cities (Chicago, IL; Athens, GA;
St. Luis, MO). The supplier can ship every day, every other day, or every third day.
There is a penalty of $0.30/cwt for each day delayed.
Consolidating shipments allows for lower transportation costs from larger loads, but incurs penalty
costs due to the delay.
Transportation Rate
(S/cwt)
Shipment
City
Weight/day
LTL
50,000 lb
50000 Ib
Chicago, IL
18,000 lb (180 cwt)
1.50
1.25
Athens, GA
15,000 lb (150 cwt)
1.35
1.00
St. Luis, MO
12,000 lb (120 cwt)
2.00
1.50
Total
45,000 lb = 450 cwt
!3!
Find what is the cost for the following:
Shipping Every Day
Shipping on the alternate Day (every two days)
Shipping every three Day
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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
- The new software organization requires a new point of sale and stock control system for their many stores throughout Pakistan to replace their aging mini-based systems. A sales assistant will be able to process an order by entering product numbers and required quantities into the system. The system will display a description, price, and available stock. In-stock products will normally be collected immediately by the customer from the store but may be selected for delivery to the customer's home address for which there will be a charge. If stock is not available, the sales assistant will be able to create a backorder for the product from a regional warehouse. The products will then either be delivered directly from the regional warehouse to the customer's home address, or the store for collection by the customer. The system will allow products to be paid for by cash or credit card. Credit card transactions will be validated via an online card transaction system. The system will produce…arrow_forwardE-5 Boston Executive, Inc., produces executive limousines and currently manufactures the mini-bar inset at these costs: (refer the attached image) The company received an offer from Elite Mini-Bars to produce the insets for $2,100 per unit and supply 1,000 mini-bars for the coming year’s estimated production. If the company accepts this offer and shuts down production of this part of the business, production workers and supervisors will be reassigned to other areas. Assume that for the short-term decision-making process demonstrated in this problem, the company’s total labor costs (direct labor and supervisor salaries) will remain the same if the bar inserts are purchased. The specialized equipment cannot be used and has no market value. However, the space occupied by the mini-bar production can be used by a different production group that will lease it for $55,000 per year. Should the company make or buy the mini-bar insert?arrow_forwardValles Galactic Industries (VGI) owns a small company (VGI-Durango Sur) that manufactures various electronic products for original equipment manufacturers.   Customer companies provide engineering designs, materials lists, and some unique materials. VGI-DS provides labor and space for the manufacturing and assembly operations and stocking a variety of inventory items for production, such as wire, cables, some electronic components, etc. Thus, VGI-DS orders a variety of components and raw materials by contract. The labor pool is primarily composed of about 100 retirees picking up extra cash by working four to six-hour shifts. Thus, the assembly operations must be simple and easy to teach.  Skilled employees must do several raw material conversions for packaging—there are currently three such employees. VGI-DS receives forecasts from VGI headquarters for planned production for two years on a rolling quarterly basis. Staff at VGI-DS develop schedules and inventory plans based on this…arrow_forward
- MS Company is a Trading Company involved in Import and export trade. With various suppliers from Europe and Asia, MS has to keep track of the activities of its suppliers and the entire supply chain. Indeed, MS has to ensure that quality standards and other production standards like occupation safety, labour and human rights are upheld. The shipment process also has its own challenges ranging from damage due to poor handling in shipment containers, loss of goods on transit due to theft or as a result of sea jettisoning practice, and delays in delivery.  Considering MS’s internal operations, the company equally has challenges of managing the same. MS has both bonded warehouses and stores with a very large workforce. The employees are a responsibility of MS company. And given that they work in a risky environment and conditions, MS is vulnerable to heavy expenses in form of compensation and life cover for its employees in case these risks become issues or materialize. There’s also need…arrow_forwardMS Company is a Trading Company involved in Import and export trade. With various suppliers from Europe and Asia, MS has to keep track of the activities of its suppliers and the entire supply chain. Indeed, MS has to ensure that quality standards and other production standards like occupation safety, labour and human rights are upheld. The shipment process also has its own challenges ranging from damage due to poor handling in shipment containers, loss of goods on transit due to theft or as a result of sea jettisoning practice, and delays in delivery.  Considering MS’s internal operations, the company equally has challenges of managing the same. MS has both bonded warehouses and stores with a very large workforce. The employees are a responsibility of MS company. And given that they work in a risky environment and conditions, MS is vulnerable to heavy expenses in form of compensation and life cover for its employees in case these risks become issues or materialize. There’s also need…arrow_forwardMS Company is a Trading Company involved in Import and export trade. With various suppliers from Europe and Asia, MS has to keep track of the activities of its suppliers and the entire supply chain. Indeed, MS has to ensure that quality standards and other production standards like occupation safety, labour and human rights are upheld. The shipment process also has its own challenges ranging from damage due to poor handling in shipment containers, loss of goods on transit due to theft or as a result of sea jettisoning practice, and delays in delivery.  Considering MS’s internal operations, the company equally has challenges of managing the same. MS has both bonded warehouses and stores with a very large workforce. The employees are a responsibility of MS company. And given that they work in a risky environment and conditions, MS is vulnerable to heavy expenses in form of compensation and life cover for its employees in case these risks become issues or materialize. There’s also need…arrow_forward
- MS Company is a Trading Company involved in Import and export trade. With various suppliers from Europe and Asia, MS has to keep track of the activities of its suppliers and the entire supply chain. Indeed, MS has to ensure that quality standards and other production standards like occupation safety, labour and human rights are upheld. The shipment process also has its own challenges ranging from damage due to poor handling in shipment containers, loss of goods on transit due to theft or as a result of sea jettisoning practice, and delays in delivery.  Considering MS’s internal operations, the company equally has challenges of managing the same. MS has both bonded warehouses and stores with a very large workforce. The employees are a responsibility of MS company. And given that they work in a risky environment and conditions, MS is vulnerable to heavy expenses in form of compensation and life cover for its employees in case these risks become issues or materialize. There’s also need…arrow_forwardMark Ewing has decided to enter contract with uber service provider in his area. The driver offers a car variety of mileage or distance to be travelled to him. All contracts were to be signed for three years. The first option has a monthly rent of P3,000, with a total mileage allowance of 36,000 kilometers (an average of 12,000 kilometers per year) and a cost of P35 per kilometer for any kilometers over 36,000. The following table summarizes each of the Uber Service Contract offered to him: 3-Year Contract Monthly Cost Mileage Allowance Cost Per Excess Kilometer Option A P3,000 30,000 P 35 Option B P3,500 45,000 P 25 Option C P4,000 54,000 P 15  Mark has estimated that, during the 3 years of the agreement, there is a 40% chance he will drive an average of 12,000 kilometers per year, a 30% chance he will drive an average of 15,000 miles per year, and a 30% chance that he will drive 18,000 miles per year. In evaluating the options, Mark would…arrow_forwardMS Company is a Trading Company involved in Import and export trade. With various suppliers from Europe and Asia, MS has to keep track of the activities of its suppliers and the entire supply chain. Indeed, MS has to ensure that quality standards and other production standards like occupation safety, labour and human rights are upheld. The shipment process also has its own challenges ranging from damage due to poor handling in shipment containers, loss of goods on transit due to theft or as a result of sea jettisoning practice, and delays in delivery.  Considering MS’s internal operations, the company equally has challenges of managing the same. MS has both bonded warehouses and stores with a very large workforce. The employees are a responsibility of MS company. And given that they work in a risky environment and conditions, MS is vulnerable to heavy expenses in form of compensation and life cover for its employees in case these risks become issues or materialize. There’s also need…arrow_forward
- Mount Isa Mines is one of the world’s great metal mines. Its main operations are at Mount Isa, in Queensland, Australia, where it mines adjacent deposits of copper and silver-lead-zinc ores. Production levels changes with world demand and prices, but in atypical year 7 million tonnes of ore are mined to give 150,000 tonnes of copper and lead (containing silver) and 200,000 tonnes of zinc. Mount Isa has serious transport problems. It produces huge quantities of ore in a remote area of Australia, while the main demand for finished metals is in the industrialised areas of the world, particularly Europe. The problem is to process the ores and move them to final markets as cheaply as possible. You can see the scope of the problem from an outline of the journey for copper, this starts with underground explosions to break up the ore body. The broken ore is collected by front-end loaders and put onto ore trains that carry it to underground crushers. The crushed ore is then hoisted to the…arrow_forwardMount Isa Mines is one of the world’s great metal mines. Its main operations are at Mount Isa, in Queensland, Australia, where it mines adjacent deposits of copper and silver-lead-zinc ores. Production levels changes with world demand and prices, but in atypical year 7 million tonnes of ore are mined to give 150,000 tonnes of copper and lead (containing silver) and 200,000 tonnes of zinc. Mount Isa has serious transport problems. It produces huge quantities of ore in a remote area of Australia, while the main demand for finished metals is in the industrialised areas of the world, particularly Europe. The problem is to process the ores and move them to final markets as cheaply as possible. You can see the scope of the problem from an outline of the journey for copper, this starts with underground explosions to break up the ore body. The broken ore is collected by front-end loaders and put onto ore trains that carry it to underground crushers. The crushed ore is then hoisted to the…arrow_forwardProblem 16-17 (Algo)The U.S. Airfilter company has hired you as a supply chain consultant. The company makes air filters for residential heating and air-conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in 100 locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U.S. Airfilter supply chain:    QUARTER 1(JANUARYTHROUGHMARCH)   QUARTER 2(APRIL THROUGHJUNE)   QUARTER 3(JULYTHROUGHSEPTEMBER)   QUARTER 4(OCTOBERTHROUGHDECEMBER)   All amounts in millions of U.S. dollarsSales (total quarter):           United states   414   402   520   514Canada   135   96   126   117Europe   41   34   42   25           Cost of goods sold (total quarter)   384   347   453   434           Raw materials at the Louisville plant (end-of-quarter)   73   62…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
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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