I need help in this question. Please do it correctly and 100%. Please show me the formulas or methods so i can follow it, please do it as the excel sheets are to make it easy. I will be very thankful

Part B

Part C

B D E F G H J K L 1 $10! $20 $16 A 1 Assembling and testing computers 2 3 Cost per labor hour assembling 4 Cost per labor hour testing, line 1 5 Cost per labor hour testing, line 2 6 6 7 Inputs for assembling and testing a computer 8 9 Labor hours for assembly 10 Labor hours for testing, line 1 11 Labor hours for testing, line 2 12 Cost of component parts 13 Selling price 14 Unit margin, tested on line 1 15 Unit margin, tested on line 2 16 Model 1 Model 2 Model 3 Model 4 Model 5 Model 6 Model 7 Model 8 Model 9 Model 10 5.5 6.7 5 6 5.7 4.5 5.8 7 5.4 5.2 1.5 2 2 2 2.5 2.5 2.5 3 3.5 2.5 2 2.5 2.5 2.5 3 3 3.5 3.5 4.5 3 $150 $225 $225 $225 $250 $250 $250 $300 $350 $250 $350 $450 $460 $470 $500 $525 $530 $600 $700 $550 16 17 Assembling, testing plan (# of computers) 18 Model 1 Model 2 Model 3 Model 4 Model 5 Model 6 Model 7 Model 8 Model 9 Model 10 1500 1250 1250 1250 1000 1000 1000 800 600 900 Hours used