I need assistance calculating the common-size percentages on the worksheet that is attached. The yellow columns under Company A and Company B contain drop-down lists that have percentages from 1% to 100%. I appreciate the help. Thanks!

Problem 1. Commonsize percentages are often used to compare the statements of companies of unequal size. The condensed income statements of Companies A and B are given below. Enter in the spaces provided the amounts expressed in commonsize percentages. Company A and Company B Income Statements for Year Ended December 31, 2007 Dollar Amounts Sales Cost of goods sold Gross margin Selling expenses Administrative expenses Total operating expenses Income 2. Company A $450,000 261,000 $189,000 $81,000 45,000 $126,000 $63,000 CommonSize Percentages Company B $525,000 210,000 $315,000 $89,250 52,500 $141,750 $173,250 Company A Company B After expressing the amounts of the income statements in commonsize percentages, examine them and name the company that operated more efficiently