Pls explain the function

Inventory Inventory Management In Stock - On Backor Reorder Reorder- - to 2 2 18 Min Slock Level Max Slock Level Reorder At Reorder Due 20 40 22 40 Price Bracket Re-order Amount 0 0 25 50 20 100 15 200 10 On Backorder Over-Stocked 1 2 3 Part Co. Product Description 4 AC1508 Fairing M5 Bolts 5 AC1914 RockBros S60 Pedals 6 AC1919 6 Bikes Plus Deluxe Pedals 7 AC1945 7 Alloy CR Bolts 8 AC2174 Rockgrip Alpe d Huez Pedals 9 AC2733 Titanium Stem Bolts 10 AC2964 Generic FD Adapter 11 C01099 Nashbar Carbon Bar 12 C01104 Rockglider Carbon Bar 13 CO1469 Generio Foam Tape Tape 14 CO1649 KCNC Scandium Seatpost 15 CO1650 Diamond Seatpost 16 CO1688 Specialised Foam Tape Tape 17 CO2143 Spacers 18 CO2202 Uno 7050 Stem 19 C02203 BBCycle 5000 Stem 20 CO2357 RockBros CrMo Saddle 21 CO2361 Diamond Ultra Saddle 22 CO2904 Custom Bar Plugs 23 FR1080 J&L Top Cap & Screw 24 FR1081 Mr. Ride Seat Clamp 25 FR1082 Finn Cap & Screw 26 FR1086 RockBros Seat Clamp 27 FR1235 J&L Fork 28 FR1240 FirstLite Fork 29 FR1323 Nashbar Carbon Frame 30 FR1324 RockBros Carbon Frame 31 FR1934 Headset 32 FR1937 Giga Headset 33 FR2360 J&L Plug 34 GR1172 Ultegra FD 35 GB1177 Firma En Category Supplier Accessories and tuning Cycle Warehouse Accessories and tuning Nashbar Accessories and tuning Bikes Plus Accessories and tuning Cycle Warehouse Accessories and tuning Cycle Warehouse Accessories and tuning Cycle Warehouse Accessories and tuning Cycle Warehouse Contact Points Nashbar Contact Points Nashbar Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Bikes Plus Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Frameset Cycle Warehouse Frameset Cycle Warehouse Frameset Cycle Warehouse Frameset Cycle Warehouse Frameset Bikes Plus Frameset Bikes Plus Frameset Nashbar Frameset Nashbar Frameset Bikes Plus Frameset Bikes Plus Frameset Bikes Plus Groupset Nashbar Grounset Nachhar Price:Un Weight ( $0.47 0.8 $22.50 131.6 $23.00 131.6 $2.27 0.3 $25.24 110.3 $7.95 8.7 $2.69 23.6 $57.37 189 $68.72 189 $0.15 0.6 $85.37 180.1 $81.45 180.1 $0.15 0.5 $27.44 2.4 $14.27 130.9 $17.22 130.9 $17.40 210.6 $19.91 210.6 $0.77 2.2 $3.41 7.8 $15.70 9.5 $3.56 7.8 $14.98 9.5 $156.64 344 $183,04 344 $395.14 957 $455.62 957 $22.95 60.6 $12.88 60.6 $10.07 6 $25.35 91.7 +25.07 917 Supplier Cycle Warehouse Nashbar Performance Bikes Plus Backcountry LBS 2 20 19 2 34 29 35 25 20 15 20 1 3 20 6 34 30 38 16 39 3 11 31 8 15 28 6 9 Y 20 - On Backor - Reorder? Reorder to NO Y Part CodProduct Description 35 GR1177 Firma FD 36 GR1215 Dura Ace Chain 37 GR1218 Magneto Chain 38 GR1322 Ultegra RD 39 GR1325 Firma RD 40 GR1406 Ultegra BB 41 GR1407 Firma BB 42 GR1432 Nashbar Levers 43 GR1435 Rockgrip Levers 44 GR1550 Ultegra Cables 45 GR1554 Firma Cables 46 GR1751 CNC brakes 200g Brakes 47 GR1753 Firma Brakes 48 GR1770 Nashbar RD 49 GR1773 Rookgrip RD 50 GR1836 Ultegra Cassette 51 GR1840 Firma Cassette 52 GR1966 Nashbar FD 53 GR1967 Rookgrip FD 54 GR2009 Ultegra Cranks 55 GR2013 Firma Cranks 56 GR2589 Ultegra Levers 57 GR2594 Firma Levers 58 GR2655 Nashbar Cassette 59 GR2658 Rockgrip Cassette 60 WH1100 XR-270/Bitex Wheel 61 WH1200 Ultrazen 5 Wheel 62 WH1260 CNC V18 Ultra Wheels 63 WH1573 Forte Light Tubes 64 WH1575 Firma Inner Tubes 65 WH2373 Veloplugs Rim tape 66 WH2778 CNC V16 Super Grip Wheels 67 WH2856 Forte LCR Tyres 68 WH2859 Ultra Rook Tyres 69 WH2942 Titanium QR Skewers Category Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Wheels Wheels Wheels Wheels Wheels Wheels Wheels Wheels Wheels Wheels Supplier Nashbar Nashbar Nashbar Backcountry Backcountry Backcountry Backcountry Nashbar Nashbar Nashbar Nashbar Cycle Warehouse Cycle Warehouse Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Cycle Warehouse Cycle Warehouse Cycle Warehouse Performance Performance LBS Cycle Warehouse Performance LBS Cycle Warehouse Price/Unit $25.07 $27.97 $24.81 $38.18 $40.26 $13.45 $12.43 $100.98 $130.68 $26.22 $9.18 $68.21 $66.94 $39.29 $48.07 $44.14 $49.05 $34.85 $29.15 $162.37 $162.37 $94.75 $74.97 $36.04 $33.66 $112.75 $126.15 $199.75 $59.66 $47.19 $4.70 $129.89 $17.14 $39.36 $3.96 Weight (g) 91.7 217.6 217.6 204.8 204.8 51 51 199.8 199.8 49.1 49.1 84 84 202.8 202.8 176 176 86.3 86.3 694.9 694.9 216.8 216.8 197.2 197.2 595 595 588 56.1 56.1 4 778.1 228.9 228.9 26.8 In Stock 20 12 35 38 24 13 23 14 20 30 7 35 28 19 6 25 3 17 16 9 22 36 38 23 27 0 17 40 7 32 35 31 34 36 23 Y Y F1 F2 F3 If a stock item falls below the minimum stock level in M3 and is not on backorder (value in column H is not "Y"), then we need to reorder it. In 14 create a calculation that will return "Y" if the item needs reordering and an empty string (nothing) if it does not The quantity to reorder is determined by the price of the item as shown in the table in 19:M12, e.g. anything that costs under $50 we reorder 25 (these values can change). In 14 calculate the reorder quantity, return Oif 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.) F4 F5 Inventory Inventory Management In Stock - On Backor Reorder Reorder- - to 2 2 18 Min Slock Level Max Slock Level Reorder At Reorder Due 20 40 22 40 Price Bracket Re-order Amount 0 0 25 50 20 100 15 200 10 On Backorder Over-Stocked 1 2 3 Part Co. Product Description 4 AC1508 Fairing M5 Bolts 5 AC1914 RockBros S60 Pedals 6 AC1919 6 Bikes Plus Deluxe Pedals 7 AC1945 7 Alloy CR Bolts 8 AC2174 Rockgrip Alpe d Huez Pedals 9 AC2733 Titanium Stem Bolts 10 AC2964 Generic FD Adapter 11 C01099 Nashbar Carbon Bar 12 C01104 Rockglider Carbon Bar 13 CO1469 Generio Foam Tape Tape 14 CO1649 KCNC Scandium Seatpost 15 CO1650 Diamond Seatpost 16 CO1688 Specialised Foam Tape Tape 17 CO2143 Spacers 18 CO2202 Uno 7050 Stem 19 C02203 BBCycle 5000 Stem 20 CO2357 RockBros CrMo Saddle 21 CO2361 Diamond Ultra Saddle 22 CO2904 Custom Bar Plugs 23 FR1080 J&L Top Cap & Screw 24 FR1081 Mr. Ride Seat Clamp 25 FR1082 Finn Cap & Screw 26 FR1086 RockBros Seat Clamp 27 FR1235 J&L Fork 28 FR1240 FirstLite Fork 29 FR1323 Nashbar Carbon Frame 30 FR1324 RockBros Carbon Frame 31 FR1934 Headset 32 FR1937 Giga Headset 33 FR2360 J&L Plug 34 GR1172 Ultegra FD 35 GB1177 Firma En Category Supplier Accessories and tuning Cycle Warehouse Accessories and tuning Nashbar Accessories and tuning Bikes Plus Accessories and tuning Cycle Warehouse Accessories and tuning Cycle Warehouse Accessories and tuning Cycle Warehouse Accessories and tuning Cycle Warehouse Contact Points Nashbar Contact Points Nashbar Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Bikes Plus Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Contact Points Cycle Warehouse Frameset Cycle Warehouse Frameset Cycle Warehouse Frameset Cycle Warehouse Frameset Cycle Warehouse Frameset Bikes Plus Frameset Bikes Plus Frameset Nashbar Frameset Nashbar Frameset Bikes Plus Frameset Bikes Plus Frameset Bikes Plus Groupset Nashbar Grounset Nachhar Price:Un Weight ( $0.47 0.8 $22.50 131.6 $23.00 131.6 $2.27 0.3 $25.24 110.3 $7.95 8.7 $2.69 23.6 $57.37 189 $68.72 189 $0.15 0.6 $85.37 180.1 $81.45 180.1 $0.15 0.5 $27.44 2.4 $14.27 130.9 $17.22 130.9 $17.40 210.6 $19.91 210.6 $0.77 2.2 $3.41 7.8 $15.70 9.5 $3.56 7.8 $14.98 9.5 $156.64 344 $183,04 344 $395.14 957 $455.62 957 $22.95 60.6 $12.88 60.6 $10.07 6 $25.35 91.7 +25.07 917 Supplier Cycle Warehouse Nashbar Performance Bikes Plus Backcountry LBS 2 20 19 2 34 29 35 25 20 15 20 1 3 20 6 34 30 38 16 39 3 11 31 8 15 28 6 9 Y 20 - On Backor - Reorder? Reorder to NO Y Part CodProduct Description 35 GR1177 Firma FD 36 GR1215 Dura Ace Chain 37 GR1218 Magneto Chain 38 GR1322 Ultegra RD 39 GR1325 Firma RD 40 GR1406 Ultegra BB 41 GR1407 Firma BB 42 GR1432 Nashbar Levers 43 GR1435 Rockgrip Levers 44 GR1550 Ultegra Cables 45 GR1554 Firma Cables 46 GR1751 CNC brakes 200g Brakes 47 GR1753 Firma Brakes 48 GR1770 Nashbar RD 49 GR1773 Rookgrip RD 50 GR1836 Ultegra Cassette 51 GR1840 Firma Cassette 52 GR1966 Nashbar FD 53 GR1967 Rookgrip FD 54 GR2009 Ultegra Cranks 55 GR2013 Firma Cranks 56 GR2589 Ultegra Levers 57 GR2594 Firma Levers 58 GR2655 Nashbar Cassette 59 GR2658 Rockgrip Cassette 60 WH1100 XR-270/Bitex Wheel 61 WH1200 Ultrazen 5 Wheel 62 WH1260 CNC V18 Ultra Wheels 63 WH1573 Forte Light Tubes 64 WH1575 Firma Inner Tubes 65 WH2373 Veloplugs Rim tape 66 WH2778 CNC V16 Super Grip Wheels 67 WH2856 Forte LCR Tyres 68 WH2859 Ultra Rook Tyres 69 WH2942 Titanium QR Skewers Category Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Groupset Wheels Wheels Wheels Wheels Wheels Wheels Wheels Wheels Wheels Wheels Supplier Nashbar Nashbar Nashbar Backcountry Backcountry Backcountry Backcountry Nashbar Nashbar Nashbar Nashbar Cycle Warehouse Cycle Warehouse Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Nashbar Cycle Warehouse Cycle Warehouse Cycle Warehouse Performance Performance LBS Cycle Warehouse Performance LBS Cycle Warehouse Price/Unit $25.07 $27.97 $24.81 $38.18 $40.26 $13.45 $12.43 $100.98 $130.68 $26.22 $9.18 $68.21 $66.94 $39.29 $48.07 $44.14 $49.05 $34.85 $29.15 $162.37 $162.37 $94.75 $74.97 $36.04 $33.66 $112.75 $126.15 $199.75 $59.66 $47.19 $4.70 $129.89 $17.14 $39.36 $3.96 Weight (g) 91.7 217.6 217.6 204.8 204.8 51 51 199.8 199.8 49.1 49.1 84 84 202.8 202.8 176 176 86.3 86.3 694.9 694.9 216.8 216.8 197.2 197.2 595 595 588 56.1 56.1 4 778.1 228.9 228.9 26.8 In Stock 20 12 35 38 24 13 23 14 20 30 7 35 28 19 6 25 3 17 16 9 22 36 38 23 27 0 17 40 7 32 35 31 34 36 23 Y Y F1 F2 F3 If a stock item falls below the minimum stock level in M3 and is not on backorder (value in column H is not "Y"), then we need to reorder it. In 14 create a calculation that will return "Y" if the item needs reordering and an empty string (nothing) if it does not The quantity to reorder is determined by the price of the item as shown in the table in 19:M12, e.g. anything that costs under $50 we reorder 25 (these values can change). In 14 calculate the reorder quantity, return Oif 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.) F4 F5