Review attachment and make a spreadsheet

EX 6-9 Variable and absorption costing Obj. 1 if A. Contribution Ansara Company had the following abbreviated income statement for the year ended December margin. 56.263 31, ZOYZ: (in millions] Sales ......................................................................... 518.769 Cost of goods sold ............................................................ $15,471 Seiling, administrative. and other expenses .................................... 2.049 Total expenses ............................................................ 51 7,520 Income from operations ...................................................... 5 1,249 Assume that there were $3,860 million xed manufacturing costs and $1,170 million xed sell- ing, administrative, and other costs for the year. The nished goods inventories at the beginning and end of the year from the balance sheet were as follows: January 1 $2,354 million December 31 $2,408 million Assume that 30% of the beginning and ending inventory consists of xed costs. Assume work in process and materials inventory were unchanged during the period. A. Prepare an income statement according to the variable costing concept for Ansara Company for 20Y2. (Round numbers to nearest million.) B. - Explain the difference between the amount of income from operations reported under the absorption costing and variable costing concepts. (Round numbers to nearest million.)