Can I get help with this.

Required information Excel Analytics 13-1 (Static) Volume Trade-Off Decisions (LO13-5) [The following information applies to the questions displayed below.) Conroy Company manufactures two products-B100 and A200. The company provided the following information with respect to these products: Estimated customer demand (in units) Selling price per unit Variable expenses per unit B100 A200 2,800 2,000 $1,200 $2,100 $ 700 $1,200 The company has four manufacturing departments-Fabrication, Molding, Machining, and Assemble & Pack. The capacity available in each department (in hours) and the demands that one unit of each of the company's products makes on those departments is as follows: B100 A200 (hours per unit) (hours per unit) Fabrication Molding Machining Assemble & Pack 1 2 2 0 2 2 0 3 Capacity (in hours) 4,000 6,000 5,000 4,500 The company is trying to decide what product mix will maximize profits. Given that its fixed costs will not change regardless of the chosen mix, the company plans to identify the product mix that maximizes its total contribution margin. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a brief tutorial on SOLVER in Excel. Click here for a a brief tutorial on Charts in Excel. C12 =(-0.5*B12)+"Requirements 1-3'!$K$7 A B D E F G H Fabrication A200 Units Molding Machinery 0 Assemble & Pack 0 0 REBOUWN B100 Units 0 500 1000 1500 2000 2500 2500 3000 3500 4000 OO -3000 -2000 0 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Requirements 1-3 Requirement 4 Requirement 5 + Requirement 7 100% Ready Excel Analytics 13-1 (Static) Part 5 5. In the Excel template, navigate to the "Requirement 5" tab. Using Charts, prepare a graph using the following three guidelines. First, label the X-axis B100: Units Produced and the Y-axis A200: Units Produced. Then establish a range on each axis of 0 - 4,000 units. Second, plot four lines that depict the production possibilities within each of the four departments. For example, the Fabrication Department could produce a maximum of 4,000 units of B100 = 4,000 hours available + 1 hour per unit) or a maximum of 2,000 units of A200 (= 4,000 hours available + 2 hours per unit). Thus, this line should connect two data points, 4,000 units on the X-axis and 2,000 units on the Y-axis. Third, once you have plotted all four lines, pay particular attention to the portion of the graph that is enclosed by the four lines because it depicts the full range of Conroy's production possibilities. Based on the graph that you have created, which of the following statements are true? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) Producing 1,000 units of A200 and 1,500 units of B100 is outside the range of production possibilities. 2 Producing 1,500 units of A200 and 1,500 units of B100 is outside the range of production possibilities. 2 Producing 500 units of A200 and 2,500 units of B100 is within the range of production possibilities. Producing 2,000 units of A200 and 1,500 units of B100 is within the range of production possibilities