Question: How can I draw total cost lines for multiple items with different optputs in one chart? Please note that some have fixed costs and some
How can I draw total cost lines for multiple items with different optputs in one chart? Please note that some have fixed costs and some do not
| when the demandoutput) is 10000 | ||||
| output | Fixed costs | Variabe costs per unit | Total cost | |
| Process 1 | 10000 | $200,000 | $16 | $360,000 |
| Process 2 | 10000 | $240,000 | $14 | $380,000 |
| Vendor A | 10000 | $0 | $20 | $200,000 |
| Vendor B | 10000 | $0 | $18 | $180,000 |
| Vendor C | 10000 | $0 | $19 | $190,000 |
| when the demandoutput) is 60000 | ||||
| output | Fixed costs | Variabe costs per unit | Total cost | |
| Process 1 | 60000 | $200,000 | $16 | $1,160,000 |
| Process 2 | 60000 | $240,000 | $14 | $1,080,000 |
| Vendor A | 60000 | $0 | $20 | $1,200,000 |
| Vendor B | 60000 | $0 | $18 | $1,080,000 |
| Vendor C | 60000 | $0 | $19 | $1,140,000 |
The correct one is the following kind of chart, but I can't do it, If possible I would like to know the steps in excel. thank you!

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
