Part 1) In column G some items have a Y against them indicating that they are Premium
Question:
Part 1) In column G some items have a “Y” against them indicating that they are Premium items. Premium items incur a higher mark-up than standard items, both, the standard and premium mark-up rates can be found in O3 and O4. In H4 calculate the retail price by adding the appropriate mark-up amount to the Cost price. The formula should automatically copy down. (Note the rates can change so ensure you refence the cells – do not type the rates into the calculation.)
Part 2) In column K calculate the number of items to reorder if a reorder is required. If not, the calculation should return 0 (not “0”). Reorder quantities are based on two factors, the category shown in column C and whether or not the item is premium or standard, the lookup table in M10:O14 shows the appropriate number for each combination. For example: for a Category A premium item we need to reorder 25 whereas a regular item we only reorder 20. This is a challenge question so limited help can be given, but you may choose a simpler option and just return the standard amount for all items that need reordering, and if correct you will still receive 3 marks. Note reorder values in the lookup table can change, so don’t type them, your calculation must be consistent and work regardless of values or sort order.)
Please don't consider this as 2 separate questions. These are 2 parts from the same question.
K4 A 1 SafeTNET Network Equipment Inventory 3 Item Code 4 EIF-CZ-73600 5 EIF-CZ-97375 6 EIF-A-64872 7 EIF-CZ-48270 8 EIF-CZ-66531 9 10G-XF-75398 10 10G-XF-96371 11 10G-XF-92273 12 E1M-SX-85914 13 E1M-LX-85720 x ✓ fx 14 E1M-LH-64896 15 E1M-CW-32246 16 E1M-CW-78899 17 E1M-CW-72258 18 E1M-CW-28966 19 E1M-CW-36738 20 E1M-CW-40232 21 E1M-CW-28783 22 E1M-CW-31995 23 FES-CZ-51280 24 FES-CZ-23915 25 FES-CZ-65136 26 FES-DC-62571 27 FES-DC-25460 28 FES-DC-59060 29 FES-PR-77806 30 FES-PR-91987 31 FES-PR-88772 32 FES-PR-27658 33 FES-PR-84308 34 FES-PR-78728 35 FES-WL-42909 36 FES-WL-97334 37 FES-WL-57764 38 FES-WL-69103 39 FES-WL-85721 40 FES-WL-84668 41 FES-PO-81088 42 FES-PO-24400 43 FES-CZ-78088 44 FES-CZ-44941 45 FES-DC-92979 46 FES-PR-63235 47 FES-PR-76605 48 FES-PO-55523 B Item Description EIF 24 10/100 +2 Combo GbE EIF 48 10/100 +2 Combo GbE 20 FE/1000 +4 C/F Gbi 48-port 10/100/1000 with up to 4-port combo SFP slots EIF with 8-port XFP slots and complete L2 SW. 10GbE SR XFP, MMF, LC 10GbE LR XFP, SMF, LC 10GbE ER XFP optics, SMF, LC connector SX MMF SFP LX SMF SFP LHA SMF SFP 80Km, 1470nm, LC connector 80Km, 1490nm, LC connector 80Km, 1510nm, LC connector 80Km, 1530nm, LC connector 80Km, 1550nm, LC connector 80Km, 1570nm, LC connector 80Km, 1590nm, LC connector 80Km, 1610nm, LC connector 24p 2 C/F w 1 AC 48p, 2 C/F & 1 AC 96p, 4 C/F & AC 24p, 2 C/F & 1 DC 48p, 2 C/F & 1 DC 96p, 4 C/F & DC Prem 24p, 2 C/F & 1 AC Prem 48p, 2 C/F & 1 AC Prem 96p, 4 C/F & AC Prem 24p, 2 C/F & 1 DC Prem 48p, 2 C/F & 1 DC Prem 96p, 4 C/F & DC FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-T and 1000Base- FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-Tand 1000Base- FES-port 10/100Base-TX (RJ45) plus 4-port 1000Base-T and 1000Base- FES-DC with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 96-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba TRONPoint WLAN upgrade kit for FES Switch 12G C/F w 1 AC 12G C/F w 1 DC 12G C/F Prem w 1 AC 12G C/F Prem w1 DC POE 24p 2-GCF C Category A A B C D A B D A A B C C с с с C C C B с D B C D B C D B C D B C D B C D B C A C C C C 8 D Num In Stock On Backorde 12 28 33 20 5 11 8 7 19 34 15 34 14 13 29 6 10 20 5 35 32 20 32 24 23 29 15 23 24 9 E 23 27 8 3 32 4 0 26 17 25 18 23 5 29 14 Y Y Y Y Y Y Y Y Y Y F Cost Pr $1,044.75 $1,745.85 $3,492.70 $5,043.90 $11,434.80 $1,424.80 $2,937.15 $11,214.90 $524.30 $1,171.65 $4,526.85 $5,824.70 $5,769.75 $5,659.85 $5,879.65 $5,824.70 $5,769.75 $5,659.85 $5,769.75 $2,850.90 $5,094.90 $10,052.65 $3,280.70 $5,612.70 $10,400.00 $4,526.85 $7,554.75 $14,346.80 $4,938.85 $7,869.75 $14,658.80 $4,037.25 $6,165.90 $11,071.70 $4,467.25 $6,757.50 $11,206.00 $4,570.80 $6,792.85 $1,127.85 $6,792.85 $7,202.00 $8,970.90 $9,490.00 $3,459.75 G Premium? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y H Retail Price Over Stocked Y Y Y Y I Y Y Y Y J K Reorder? Reorder Qty L M Standard Markup: Premium Markup: Maximum Stock Level: Minimum Stock Level: Reorder Amounts Lookup Category A R с D E Item Codes Over Stocked: Item Codes to Reorder Reorders A B C D E N Premium 25 20 15 10 5 Premium O 32995 Regular 20 15 10 2 Regular 20% 25% 30 5 K4 A 1 SafeTNET Network Equipment Inventory 3 Item Code 4 EIF-CZ-73600 5 EIF-CZ-97375 6 EIF-A-64872 7 EIF-CZ-48270 8 EIF-CZ-66531 9 10G-XF-75398 10 10G-XF-96371 11 10G-XF-92273 12 E1M-SX-85914 13 E1M-LX-85720 x ✓ fx 14 E1M-LH-64896 15 E1M-CW-32246 16 E1M-CW-78899 17 E1M-CW-72258 18 E1M-CW-28966 19 E1M-CW-36738 20 E1M-CW-40232 21 E1M-CW-28783 22 E1M-CW-31995 23 FES-CZ-51280 24 FES-CZ-23915 25 FES-CZ-65136 26 FES-DC-62571 27 FES-DC-25460 28 FES-DC-59060 29 FES-PR-77806 30 FES-PR-91987 31 FES-PR-88772 32 FES-PR-27658 33 FES-PR-84308 34 FES-PR-78728 35 FES-WL-42909 36 FES-WL-97334 37 FES-WL-57764 38 FES-WL-69103 39 FES-WL-85721 40 FES-WL-84668 41 FES-PO-81088 42 FES-PO-24400 43 FES-CZ-78088 44 FES-CZ-44941 45 FES-DC-92979 46 FES-PR-63235 47 FES-PR-76605 48 FES-PO-55523 B Item Description EIF 24 10/100 +2 Combo GbE EIF 48 10/100 +2 Combo GbE 20 FE/1000 +4 C/F Gbi 48-port 10/100/1000 with up to 4-port combo SFP slots EIF with 8-port XFP slots and complete L2 SW. 10GbE SR XFP, MMF, LC 10GbE LR XFP, SMF, LC 10GbE ER XFP optics, SMF, LC connector SX MMF SFP LX SMF SFP LHA SMF SFP 80Km, 1470nm, LC connector 80Km, 1490nm, LC connector 80Km, 1510nm, LC connector 80Km, 1530nm, LC connector 80Km, 1550nm, LC connector 80Km, 1570nm, LC connector 80Km, 1590nm, LC connector 80Km, 1610nm, LC connector 24p 2 C/F w 1 AC 48p, 2 C/F & 1 AC 96p, 4 C/F & AC 24p, 2 C/F & 1 DC 48p, 2 C/F & 1 DC 96p, 4 C/F & DC Prem 24p, 2 C/F & 1 AC Prem 48p, 2 C/F & 1 AC Prem 96p, 4 C/F & AC Prem 24p, 2 C/F & 1 DC Prem 48p, 2 C/F & 1 DC Prem 96p, 4 C/F & DC FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-T and 1000Base- FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-Tand 1000Base- FES-port 10/100Base-TX (RJ45) plus 4-port 1000Base-T and 1000Base- FES-DC with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 96-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba TRONPoint WLAN upgrade kit for FES Switch 12G C/F w 1 AC 12G C/F w 1 DC 12G C/F Prem w 1 AC 12G C/F Prem w1 DC POE 24p 2-GCF C Category A A B C D A B D A A B C C с с с C C C B с D B C D B C D B C D B C D B C D B C A C C C C 8 D Num In Stock On Backorde 12 28 33 20 5 11 8 7 19 34 15 34 14 13 29 6 10 20 5 35 32 20 32 24 23 29 15 23 24 9 E 23 27 8 3 32 4 0 26 17 25 18 23 5 29 14 Y Y Y Y Y Y Y Y Y Y F Cost Pr $1,044.75 $1,745.85 $3,492.70 $5,043.90 $11,434.80 $1,424.80 $2,937.15 $11,214.90 $524.30 $1,171.65 $4,526.85 $5,824.70 $5,769.75 $5,659.85 $5,879.65 $5,824.70 $5,769.75 $5,659.85 $5,769.75 $2,850.90 $5,094.90 $10,052.65 $3,280.70 $5,612.70 $10,400.00 $4,526.85 $7,554.75 $14,346.80 $4,938.85 $7,869.75 $14,658.80 $4,037.25 $6,165.90 $11,071.70 $4,467.25 $6,757.50 $11,206.00 $4,570.80 $6,792.85 $1,127.85 $6,792.85 $7,202.00 $8,970.90 $9,490.00 $3,459.75 G Premium? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y H Retail Price Over Stocked Y Y Y Y I Y Y Y Y J K Reorder? Reorder Qty L M Standard Markup: Premium Markup: Maximum Stock Level: Minimum Stock Level: Reorder Amounts Lookup Category A R с D E Item Codes Over Stocked: Item Codes to Reorder Reorders A B C D E N Premium 25 20 15 10 5 Premium O 32995 Regular 20 15 10 2 Regular 20% 25% 30 5 K4 A 1 SafeTNET Network Equipment Inventory 3 Item Code 4 EIF-CZ-73600 5 EIF-CZ-97375 6 EIF-A-64872 7 EIF-CZ-48270 8 EIF-CZ-66531 9 10G-XF-75398 10 10G-XF-96371 11 10G-XF-92273 12 E1M-SX-85914 13 E1M-LX-85720 x ✓ fx 14 E1M-LH-64896 15 E1M-CW-32246 16 E1M-CW-78899 17 E1M-CW-72258 18 E1M-CW-28966 19 E1M-CW-36738 20 E1M-CW-40232 21 E1M-CW-28783 22 E1M-CW-31995 23 FES-CZ-51280 24 FES-CZ-23915 25 FES-CZ-65136 26 FES-DC-62571 27 FES-DC-25460 28 FES-DC-59060 29 FES-PR-77806 30 FES-PR-91987 31 FES-PR-88772 32 FES-PR-27658 33 FES-PR-84308 34 FES-PR-78728 35 FES-WL-42909 36 FES-WL-97334 37 FES-WL-57764 38 FES-WL-69103 39 FES-WL-85721 40 FES-WL-84668 41 FES-PO-81088 42 FES-PO-24400 43 FES-CZ-78088 44 FES-CZ-44941 45 FES-DC-92979 46 FES-PR-63235 47 FES-PR-76605 48 FES-PO-55523 B Item Description EIF 24 10/100 +2 Combo GbE. EIF 48 10/100 +2 Combo GbE 20 FE/1000 +4 C/F Gbi 48-port 10/100/1000 with up to 4-port combo SFP slots EIF with 8-port XFP slots and complete L2 SW. 10GbE SR XFP, MMF, LC 10GbE LR XFP, SMF, LC 10GbE ER XFP optics, SMF, LC connector SX MMF SFP LX SMF SFP LHA SMF SFP 80Km, 1470nm, LC connector 80Km, 1490nm, LC connector 80km, 1510nm, LC connector 80Km, 1530nm, LC connector 80Km, 1550nm, LC connector 80Km, 1570nm, LC connector 80Km, 1590nm, LC connector 80Km, 1610nm, LC connector 24p 2 C/F w 1 AC 48p, 2 C/F & 1 AC 96p, 4 C/F & AC 24p, 2 C/F & 1 DC 48p, 2 C/F & 1 DC 96p, 4 C/F & DC Prem 24p, 2 C/F & 1 AC Prem 48p, 2 C/F & 1 AC Prem 96p, 4 C/F & AC Prem 24p, 2 C/F & 1 DC Prem 48p, 2 C/F & 1 DC Prem 96p, 4 C/F & DC FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-T and 1000Base- FES-port 10/100Base-TX (RJ45) plus 2-port 1000 Base-Tand 1000Base- FES-port 10/100Base-TX (RJ45) plus 4-port 1000Base-T and 1000Base- FES-DC with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 96-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba TRONPoint WLAN upgrade kit for FES Switch 12G C/F w 1 AC 12G C/F w 1 DC 12G C/F Prem w 1 AC 12G C/F Prem w1 DC POE 24p 2-GCF C Category A A B C D A B D A A B C C с с с C C C B с D B C D B C D B C D B C D B C D B C A C C C C 8 D Num In Stock On Backorde 12 28 33 20 5 11 8 7 19 34 15 34 14 13 29 6 10 20 5 35 32 20 32 24 23 29 15 23 24 9 E 23 27 8 3 32 4 0 26 17 25 18 23 5 29 14 Y Y Y Y Y Y Y Y Y Y F Cost Pr $1,044.75 $1,745.85 $3,492.70 $5,043.90 $11,434.80 $1,424.80 $2,937.15 $11,214.90 $524.30 $1,171.65 $4,526.85 $5,824.70 $5,769.75 $5,659.85 $5,879.65 $5,824.70 $5,769.75 $5,659.85 $5,769.75 $2,850.90 $5,094.90 $10,052.65 $3,280.70 $5,612.70 $10,400.00 $4,526.85 $7,554.75 $14,346.80 $4,938.85 $7,869.75 $14,658.80 $4,037.25 $6,165.90 $11,071.70 $4,467.25 $6,757.50 $11,206.00 $4,570.80 $6,792.85 $1,127.85 $6,792.85 $7,202.00 $8,970.90 $9,490.00 $3,459.75 G Premium? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y H Retail Price Over Stocked Y Y Y Y I Y Y Y Y J K Reorder? Reorder Qty L M Standard Markup: Premium Markup: Maximum Stock Level: Minimum Stock Level: Reorder Amounts Lookup Category A R с D E Item Codes Over Stocked: Item Codes to Reorder Reorders A B C D E N Premium 25 20 15 10 5 Premium O 32995 Regular 20 15 10 2 Regular 20% 25% 30 5 K4 A 1 SafeTNET Network Equipment Inventory 3 Item Code 4 EIF-CZ-73600 5 EIF-CZ-97375 6 EIF-A-64872 7 EIF-CZ-48270 8 EIF-CZ-66531 9 10G-XF-75398 10 10G-XF-96371 11 10G-XF-92273 12 E1M-SX-85914 13 E1M-LX-85720 x ✓ fx 14 E1M-LH-64896 15 E1M-CW-32246 16 E1M-CW-78899 17 E1M-CW-72258 18 E1M-CW-28966 19 E1M-CW-36738 20 E1M-CW-40232 21 E1M-CW-28783 22 E1M-CW-31995 23 FES-CZ-51280 24 FES-CZ-23915 25 FES-CZ-65136 26 FES-DC-62571 27 FES-DC-25460 28 FES-DC-59060 29 FES-PR-77806 30 FES-PR-91987 31 FES-PR-88772 32 FES-PR-27658 33 FES-PR-84308 34 FES-PR-78728 35 FES-WL-42909 36 FES-WL-97334 37 FES-WL-57764 38 FES-WL-69103 39 FES-WL-85721 40 FES-WL-84668 41 FES-PO-81088 42 FES-PO-24400 43 FES-CZ-78088 44 FES-CZ-44941 45 FES-DC-92979 46 FES-PR-63235 47 FES-PR-76605 48 FES-PO-55523 B Item Description EIF 24 10/100 +2 Combo GbE EIF 48 10/100 +2 Combo GbE 20 FE/1000 +4 C/F Gbi 48-port 10/100/1000 with up to 4-port combo SFP slots EIF with 8-port XFP slots and complete L2 SW. 10GbE SR XFP, MMF, LC 10GbE LR XFP, SMF, LC 10GbE ER XFP optics, SMF, LC connector SX MMF SFP LX SMF SFP LHA SMF SFP 80Km, 1470nm, LC connector 80Km, 1490nm, LC connector 80Km, 1510nm, LC connector 80Km, 1530nm, LC connector 80Km, 1550nm, LC connector 80Km, 1570nm, LC connector 80Km, 1590nm, LC connector 80Km, 1610nm, LC connector 24p 2 C/F w 1 AC 48p, 2 C/F & 1 AC 96p, 4 C/F & AC 24p, 2 C/F & 1 DC 48p, 2 C/F & 1 DC 96p, 4 C/F & DC Prem 24p, 2 C/F & 1 AC Prem 48p, 2 C/F & 1 AC Prem 96p, 4 C/F & AC Prem 24p, 2 C/F & 1 DC Prem 48p, 2 C/F & 1 DC Prem 96p, 4 C/F & DC FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-T and 1000Base- FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-Tand 1000Base- FES-port 10/100Base-TX (RJ45) plus 4-port 1000Base-T and 1000Base- FES-DC with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 96-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba TRONPoint WLAN upgrade kit for FES Switch 12G C/F w 1 AC 12G C/F w 1 DC 12G C/F Prem w 1 AC 12G C/F Prem w1 DC POE 24p 2-GCF C Category A A B C D A B D A A B C C с с с C C C B с D B C D B C D B C D B C D B C D B C A C C C C 8 D Num In Stock On Backorde 12 28 33 20 5 11 8 7 19 34 15 34 14 13 29 6 10 20 5 35 32 20 32 24 23 29 15 23 24 9 E 23 27 8 3 32 4 0 26 17 25 18 23 5 29 14 Y Y Y Y Y Y Y Y Y Y F Cost Pr $1,044.75 $1,745.85 $3,492.70 $5,043.90 $11,434.80 $1,424.80 $2,937.15 $11,214.90 $524.30 $1,171.65 $4,526.85 $5,824.70 $5,769.75 $5,659.85 $5,879.65 $5,824.70 $5,769.75 $5,659.85 $5,769.75 $2,850.90 $5,094.90 $10,052.65 $3,280.70 $5,612.70 $10,400.00 $4,526.85 $7,554.75 $14,346.80 $4,938.85 $7,869.75 $14,658.80 $4,037.25 $6,165.90 $11,071.70 $4,467.25 $6,757.50 $11,206.00 $4,570.80 $6,792.85 $1,127.85 $6,792.85 $7,202.00 $8,970.90 $9,490.00 $3,459.75 G Premium? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y H Retail Price Over Stocked Y Y Y Y I Y Y Y Y J K Reorder? Reorder Qty L M Standard Markup: Premium Markup: Maximum Stock Level: Minimum Stock Level: Reorder Amounts Lookup Category A R с D E Item Codes Over Stocked: Item Codes to Reorder Reorders A B C D E N Premium 25 20 15 10 5 Premium O 32995 Regular 20 15 10 2 Regular 20% 25% 30 5 K4 A 1 SafeTNET Network Equipment Inventory 3 Item Code 4 EIF-CZ-73600 5 EIF-CZ-97375 6 EIF-A-64872 7 EIF-CZ-48270 8 EIF-CZ-66531 9 10G-XF-75398 10 10G-XF-96371 11 10G-XF-92273 12 E1M-SX-85914 13 E1M-LX-85720 x ✓ fx 14 E1M-LH-64896 15 E1M-CW-32246 16 E1M-CW-78899 17 E1M-CW-72258 18 E1M-CW-28966 19 E1M-CW-36738 20 E1M-CW-40232 21 E1M-CW-28783 22 E1M-CW-31995 23 FES-CZ-51280 24 FES-CZ-23915 25 FES-CZ-65136 26 FES-DC-62571 27 FES-DC-25460 28 FES-DC-59060 29 FES-PR-77806 30 FES-PR-91987 31 FES-PR-88772 32 FES-PR-27658 33 FES-PR-84308 34 FES-PR-78728 35 FES-WL-42909 36 FES-WL-97334 37 FES-WL-57764 38 FES-WL-69103 39 FES-WL-85721 40 FES-WL-84668 41 FES-PO-81088 42 FES-PO-24400 43 FES-CZ-78088 44 FES-CZ-44941 45 FES-DC-92979 46 FES-PR-63235 47 FES-PR-76605 48 FES-PO-55523 B Item Description EIF 24 10/100 +2 Combo GbE EIF 48 10/100 +2 Combo GbE 20 FE/1000 +4 C/F Gbi 48-port 10/100/1000 with up to 4-port combo SFP slots EIF with 8-port XFP slots and complete L2 SW. 10GbE SR XFP, MMF, LC 10GbE LR XFP, SMF, LC 10GbE ER XFP optics, SMF, LC connector SX MMF SFP LX SMF SFP LHA SMF SFP 80Km, 1470nm, LC connector 80Km, 1490nm, LC connector 80Km, 1510nm, LC connector 80Km, 1530nm, LC connector 80Km, 1550nm, LC connector 80Km, 1570nm, LC connector 80Km, 1590nm, LC connector 80Km, 1610nm, LC connector 24p 2 C/F w 1 AC 48p, 2 C/F & 1 AC 96p, 4 C/F & AC 24p, 2 C/F & 1 DC 48p, 2 C/F & 1 DC 96p, 4 C/F & DC Prem 24p, 2 C/F & 1 AC Prem 48p, 2 C/F & 1 AC Prem 96p, 4 C/F & AC Prem 24p, 2 C/F & 1 DC Prem 48p, 2 C/F & 1 DC Prem 96p, 4 C/F & DC FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-T and 1000Base- FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-Tand 1000Base- FES-port 10/100Base-TX (RJ45) plus 4-port 1000Base-T and 1000Base- FES-DC with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 96-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba TRONPoint WLAN upgrade kit for FES Switch 12G C/F w 1 AC 12G C/F w 1 DC 12G C/F Prem w 1 AC 12G C/F Prem w1 DC POE 24p 2-GCF C Category A A B C D A B D A A B C C с с с C C C B с D B C D B C D B C D B C D B C D B C A C C C C 8 D Num In Stock On Backorde 12 28 33 20 5 11 8 7 19 34 15 34 14 13 29 6 10 20 5 35 32 20 32 24 23 29 15 23 24 9 E 23 27 8 3 32 4 0 26 17 25 18 23 5 29 14 Y Y Y Y Y Y Y Y Y Y F Cost Pr $1,044.75 $1,745.85 $3,492.70 $5,043.90 $11,434.80 $1,424.80 $2,937.15 $11,214.90 $524.30 $1,171.65 $4,526.85 $5,824.70 $5,769.75 $5,659.85 $5,879.65 $5,824.70 $5,769.75 $5,659.85 $5,769.75 $2,850.90 $5,094.90 $10,052.65 $3,280.70 $5,612.70 $10,400.00 $4,526.85 $7,554.75 $14,346.80 $4,938.85 $7,869.75 $14,658.80 $4,037.25 $6,165.90 $11,071.70 $4,467.25 $6,757.50 $11,206.00 $4,570.80 $6,792.85 $1,127.85 $6,792.85 $7,202.00 $8,970.90 $9,490.00 $3,459.75 G Premium? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y H Retail Price Over Stocked Y Y Y Y I Y Y Y Y J K Reorder? Reorder Qty L M Standard Markup: Premium Markup: Maximum Stock Level: Minimum Stock Level: Reorder Amounts Lookup Category A R с D E Item Codes Over Stocked: Item Codes to Reorder Reorders A B C D E N Premium 25 20 15 10 5 Premium O 32995 Regular 20 15 10 2 Regular 20% 25% 30 5 K4 A 1 SafeTNET Network Equipment Inventory 3 Item Code 4 EIF-CZ-73600 5 EIF-CZ-97375 6 EIF-A-64872 7 EIF-CZ-48270 8 EIF-CZ-66531 9 10G-XF-75398 10 10G-XF-96371 11 10G-XF-92273 12 E1M-SX-85914 13 E1M-LX-85720 x ✓ fx 14 E1M-LH-64896 15 E1M-CW-32246 16 E1M-CW-78899 17 E1M-CW-72258 18 E1M-CW-28966 19 E1M-CW-36738 20 E1M-CW-40232 21 E1M-CW-28783 22 E1M-CW-31995 23 FES-CZ-51280 24 FES-CZ-23915 25 FES-CZ-65136 26 FES-DC-62571 27 FES-DC-25460 28 FES-DC-59060 29 FES-PR-77806 30 FES-PR-91987 31 FES-PR-88772 32 FES-PR-27658 33 FES-PR-84308 34 FES-PR-78728 35 FES-WL-42909 36 FES-WL-97334 37 FES-WL-57764 38 FES-WL-69103 39 FES-WL-85721 40 FES-WL-84668 41 FES-PO-81088 42 FES-PO-24400 43 FES-CZ-78088 44 FES-CZ-44941 45 FES-DC-92979 46 FES-PR-63235 47 FES-PR-76605 48 FES-PO-55523 B Item Description EIF 24 10/100 +2 Combo GbE. EIF 48 10/100 +2 Combo GbE 20 FE/1000 +4 C/F Gbi 48-port 10/100/1000 with up to 4-port combo SFP slots EIF with 8-port XFP slots and complete L2 SW. 10GbE SR XFP, MMF, LC 10GbE LR XFP, SMF, LC 10GbE ER XFP optics, SMF, LC connector SX MMF SFP LX SMF SFP LHA SMF SFP 80Km, 1470nm, LC connector 80Km, 1490nm, LC connector 80km, 1510nm, LC connector 80Km, 1530nm, LC connector 80Km, 1550nm, LC connector 80Km, 1570nm, LC connector 80Km, 1590nm, LC connector 80Km, 1610nm, LC connector 24p 2 C/F w 1 AC 48p, 2 C/F & 1 AC 96p, 4 C/F & AC 24p, 2 C/F & 1 DC 48p, 2 C/F & 1 DC 96p, 4 C/F & DC Prem 24p, 2 C/F & 1 AC Prem 48p, 2 C/F & 1 AC Prem 96p, 4 C/F & AC Prem 24p, 2 C/F & 1 DC Prem 48p, 2 C/F & 1 DC Prem 96p, 4 C/F & DC FES-port 10/100Base-TX (RJ45) plus 2-port 1000Base-T and 1000Base- FES-port 10/100Base-TX (RJ45) plus 2-port 1000 Base-Tand 1000Base- FES-port 10/100Base-TX (RJ45) plus 4-port 1000Base-T and 1000Base- FES-DC with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba FES-DC with integrated TRONPoint WLAN/L2 SW and 96-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 24-port 10/100Ba FES-PO with integrated TRONPoint WLAN/L2 SW and 48-port 10/100Ba TRONPoint WLAN upgrade kit for FES Switch 12G C/F w 1 AC 12G C/F w 1 DC 12G C/F Prem w 1 AC 12G C/F Prem w1 DC POE 24p 2-GCF C Category A A B C D A B D A A B C C с с с C C C B с D B C D B C D B C D B C D B C D B C A C C C C 8 D Num In Stock On Backorde 12 28 33 20 5 11 8 7 19 34 15 34 14 13 29 6 10 20 5 35 32 20 32 24 23 29 15 23 24 9 E 23 27 8 3 32 4 0 26 17 25 18 23 5 29 14 Y Y Y Y Y Y Y Y Y Y F Cost Pr $1,044.75 $1,745.85 $3,492.70 $5,043.90 $11,434.80 $1,424.80 $2,937.15 $11,214.90 $524.30 $1,171.65 $4,526.85 $5,824.70 $5,769.75 $5,659.85 $5,879.65 $5,824.70 $5,769.75 $5,659.85 $5,769.75 $2,850.90 $5,094.90 $10,052.65 $3,280.70 $5,612.70 $10,400.00 $4,526.85 $7,554.75 $14,346.80 $4,938.85 $7,869.75 $14,658.80 $4,037.25 $6,165.90 $11,071.70 $4,467.25 $6,757.50 $11,206.00 $4,570.80 $6,792.85 $1,127.85 $6,792.85 $7,202.00 $8,970.90 $9,490.00 $3,459.75 G Premium? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y H Retail Price Over Stocked Y Y Y Y I Y Y Y Y J K Reorder? Reorder Qty L M Standard Markup: Premium Markup: Maximum Stock Level: Minimum Stock Level: Reorder Amounts Lookup Category A R с D E Item Codes Over Stocked: Item Codes to Reorder Reorders A B C D E N Premium 25 20 15 10 5 Premium O 32995 Regular 20 15 10 2 Regular 20% 25% 30 5
Expert Answer:
Part 1 To calculate the retail price in column H we can use the following formula IFG4YO4H4O4H4100O3H4O3H4100 This formula checks the value in column ... View the full answer
Students also viewed these finance questions
-
Explain how fixed and crawling peg exchange rates can be used to manipulate trade balances in the short run, but not the long run. The Bush administration has declined to cite China for manipulating...
-
Blood flow rates can be found by measuring the Doppler shift in frequency of ultrasound reflected by red blood cells (known as angiodynography). If the speed of the red blood cells is v, the speed of...
-
Should firms require higher rates of return on foreign projects than on identical projects located at home? Explain.
-
Draw with Ruler Touch Touch 4x For each of the three simple circuit boards you will need to calculate the total resistance, Req, for the entire circuit board by using the measured resistances of each...
-
(a) In question 19, give a title to the graph, using as a function of. (b) If you participated in the study in question 19 and had been deprived of 5 hours of sleep, how many errors do you think you...
-
Every year the Loebner prize is awarded to the program that comes closest to passing a version of the Turing test. Research and report on the latest winner of the Loehner prize. What techniques does...
-
Explain what is meant by the term qualifying asset in the context of foreign currency transactions. Describe the accounting treatment for exchange differences that relate to qualifying assets.
-
Saina Supplies leases and sells materials, tools, and equipment and also provides add-on services such as ground maintenance and waterproofing to construction and mining sites. The company has grown...
-
1. Find the focal length of a convex mirror of radius of curvature 1m. 2. Focal length of a convex mirror is 50 cm. What is its radius of curvature? 3. Radius of curvature of a concave mirror is 25...
-
Refer to the financial statements of The Home Depot in Appendix A at the end of this book. Required: 1. How much did The Home Depots sales revenue increase or decrease in the year ended January 29,...
-
1) In what phase is CO2 at 25 atm and ?65 ?C? 2) Starting from the point described above, what phase change would eventually result from a decrease in pressure? 73.0 Pressure (atm) 5.11 1.0 solid...
-
Implement a C# application to sort 'N' randomly generated numbers using Rank sort. The Program should use following three design techniques: a) Serial (single threaded) application b) Multithreaded...
-
Given Goffman's discussion of team performance, team collusion, and derisive collusion, tell me how these operate in your performance team. Your performance team could be anything from you and your...
-
In responding to a Request for Proposal (RFP), XYZ Contractor is preparing a lump sum price proposal for digging an underground hole with specifications below. 10m x 10m x 5m - Concept Design No...
-
The following table gives the ages (in years) and prices (in hundreds of dollars) for eight used cars of a specific model. Find the correlation coefficient for this data. Age (years) x 8 3 6 9 2 5 6...
-
Two newly enrolled children at a community preschool have severe allergies - one to peanuts and peanut-based products and one to eggs (including egg cartons). In response, Brenda the new Director...
-
Kenneth jarred 30 liters of jam after 3 days. How many days does Kenneth need to spend making jam if he wants to jar 60 liters of jam in all? Solve using unit rates. 1 answer
-
Nike manufactures shoes and sportswear. How has the Internet changed the way this company communicates with its suppliers and retail customers?
-
What are five characteristics of good audience benefits?
-
Why might you choose a phone call, an email, a memo, a text message, or a particular social media for a given business message?
-
The Acme Corporation has been planning to acquire Best Products, and Acme employees are worried about how the acquisition will affect them. Ed Zeplin, Acmes human resource manager, has been visiting...
Study smarter with the SolutionInn App