The Rockhead Quarry produces four types of stone sculptures: Figures, Figureines, Free forms, and Statues. Each product sells for the price below and requires the following hours of work for cutting and chiseling stone and polishing the final product: Type of Product Operation
Figures Figurines Free Forms Statues
Cutting 30 5 45 60
Chiseling 20 8 60 30
Polishing 0 20 0 120
Price 280 40 500 510
All products will be sold. Rockhead Quarry work force has production capacity to allocate 300 hours to cutting, 180 hours to chiseling and 300 hours to polishing in any week. Create and solve a linear program to maximize the weekly profit in Excel. (Assume that the quarry can make and sell fractional numbers of each product).