Question: Can someone please input the data into this spreadsheet format? M9.7. The finished goods inventory of a small manufacturing company is shown below (available in

Can someone please input the data into this

Can someone please input the data into this spreadsheet format?

Can someone please input the data into this

M9.7. The finished goods inventory of a small manufacturing company is shown below (available in data file for Module 9). Perform an ABC analysis on the data (Assign A items to a maximum of 70 % of the cumulative value and B items to a maximum of the next 20% of the cumulative value (a total of 90%).) SKU Unit Demand Code Value (units) 1021 1204 1448 2144 2282 2456 2698 3129 3141 3310 3312 3712 3943 4351 4682 4683 4991 5231 5940 5995 6466 6912 7006 7060 7087 7670 8101 8447 8989 9034 $ 125.00 $ 10.00 $ 12.00 $ 20.00 $ 17.00 $ 500.00 $ 25.00 $ 5.00 $ 2.00 $ 1.00 $ 0.75 $ 8.00 $ 1.50 $ 0.75 $ 3.00 $ 1.00 $1,500.00 $ 20.00 $ 110.00 $ 50.00 $ 0.90 $ 8.00 $ 45.00 $ 3.00 $ 4.00 $ 2.00 $ 10.00 $ 7.00 $ 6.00 $ 4.00 100 1,750 2,000 200 330 675 85 2,500 1,000 1,500 625 200 125 410 700 1,200 320 600 120 1,500 200 1,200 1,700 300 800 75 6,000 800 500 1,500 a) How many items are assigned as "A" items? b) How many items are assigned as "B" items? c) How many items are assigned as "C" items? d) What assignment was made to the following items: 2456? 5995? 89897 9034? M9.8 Submit Excel file with solution for M9.7 using Inventory Calculations Template worksheet as demonstrated and formatted in videos. No credit for M9.7 unless this Excel file is submitted. B C D E F G Optimal Alternate Value 1 ECONOMIC ORDER QUANTITY 2 Yellow - Enter Data 3 Blue - Calculated Value 4 5 DATA 6 Demand rate, D 7 Ordering/Setup cost, S 8 Holding cost, H 9 Unit Cost, 10 Carrying Cost 9,1 11 12 13 RESULTS 14 Optimal Order Quantity, Q* 15 Maximum Inventory 16 Average Inventory 17 Number of Orders 18 Holding cost 19 Order cost 20 Purchase cost 21 Total cost, T. 22 23 24 25 26 COST TABLE 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Starting Value Increment g Setup/Order cost Holding cost Total cost

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!