Load the Solver add-in if it is not already loaded. Set the objective to calculate the highest Net Profit possible. Use the units sold as changing variable cells. Use the Limitations section of the spreadsheet model to set a constraint for raw materials (The raw materials consumed must be less than or equal to the raw materials available). Use cell references to set constraints. Set a constraint for labor hours. Use cell references to set constraints. Set a constraint for maximum production capability. Units sold

must be less than or equal to maximum capability per week . Use cell references to set constraints. Solve the problem. Generate the Answer Report and Keep Solver Solution

A B C Delta Paint 3 Input A Units Sold 100 5 Unit Selling Price S 30.00 Employee Hourly Wage 15.00 7 Maximum Capability per week 200 B 9 Limitations 10 Raw Materials in Units 15000 11 Required raw materials per unit 3 12 Required Labor Hours Per Gallor 0.25 13 Labor Hours available 2,000 14 15 Expenses 16 Raw Materials Consumed 300 17 Labor Hours Consumed 25 18 Total Production Cost S 375.00 19 20 Income 21 Gross Profit 3,000 22 Net Profit 2,625