Assignment Instructions: Anderson Metals manufactures and sells #3 steel rebar that is used in the construction of slabs and driveways. The steel bar not only strengthens the finished concrete product, but it also has unique properties such that its temperature related expansion and contraction matches that of concrete. The product is manufactured and sold in 20' long "sticks." The product is generally produced and sold to match customer demand, and there is not a significant amount of finished goods inventory at any point in time. Summary information for 2021 is below. The data can be found on the "problem" worksheet. On the "worksheet" tab, prepare the contribution margin income statements so that you can answer the questions. Place your answer in the bold outlined cells. An income statement must be prepared for each scenario to receive credit! Sales were $35,000,000, consisting of 10,000,000 sticks. Total variable costs were $20,000,000. Total fixed costs were $12,000,000. Net income was $3,000,000. The general economic conditions appear to be deteriorating heading into 2022, and there is some concem about a reduction in sales volume. The following questions should each be answered independent of one another. DO NOT ANSWER THE QUESTIONS ON THE PROBLEM WORKSHEET. USE THE WORKSHEET TAB TO ANSWER THE QUESTIONS in the bold cells. An income statement must be presented for each scenario to receive credit! (a) What is the company's break-even point in "sticks?" (b) 1) What would be their net income or net loss if volume is reduced by 25%? 2) Can the company sustain a 25% reduction in total volume, and remain profitable? Answer both questions. (c) The company's sole shareholder, Doug Anderson, generally lives off of dividends paid by the business. The business typically declares and pays a dividend equal to $150,000 for Doug's normal living expenses. Doug is demanding a $100,000 increase in dividends for 2022. What total sales volume must Anderson Metals produce in 2022 to accomodate the increase in dividends andmaintain the same net income? (d) If total volume is expected to decrease by 10%, and the company wishes to continue to produce a $3,000,000 net income by raising the per unit selling price, 1) what revised per stick price must be imposed? 2) Will this strategy necessarily work? Answer both questions. Justify your answer to the second question. A "Yes" or "No" answer will not recieve credit. (e) If the company expects a drop in raw material prices to reduce total variable costs to $1.75 per stick, but all other revenue and cost factors to be unaffected, what will be the revised break- even point in sales and units?