hi. i provided the spreadsheet screenshots for this question as well. pls someone attempt

Income statements under absorption costing and variable costing Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (125,000 units) during the first month, creating an ending inventory of 17,000 units. During February, the company produced 108,000 units during the month but sold 125,000 units at $580 per unit. The February manufacturing costs and selling and administrative expenses were as follows: Unit Total Number of Units Cost Cost Manufacturing costs in February 1 beginning inventory: Variable 17,000 $290.00 $4,930,000 Fixed 17,000 32.00 544,000 Total $322.00 $5,474,000 Manufacturing costs in February: Variable 108,000 $290.00 $31,320,000 Fixed 108,000 36.90 3,985,200 Total $326.90 $35,305,200 Selling and administrative expenses in February: Variable 125,000 24.60 $3,075,000 Fixed 125,000 2.00 250,000 Total 26.60 $3,325,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Prepare an income statement according to the absorption costing concept for February. Enter all amounts as positive numbers. Fresno Industries Inc. Absorption Costing Income Statement For the Month Ended February 28 Cost of goods sold: $ b. Prepare an income statement according to the variable costing concept for February. Enter all amounts as positive numbers. Fresno Industries Inc. Variable Coctinn Income Statement b. Prepare an income statement according to the variable costing concept for February. Enter all amounts as positive numbers. Fresno Industries Inc. Variable Costing Income Statement For the Month Ended February 28 Fixed costs: Arial 10 B Merge General Ev 27 v Ov B27 fx C D E F G H J A B Income statements under absorption and variable costing 1 2 Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity during the first month, creating an ending inventory. The following data summarize the results for the February manufacturing costs, 3 selling and administrative expenses and general information about Fresno Industries Inc.'s operations for January and February. 4 5 DATA 6 Number of Units Unit Cost Total Cost 7 Manufacturing costs in February 1 beginning inventory: 8 Variable 17,000 $290.00 $4,930,000 9 Fixed 17,000 32.00 544,000 10 Total $322.00 $5,474,000 11 Manufacturing costs in February: 12 Variable 108,000 $290.00 $31,320,000 13 Fixed 108,000 36.90 3,985,200 14 Total $326.90 $35,305,200 15 Selling and administrative expenses in February 16 Variable 125,000 $24.60 $3,075,000 17 Fixed 125,000 2.00 250,000 18 Total $26.60 $3,325,000 19 20 Goods sold in February 125,000 $580 21 Select the corresponding accounts in the dropdowns in cells B27, B29:B34, B39:B43, B45:48. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C and D columns. Enter all amounts as positive numbers. Transfer the = Data Sheet1 + Arial 10 B Av Merge General 60 00 .00 >0 27 327 fx G H B C D E F Select the corresponding accounts in the dropdowns in cells B27, B29:B34, B39:B43, B45:48. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C and D columns. Enter all amounts as positive numbers. Transfer the numeric results for the green entry cells (C29:C30, C45:C46, D27, D31:D34, D39:D43, D47:D48) into the appropriate fields in CNOWv2 for 22 grading. 23 24 Fresno Industries Inc. 25 Absorption Costing Income Statement 26 For the Month Ended February 28 Formulas 27 a. 28 Cost of goods sold: 29 30 31 32 33 34 35 36 Fresno Industries Inc. 37 Variable Costing Income Statement 38 For the Month Ended February 28 Formulas 39 b. 40 41 42 43 44 Fixed costs Arial 10 B v abe Merge v General $ v 60 .00 .00 >0 HIV 2 B27 fx A B D E F G I 1 Fresno Industries Inc. Variable Costing Income Statement For the Month Ended February 28 Formulas Fixed costs: 36 37 38 39 b. 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60