Operations Branch P&L Illustration

Background

You should always be prepared to dig into the detail of your numbers when asked a question. Please read below.

Tasks

In the excel file called Operations Case Study is a P&L.

1. Add/insert columns to the right of each reported set of numbers (actual, budget and LY). In the added/inserted column create a calculation to state each expense item as a % of TOTAL revenue.

Fixed (F) or Variable (V) If Variable what drives it? June Actual 1,913 June Budget 1,872 June Last Yr 630 Net Subcontracting Net Unit Operating Profit 299,953 505,242 57% 373,393 48% 36% 15,474 6,770 1,887 14,200 1,391 6,950 725 14,471 27,553 22,661 17,879 17,979 1,391 6,770 1,886 13,295 23,809 22,456 15,248 10,862 26,719 25,764 15,164 Location G & A Mgmt & Admin Payroll Bonuses Rent Occupancy Insurance Fuel Fleet expense Advertising & mkting Printing & collateral EE benefits H/R & recruiting Telecommunications Office expenses Professional fees Permits & licenses Travel & entertainment Other Total Location G & A Location Profit 11,549 9,090 1,624 1,147 2,102 712 200 4,871 5,378 13,856 85 1,603 661 200 5,666 780 3,973 129,462 243,931 31% 658 1,804 127,069 172,885 21% 4,171 124,902 380,340 43%