Solutions Plus is an industrial chemicals company that produces specialized cleaning ?uids and solvents for a wide variety of applications. Solutions Plus just received an invitation to submit a bid to supply Great North American railroad with a cleaning ?uid for locomotives. Great North American needs the cleaning ?uid at 11 locations (railway stations); it provided the following information to Solutions Plus regarding the number of gallons of cleaning ?uid required at each location (see Table 6.8):
Solutions Plus can produce the cleaning ?uid at its Cincinnati plant for $1.20 per gallon. Even though the Cincinnati location is its only plant, Solutions Plus has negotiated with an industrial chemicals company located in Oakland, California, to produce and ship
up to 50,000 gallons of the locomotive cleaning ?uid to selected Solutions Plus customer
locations. The Oakland company will charge Solutions Plus $1.65 per gallon to produce the cleaning ?uid, but Solutions Plus thinks that the lower shipping costs from Oakland to some customer locations may offset the added cost to produce the product.
Location Gallons Required Location Gallons Required
Santa Ana 22,418 Glendale 33,689
El Paso 6,800 Jacksonville 68,486
Pendleton 80,290 Little Rock 148,586
Houston 100,447 Bridgeport 111,475
Kansas City 241,570 Sacramento 112,000
Los Angeles 64,761
TABLE 6.9 FREIGHT COST ($ PER GALLON)
Santa Ana — 0.22
El Paso 0.84 0.74
Pendleton 0.83 0.49
Houston 0.45 —
Kansas City 0.36 —
Los Angeles — 0.22
Glendale — 0.22
Jacksonville 0.34 —
Little Rock 0.34 —
Bridgeport 0.34 —
Sacramento — 0.15
The president of Solutions Plus, Charlie Weaver, contacted several trucking companies
to negotiate shipping rates between the two production facilities (Cincinnati and Oakland) and the locations where the railroad locomotives are cleaned. Table 6.9 shows the quotes received in terms of dollars per gallon. Theentries in Table 6.9 identify shipping routes that will not be considered because of the large distances involved. These quotes for shipping rates are guaranteed for one year.
To submit a bid to the railroad company, Solutions Plus must determine the price per
gallon they will charge. Solutions Plus usually sells its cleaning ?uids for 15% more than
its cost to produce and deliver the product. For this big contract, however, Fred Roedel, the director of marketing, suggested that maybe the company should consider a smaller pro?t margin. In addition, to ensure that if Solutions Plus wins the bid, they will have adequate capacity to satisfy existing orders as well as accept orders for other new business, the management team decided to limit the number of gallons of the locomotive cleaning ?uid produced in the Cincinnati plant to 500,000 gallons at most.
You are asked to make recommendations that will help Solutions Plus prepare a bid. Your report should address, but not be limited to, the following issues:
1. If Solutions Plus wins the bid, which production facility (Cincinnati or Oakland)
should supply the cleaning ?uid to the locations where the railroad locomotives are
cleaned? How much should be shipped from each facility to each location?
2. What is the breakeven point for Solutions Plus? That is, how low can the company
go on its bid without losing money?
3. If Solutions Plus wants to use its standard 15% markup, how much should it bid?
I need the excel answer with all info and constraints. Please.
Why Homework Market
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.
If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account.
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. We will always strive to deliver on time.
We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on essay at night. Sleep tight, we will cover your back. We offer all kinds of essay writing services.
No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.
Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied.