PPLS USE EXCEL SOLVER USE EXCEL SOLVER PLEASE AND SHOW FORMULAS

Paste BIU . . Merge & Centre KU% 9 of 98 Conal Format Formatting as Table C6 A X fx A B D E F G 50 min. in class test 2019 H K M Save your work every 10 mins. Submit your final version submit to Dropbox N 0 P cutoff 200 50,000 300 30,000 80,000 55,00,000 70,00,000 85,00,000 84,000 1 CKT1.3 Ltd 2 Student ID: 3 Data Input Area 4 Motherboard Motherboard Motherboard 7 Monitor 8 Labour 9 Labour 10 Labour 11 Labour Tahu 12 Fixed overheads low 13 Fixed overheads 14 Fixed overheads medium 15 Fixed overheads 16 Fixed overheads high 17 Selling price per unit 18 Sales volume 19 20 Output area 21 22 23 24 2002 50 50 cutoffp mo 7,000 months in 12 109 100 55,00,000 cutoffi 30,000 70,00,000 cutoff2 80,000 85,00,000 750 units pa 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 1,00,000 + 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 42 42 A Sheet1 + Paste BIU . . Merge & Centre KU% 9 of 98 Conal Format Formatting as Table C6 A X fx A B D E F G 50 min. in class test 2019 H K M Save your work every 10 mins. Submit your final version submit to Dropbox N 0 P cutoff 200 50,000 300 30,000 80,000 55,00,000 70,00,000 85,00,000 84,000 1 CKT1.3 Ltd 2 Student ID: 3 Data Input Area 4 Motherboard Motherboard Motherboard 7 Monitor 8 Labour 9 Labour 10 Labour 11 Labour Tahu 12 Fixed overheads low 13 Fixed overheads 14 Fixed overheads medium 15 Fixed overheads 16 Fixed overheads high 17 Selling price per unit 18 Sales volume 19 20 Output area 21 22 23 24 2002 50 50 cutoffp mo 7,000 months in 12 109 100 55,00,000 cutoffi 30,000 70,00,000 cutoff2 80,000 85,00,000 750 units pa 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 1,00,000 + 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 42 42 A Sheet1 +