I would like to know the excel formulas for F3, F4 and F5
F3 3 F4 change). In J4 calculate the reorder quantity, return 0 if reorder not required. The inventory manager prefers to wait until a certain number of parts require re- ordering before placing the orders. He has specified this value in M5 but does adjust it depending on production levels. In M6 create a calculation to count how many Part Codes are due to be re-ordered and return a "Yes" if it is equal or over the value in M5 and a "No" otherwise. In M15:M20 calculate how many Part Codes are on Backorder for each supplier (in column L). M4 shows the Maximum Stock Level. In N15:N20 calculate how many part codes are over-stocked for each supplier, remember that the value in M4 can change. (This is a challenge question.) TOTAL MARKS 2 F5 3 90 Inventory Management In Stock - On Backord 9 Min Slock Level Max Slock Level Reorder At Reorder Due 20 40 22 Price Bracket Re-order Amount 0 25 50 20 100 15 200 10 On Backorder Over-Stecked Y 35 12 35 37 35 42 28 22 22 5 24 7 25 20 1 1 30 15 34 14 18 1/ Y Supplier Cycle Warehouse Nashbar Performance Bikes Plus Backcountry LBS B Inventory 1 2 3 Part Coc Product Description Category - Supplier Price/Uni Weight - 4 AC1045 Alloy CR Bots Accessories and tuning Cycia Warehouse $1.91 5 GR1751 CNG brukes 200g Brakes Groups Cyrila Warehouse 85993 6 W112776 6 CNC V18 Super Grip Who Whe Cyk: Wische $152.03 770.1 7 WH1280 CNC V18 Ulina Wheels Wheels Cycle Warehouse $252.58 588 8 CO2914 Gustom Rar Plus Contact Print Cyrik Warehouse $D AS SR5 22 9 GR1215 Dura Ace Choin Groupset Nashbar S26.01 217.6 10 AC1500 Fairing MS Bols Accessories and tuning Cycle Warehouse $0.52 0.8 11 WH2A56 Form ICR Tyres When Performance 819 14 2299 12 WH1573 Forte Light Tubes Wheels Performance 31.83 30.1 13 AC2964 Generic FD Adaptor Accessories and uning Cycle Warehouse 32.42 23.6 14 G1410 Ganen Foam Tape Toon Contact Prints Cyrie Warehuse $D 18 15 FR1931 Headset Frameset Bikes Plus S23.19 60.6 16 FR1235 J&L Fork Frames Dikus Plus $179.52 344 17 FR230 J&l Plug Frameset Hikas Plus 811 67 18 FR1080 J&L Top Cep & Screw Frameset Cycle Warehouse $1.05 7.8 19 C01849 KCNC Scandium Seapol Cumlack Points Cycle Waleuse S7632 180.1 20 FR1041 Mr Ride Seat Clamp Frameset Cyrila Warehouse $14 28 915 21 C01099 Nashbor Carton Bar Contact Points Nashbar $50.17 189 22 R1323 Nastrar Carbon Frame Frameset Nash $303 04 957 23 GR2145 Nashbar Cassette Groupset Nashbar 5312 1972 24 OR1900 Nashber FD Groupset Nashber $31.21 $ 83.3 25 GR1432 Nasser Levers Groups Nissa $116.00 199.0 26 GR1770 Nashbar RI Groups Nashbar 530 71 2012.8 27 C02357 RockBros CrMo Saddle Contact Points Cycle Warehouse $15.61 210.6 28 AC1914 RockBus SBO Perials neck and luning Nies S21.25 131.6 29 C02143 Spacers Contact Points Hikes Hus 53136 24 30 C01688 Specialised Foam Tape Tape Contact Points Cycle Warehouse 30.18 0.5 31 W112942 Tilasrum OR Scrates Wheti Cyckt Watch $4.74 28.0 32 A02733 Titanium Sham Hots Accessories and tuning Cyola Warehouse 33 GR1100 Ultegre BB Groupset Backcountry $15.20 51 34 GR1560 Lilica Casties Groups Nosesha S2578 49.1 35 GR1836 Uhoorn Cassette Groupset Nachbar 851.28 36 GR 2009 Ultegra Cranks Groupset Nashbar $165.30 694.9 37 GR! 172 Liligran Groupe Nisha 831 41 917 38 0R2589 Utegra Levers Groupset Nashbar S/2.50 216.8 39 GR1322 Ultegra RD Groupset Backcountry $13.18 204.8 40 C02200 Lina 7050 Sim Contact Prints Cyrk: Watch S1394 1309 - March Sales Labour Costs BOM CVP Analysis Prafit Volume Forecast Inventory Y Reorder. Reorder 25 20 15 10 25 25 25 25 20 25 25 25 15 25 25 20 25 20 10 25 25 15 25 25 25 25 25 25 25 25 25 20 15 25 20 25 25 Y 41 4 44 301 3 32 16 31 42 11 Y
