A1 Xfx Accessibility tab summary: Cost and sales information for Sims Company is presented in cells A4 to C12. A sta A B C D E F G H M 1 2 Sims Company began operations on January 1. Its cost and sales information for this year follow. 3 4 Direct materials 5 Direct labor $40 per unit $60 per unit 6 Variable overhead 7 Fixed overhead 8 Variable selling and administrative expenses 9 Fixed selling and administrative expenses 10 Units produced 11 Units sold 12 Sales price 13 14 Required: $30 per unit $7,000,000 per year $11 per unit $4,250,000 per year 100,000 units 70,000 units $350 per unit 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 BGraded Worksheet + Calculation Mode: Automatic Workbook Statistics Lea need Sc works