![nursing home budget spreadsheet nursing home budget spreadsheet](https://cdn.vertex42.com/ExcelTemplates/Images/money-management-template_200.png)
![nursing home budget spreadsheet nursing home budget spreadsheet](https://images.template.net/wp-content/uploads/2016/01/07123355/vacation-budget-planner-Excel-Format.jpeg)
![nursing home budget spreadsheet nursing home budget spreadsheet](https://7xk97xuoap48okb9omr8xfdk-wpengine.netdna-ssl.com/wp-content/uploads/2020/04/Screen-Shot-2020-04-13-at-11.38.58-AM.png)
![nursing home budget spreadsheet nursing home budget spreadsheet](https://db-excel.com/wp-content/uploads/2019/01/operating-expenses-spreadsheet-within-real-estate-spreadsheet-examples-commercial-analysis-development-cma-601x778.png)
Value in Rupees Oct'04 Nov'04 Dec'04 TOTAL Per bus) = 360 employees = 1008 employees. HUMAN RESOURCESWater ExpensesPARTICULARS Jan'04 Feb'04 Mar'04 Apr'04 May'04 Jun'04 Jul'04 Aug'04 Sep'04 Oct'04 of Days Meals Tea / Coffee Biscuits Cutlery ,Crockery, Jugs etc Tea tumblers (Rs.30/- x 400 nos) Water Jugs (Rs.85/- x 50 nos) Water Tumblers (Rs.9/- x 400 nos) TOTAL1100 emp x 26 days x Rs.13/- = 371800ġ100 emp x 2 times x 24 days x Rs. Rs.40/- x 1000 emp & Rs.80/- x 300 others = 64,000/per month consumption = 40 packs horliks, 20 packs Bournvita, 12 packs coffee & 12 packs Tea. Per packet may have 85 units x 84 packs = 7140 units per month / 60 employees per day & 10 visitors per day x 2 x 26 = 3640 cups / 7140 units = 1.96 times per day / Rs.14508/- = Rs.3.98/- per cup.ġ050 meals X Rs.20/. Per month consumption = 40 packs horliks, 20 packs Bournvita, 12 packs coffee & 12 packs Tea. Tax only for qualis + Rs.18000/- x 3 per year = 54,000/-ĥ000/- twice a month for 4 vehicles x 6 = 120000/-ħ40644Present Rates Diesal 27.00 Petrol 41.50 Expecting 12 % hike in the next year.18000/- for one qualis (4 tyres) x 3 qualis + 1 lancer = 72000/-ģ00 liters per vehicle per month x 3 vehicles = 900 litters pm x Rs.27/- = 24,300/- per month x 12 % hike = Rs.27216/- per month 200 liters per vehicle per month x 1 vehicle = Rs.41,50 = Rs.8,300/- pm x 12 % hike = Rs.9296/- per month HUMAN RESOURCESCompany VehiclesValue in Rupees PARTICULARS No. HUMAN RESOURCESGUEST HOUSE MAINTENANCEValue in Rupees PARTICULARS Jan'04 Feb'04 Mar'04 Apr'04 May'04 Jun'04 Jul'04 Aug'04 Sep'04 Oct'04 Nov'04 Dec'04 TOTALĮldams RENT EB Tele Caretaker Tax Water Tax Flat Maintenance Food, Laundry etcĮast Rent EB Tele Caretaker Watchman Cable (6 thru consultants & 7 thru referals & Data Base)Īve. We have filled up 13 positions in last year (4 exe & 9 staff) (out of 13 / 9 new positions & 4 replacements) Consultants fees approx. Lamination Machine Visitors welcome chain Public Announcement System Color Mike / Cardless mike set Chair one no.ĭEPT :HRRecruitment Expenses (Staff, Executives, Managers) HUMAN RESOURCESCAPITAL EXPENSESValue in Rupees COURSE Camera (polaroid) Purpose ID Cards (Per year approx 500 no's) ID Cards (Per year approx 500 no's) Jan'04 Feb'04 Mar'04 Apr'04 May'04 Jun'04 Jul'04 Aug'04 Sep'04 Oct'04 Nov'04 Dec'04 TOTAL
Nursing home budget spreadsheet professional#
Heads Capital Expenses Production Payroll Recruitment Expenses Guest House Company Vehicles Staff Welfare Canteen Water Transport Uniforms Medical Visitor's Expense House Keeping Staff Training Local Conveyance Legal & Professional Fees Security Technical Traning Books, Journals & Subcriptions Stationery Consumables - Canteen Xerox Total