Q Search (Cmd + Ctrl + U) AutoSave W H FC ... Breed Aviation Template.xIsx - Read-Only Comments Share Home Insert Draw Page Layout Formulas Data Review View Acrobat Insert v 2 Times New Roman 12 AA 5 v General x Delete Conditional Format Cell Sort & Find & Add-ins Analyze Create PDF Paste BIUV A $ ~ % 9 Formatting as Table Styles Format v Filter Select Data and share link P26 X V fx B C D E F G H K L M N O P Q R S U V W A MRO Department - 2020 Results Revenues (billed out): Budget Actual Fav./(Unfav.) Change in Gross Margin - Labor (hrs.) 3,641 3,654 13 38,558 -Labor rate ($/hr.) 120 121 - Parts ($/hr.) 344 322 (22) Labor Variance Parts Variance Costs: Revenue (hrs.) Revenue (hrs.) - Labor (hrs.) 3,980 3,916 (64) Rate ($/hr.) Revenue ($/hr.) - Labor ($/hr.) 45 42 (3) Costs (hrs.) Costs (hrs.) - Parts (% of revenue) 78% 75% .3% Labor ($/hr.) Costs ($/hr.) Total Mark-up 12 Revenues: $ Fav./(Unfav.) Other - Labor 436,920 442, 191 5,271 Total - Parts 1,252,504 1,178,092 (74,412) Total Revenues 1,689,424 1,620,283 (69,141) Costs: 17 - Labor 179,100 166,211 (12,889) - Parts 976,953 882, 143 (94,810) Total Costs 1,156,053 1,048,354 (107,699) Gross Margin 533,371 571,929 38,558 22 Overhead: - Space 75,000 75,00 - General & Admin. 35,000 35,00 - Depreciation 68,50 58,50 - Legal & Regulatory 18,000 18,000 Total Overhead 196,500 196,500 29 Net before Taxes 336,871 375,429 38,558 30 Taxes 70,743 78,840 8,097 31 Net after Taxes 266,128 296,589 30,461 32 36 38 39 Jan Feb BS 2019 actuals Jan Feb BS recalc 2021 budgets Variances V. MAR24 + 100% Ready Accessibility: Investigate