Question

A contractor, Susan Mayer, has to haul gravel to three building sites. She can purchase as much as 18 tons at a gravel pit in the north of the city and 14 tons at one in the south. She needs 10, 5 and 10 tons at sites 1, 2, and 3 respectively. The purchase price per ton at each gravel pit and the hauling cost per ton are given in the table below. 2 Pit North South Hauling Cost per Ton at Site 1 3 $30 $60 $50 $60 $30 $40 | Price per Ton $100 L $120 Susan also needs to hire the trucks to do the hauling. Each truck can only be used to haul gravel from a single pit to single site. In addition, to the hauling and gravel costs specified, there is a fixed cost of $50 associated with hiring each truck. A truck can haul 5 tons, but it is not required to go full. For each combination of pit and site, there are two decisions to be made: the number of trucks to be used and the amount of gravel to be hauled. Formulate and solve this problem using excel solver. A real estate development firm, Peterson and Johnson, is

Answer 1

Answer Has to haul to three building sites Purchase as much as is tons A gravel pit in the north of the city intens Need, 10 ,5 and 10, at sikes 1, 2 and 2 follow Pilt ② - Lost from North is as North Purchase price. = 100. Hauling lost = 30 Total = 180 Pilt @ North purchase price = 100 Hauling Cost = 60 Total = 160

PiH 3 . North purchas price a 100 . Hauling cast - 50 Total = 150 Cast from south is as follow . Pit South purchas pruce = 120 Hauling cost - 60 Total = 180 Pilt ② :o) south purchase price = 120 Hauling cost . =30 Total = 150

South Purchase price Hauling cost = 120 = 40 are the follow Total = 160 The differnce of these cat Pilt o North = 130 south 180 = 130-180 Delta 3.50 North South = 160 - 150 = 16-150 . Delta .= 10

Pilt ② North = 150 South = 160 - 150-160 Delta =-10 The grequirement based ipo limited is tones from North le tones from south quity. Piht © Required Gravel = 10 Welta from North = -50 Noth.aty ... to Pilt ② Requered Gravel =5 Hello from North 210 :

South aty = 5 BiH @ Required Goavel = 10 Della from North = -10 North.aty = 8 South Gly = 2 Total North aty = loti8 2 = 18 Total South aty = 5th