please i just need help with this last question plz answer asap

8. Prepare a Budgeted Income Statement for the quarter for FireGlobe. Assume interest expense of $0, and income tax expense of 21% of income before taxes. FireGlobe's goal for the quarter is to make its net income greater than 5% of its sales revenue. To determine whether the company achieves the goal, use @ IF function. In the IF function, you need to label "Achieved" if it achieves the goal (if the condition is met) or "Not Achieved" if it does not achieve (if the condition is not met). Use the CELL right next to 'Net Income' cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue*5%) is met or not. 11:04 wy Diest September My units to produce 22 Laber Hours per 30 30 Falcular Here UN 200 12.0 240 cost per labor hour 25 Total Direct Laborat L.900.00 182,000 2,100 250 Manufacturing Dead Budget July August September Total units to Produce scopert Totes TL 2. " Junits to Produce indirector per 100 100 Total Indirect labor 200 32,00 17.00 sollte Overead 3.100 72.00 7.000 15.00 Fedora indirector 5.000 5,000 15.000 Depreciation 1.000 35.000 15.000.000 Other 8.000 3.600 6.000 TL Totaled head 2.000 2,100.00 Total head out L100 L 104.00 1,0 Deprecat 15.000 15.000 45.000 Total header 1.100 M.6.0 Best at berletal es LIM Outwerper 20 Total Outware 0,000 120,000 2.0 Total Revenue 57000 70.00 SO 2152 Como Sales Comunion WAND . BL SU Total de 147,00 18.00 SAA wees Le 130.000 Marketing Feed Total expen 2212 . LI A UM 2 the for wy Direct labore (alcuttin| Reged July August September Total uly August September Units to produce 21 530 Labor Hours per 30 10 10 20 Total Labor Hours required 2,340 4820 12,35 234910 205.2010 Cost perator how 25 Total Director Com 1,900 100.00 182,000 12 234035 282035 3200 Manufacturing Overhead det August September Total July August September Units to produce 21 530 28 Utilities cost perunt 50 50 90 Total Utilities.com 11.700 100 Units to produce 234 520 1.216 Indirect labor per 300 100 300 300 Total Indirector 23.400 L200 2.300 123,600 234100 482100 50100 Total Variable Overhead 15,300 72.00 78,000 1,400 Fleed Overhead indirect labor 5.000 5.00 5.000 35.000 Depreciation 15.000 15.000 35.000 45.000 000 8.000 6,000 18.000 Total Fixed Overhead 26,000 26.000 2.00 78.000 Total Overhead con 61,500 48,300 14000 1400 Depreciation 15.000 15.000 15. 45.000 Total Overhead disbursement 41,100 100 0.000 20,400 July August September Total Unit Sale 400 510 LIS Output 250 250" 250 Total Outward 90,000 120,000 12. 330.010250 Total Sales Revenue 530200.000 11,4 2,2 Sales Commissionate 30 10 Total Sales Common . 235,125 500 600 Total Variable SAA 102,420 16.566 845 Tied Webpage fees 1.500 1,500 1_500 4.500 Administration 0.000 0.000 120.000 Marine 150 15.000 5.000 Feed 22 Total expenses 223.620.00 28. 102,335 8. Prepare a Budgeted Income Statement for the quarter for FireGlobe. Assume interest expense of $0, and income tax expense of 21% of income before taxes. FireGlobe's goal for the quarter is to make its net income greater than 5% of its sales revenue. To determine whether the company achieves the goal, use @ IF function. In the IF function, you need to label "Achieved" if it achieves the goal (if the condition is met) or "Not Achieved" if it does not achieve (if the condition is not met). Use the CELL right next to 'Net Income' cell to make the IF function that returns one of the labels based on whether the condition (net income > sales revenue*5%) is met or not. 11:04 wy Diest September My units to produce 22 Laber Hours per 30 30 Falcular Here UN 200 12.0 240 cost per labor hour 25 Total Direct Laborat L.900.00 182,000 2,100 250 Manufacturing Dead Budget July August September Total units to Produce scopert Totes TL 2. " Junits to Produce indirector per 100 100 Total Indirect labor 200 32,00 17.00 sollte Overead 3.100 72.00 7.000 15.00 Fedora indirector 5.000 5,000 15.000 Depreciation 1.000 35.000 15.000.000 Other 8.000 3.600 6.000 TL Totaled head 2.000 2,100.00 Total head out L100 L 104.00 1,0 Deprecat 15.000 15.000 45.000 Total header 1.100 M.6.0 Best at berletal es LIM Outwerper 20 Total Outware 0,000 120,000 2.0 Total Revenue 57000 70.00 SO 2152 Como Sales Comunion WAND . BL SU Total de 147,00 18.00 SAA wees Le 130.000 Marketing Feed Total expen 2212 . LI A UM 2 the for wy Direct labore (alcuttin| Reged July August September Total uly August September Units to produce 21 530 Labor Hours per 30 10 10 20 Total Labor Hours required 2,340 4820 12,35 234910 205.2010 Cost perator how 25 Total Director Com 1,900 100.00 182,000 12 234035 282035 3200 Manufacturing Overhead det August September Total July August September Units to produce 21 530 28 Utilities cost perunt 50 50 90 Total Utilities.com 11.700 100 Units to produce 234 520 1.216 Indirect labor per 300 100 300 300 Total Indirector 23.400 L200 2.300 123,600 234100 482100 50100 Total Variable Overhead 15,300 72.00 78,000 1,400 Fleed Overhead indirect labor 5.000 5.00 5.000 35.000 Depreciation 15.000 15.000 35.000 45.000 000 8.000 6,000 18.000 Total Fixed Overhead 26,000 26.000 2.00 78.000 Total Overhead con 61,500 48,300 14000 1400 Depreciation 15.000 15.000 15. 45.000 Total Overhead disbursement 41,100 100 0.000 20,400 July August September Total Unit Sale 400 510 LIS Output 250 250" 250 Total Outward 90,000 120,000 12. 330.010250 Total Sales Revenue 530200.000 11,4 2,2 Sales Commissionate 30 10 Total Sales Common . 235,125 500 600 Total Variable SAA 102,420 16.566 845 Tied Webpage fees 1.500 1,500 1_500 4.500 Administration 0.000 0.000 120.000 Marine 150 15.000 5.000 Feed 22 Total expenses 223.620.00 28. 102,335