3. Refer to sheet titled "03". The data provides the description for three items (C1, C2, and C3) produced by a company and the selling price of each of these items. A combination of Sinput materials (IM) are required to produce each item. The quantity of each material required to produce one unit of an item is shown, along with the cost of each input material, and the quantity of each of the input material available. Based on this information, answer the following questions: a. What is the per unit profit margin for products C1, C2, and C3? Complete the table below. (5 points) b. if the company were required to produce at least 15 units of C1, 28 units of C2 and 5 units of What would be their total profit? (5 points) il How much quantity of the input materials are consumed? (5 points) ill. Identify the input materials that are constraining the ability of the company to increase their profit. List the input materials below: (5 points) c The company would like to know the most they should pay to an outside vendor for each additional input material identified in part b. ll (Keep all constraints added in part b.) Complete the table below. (5 points) IM1 IM2 IM4 IM5 3 C1 3 1 IM3 0 3 2 Sell Price $ 235.80 $ 1,325.69 $ 814.28 6 C3 2 3 N00 8 IM1 460 3.38 Available Quantities Cost per 1 of Each M2 300 30.48 IM3 100 35.86 M5 950 M4 450 140.00 $ $ $ $ $ 3.00 10 11