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!

How can I draw total cost lines for multiple

Process 1-+ Process 2 Vendor A* Vendor B* Vendor C 2,500,000 2,000,000 1,500,000 TOTAL COST 1,000,000 500,000 0,0 0,0 20,000 40,000 60,000 80,000 100,000 120,000 VOLUME

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!