Production Planning. The Bogard Corporation produces three types of bookcases, which it sells to large office supply companies. The production of each bookcase requires two machine operations, trimming and shaping, followed by assembly, which includes inspection and packaging. All three types require 0.4 hours of assembly time, but the machining operations have different processing times, as shown below, in hours per unit:
Standard Narrow Wide
Trimmer 0.2 0.4 0.6
Shaper 0.6 0.2 0.5
Each machine is available 150 hours per month, and the current size of the assembly department provides capacity of 600 hours. Each bookcase produced yields a unit profit contribution as follows: Standard Narrow Wide
Profit $8 $6 $10 .
What are the optimal production quantities for the company? What is the pattern in the optimal allocation?
Fertilizing the Lawn. The facilities manager at Oxbridge University is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table.
Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. There is virtually unlimited supply of each kind of fertilizer.
How much of each fertilizer should be purchased to satisfy the requirements at minimum cost?
If this can be completed by Thursday morning that is great......I seems a bit lengthy, but maybe easier than it looks as well. If the price is too low we can work out a deal on the bonus, please let me know...
We are just now covering this chapter....so far we have covered Linear and non-linear optimization the basics from the previous chapter....this begins chapter 11 with allocation models, covering models and blending models. Really the basics for Excel modeling. The following is a link to the online chapter......http://my.safaribooksonline.com/book/management/9780470530672/linear-optimization/linear_optimization
Thanks Ryan...and the Excel file is greatly appreciated!
Have a wonderful day:)