Question: *Please provide excel link with solution or show excel inputs to replicate* The Moore & Harman Company is in the business of buying and selling


*Please provide excel link with solution or show excel inputs to replicate*
The Moore \& Harman Company is in the business of buying and selling grain. An important aspect of the company's business is arranging for the purchased grain to be shipped to customers. If the company can keep freight costs low, profitability will improve. The company recently purchased five rail cars of grain at Muncie, Indiana; three rail cars at Brazil, Indiana; and six rail cars at Xenia, Ohio. Twelve carloads of grain have been sold. The locations and the amount sold at each location are as follows: All shipments must be routed through either Louisville or Cincinnati. Shown are the shipping costs per bushel (in cents) from the origins to Louisville and Cincinnati and the costs per bushel to ship from Louisville and Cincinnati to the destinations. A rail car holds 3,200 bushels of grain. Cost ner bushel in cents Cost per bushel in cents Determine a shipping schedule that will minimize the freight costs necessary to satisfy demand. Enter the values that complete the shipping schedule. Numher nf Care th Shin Number of Cars to Ship The Moore \& Harman Company is in the business of buying and selling grain. An important aspect of the company's business is arranging for the purchased grain to be shipped to customers. If the company can keep freight costs low, profitability will improve. The company recently purchased five rail cars of grain at Muncie, Indiana; three rail cars at Brazil, Indiana; and six rail cars at Xenia, Ohio. Twelve carloads of grain have been sold. The locations and the amount sold at each location are as follows: All shipments must be routed through either Louisville or Cincinnati. Shown are the shipping costs per bushel (in cents) from the origins to Louisville and Cincinnati and the costs per bushel to ship from Louisville and Cincinnati to the destinations. A rail car holds 3,200 bushels of grain. Cost ner bushel in cents Cost per bushel in cents Determine a shipping schedule that will minimize the freight costs necessary to satisfy demand. Enter the values that complete the shipping schedule. Numher nf Care th Shin Number of Cars to Ship
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
