solution

One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. Your recommendation should identify and explain at least 3 options. These three options must be based only with information present in the excel production plan and components of LP modeling [decision variables, objective function (prices and variable cost) and resource constraints). The business memo should be 1 to 2 pages. Proper style and grammar are worth 50% of the grade. Your recommendations are worth 50%. ? B ? D E F G Incline Electronics Product 1 6.67 $90.00 Product 2 41.25 $120.00 Product 3 9.17 $150.00 Total Profit $6,925 1 2 3 4 5 Quantity 6 Unit Profit 7 8 9 Machine 1 10 Machine 2 11 Machine 3 12 Total Labor 1 Processing Time (hours per unit) 2 2 3 4 6 4 6 5 9 12 12 Hours Used Hours Available Workers Needed 105 400 3.0000 240 240 6.8571 320 320 9.1429 665 665