Excel homework
ProfessorGrayson
16flbe2.docxImagine you have THREE ways to make WIDGETs.
Fix the old machine, which costs $ 5000. Each widget made will cost $ 11 each.
Buy a used machine, which costs $ 8000. Each widget made will cost $ 9 cents each.
Buy a new machine, which costs $ 12000. Each widget made will cost $ 6.50 cents each.
On sheet#1, create a chart with FIVE columns
|
|
A |
B |
C |
D |
E |
|
1 |
# of units |
Fix Old |
Buy Used |
Buy New |
Cheaper |
|
2 |
1450 |
|
|
|
|
|
3 |
1500 |
|
|
|
|
|
4 |
…. |
|
|
|
|
|
5 |
1750 |
|
|
|
|
Note: I ran the chart from 1450 units to 1750 units in 50 unit increments.
Note: You will need a NESTED IF to determine which of the THRE options is cheaper.
Hint:
=if(b2=min(b2:d2),”FixOld”,if(c2=min(b2:d2),”BuyUsed”,”BuyNew”))
There are other ways of doing this.
Besides filling in the graph, you will need to produce a graph with THREE lines – FixOld, BuyUsed, BuyNew.
The horizontal axis is dollars. The vertical axis is units.
There is no GOAL-SEEK portion to this problem.
As you can see, sometimes FIXOLD is cheaper, sometimes BuyUsed is cheaper, sometimes BuyNew is cheaper.
You do not need a WORD document for this assignment.
BE2 (your name).XLSx
