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 toreplicate* The Moore \& Harman Company is in the business of buying

*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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!