12.60 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.

10 ! Ble Edit Your Insert Format Iods Data Window Help E13 1 Data input SUM(B13.013) 2 Contribution margin per unit 3 Resource constraints 4 Direct materials, per unit Products 5 Design hours per unit 6 Machining, hours per unit 7 Demand constraints 8 Bangles sales, units 9 Beads sales, units 10 Initial guess at sales levels Baubles Bangles Beads $ 12.00 $8.00 $ 14.00 OM Constraint 22.00 8.00 13.00 less than 800 4.00 1.00 5.00 less than 120 2.00 1.00 2.00 less than 80 no more than 30 at least 10 10 10 10 Products Baubles Bangles Beads Tatal Constraint 10 30 10 50 120 $240 $140 $ 500 220 240 130 590 600 40 30 50 120 120 20 30 20 70 80 30 30 30 10 10 10 11 Linear Program Model 12 Units sold (replaced by the optimal solution), 13 Contribution margin (B2B12,C2C12,02 D12) 14 Material used (B4 B12, etc.) 15 Design hours used (85-812, etc.) 16 Machining hours used (BS-B12, etc.) 17 Sales of Bangles (C12) 18 Sales of Beads (012) 19 Ready 12-62 12.60Sheet 1 ex