answer all Q please
Santiago 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 D JE F Uno per kg/hour A B 2 3 4 3.5 21 Direct materials(per kg) Direct labour (per hour) Direct Expenses Variable Cost per unit Selling price Sales Demand Dos E 52.50 78.75 26.25 157.50 237.50 1,300 70.00 105.00 17.50 192.50 253.75 1,750 Tres E 78.75 210.00 17.50 306.25 400.00 900 ON 009 Cuatro E 105.00 183.75 43.75 332.50 475.00 2,150 11 12 13 E13 Una Dos Tres Cuatro Rank the Direct Materials by Most Expensive to purchase Required Advice Santiago by ranking the products,(First is the product that should be made first and last would be made last) Tres Cuatro Uno Choose... Dos Choose... Choose.... Choose... Order of production What formula needed in E13, if Santiago is going to Rank the Direct Materials by Most Expensive to purchase Choose... A printing manufacturer sells inks to its customers in 4 separate colours. The latest results of sales have just been released and the Senior Manager is not happy with the results for some of the products. He has suggested that we drop the ones that are not making profit. Before making the final decision, he has asked you to tell him which products to DROP and which ones to KEEP. He also wants to know the overall profit that can be made from the best possible desion. Product Red Green Yellow Magenta Overall Profit Sales 2450 2450 11971 Variable costs -2100 -1050 -2520 -8190 Fixed costs -350 Profit/(Loss) -35 4550 2521 -2520 - 700 - 770 -385 -875 2625 -2310 1471 -349 Use the dropdown menu to select which products to drop and which one to keep Decisions Green Product Red Decision DROP Yellow KEEP Magenta KEEP KEEP . . How much overall profit would be made from making the best possible decision Enter your answer to the nearest whole number with no E sign Part of your answer requires attention : Input 5 (numeric input) - Please enter an