Computing the annual dollar volume


Assignment:

A growing online retailer sells thousands of SKUs yet has has one specialty product category with just 30 SKUs. They want to classify these thirty items according to the annual dollar volume (revenue) generated by each SKU. The table below lists each item number (SKU), Annual Sales (in units), and Price:

SKU  

  Annual Sales  

  Price  

514723

92

$ 3.28

516630

444

$ 46.99

517125

352

$ 9.68

523518

410

$ 148.07

526985

229

$ 32.98

531716

409

$ 180.68

532954

1,376

$ 93.67

533611

1,024

$ 7.77

535180

1,783

$ 22.49

538403

1,916

$ 7.29

541321

2,705

$ 8.17

551054

799

$ 9.17

551589

2,289

$ 5.59

553762

1,720

$ 57.07

554657

1,921

$ 23.49

556278

7,613

$ 5.79

556731

12,459

$ 103.78

558685

8,174

$ 84.68

561619

3,766

$ 69.57

564393

4,942

$ 26.59

566053

17,413

$ 43.97

566679

17,970

$ 5.29

567067

14,907

$ 3.78

567643

2,808

$ 8.88

568990

8,711

$ 9.48

569412

10,451

$ 154.78

571818

11,708

$ 3.98

573473

10,046

$ 8.08

588095

23,377

$ 6.67

510208

22,434

$ 77.39

Which item in the table above has the highest annual dollar volume?

561619

556731

569412

510208

In the answer field below, write the number that corresponds to your answer. Do not put a period after the number.

  • What is the annual dollar volume for the item you selected in the previous question? (Display your answer to the nearest whole number.)
  • Suppose that the "A" items constitute up to 80 percent of the annual dollar volume of all the parts in the list. How many "A" items should there be?
  • Suppose the "B" items are for the next 15 percent of annual dollar volume and that the "C" items are for the remaining 5 percent of annual dollar volume. How many "C" items should there be?

Your answer must be typed, double-spaced, Times New Roman font (size 12), one-inch margins on all sides, APA format and also include references.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Computing the annual dollar volume
Reference No:- TGS02007371

Expected delivery within 24 Hours