set up needs to be done on excel i also need to seee formula

E20 85 o D E 1 MGMT 5123, ASSIGNMENT 10, SPRING 2021 2 3 PROBLEM: 4 A company manufactures three products: A, B, and C. The wholesales price, variable cost, 5 and manufacturing time are given in the following table: 6 7 Product Wholesales Price (S/) Variable Cost (S/u) Manufacturing Time (hrs/u) 8 A 150 77 2.7 9 B 36 2 10 C 71 32 1.3 11 12 These products are manufactured in batches of 150 units and partial batches are not possible. 13. The company believes that the demand for each product is at least 25,000 units and wants 74 to satisfy this demand. It also expects that it cannot sell more than 80,000 units of product A, 15 60,000 units of product B, and 45,000 units of product C. If the company has 193,000 hours 16 of manufacturing time, how many batches of A, B, and C should it produce in order to 17 maximize profit while meeting the minimum demand? 18 19. The company will use an integer programming model with the following decision variables: 20 A=number of batches for product A, 21 B = number of batches for product B, 22 C = number of batches for product C. 23 24 You must help the company to formulate the integer programming model and find the 25 optimal solution using Excel Solver. 26 Create a spreadsheet model and solve it. Explain the meaning of the optimal solution for the 27 company in the context of the problem. 28