A firm offers three different prices on its products, depending upon the quantity purchased. Since available...

 

Transcribed Image Text:

A firm offers three different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $13 each for the first 50 units, $12 each for units 51-150, and $11 for each unit over 150. Product 2's profitability is $13 each for the first 40 units, $12 each for units 41-100, and $11 each for each unit over 100. The products each require 3 raw materials to produce (see table below for usages and available quantities). Available Quantity A per unit) 4 Product 1 usage (pounds Product 2 usage (pounds Raw Material per unit) 6 7 9 B C 11 7 Use separable programming to find the optimal production plan. (pounds) 1,900 1,800 2,300 (Leave no cells blank - be certain to enter "O" wherever required. Round the first two answers (units of Product 1 and 2) to the nearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.) 22 units of Product 1 and 50 units of Product 2. The total profit from this plan will be $ 40.00 A firm offers three different prices on its products, depending upon the quantity purchased. Since available resources are limited, the firm would like to prepare an optimal production plan to maximize profits. Product 1 has the following profitability: $13 each for the first 50 units, $12 each for units 51-150, and $11 for each unit over 150. Product 2's profitability is $13 each for the first 40 units, $12 each for units 41-100, and $11 each for each unit over 100. The products each require 3 raw materials to produce (see table below for usages and available quantities). Available Quantity A per unit) 4 Product 1 usage (pounds Product 2 usage (pounds Raw Material per unit) 6 7 9 B C 11 7 Use separable programming to find the optimal production plan. (pounds) 1,900 1,800 2,300 (Leave no cells blank - be certain to enter "O" wherever required. Round the first two answers (units of Product 1 and 2) to the nearest whole number. Round the total profit answer to 2 decimal places and use unrounded unit quantities to compute it.) 22 units of Product 1 and 50 units of Product 2. The total profit from this plan will be $ 40.00