Explore BrainMass

Explore BrainMass

    Charleston Textiles-Linear Programming

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    2.Charleston Textiles produces two types of cotton cloth: denim and corduroy. Corduroy is a heavier grade of cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of corduroy requires 3.2 hours of processing time; a yard of denim requires 3.0 hours. Although the demand for denim is practically unlimited, the maximum demand for corduroy is 510 yards per month. The mill has 6500 pounds of cotton and 3000 hours of processing time per month. Charleston Textiles makes a profit of $2.25 per yard of denim and $3.10 per yard of corduroy. The mill wants to maximize profits.

    a.What is the maximum profit given these constraints?
    b.How much cotton and processing time are left over at the optimal solution?
    c.Is the optimal solution sensitive to changes to profit per yard of cloth?

    © BrainMass Inc. brainmass.com June 3, 2020, 9:48 pm ad1c9bdddf

    Solution Preview

    Please see the attached file for complete working of solver in MS Excel to solve linear programming problem.


    Let x1 be the denim yards produced
    Let x2 be the corduory yards produced

    Obejective functions is
    Maximise Profit P = 2.25 x1+ 3.1x2
    Cotton ...

    Solution Summary

    The solution describes the steps in formulating linear model to maximise profit with given capacity, input, time constraints. LP Model is solved by using solver in MS Excel.