F&C is civil engineering company with Frank and Clayton as the legal partners. Assuming 2021 is complete, the annual 2021 staff data has been compiled in Table 1 and all 2021 costs are listed in Table 2.

Pls help find the following: Pls also don't do on excel. I would like to follow how it is done. Thanks

1. F&C 2021 Total Revenue
2. F&C 2021 Total Costs
3. F&C 2021 Profit/Loss, before taxes
4. 2021 Profit/Loss for Frank only, before taxes
5. Pearl's Utilization Rate

TABLE 1 - F&C 2021 STAFF DATA CLIENT DIRECT INDIRECT ANNUAL NAME TITLE BILLING LABOR LABOR SALARY RATE* HOURS HOURS Clayton Principal Engineer $300 $158,000 900 1180 Mike Project Engineer $220 $118,000 1700 380 Pearl Staff Engineer $200 $98,000 1960 120 Kinga CADD Tech $90 $54,000 2000 80 Administrative Frank $60 $42,000 400 1680 Assistant *Assume all projects and all clients had the same billing rateTABLE 2 - F&C 2021 COSTS ITEM 2021 COST Office Space Rent $135,000 Marketing and other non-billable by $76,000 Clayton (1000 hours) Accounting and other non-billable admin $32,000 by Frank (1600 hours) New computers, monitors, keyboards, etc. $9,000 for Mike, Pearl, and Kinga Paid Time Off (PTO) - Vacation, Sick, Holiday, Jury Duty, Maternity Leave, $48,000 Paternity Leave, other. For all staff. Electric bill, water bill, gas bill $10,000 New Cadillac company vehicle for Clayton. Includes fuel costs, insurance, $99,000 maintenance. Insurance (Life, Worker's Comp, Dental, $45,000 Medical)