Please help with ticklers I have attached my values, formulas and chart.

TICKLERS (optional) Worksheet. The MFG2 worksheet presents the company's manufacturing activities for 2011, The company also had the following selling and general activities in 2011: sales of $13,503,000, seling expenses of $2,400,000, and general expenses of $1,200,000. Modify the worksheet to include this information in the Data Section and change the Answer Section so that it is in the form of an income statement. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as MFGT. Hint: Expand the Data Section to include these additional input items alphabetically. Insert a row for sales under the heading in the Answer Section. Add the rest of the income statement information to the bottom of the schedule. You will need to enter formulas for gross profit, all the expenses, and net income. You will also need to change the statement name. Chart. Using the MFG2 file, prepare a single 3-D bar chart to show the dollar amount of materials, labor, and overhead incurred by Twisp in 2011 and 2012. Complete the Chart Data Table and use it as a basis for preparing the chart. Enter all appropriate titles, legends, and formats. Enter your name somewhere on the chart. Save the file again as MFG2. Print the chart. MONO A B 1 2 MFG 3 Manufacturing Accounting 4 5 Data Section 6 7 Depreciation--equipment $180,000 8 Direct labor 2,568,000 9 Direct materials inventory, 1/1 366,000 10 Direct materials inventory, 12/31 372,000 11 Factory rent 305,640 12 Finished goods, 1/1 528,000 13 Finished goods, 12/31 690,000 14 Indirect labor 150,000 15 Indirect materials 105,000 16 Purchases of direct materials 2,580,720 17 Work in process, 1/1 121,200 18 Work in process, 12/31 114,660 19 20 Answer Section 21 22 Twisp Industries 23 Schedule of Cost of Goods Manufactured and Sold 24 For the Year Ended December 31, 2011 25 26 Direct materials 27 Direct materials inventory, 1/1 28 Add: Purchases of direct materials 29 Cost of direct materials available 30 Less: Direct materials inventory, 12/31 31 Cost of direct materials used 32 Direct labor 33 Manufacturing overhead: 34 Factory rent $305,640 35 Depreciation--equipment 180,000 36 Indirect labor 150,000 37 'Indirect materials 105,000 38 Total manufacturing costs 39 Work in process, 1/1 40 Total work in process available 41 Less: Work in process, 12/31 42 Cost of goods manufactured 43 Finished goods, 1/1 44 Cost of goods available for sale 45 Less: Finished goods, 12/31 46 Cost of good sold $366,000 2,580,720 $2,946,720 372,000 $2,574,720 2,568,000 740,640 $5,883,360 121,200 $6,004,560 114,660 $5,889,900 528,000 $6,417,900 690,000 $5,727,900 47 B MFG Data Section 180000 2568000 366000 372000 305640 528000 690000 150000 105000 2580720 121200 114660 Answer Section Twisp Industries 7 Depreciation--equipm 8 Direct labor 9 Direct materials inven 10 Direct materials inven 11 Factory rent 12 Finished goods, 1/1 13 Finished goods, 12/3 14 Indirect labor 15 Indirect materials 16 Purchases of direct n 17 Work in process, 1/1 18 Work in process, 127 19 20 20 21 22 23 20 24 24 23 26 Direct materials 27 Direct materials ir 28 Add: =A16 29 Cost of direct mat 30 Less: =A10 31 Cost of direct materia 32 Direct labor 33 Manufacturing overhe 34 Factory rent 35 =A7 36 =A14 37 =A15 38 Total manufacturing 39 Work in process 40 Total work in proc 41 Less =A18 42 Cost of goods manufa 43 -A12 44 Cost of goods ava 45 Less: Finished goods, 12/31 46 Cost of good sold =C9 =C1 =IF(D28=0,0,D28+D27 =C10 =D29-D30 =C8 =C11 =C7 =C14 =C15 =IF(C37=0),0, SUM(C34:C37)) =D31+D32+D37 =C17 =IF((D38=0),0, (+D38+D39)) =C18 =D40-D41 =C12 =D42+D43 =C13 =D44-D45 A B D E F Components of Manufacturing Costs Overhead 12% Materials Labar 44% 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 Chart Data Table Materials 2574720 Labor 2568000 Overhead 740640 2012 Chart Tickler Data Table 2011 Materials Labor Overheadl