Question: IM1 IM2 IM3 IM4 IM5 Available Quantities 460 300 100 450 950 Cost per 1 of Each $ 3.38 $ 30.48 $ 35.86 $ 140.00
| IM1 | IM2 | IM3 | IM4 | IM5 | |
| Available Quantities | 460 | 300 | 100 | 450 | 950 |
| Cost per 1 of Each | $ 3.38 | $ 30.48 | $ 35.86 | $ 140.00 | $ 3.00 |
| Requirements | IM1 | IM2 | IM3 | IM4 | IM5 |
| C1 | 3 | 1 | 0 | 1 | 2 |
| C2 | 0 | 0 | 3 | 6 | 8 |
| C3 | 2 | 3 | 2 | 3 | 2 |
REFERENCING THE TABLE ABOVE***
I included the answers for the majority of the problem... I am needing help on part C (underlined)
- 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 5 input 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:
- What is the per unit profit margin for products C1, C2, and C3?
Complete the table below: (5 points)
ANSWER:
|
| C1 | C2 | C3 |
| Profit per Unit | $49.18 | $354.11 | $218.36 |
- If the company were required to produce at least 15 units of C1, 28 units of C2 and 5 units of C3:
- What would be their total profit? (5 points) ANSWER: $11,744.58
- How much quantity of the input materials are consumed? (5 points)
ANSWER:
|
| Total Consumed |
| IM1 | 55 |
| IM2 | 30 |
| IM3 | 94 |
| IM4 | 198 |
| IM5 | 264 |
- Identify the input materials that are constraining the ability of the company to increase their profit.
List the input materials below: (5 points)
ANSWER: IM3 is constraining the company from increasing their profit.
- The company would like to know the most they should pay to an outside vendor for each additional input material identified in part b. iii. (Keep all constraints added in part b.)
Complete the table below: (5 points)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
