please use excel and show how you did it.

the for the Income statement below glven the following information: Pilf In Net margin is i06 Gross margin is 31% Direct labor costs are 45% of the amount of Direct materials costs Tax rate is 35% mlssing values 6) Mashayekhi and Meckstroth Merchandising, Inc. Income Statement as of the year ending September 30, 2017 (in thousands) Sales revenue Less: Cost of goods sold 144,000 31,000 Direct materials Direct labor Manufacturing overhead Total cost of goods sold Gross profit Less: Operating expenses Selling expenses General and administrative expenses 7,100 Total operating expenses Earnings before interest and taxes Interest expense Income before income taxes Income tax expense NET INCOME (LOSS) 6,850