Question

1 Approved Answer

Posted on Sep 11, 2024

1423 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

1423 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? M M N 1 Only enter data into light blue cells. 3 4 A Social Secure Rate Social Security Limit Medicare Rate FUTA Rate FUTA Limit SUTAR SUTA Limit 6-20% 24,700 145 0.60 7.000 2.00 22,000 6 7 February March April May June July August September October November December. Total 9,000 3.000 9.000 550 31 42 9,000 550 11 3,000 550 131 0,000 58 131 3.000 558 131 3,000 330 131 550 131 3,000 558 131 9,000 558 9,000 558 131 131 131 190.000 6.696 1565 42 440 Rem 10 Over Vages Social Security Medicare FUTA SUTA 15 17 Project Manager/Estimator Vages 13 Sool Security 20 Medicare 21 FUTA 22 SUTA 08 130 03 8 6.500 6500 6,500 6,500 400 94 70,000 6500 400 8,500 400 14 6,500 403 COS COM 16 6.500 400 94 6,500 400 6,500 403 94 6,500 403 94 COP PG 6.500 403 94 15 94 16 15 BC - 3 130 1.11 2 440 01 50 5500 15.500 15,500 15.500 5.500 15.500 15,500 16.500 15,500 15.500 15.500 15.500 155,000 42 42 Q SC SE SC 21 SC 17:15 3.230 200 42 19 65 42 17:35 3233 200 47 19 ES 1230 200 47 3 65 42 17.35 3230 200 47 42" 1735 3.230 200 42 42 17:35 7,233 200 42 42" 1,35 2233 200 47 3.233 200 47 1735 3233 200 47 42" 1735 3,233 200 47 42 1735 3,230 200 67 42 1735 3.733 200 47 3795 2.405 563 2 40 C 2 65 65 52 45 20 Office Salaries 25 23 Secretary/Receptionist 27 HousPw Veel 20 Vagele 29 Vages 30 Social Security 31 Mediowe 22 FUTA 39 SUTA 34 35 Bookkeeper 26 Hours Pe Vert 37 Vage Rate Veges Sony 40 Me 41 FUTA 42 SUTA 49 44 Accounting Clerk 45 Hours Pervert 46 Van 40 Soul Seory 49 Med FUTA SUTA 45 2265 4,662 45 22.65 45 22.65 4562 2265 45 2255 462 200 BC SC 45 2265 4,662 200 45 22.05 45 22.65 4,662 200 462 200 45 2265 4662 205 80 45 22.65 4642 23 68 45 22.65 4662 209 68 682 55.546 2469 ce ce 09 09 ce 20 09 219 50 0 06 06 90 93 29 42 440 . 42 62 14.07 2,622 42 14.07 262 42" MO? 2.622 107 42 HOY 2622 163 30 1407 2,622 163 20N 00 2,622 162 30 HOY 2.6.2 42 MOT 2.622 TONE 42 107 2622 1407 2.622 16 2.622 34461 CS CS 53 30 CN CH EN 1961 30 16 06 50 30 30 30 09 19 9 20 16 52 30 11 52 44 42 440 52 52 52 52 21 0517 10.517 10.07 10517 ISO 10.517 10.517 10.512 10.517 10,512 10517 10.017 26201 26.017 20 20.01 200 20.00 26.017 LION 26.017 26.017 26.017 26.017 26,017 312.201 US 53 Hours Vages 54 55 Total Vages 54 67 Tases Soolecul BA Meie FUTA SUTA C TOTAL 3 14 160 377 160 LLE 10 377 & 160 972 191 377 14 1603 377 LLC 16 372 377 1613 372 1,00 372 29 14 16 372 - 17 2.0 1956 4.527 200 2200 029 092 10 21 2856 2062 104 2.174 2,424 2.251 2.095 52 2009 zo 1930 06 0561 3 IRT Bom HERS c D H K N Annual Cash Flow Fun Operations 2021 Feb March Apel My My AUS 52.00000712.000.000.000.000.000 1.000.000.000.000.000.000.000.000.000006616,000.00 56.000.000.00 Eps Oct lov Der T 15 80 7.120 T.850 700 500 5,460 1910 3,400 4.000 4900 5.100 15 000 100 6400 23.000 1300 1300 1.300 1,300 LI 5.000 8.000 1300 18.000 2017 1300 1,300 100 1300 1300 15.00 2011 2.250 2017 2007 250 71 21 2011 2760 781 20017 2017 2,250 OKC 11 2017 2.250 DRET 21011 2200 71 3370 18 20.011 2250 PU 2011 2200 TODO 712201 27000 106 MOTY 2250 781 1050 2017 22 at 100 2.0 2,211 71 2005 2010 2174 Overal Aderang 7 Promotion Carduck Expers 9 Care we Once 19 Employee Wipende 11 Employee lende 13 rokopetrument mes 14 Tres Les Office Suppe 17 Orice Rent Otices Powder 20 21 Telephone 22 Chor 23 Desember 4 Legends 26 Med 2.210 701 1 2.870 2,107 3285 USER 41 OD 2.654 4410 100 00 1.000 03 4405 500 1.500 260 100 000 500 008 500 20 100 1500 05 00 0033 1.500 2005 2.435 500 1,500 200 100 430 460 0051 09 500 1.500 30 100 00 40 1.100 WE OPIC 100 100 950 100 499 40 100 6.000 . 2700 1200 20 5.00 00 200 100 431 40 250 100 100 1.100 350 100 and Cher CCF 50 100 433 40 100 03 100 CD 400 440 M40 640 410 40 2000 1000 10 BOE 00 too M 10 1000 ZO 190 01 0 100 50 10.400 WY 50 100 M 00 CHE 50 100 50 NO 100 000 OFW 100 201 00 0930 TO 1200 105 50 50 100 100 15.040 Tour 1225 COD 30 1423 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? M M N 1 Only enter data into light blue cells. 3 4 A Social Secure Rate Social Security Limit Medicare Rate FUTA Rate FUTA Limit SUTAR SUTA Limit 6-20% 24,700 145 0.60 7.000 2.00 22,000 6 7 February March April May June July August September October November December. Total 9,000 3.000 9.000 550 31 42 9,000 550 11 3,000 550 131 0,000 58 131 3.000 558 131 3,000 330 131 550 131 3,000 558 131 9,000 558 9,000 558 131 131 131 190.000 6.696 1565 42 440 Rem 10 Over Vages Social Security Medicare FUTA SUTA 15 17 Project Manager/Estimator Vages 13 Sool Security 20 Medicare 21 FUTA 22 SUTA 08 130 03 8 6.500 6500 6,500 6,500 400 94 70,000 6500 400 8,500 400 14 6,500 403 COS COM 16 6.500 400 94 6,500 400 6,500 403 94 6,500 403 94 COP PG 6.500 403 94 15 94 16 15 BC - 3 130 1.11 2 440 01 50 5500 15.500 15,500 15.500 5.500 15.500 15,500 16.500 15,500 15.500 15.500 15.500 155,000 42 42 Q SC SE SC 21 SC 17:15 3.230 200 42 19 65 42 17:35 3233 200 47 19 ES 1230 200 47 3 65 42 17.35 3230 200 47 42" 1735 3.230 200 42 42 17:35 7,233 200 42 42" 1,35 2233 200 47 3.233 200 47 1735 3233 200 47 42" 1735 3,233 200 47 42 1735 3,230 200 67 42 1735 3.733 200 47 3795 2.405 563 2 40 C 2 65 65 52 45 20 Office Salaries 25 23 Secretary/Receptionist 27 HousPw Veel 20 Vagele 29 Vages 30 Social Security 31 Mediowe 22 FUTA 39 SUTA 34 35 Bookkeeper 26 Hours Pe Vert 37 Vage Rate Veges Sony 40 Me 41 FUTA 42 SUTA 49 44 Accounting Clerk 45 Hours Pervert 46 Van 40 Soul Seory 49 Med FUTA SUTA 45 2265 4,662 45 22.65 45 22.65 4562 2265 45 2255 462 200 BC SC 45 2265 4,662 200 45 22.05 45 22.65 4,662 200 462 200 45 2265 4662 205 80 45 22.65 4642 23 68 45 22.65 4662 209 68 682 55.546 2469 ce ce 09 09 ce 20 09 219 50 0 06 06 90 93 29 42 440 . 42 62 14.07 2,622 42 14.07 262 42" MO? 2.622 107 42 HOY 2622 163 30 1407 2,622 163 20N 00 2,622 162 30 HOY 2.6.2 42 MOT 2.622 TONE 42 107 2622 1407 2.622 16 2.622 34461 CS CS 53 30 CN CH EN 1961 30 16 06 50 30 30 30 09 19 9 20 16 52 30 11 52 44 42 440 52 52 52 52 21 0517 10.517 10.07 10517 ISO 10.517 10.517 10.512 10.517 10,512 10517 10.017 26201 26.017 20 20.01 200 20.00 26.017 LION 26.017 26.017 26.017 26.017 26,017 312.201 US 53 Hours Vages 54 55 Total Vages 54 67 Tases Soolecul BA Meie FUTA SUTA C TOTAL 3 14 160 377 160 LLE 10 377 & 160 972 191 377 14 1603 377 LLC 16 372 377 1613 372 1,00 372 29 14 16 372 - 17 2.0 1956 4.527 200 2200 029 092 10 21 2856 2062 104 2.174 2,424 2.251 2.095 52 2009 zo 1930 06 0561 3 IRT Bom HERS c D H K N Annual Cash Flow Fun Operations 2021 Feb March Apel My My AUS 52.00000712.000.000.000.000.000 1.000.000.000.000.000.000.000.000.000006616,000.00 56.000.000.00 Eps Oct lov Der T 15 80 7.120 T.850 700 500 5,460 1910 3,400 4.000 4900 5.100 15 000 100 6400 23.000 1300 1300 1.300 1,300 LI 5.000 8.000 1300 18.000 2017 1300 1,300 100 1300 1300 15.00 2011 2.250 2017 2007 250 71 21 2011 2760 781 20017 2017 2,250 OKC 11 2017 2.250 DRET 21011 2200 71 3370 18 20.011 2250 PU 2011 2200 TODO 712201 27000 106 MOTY 2250 781 1050 2017 22 at 100 2.0 2,211 71 2005 2010 2174 Overal Aderang 7 Promotion Carduck Expers 9 Care we Once 19 Employee Wipende 11 Employee lende 13 rokopetrument mes 14 Tres Les Office Suppe 17 Orice Rent Otices Powder 20 21 Telephone 22 Chor 23 Desember 4 Legends 26 Med 2.210 701 1 2.870 2,107 3285 USER 41 OD 2.654 4410 100 00 1.000 03 4405 500 1.500 260 100 000 500 008 500 20 100 1500 05 00 0033 1.500 2005 2.435 500 1,500 200 100 430 460 0051 09 500 1.500 30 100 00 40 1.100 WE OPIC 100 100 950 100 499 40 100 6.000 . 2700 1200 20 5.00 00 200 100 431 40 250 100 100 1.100 350 100 and Cher CCF 50 100 433 40 100 03 100 CD 400 440 M40 640 410 40 2000 1000 10 BOE 00 too M 10 1000 ZO 190 01 0 100 50 10.400 WY 50 100 M 00 CHE 50 100 50 NO 100 000 OFW 100 201 00 0930 TO 1200 105 50 50 100 100 15.040 Tour 1225 COD 30