Page 1 of 1

Revenues (billed out): - Labor (hrs.) -Labor rate ($/hr.) - Parts (S/hr.) Costs: - Labor (hrs.) - Labor ($/hr.) -Parts (

Posted: Wed Jul 06, 2022 6:45 pm
by answerhappygod
Revenues Billed Out Labor Hrs Labor Rate Hr Parts S Hr Costs Labor Hrs Labor Hr Parts 1
Revenues Billed Out Labor Hrs Labor Rate Hr Parts S Hr Costs Labor Hrs Labor Hr Parts 1 (107.76 KiB) Viewed 27 times
I need help understanding how to complete the yellow blocks. Ihave submitted once already that was rejected because of acalculation error.
Revenues (billed out): - Labor (hrs.) -Labor rate ($/hr.) - Parts (S/hr.) Costs: - Labor (hrs.) - Labor ($/hr.) -Parts (% of revenue) Revenues: - Labor - Parts Costs: - Labor -Parts Gross Margin Overhead: - Space - General & Admin. - Depreciation - Legal & Regulatory Budget 3,456 Total Overhead 120 345 Net before Taxes Taxes Net after Taxes 3,840 42 414,720 437,760 1,192,320 1,168,092 Total Revenues 1,607,040 1,605,852 80% 161,280 168,650 953,856 899,431 Total Costs 1,115,136 1,068,080 491,904 537,772 Actual Fav./(Unfav.) 3,648 192 120 320 (25) Labor Variance Revenue (hrs.) 3,877 44 77% 75,000 35,000 68,500 18,000 196,500 295,404 62,035 233,369 75,000 35,000 68,500 MRO Department - 2020 Results 18,000 196,500 341,272 71,667 269,605 37 Rate (S/hr.) 2 Costs (hrs.) -3% Labor ($/hr.) $ Fav./(Unfav.) 23,040 (24,228) (1,188) 7,370 (54,425) (47,056) 45,868 45,868 9,632 36,235 Total Change in Gross Margin 45,868 Parts Variance Revenue (hrs.) Revenue ($/hr.) Costs (hrs.) Costs ($/hr.) Mark-up Other Total Insert your text explanation of the variances here.