Bilbao is looking at launching four new products to add on to the range that he already has. He is not quite sure whether he will be able to make all the four products, so he has approached you to help him with his decision. A B G 2 3 4 Direct materials(per kg) 5 Direct labour (per hour) 6 Direct Expenses 7 Variable Cost per unit 8 Selling price 9 Sales Demand Uno Dos Tres Cuatro per kg/hour 84.00 112.00 168.00 126.00 7 168.00 126.00 336.00 294.00 14 28.00 42.00 28.00 70.00 280.00 280.00 532.00 490.00 406.00 380.00 640.00 760.00 4,375 3,250 2,250 5,375 10 11 12 Uno Dos Tres 13 Rank the Sales by the cheapest price to sell Cuatro F13 Advice Bilbao by ranking the products (First is the product that should be made first and last would be made last) Order of production Uno 1,2,3 or 4 Dos 1,2,3 or 4 Tres 1,2,3 or 4 Cuatro 1,2,3 or 4 What formula needed in F13, if Bilbao is going to Rank the Sales by the cheapest price to sell? =RANK(F8,$C$8:$F$8,0) =RANK(F7,$C$4:$F$4,0) =RANK(F8,$C$8:$F$8,1) =RANK(F7,$C$4:$F$4,1) =RANK(F9,$C$9:$F$9,1) =RANK(F9,$C$9:$F$9,0)