Question: Blue Construction has been awarded a contract to supply lumber for contractors working on Blue Village, a mixed residential/retail area for students being constructed on 30 acres of land north of the Blue U. campus. Blue Construction operates two sawmills, one on Reynolda Road and the other on Northwest Blvd. The Reynolda mill costs $30,000 per day to operate and can produce 600 board feet of pine, 450 board feet of spruce, and 300 board feet of oak each day. The Northwest plant costs $38,000 per day to operate and can produce 450 board feet of pine, 600 board feet of spruce, and 750 board feet of oak each day. Blue Construction has orders from 28 contractors for a total of 37,500 board feet of pine, 30,500 board feet of spruce, and 45,000 board feet of oak. How many days should Blue Construction operate each sawmill to minimize its costs and still fulfill its orders?

1. Using mathematical symbols and numbers, specify the objective function for this problem and state if you are trying to maximize or minimize it.

b. Using mathematical symbols and numbers, specify all constraints for this problem.

c. Analyze the data and managerially interpret the results. Include Excel output to support your analysis.

Price: $2.99

Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document