please answer both questions
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 D LE 2 Und Dos Tres 3 Cuatro E per hour E E E E 4 Direct materials(per kg) 84.00 112.00 168.00 126.00 7 5 Direct labour (per hour) 168.00 126.00 336.00 29-1.00 14 6 Direct Expenses 28.00 42.00 28.00 70.00 7 Variable Cost per unit 280.00 280.00 532.00 490.00 8 Selling price 406.00 380.00 640.00 760.00 9 Sales Demand 4,375 3,250 2,250 5,175 10 11 12 Uno Dos Tres Cuatro 13 FB Rank the sales by the cheapest price to sell Required Advice Bilbao by ranking the products (First is the product that should be made first and last would be made last) Uno Dos Tres Cuatro Choose.... Choose... - Choose.... Order of production Choose What formula needed in F13, if Bilbao is going to Rank the Sales by the cheapest price to sell Choose Eperk hour Direct materials(@3.5 per kg) Direct labour (@21 per hour) Direct Expenses Selling price Sales Demand Product 1 Product 2 Product 3 Product 4 E E 21.60E 21.60E 13.77E 20.25 E 27.00 E 21.26 56.70E 49.61 E 2.36E 7.09 4.73 1181 E 70.88 87.75 E 108.00 114.75 22,050 9,100 6,300 15.050 7 21 Product 1 Product 3 Rank Product 2 2 Product 4 3 A trainee management accountant has been helping a client with choosing the best products to make by ranking the clients products as above The limiting factor is materials and this is limited to a maximum of 95,000 kgs He is not sure how to calculate and create the optimal production plan. Help the trainee and calculate the number of products that need to be made Product 1 Product 2 Product 3 Product 4 Units Produced Enter your units to the nearest whole number with no commas