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 5, Problem 3.2C
Summary Introduction
Case summary:
Company USE is a package delivery company operating in City A. The expense of Jet fuel is one of the largest operating costs incurred by the company. The company is looking to manage this cost. The goal is to identify the most economic fuel purchasing plan for the previous schedule.
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
A. An Electrical Company has three workshops in Koforidua,
Accra and Kumasi. These workshops produce the following
quantities of electric fan.
Workshops
Monthly production (units)
Koforidua
130
Аccra
70
Kumasi
100
The monthly demand for these fans in three towns: Sunyani, Cape
Coast and Ho is given below:
Destination
Weekly Demand (units)
Sunyani
80
Саре Сoast
110
Но
60
The unit transportation costs per unit (in GH¢000) from the
sources to the destinations are as shown:
To
From
Sunyani
Саре Сoast
Но
Koforidua
9.
14
12
Accra
11
10
6.
Kumasi
12
15
00
As a supply chain and logistics management student, you have completed key aspects of the discipline throughout your qualification, namely, management, logistics, procurement, sustainability, warehouse and inventory management.
This question requires you to reflect on your knowledge and understanding of transportation management as a component of supply chain management. You are required to write a one-page report where you reflect on:
Your experience of learning the discipline of transportation management. Which areas of this module did you find most interesting to learn about? Have you learned anything interesting from a SADC perspective?
Which areas of this module did you find most challenging to learn about? Why?
What are some of the skills you have learned thus far (i.e., reflection, critical thinking, technology, artificial intelligence – or any other) that you believe will be able to assist you
once you have graduated?
In your opinion, based on what you have learned, do…
How can the transportation planners dealing with cases where the results cannot be reduced to a single monetary value?
Chapter 5 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
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 Federal Aviation Administration posts monthly percentage on-time arrival data for all the major airlines on its website. Some airlines are regularly on the top of the list, while others are frequently on the bottom of the list. What type of service gap does this list illustrate? What can airlines on the bottom of the list do to address this gap?arrow_forwardUnlike most other forms of transport the airline industry is heavily regulated and controlled”. Justify this statement with suitable explanation and examples.arrow_forwardThe state of public transport in the city of Lusaka has been a source of concern to Government and the public for a long time. A Zambian company has mooted the idea of coming up with a Public Private Partnership (PPP) with the Lusaka City Council (LCC) with the aim of modernising the transport system in the city by way of introducing modern electric buses. You are a consultant who has been approached by this company requesting you to prepare a information memorandum document to be used for the purposes of ‘selling’ the project to potential financiers. Prepare an information memorandum for the project to be presented to the potential financiers. Among others it should contain the following: The full business description of the project. Any other sponsors apart from the client company and LCC that could be included to make the project a success. An analysis of the key risks facing the project and the ways of mitigating the risks. The proposed financing structure and justification…arrow_forward
- As a supply chain and logistics management student, you have completed key aspects of the discipline throughout your qualification, namely, management, logistics, procurement, sustainability, warehouse and inventory management. This question requires you to reflect on your knowledge and understanding of transportation management as a component of supply chain management. You are required to write a one-page report where you reflect on: • Your experience of learning the discipline of transportation management. Which areas of this module did you find most interesting to learn about? Have you learned anything interesting from a SADC perspective? • Which areas of this module did you find most challenging to learn about? Why? • What are some of the skills you have learned thus far (i.e., reflection, critical thinking, technology, artificial intelligence – or any other) that you believe will be able to assist you once you have graduated? • In your opinion, based on what you have learned, do…arrow_forwardUsing the the 3 methods: Vogel's Approximation Method, Northwest Corner Method and Minimum Cost Method what is the total transportation cost per method?arrow_forwardPlease read the question correctly and accordingly answer Define ‘inbound’ and ‘outbound’ transportation. Compare how these transportation costs differ for an online business such as Amazon and a retailer such as Home Depot when selling home-improvement items such as drills and floor tiles.arrow_forward
- Discuss how a transportation manager might take advantageof the trade-offs between price and service.arrow_forward4.Compare the transportation costs for an online business such as Amazon and a retailer such as Home Depot when selling home-improvement materials.arrow_forwardPlease help me calculate this. What is the total cost using the transportation method.arrow_forward
- What has been the effect of deregulation of transportation prices in the United States?arrow_forwardWhat is a closed-loop transportation scheme, and how does it work? Why is it essential to have dedicated or contracted transportation carriers in such a system?arrow_forwardThe transportation company is it a customer-oriented or a product-oriented company? and Why ?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,