Question: Marc Hernandezs construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide

Marc Hernandez€™s construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez€™s needs, but shipping costs differ from location to location. The following table summarizes the transportation costs:

(a) Determine Hernandez€™s optimal shipping quantities so as to minimize total transportation costs.
(b) It is the case that Rock Pit and Central Pit can send gravel by rail to Acme for $1 per ton. Once the gravel is relocated, it can be trucked to the jobs. Reformulate this problem to determine how shipping by rail could reduce the transportation costs for the gravel.

TO TONNAGE FROM Central pit Rock pit Acme pit Job requirements JOB1 JOB2 JOB 3 ALLOWANCE $9 $7 $4 $3 : $7 3,000 3a 56 4,000 4.000 2,500 3,750 4,850 (tons)

Step by Step Solution

★★★★★

3.33 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

718-M-S-L-P (1102).xlsx

300 KBs Excel File

Students Have Also Explored These Related Statistics Questions!

Marc Smith's construction firm currently has three projects under way in various counties in Iowa. Each requires a specific supply of gravel. Three gravel pits are available in Iowa to provide for...

Required Tasks: a. Use the data that Angie has collected to develop and analyze the appropriate control charts for this process. Be sure to label each control chart carefully and also to identify the...

In December 2005, Bill Stock, general manager for the Louisiana Division of Coastal States Chemicals and Fertilizers, received a letter from Fred McNair of the Cajan Pipeline Company, which notified...

13 Marc Hernandezs construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandezs needs, but...

Marc Hernandezs construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandezs needs, but...

Marc Hernandez's construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez's needs, but...

QSO320 Mgmt Science Thru Spreadsheets Problem 5-13 Part A and Part B I need help with the second portion of this activity (Transshipment). Thanks in advance for any help that you can offer. I don't...

Marc Hernandez's construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez's needs, but...

" 5 - 1 3 Marc Hernandez's construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez's...

How much do you have to deposit today so that beginning 11 years from now you can withdraw $10,000 a year for the next five years (Periods 11 through 15) plus an additional amount of $20,000 in the...

Sketch a direction field for the differential equation. Then use it to sketch three solution curves. 10. y' - x - y 9. y' -1 + y

One reason for the existence of agency problems between managers and stockholders is that: stockholders have unreasonable expectations about managerial performance. managers and stockholders agree...

Companies should use liquidation values to report assets if which of the following conditions exists? a. There are changes in the value of the dollar. b. The periodicity assumption is applied. c. The...

Major Bill Bligh, director of the Army War College's new 6-month attach training program, is concerned about how the 20 officers taking the course spend their precious time while in his charge. Major...

Mick Garcia, a certified financial planner (CFP) has been asked by a client to invest $250,000. This money may be placed in stocks, bonds, or a mutual fund in real estate. The expected return on...

Hinkel Rotary Engine, Ltd., produces four- and sixcylinder models of automobile engines. The firm's profit for each four-cylinder engine sold during its quarterly production cycle is $1,800 $50X1,...

Balance sheet effects of leasing Two textile companies, McDaniel-Edwards Manufacturing and Jordan-Hocking Mills, began operations with identical balance sheets. A year later both required additional...

PLEASE ANSWER BOTH USING A BA II FINANCE CALCULATOR AND SHOW KEY STROKES. Will rate all answers, thanks!! "ROOM FOR INTERPRETATION RELATIVE TO THIS INSTRUCTION, AND NO APPEALS WILL BE CONSIDERED. 1....

Assume that Valley Forge Hospital has only the following three payer groups: The hospital s fixed costs are $ 3 8 million.