Share
Explore BrainMass

# Cost and Profit Functions

Please answer questions, listed below and also shown in original format in the attachment; show work and explain in Microsoft Word and Excel how you came to each solution.

1. As part of its planning process, the Sam Manufacturing Company must determine the mix of its products to be manufactured next year. The company produces two principal product lines for the commercial construction industry, a line of circular saws and a line of table saws. These two lines share the same production capacity and are sold through the same supply chain. The average profit for each circular saw is \$900 and the average profit for each table saw is \$600. There is a maximum of 4,000 hours of fabrication capacity available per month and a maximum of 5,000 hours of assembly capacity available per month. Each circular saw requires 2 hours of fabrication and 1 hour of assembly and each table saw requires 1 hour of fabrication and 2 hours of assembly. The marketing department estimates that the maximum demand for both product lines will be 3,500 per month next year. Formulate this LP problem and solve it graphically to determine the number of each line of saw Strayer should produce per month next year.

3. Ruby's Fertilizer company ships fertilizer from two plants to three customers. The shipping cost per ton of fertilizer from each plant to each customer is:

Customer

Plant A B C

1 \$15 \$30 \$20

2 20 25 15

Plant 1 has a monthly capacity of 1,000 tons and Plant 2 has a monthly capacity of 2,000 tons. The monthly customer demand is: A=500 tons, B=1,500 tons, and C=1,000 tons. Formulate an LP problem to determine how much fertilizer should be shipped from each plant to each customer per month. Use solver to make a decision. Show your work.

#### Solution Summary

Cost and Profit Functions are exemplified.

\$2.19