Whoever answers this can you do step by step please (first tab of information)

(second tab of information - letter c)

Pro forma income statementScenario analysis Allen Products LP, wants to do a scenario analysis for the coming year. The pessimistic prediction for sales is $894,000; the most likely amount of sales is $1,134,000; and the optimistic prediction is $1,273,000. Allen's income statement for the most recent year is shown here 3 a. Use the percent-of-sales method, the income statement for December 31, 2019, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. b. Explain how this method could result in overstatement of profits for the pessimistic case and understatement of profits for the most likely and optimistic cases. c. Restate the pro forma income statements prepared in part a. to incorporate the following assumptions about the 2019 costs: $288,008 of the cost of goods sold is fixed; the rest is variable. $222,803 of the operating expenses is fixed; the rest is variable. All the interest expense is fixed. (Please see: B.) d. Compare your findings in part c. to your findings in part a. Do your observations confirm your explanation in part b? (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Allen Products, Inc. Income Statement for the Year Ended December 31, 2019 Sales revenue $936,700 Less: cost of good sold 462,730 Gross profits $473,970 Less: operating expenses 279,137 Operating profits $194,833 Less: interest expense 31,848 Net profit before taxes $162,985 Less: taxes (rate 30%) 48,896 Net profits after taxes $114,089 (VIIG UIT LUIC ICUIT Calcu VIT LUI LOPITIL COMTICI VI IC uala cavie VCIVWII UTUCI copy its contents into a spreadsheet.) Allen Products, Inc. Income Statement for the Year Ended December 31, 2019 Sales revenue $936,700 Less: cost of good sold Fixed 288,008 Variable 174,722 Gross profits $473,970 Less: operating expenses Fixed 222,803 Variable 56,334 Operating profits $194,833 Less: interest expense 31,848 Net profit before taxes $162,985 Less: taxes (rate 30%) 48,896 Net profits after taxes $114,089