Achieving a pre-determined profit in profit maximization using linear programming. Attachments in MS Word and Excel.

Durham Designs manufactures home furnishings for department stores.  Planning is underway for the production of items in the "Wildflower" fabric pattern during the next production period.

Inventory of the Wildflower fabric is 3000 yards.  Five hundred hours of production time have been scheduled.  Four hundred units of packaging material are available.  Each of these values can be adjusted through overtime or extra purchases.

Durham would like to achieve a profit of $3200, avoid purchasing more fabric or packaging material, and use all of the hours scheduled (overtime is allowed).  

See attached file for additional information and table.