70.2K

Verified Solution

Link Copied!

PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I WILL REALLY APPRECIATE. THANKS

. B D E F H 1 K L M N O P Q R S 3 Price Quanty Quantity 4 Discount table 1 5 6 7 8 9 Totals due 101 48 56 2 35 21 635 65 Price table Parts Unit Price Bearing 17.34 Gear 23.56 Widget A14.76 COG 20.21 Bolt 1.54 Washer 10 25 100 500 1000 0% 1% 2% 3% 4% 5% Customers Parts Customer1 Bearing Customer2 Gear Customer3 Widget Customer4 COG Customer5 Bolt Customer6 Washer Customer 7 Gear Customer8 Gear Customer9 Bearing Customer10 Bolt Customer11 Washer Customer12 Gear Customer13 Bearing Customer14 Widget Customer15 Gear Customer16 Bolt 10 11 12 13 14 1.43 3 243 31 32 11 12 15 Use this table to determine the correct price here. Use the discount table to determine "Total due". You must use the appropriate function(s) to maximize your marks. 16 17 18 19 31 314 20 21 22 Customer17 Washer Customer18 Widget Customer19 Bearing Customer20 Gear 4 34 54 65 23 24 25 . B D E F H 1 K L M N O P Q R S 3 Price Quanty Quantity 4 Discount table 1 5 6 7 8 9 Totals due 101 48 56 2 35 21 635 65 Price table Parts Unit Price Bearing 17.34 Gear 23.56 Widget A14.76 COG 20.21 Bolt 1.54 Washer 10 25 100 500 1000 0% 1% 2% 3% 4% 5% Customers Parts Customer1 Bearing Customer2 Gear Customer3 Widget Customer4 COG Customer5 Bolt Customer6 Washer Customer 7 Gear Customer8 Gear Customer9 Bearing Customer10 Bolt Customer11 Washer Customer12 Gear Customer13 Bearing Customer14 Widget Customer15 Gear Customer16 Bolt 10 11 12 13 14 1.43 3 243 31 32 11 12 15 Use this table to determine the correct price here. Use the discount table to determine "Total due". You must use the appropriate function(s) to maximize your marks. 16 17 18 19 31 314 20 21 22 Customer17 Washer Customer18 Widget Customer19 Bearing Customer20 Gear 4 34 54 65 23 24 25

Answer & Explanation Solved by verified expert

See Answer