show all calculations

On these Excel sheets, you will need to prepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible but The cells will be checked for appropriate formulas, when appropriafe. Please highlight the specific answer to the question being pased. Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to take next year to reach profitability. They begin by reviewing the most recent income statement (below). overhead is forty-five cents per unit. The plant has a capacity of 75,000 units per year. In order to facilitate the work of the management team, you are asked to prepare various spreadsheets and specific computations in Excel. A) Reformat the income statement in the contribution format. Include both a Total column and Per Unit column in the statement. D) Again with original data, the tean speculates that the problem mighs lie in inadequate pronsotion. They want to knew by how much they could increase advertising and shill allow the company to earn a target profit of 5% of sales on sales of 60,000 units