12.58 A computer spreadsheet solution of a linear programming model follows:

Required Write the linear programming objective function and constraints in equation form.

b. Explain the meaning of each cell in the linear program model section of the spreadsheet.

Insert Format Iools Data indow Help Acrobat =SUM(B226 0226) 100% E226 213 12.60 214 Data input Products Whos Whats Wheres Constraint 215 Contribution margin per unit $ 8.00 $ 7.00 $ 9.00 216 Resource constraints 217 Direct materials, per unit 12.00 3.00 6.00 less than 500 218 Design hours per unit 1.00 2.00 3.00 less than 80 219 Machining, hours per unit 2.00 1.00 1.00 less than 80 220 Demand constraints 221 Whos sales, units ne more than 20 222 Wheres sales, units at least 30 223 Initial guess at sales levels 10 10 10 224 Linear Program Model Products Whos Whats Wheres Total Constraint 225 Units sold (replaced by the optimal solutio 30 11 9 50 226 Contribution margin $ 240 $ 77 $ 81 $ 398 227 Material used 360 33 54 447 500 228 Design hours used 30 22 27 79 80 229 Machining hours used 60 11 9 80 80 230 Sales of Whos 11 11 20 9 9 30 231 Sales of Wheres 232 HP Excses Problems Case/ Ready 14.