Managerial Accounting Excel HW help

Thanks in advance, really just need help figuring out which values to use to calculate the values to complete tables 2 and 3.

Data 1- Estimated Demand Demand parameter 1 Demand parameter 2 301,200 Table 1: Demand Schedule Table 3: Profit T2 Total Table 2: Total Cost Qua Price T3 T3 22,773 40.00 910,905 27,773 38.00 $ 1,055,360 32,773 $ 36.00 1179,814 37,773 $ 34.0O 1,284,269 42,773 32.00 1,368,724 constraints Maximum profit use"Max function Should reflect capacity constraints Original Values Position of maximum value in the list of possible values use "Match" function can take on values 1 to 6.(This is optional) Variable Cost Fixed Cost Maximum ology per unit Capacity For Reference only Do Not Chan 5 24.00 125,000 25,000$24.00 125,000 $ 21.00 255,000 35,000 21.00 255,000 25,000 35,000 Answer the following questions pertaining to the problem and your cost and profit analysis: Constant Enterprises is considering adding a new product to its fall line-up. The marketing department has worked up the expected demand for the new product at various prices in the range of $30 to $40. It is felt that demand would fall off sharply beyond a sales price of $40 and that it would be hard to be profitable below $30. The production department has come up with cost estimates for three technologies that could be implemented (A, B, and C) to manufacture the product. The details for each technology (variable cost per, total fixed cost, and maximum capacity in terms of units of production) are given in a table above Questions Complete the cost and profit tables provided above (Tables 2 and 3] 1. What is the price that maximize profit for technology A? 2. What is the maximum profit attained for technology A? 3. What is the price that maximize profit for technology B? 4. What is the maximum profit attained for technology B? 5. What is the price that maximize profit for technology C? 6. What is the maximum profit attained for technology C? 7. What is the profit for the "best" technology? 8. What is the price for the "best" technology? 9. If the value of cell C22 (VC of Technology C) is changed Use the Index function to find price that corresponsds with maximum profit. Index the price schedule. This method is optional to $19 does the choice of "best" technology change? 1 if Yes, O if no 10. If the value of cell C22 (VC of Technology C) is changed to $19 does the choice of optimal price change? 1 if Yes, O if no IMPORTANT Note If you changed the value of cell C22 in order to answer Q8 or Q9, be sure to reset its value to $17.00 before saving and submitting your spreadsheet