How to do this on excel?

Calibri 11 v B v v Av ... E ab General V to A1 fx Accessibility tab summary: Cost and sales information for Sims Company is presented in cells A4 to C12. A statement for requirement 1 is presented in rows 14 to 18 and anincome S A B C D E F G H I J K McGraw Hill Sims Company began operations on January 1. Its cost and sales information for this year follow. W N Check Answers A Direct materials $40 per unit 5 Direct labor $60 per unit 2 6 Variable overhead $30 per unit Check My Work + 7 Fixed overhead $7,000,000 per year 8 Variable selling and administrative expenses $11 per unit 9 Legend Fixed selling and administrative expenses $4,250,000 per year 10 Units produced 100,000 units Graded cell: Leave blank 11 Units sold 70,000 units needed. 12 Sales price $350 per unit 13 Scratchpad: Use as a nor 14 Required: workspace 15 1. Prepare an income statement for the year using variable costing. 16 17 (Use cells A4 to C12 from the given information to complete this question. Negative amounts or amounts to be deducted 18 should be input and displayed as negative values. All other answers should be input and displayed as positive values.) 19 20 SIMS COMPANY 21 Income Statement (Variable Costing) 22 23 24 25 26 27 28 & Graded Worksheet + Save and Return to Assign Calculation Mode: Automatic Workbook Statistics