B D H N Annual Cash Flow Fin Operations 20:21 Feb Mach April May Ay 372.000 712,000.00.000.000.000.000.000.000.000.000.000.000.000.000.00 2.000.00 $516,000.00 $6.000.000.00 Aug Set Now Dec Ta om HES IRT G Oct 9 15 7.120 TASO 7.000 500 6,450 3910 3,00 4.000 006 5400 DOCZ 1300 3100 15 000 1300 1200 1,300 1,300 1300 1,300 OLI 1300 1300 Overal Adela 7 Promotion Carack Expers Cape and Once Ruhr 10 Employee Wages and Sales 11 Employees 12 Erreftrument 1 es 2011 2.250 2017 2011 2017 2,250 2017 5.000 8.000 1300 8,000 2017 2250 2005 2010 20.017 2760 781 2011 2007 2.50 TI 216 4130 2017 2250 ORE 11 15.00 10000 J12.201 27000 MOIT 22 78 2017 2250 781 1050 10 9 2,24 2.114 2,107 3295 2,200 701 100 2.870 200 2.95 1102 005 3370 20 2018 4.410 100 00 1.000 OU 000 100 500 100 500 INO 500 15:00 500 1500 6.000 1.00 4405 500 1.500 350 tou 43 440 500 500 046 500 1500 10 100 13 440 001 06 950 100 DRC DOC 500 1.30 250 100 OR Tres Les Offices 17 Officer 10 Otices Powden 20 21 The 22 Charon Dwd Member 14 Leden 26 Med OSE 100 250 100 w 440 100 100 03 440 500 1.500 100 430 40 350 100 and Cher 1.000 100 1200 20 CD 100 430 410 CL 100 431 440 CO 40 440 100 410 CE OFT 3000 1000 00 ONE 1000 1.000 DIY 0 100 0 20 09 ON 000 NU 10 WIT 50 100 10 100 50 100 ME Tube 50 100 SO os 10.000 000 1200 100 00 LCD . 000 SOD TES 0 50 100 100 100 15.04 Tulcea CD COD 30 21 C M 3 Only enter data into light blue cells. + 2 3 4 5 6 7 Social Securg Rate Social Security Limit Medicare Rule FUTARA FUTA Limit SUTAR SUTA Limit 6.2013 79,700 1455 0.00 7.300 2.00 January Februay March April May June July August September October November Decembet Total 9 Rem 10 Over Vages 12 Social Security Medicare FUTA SUTA 3,000 9.000 550 9,000 550 3,000 560 3,000 558 3.000 558 31 3.000 558 131 5.000 550 131 3.000 3:30 9,000 558 131 9,000 558 131 9,000 558 a 101 131 ICE I ICI 100.000 6.696 1566 42 440 - 42 180 130 03 - 3 6.500 6.500 6,500 403 5,500 6,500 6,500 1 Project Manager/Estimator Vages 13 Sold See 20 Medicare FUTA SUTA 70,000 6.500 403 94 6,500 403 COM 6500 403 400 6,500 400 94 COP CO 6,500 403 94 6,500 400 96 CON PG 4806 15 14 16 16 94 HE BC 96 3 130 1.11 42 440 OCH 50 5500 15.500 15,500 15.500 1,500 15.500 15,500 15.500 15.500 15.500 15.500 15.500 195.000 == 42 1735 1230 200 42 1735 3233 200 47 52 1735 3.23 200 47 19 65 427 12.35 3230 200 47 , 62 1735 3,230 200 47 42 1235 3.233 200 47 42 1735 3230 200 421 1,35 2233 200 47 42 17.35 3230 200 47 42" 17:35 2,233 200 47 42" 1735 3.230 200 67 $628 42 1735 3,733 200 47 2.405 CC 65 65 15 65 52 62 440 SC 45 45 20 Office Salaries 25 2 Secretary/Receptionist 27 House Veel 29 Vage Re Vages 30 Social Security 31 Medewe 22 FUTA SUTA 34 25 Bookkeeper House Veel 37 Vage Rate 38 Ves Sony 40 Med 41 FUTA 42 SUTA 4 44 Accounting Clerk 45 Hours Per Vet 46 VaRe Wage 40 Soudy 49 Meow FUTA 01 SUTA 45" 2265 45 22.65 4662 45 22.65 45 22.05 6662 200 4,652 200 462 200 45 2265 4,662 209 GO 45 22.65 4,662 200 CO 45 2265 4.62 45 2265 4652 205 88 45 22.05 4662 203 68 45 22.65 4.602 299 239) SC 682 20 09 ce 09 CB 89 8:33 55,346 3469 om 42 440 20 06 30 CG 62 CP 42 CP 14 07 2,02 42 14.07 262 ZON M07 2.62 1407 2,622 163 MO 2.622 3 30 1407 2,622 162 30 42 1407 2.622 HOY 202 2.622 42 107 2.622 42 107 2622 42 M07 2,622 31461 CX CH OC CN CW EN CH OC 1961 30 16 20 30 11 30 30 30 09 454 42 440 52 29 52 52 29 52 21 CS 0517 10.517 10.617 10517 ISO 10.517 90.517 10512 10.517 10,512 10.517 10,617 219 201 26.97 2017 O 20.01 2017 2.00 26.017 2017 28 017 26.012 26.01 26.017 26.017 312.201 83 Hours Vages 54 S5 Total Vages 54 57 Takes 34 Good Security Medie ce FUTA 61 SUTA TOTAL 16 277 1600 377 019 377 160 377 191 161 377 377 1613 972 160 377 US 377 96 $20 2655 29 un 377 14 420 2.424 161) 377 - 52 2013 10356 4.527 210 2200 372 - 17 2.07 620 2562 260 2.251 19 104 2.174 04 2.095 21 2.00 0651 0661 0561 4 1 pa You developed an overhed budget for a construction company. Historically, the company's construction costs are 39% of revenues. What volume of work does the construction company need to achieve in order to make $100,000 of profit this year if they expand and hire the office manager and estimator? How much must the company increase their 2 revenues in order to expand? B D H N Annual Cash Flow Fin Operations 20:21 Feb Mach April May Ay 372.000 712,000.00.000.000.000.000.000.000.000.000.000.000.000.000.00 2.000.00 $516,000.00 $6.000.000.00 Aug Set Now Dec Ta om HES IRT G Oct 9 15 7.120 TASO 7.000 500 6,450 3910 3,00 4.000 006 5400 DOCZ 1300 3100 15 000 1300 1200 1,300 1,300 1300 1,300 OLI 1300 1300 Overal Adela 7 Promotion Carack Expers Cape and Once Ruhr 10 Employee Wages and Sales 11 Employees 12 Erreftrument 1 es 2011 2.250 2017 2011 2017 2,250 2017 5.000 8.000 1300 8,000 2017 2250 2005 2010 20.017 2760 781 2011 2007 2.50 TI 216 4130 2017 2250 ORE 11 15.00 10000 J12.201 27000 MOIT 22 78 2017 2250 781 1050 10 9 2,24 2.114 2,107 3295 2,200 701 100 2.870 200 2.95 1102 005 3370 20 2018 4.410 100 00 1.000 OU 000 100 500 100 500 INO 500 15:00 500 1500 6.000 1.00 4405 500 1.500 350 tou 43 440 500 500 046 500 1500 10 100 13 440 001 06 950 100 DRC DOC 500 1.30 250 100 OR Tres Les Offices 17 Officer 10 Otices Powden 20 21 The 22 Charon Dwd Member 14 Leden 26 Med OSE 100 250 100 w 440 100 100 03 440 500 1.500 100 430 40 350 100 and Cher 1.000 100 1200 20 CD 100 430 410 CL 100 431 440 CO 40 440 100 410 CE OFT 3000 1000 00 ONE 1000 1.000 DIY 0 100 0 20 09 ON 000 NU 10 WIT 50 100 10 100 50 100 ME Tube 50 100 SO os 10.000 000 1200 100 00 LCD . 000 SOD TES 0 50 100 100 100 15.04 Tulcea CD COD 30 21 C M 3 Only enter data into light blue cells. + 2 3 4 5 6 7 Social Securg Rate Social Security Limit Medicare Rule FUTARA FUTA Limit SUTAR SUTA Limit 6.2013 79,700 1455 0.00 7.300 2.00 January Februay March April May June July August September October November Decembet Total 9 Rem 10 Over Vages 12 Social Security Medicare FUTA SUTA 3,000 9.000 550 9,000 550 3,000 560 3,000 558 3.000 558 31 3.000 558 131 5.000 550 131 3.000 3:30 9,000 558 131 9,000 558 131 9,000 558 a 101 131 ICE I ICI 100.000 6.696 1566 42 440 - 42 180 130 03 - 3 6.500 6.500 6,500 403 5,500 6,500 6,500 1 Project Manager/Estimator Vages 13 Sold See 20 Medicare FUTA SUTA 70,000 6.500 403 94 6,500 403 COM 6500 403 400 6,500 400 94 COP CO 6,500 403 94 6,500 400 96 CON PG 4806 15 14 16 16 94 HE BC 96 3 130 1.11 42 440 OCH 50 5500 15.500 15,500 15.500 1,500 15.500 15,500 15.500 15.500 15.500 15.500 15.500 195.000 == 42 1735 1230 200 42 1735 3233 200 47 52 1735 3.23 200 47 19 65 427 12.35 3230 200 47 , 62 1735 3,230 200 47 42 1235 3.233 200 47 42 1735 3230 200 421 1,35 2233 200 47 42 17.35 3230 200 47 42" 17:35 2,233 200 47 42" 1735 3.230 200 67 $628 42 1735 3,733 200 47 2.405 CC 65 65 15 65 52 62 440 SC 45 45 20 Office Salaries 25 2 Secretary/Receptionist 27 House Veel 29 Vage Re Vages 30 Social Security 31 Medewe 22 FUTA SUTA 34 25 Bookkeeper House Veel 37 Vage Rate 38 Ves Sony 40 Med 41 FUTA 42 SUTA 4 44 Accounting Clerk 45 Hours Per Vet 46 VaRe Wage 40 Soudy 49 Meow FUTA 01 SUTA 45" 2265 45 22.65 4662 45 22.65 45 22.05 6662 200 4,652 200 462 200 45 2265 4,662 209 GO 45 22.65 4,662 200 CO 45 2265 4.62 45 2265 4652 205 88 45 22.05 4662 203 68 45 22.65 4.602 299 239) SC 682 20 09 ce 09 CB 89 8:33 55,346 3469 om 42 440 20 06 30 CG 62 CP 42 CP 14 07 2,02 42 14.07 262 ZON M07 2.62 1407 2,622 163 MO 2.622 3 30 1407 2,622 162 30 42 1407 2.622 HOY 202 2.622 42 107 2.622 42 107 2622 42 M07 2,622 31461 CX CH OC CN CW EN CH OC 1961 30 16 20 30 11 30 30 30 09 454 42 440 52 29 52 52 29 52 21 CS 0517 10.517 10.617 10517 ISO 10.517 90.517 10512 10.517 10,512 10.517 10,617 219 201 26.97 2017 O 20.01 2017 2.00 26.017 2017 28 017 26.012 26.01 26.017 26.017 312.201 83 Hours Vages 54 S5 Total Vages 54 57 Takes 34 Good Security Medie ce FUTA 61 SUTA TOTAL 16 277 1600 377 019 377 160 377 191 161 377 377 1613 972 160 377 US 377 96 $20 2655 29 un 377 14 420 2.424 161) 377 - 52 2013 10356 4.527 210 2200 372 - 17 2.07 620 2562 260 2.251 19 104 2.174 04 2.095 21 2.00 0651 0661 0561 4 1 pa You developed an overhed budget for a construction company. Historically, the company's construction costs are 39% of revenues. What volume of work does the construction company need to achieve in order to make $100,000 of profit this year if they expand and hire the office manager and estimator? How much must the company increase their 2 revenues in order to expand