Calculate Labor Revenues Revenue (hrs.)= [Actual Labor (hrs.) - Budget Labor (hrs.)] x Budget Labor Rate ($/hr.)

Transcribed Image Text:

A 3 Revenues (billed out): B C D E F G H I J K Budget Actual Fav./(Unfav.) Change in Gross Margin 4 - Labor (hrs.) 3,641 3,654 13 38,558 5 Labor rate ($/hr.) 120 121 1 6 Parts ($/hr.) 344 322 (22) Labor Variance Parts Variance 7 Costs: Revenue (hrs.) 8 Labor (hrs.) 3,980 3,916 (64) Rate ($/hr.) 9 - Labor ($/hr.) 45 10 - Parts (% of revenue) 78% 42 75% (3) Costs (hrs.) -3% Labor (S/hr.) 11 12 Revenues: $ Fav./(Unfav.) 13 Labor 436,920 442,191 5,271 Total Revenue (hrs.) Revenue ($/hr.) Costs (hrs.) Costs ($/hr.) Mark-up Other Total 14 - Parts 1,252,504 1,178,092 (74,412) 15 Total Revenues 1,689,424 1,620,283 (69,141) 16 Costs: 17 - Labor 179,100 166,211 (12,889) 18 - Parts 976,953 882,143 (94,810) 19 Total Costs 1,156,053 1,048,354 (107,699) 20 A 3 Revenues (billed out): B C D E F G H I J K Budget Actual Fav./(Unfav.) Change in Gross Margin 4 - Labor (hrs.) 3,641 3,654 13 38,558 5 Labor rate ($/hr.) 120 121 1 6 Parts ($/hr.) 344 322 (22) Labor Variance Parts Variance 7 Costs: Revenue (hrs.) 8 Labor (hrs.) 3,980 3,916 (64) Rate ($/hr.) 9 - Labor ($/hr.) 45 10 - Parts (% of revenue) 78% 42 75% (3) Costs (hrs.) -3% Labor (S/hr.) 11 12 Revenues: $ Fav./(Unfav.) 13 Labor 436,920 442,191 5,271 Total Revenue (hrs.) Revenue ($/hr.) Costs (hrs.) Costs ($/hr.) Mark-up Other Total 14 - Parts 1,252,504 1,178,092 (74,412) 15 Total Revenues 1,689,424 1,620,283 (69,141) 16 Costs: 17 - Labor 179,100 166,211 (12,889) 18 - Parts 976,953 882,143 (94,810) 19 Total Costs 1,156,053 1,048,354 (107,699) 20