Question

Create a graph of Unit Cost versus Unit Number (displaying Learning Rate) for an initial unit cost of $100 and a production run of 1,000 units. Learning rates should vary from 60% to 100% and should use increments of 5%. Ensure you label the x- and y-axis and provide a graph title. The graph should be in its own worksheet. For help with moving the graph to a new sheet, go to How to Move a Chart onto a New Sheet in Excel (Links to an external site.)Links to an external site..

Answer 1

Create a table of Unit cost vs unit number of learning rates from 60% to 100% in increments of 5%

Unit Cost Learning rate Unit 85% 100% 65% 75% 95% Number 100.00 100.00 100.00 100.00 100.00100.00 100.00100.00 100.00 2 60.00 65.00 70.00 75.00 80.00 85.00 90.00 95.00 100.00 49.00 36.00 42.25 56.25 64.00 72.25 81.00 90.25 100.00 72.90 21.60 27.46 34.30 42.19 51.20 61.41 85.74 100.00 40.96 16 12.96 17.85 24.01 31.64 52.20 65.61 81.45 100.00 44.37 32 7.78 11.60 16.81 23.73 32.77 59.05 77.38 100.00 73.51 100.00 64 4.67 7.54 11.76 17.80 26.21 37.71 53.14 11 128 4.90 47.83 2.80 8.24 13.35 20.97 32.06 69.83 100.00 12 256 43.05 1.68 3.19 5.76 10.01 16.78 27.25 66.34 100.00 4.04 13 512 1.01 2.07 7.51 13.42 23.16 38.74 63.02 100.00 14 1000 0.62 1.37 2.86 5.69 10.82 19.80 34.99 59.98 100.00 15 17 18 19

FORMULAS:

B4 =100*B$3^(LN($A4)/LN(2)) copy to B4:J14

Create a scatter graph using Excel Chart utility

Unit Cost versus Unit Number Chart 60%-← 65% 70%- 75 %-← 80% 85 %·一90%--95% 100% 120 100 80 8 60 40 20 200 400 600 800 1000 1200 Unit Number