X nventory Calculations Template module 9.8 - Excel ems X Page Layout Formulas Data Review View Help ? Tell m File Home Insert File | C:/Users/catbe/Downloads/Module%209%20Assignment%20%20Problems%2.. 18 : Calibri 12 General Conditional Formatting ault application for reading PDF files? B I U ~ A $ % " Format as Table ~ Set as default X Paste Cell Styles ~ Clipboard Font IN Alignment Number Styles A1 X ECONOMIC ORDER QUANTITY 7. The finished goods inventory of a small manufacturing company is shown below (available in data for Module 9). Perform an ABC analysis on the data (Assign A items to a maximum of 70 % of the mulative value and B items to a maximum of the next 20% of the cumulative value (a total of 90%).) B C SKU Unit Demand 1 ECONOMIC ORDER QUANTITY Code Value (units) Yellow - Enter Data 1021 $ 125.00 100 3 Blue - Calculated Value 1204 $ 10.00 1,750 1448 $ 12.00 2,000 $ 20.00 200 5 DATA 2282 5 17.00 330 Demand rate, D 2456 $ 500.00 675 2698 $ 25.00 85 7 Ordering/Setup cost, S 3129 $ 5.00 2,500 8 Holding cost, H 3141 $ 2.00 1,000 9 Unit Cost, C 3310 $ 1.00 1,500 3312 $ 0.75 625 10 Carrying Cost %, I 3712 $ 8.00 200 11 3943 1.50 125 12 4351 $ 0.75 410 4682 3.00 3 RESULTS 700 Optimal 4683 $ 1,200 14 Optimal Order Quantity, Q* Alternate Value 4991 $1,500.00 320 5231 $ 20.0 15 Maximum Inventory 600 5940 $ 110.00 120 16 Average Inventory 5995 $ ,500 17 Number of Orders 6466 0.90 200 18 Holding cost 6912 8.00 1,200 7006 $ 45.00 1,700 19 Order cost 7060 3.00 300 20 Purchase cost 7087 $ 4.00 800 2.00 75 21 Total cost, T 8101 $ 10.00 6,000 8447 $ 7.00 800 8989 $ 500 9034 $ 4.00 1,500 26 COST TABLE a) How many items are assigned as "A" items? 27 Starting Value b) How many items are assigned as "B" items? 28 Increment c) How many items are assigned as "C" items 29 d) What assignment was made to the following items: 24567 59957 89897 9034? 30 Setup/Order cost Holding cost 31 Total cost 32 M9.8 Submit Excel file with solution for M9.7 using Inventory Calculations Template worksheet as 33 demonstrated and formatted in videos. No credit for M9.7 unless this Excel file is submitted. 124 O Ei Ready EOQ Safety Stock & R - Variable D ype here to search Production Lot Siz