We are supposed to use linear programming and the Solver tool in Excel to come to the solution. Please use a format in Excel similar to the one provided.

You work for the Brad's Nailer Company which manufactures three types of nailers: a pneumatic model, the "ProLine", and a cordless model. You have contracted to supply a national retail chain with all three models of nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. The goal is to maximize your revenue. Your answer will be the number of ProLine nailers to be produced (The number of nailers may not be a whole number, which is acceptable in this chapter.) You work for the Brad's Nailer Company which manufactures three types of nailers: a pneumatic model, the "ProLine", and a cordless model. You have contracted to supply a national retail chain with all three models of nailers. However, Brad's nailer production capability is limited in three departments: production, testing, and packaging. The goal is to maximize your revenue. Your answer will be the number of ProLine nailers to be produced (The number of nailers may not be a whole number, which is acceptable in this chapter.)