Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PCB Chemicals PCB chemicals of Florida makes various chemical compounds. One compound is Bug Stomper insecticide. Bug stomper is used to ward off the dreaded

PCB Chemicals
PCB chemicals of Florida makes various chemical compounds. One compound is Bug Stomper
insecticide. Bug stomper is used to ward off the dreaded Florida Palmetto Bugs. A palmetto bug is like a
3 inch long cock roach on steroids, that smells bad, can fly, and is extremely aggressive. They typically
come out at night from behind the frig and like to fly into peoples faces. PCB also makes the plastic jugs
bug stomper is sold in. Plastics jugs are made in one location, filled in another and then sent to a
distribution center for sale to local exterminators.
Plastic jugs are made in Tampa and Jacksonville. The process takes poly resin pellets from a train car
melts them and injection molds a jug. The gallon jug is then tested for quality by measuring the
thickness of the plastic at bend points and pressurizing the jug with air to see if it leaks. Jugs are then
put in a chamber and reheated and flooded with fluorine gas to seal the plastic (else the bug stomper
juice would eat through the jug). It costs $.35 to mold a jug in Tampa and $.25 to mold a jug in
Jacksonville. Each plant can mold 150,000 jugs a month. The molded jugs are placed in train cars and
sent to filling plants in Plant City, Tallahassee and Yehaw Junction.
At the filling plants the jugs are filled with bug stomper and labeled. It costs $.9 to fill a jug in Plant City,
$1.25 to fill one in Tallahassee, and $1.00 to fill one in Yehaw Junction. Each filling plant can fill 75,000
jugs a month. The filled jugs are sent to the distribution centers in Tampa (separate facility from jug
molding), Orlando, Miami and Panama City. Next months demand is as follows
Gallon Jugs
Tampa 50,000
Orlando 40,000
Miami 70,000
Panama City 30,000
Shipping costs for empty jugs are as follows
Cost Per jug $
To
From Plant City Tallahassee Yehaw Junction
Tampa .05.2.15
Jacksonville .2.06.22
Shipping costs for filled jugs are as follows
Cost per Jug $
To
From Tampa Orlando Miami Panama City
Plant City .1.1.3 CGTFH
Tallahassee .2.15.4.1
YehawJunction CGTFH .1.2.3
CGTFH = Cant get there from here.
PCB needs to know what the most cost effective plan would be to meet next months demand. How
many jugs should be molded at each molding plant, where should they be sent? How many jugs will
each filling plant fill, where will they be sent. How much will it cost? What will be the overall average
cost per jug when all jugs have arrived at the distribution centers?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago