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 3, Problem 35QP
a)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
b)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
Trending nowThis is a popular solution!
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 & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 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 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 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 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 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
- E-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_forwardThe 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_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_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_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_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_forwardSealy Ltd. is a newly established mattress factory that has calibrated its operations towards supplying high quality mattresses to the hotel trade as well as to the general public. The company intends to maximize it supply chains operations by ensuring that the three macro processes that manage the flow of information, product and funds required to generate, receive and fulfill a customer order is optimized in its operations. The company’s transportation network is also being designed but is being analyzed in terms of possible trade-offs that may have to be made in order to optimize the operation. Additionally, another far reaching decision that the company has to make is regarding the sourcing of raw material for their operations in particular whether to source in house or to outsource the supply chain function. As a new company in the 21st Century it is expected that information technology will play a pivotal role in the operations of the company  Describe the functioning of the…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