In: Operations Management
Q3. Optimal number of bats manufactured if there is no constrains and maximizing Profit:
1. Slugger Bats: 120
2. Launcher Bats : 45
Formula for Cell D2 : =640-4*C2
Formula for Cell D3 : =450-3*C3
Formula for Cell E2 : =(C2-B2)*D2
Formula for Cell E3 : =(C3-B3)*D3
Formula for Cell E4 : =SUM(E2:E3)
Solver constraints:
Q4. No , the point found in Q3 is not feasible with Constraints. With the constraint, demand for Slugger bat is 84 and for Launcher bat is 32 (rounding to the nearest integer)
Formula for F2: =2*D2
Formula for F3: =2*D3
Solver Parameters: