a. Construct a spreadsheet that permits the development of a DBV table and a graph.

Input data should be for each of n items (where, for any particular application, n would be specified by the user): p-945 i. Item identification ii. Di, the annual usage of item i, in units/year iii. vi, the unit variable cost of item i, in $/unit

b. Illustrate the use of your program for the following example involving 20 items: 2.14 Repeat Problem 2.13 for the following data:

Transcribed Image Text:

SKU ID Annual Usage in Units Unit Variable Cost (S/Unit) A 172 27.73 B 8 110.40 C 3 60.60 D 4 19.80 E 2 134.34 F 15 160.50 G 4 49.48 H 3 8.46 1 4 40.82 1 34.40 K 212 23.76 L 4 53.02 M 12 71.20 N 2 67.40 0 2 37.70 P 1 28.80 Q 4 78.40 R 12 33.20 S 3 72.00 T 18 45.00 U 50 20.87 V 19 24.40 W 1 48.30 X 10 33.84 Y 27 210.00 Z 33 73.44 1A 48 55.00 1B 5 30.00