Hartman Company Model Let1=unitsofproduct1producedx2=unitsofproduct2producedMax301+152s.t.x1+0.352=0 Complete the spreadsheet by inserting formulas in cells B19:821 to calculate the lefthand side values for the constraints. Insert a formula to calculate the profit in cell B16. make are given in cell comments in the spreadsheet. Hover your monse over the cell to see the answer. MGT 476 Business Data Analytics II Chapter 12 Homework, Part 2 10. Hartman Company [Rroduction] a) Let x1= units of product 1 produced x2= units of product 2 produced Max301+152 s. x1+0.352=0 Part b mentions that fixed costs are not included in the calculation of profit. Hartman Company must pay these costs regardless of how many products are produced. Howover, the company will pay variable costs because they are direetly related to number of products produced. According to the optimal solution, how many of esch product chould Hartman make and what is the expected profith Product 1: Pmduct 2: Profit: In the Solver Parameters dialog, you seloct Simplex LP in the dropdown box to speeify the solving method for a linear program. The simplex method is the name of the algorithm that finds an optimal solution to an LP model. The algotithm will return numbers with frectional values unless you specify that the decision variables must be integen. In the Solver Parameters dialog, add a constraint that the docision variables must be whole numbers by choosing "int" in the dropdown list: According to the new optimal solution, how many of each product should Hartman make and what is the expected profit? Product 1: Pmduet 2: Profit: Notice that the profit dropped. Anytime a constraint is added to an LP the profit will never increase, alchough it could remain unchanged. Skip part b and c of this problem in the textbook