DEVELOP A PERSONNEL PLAN FOR A GROUP HOME

Nurse Consultant (part time contractor; responsible for medication administration, staff training and monitoring, coordination of medical appointments, ETC).

Accountant (part time contractor)

Home Maintenace (part time contractor) include a one year budget. I am including a start up budget Download start up budgetform that is partially completed for your reference. It has two tabs (see bottom of the excel sheet). The first tab is "Start Up Budget 1" and the second tab is "employee cost breakout". The employee cost break out includes the pay for every position and benefits. It includes all the direct care workers for one group home. For the direct care workers, the staffing includes two full time employees during the hours of 7 am to 11 pm. The overnight hours from 11 pm to 7 am are covered by one employee. With this staffing compliment it amounts to a total of 40 hours per day. Again, look at the start up budget Download start up budgetfor the details. The start up budget must contain all the personnel costs you will cover in year one. This budget assumes it is a full 12 months for every employee. In some start-ups the hiring is done in stages as employees are hired and trained. However, for our purposes assume that everyone is full time (except the contractors), and everyone has a full set of benefitsfor the entire year (which is generally 30%; that covers all insurance and leave time).

Insert Draw 'X Calibri Paste [By B I 2 v A \" 4' Clipboard Font Page Layout V11 vgvAv Formulas Data v A 0 Number Alignment ft 50000 POSITION Chief Executive Officer (CEO) Human Resource Manager Nurse (25 hrs/wk] Group Home Supervisor *Direct Care Workers (4O hrs/day is total hrs for all workers] Fillain Staff (time off, vacations] HOURLV WAGE (if applicable] $19.00/hr x 40 hrs/clay x 250 clays/yr $16.00/hr x 40 hrs/clay x 165 clays/yr Review View Automate Conditional Formatting V @ Format as Table V g Cell Styles V Help Acrobat Data Mining @D Editing Analytic Solver Styles Sensitivity Addains ANUALSALARV CALCULATION COST BENEFITS {multiply x 30%] $90,000 27,000 70,000 21,000 $50,000 0 $60,000 18,000 $190,000 57,000 $105,600.00 NA TOTAL PERSONNEL COSTS FOR YEAR ONE Addeins Analyze - Comments Create PDF Create PDF and Data and Share link Share via Outlook Adobe Acrobat TOTAL COST BY FUNCTION 117,000 91,000 50,000 78,000 247,000 105,600 688,600 *For direct care workers, estimate two staff for 7 am to 3 pm,and 3 pm to 11 pm. Estimate one overnight staff from 11 pm to 7 am. Daily hours = 4staff x8 hours = 32hours + 1 staff x 8 hours = 8 hours; Total hrs/day = 40 Benefits , Solver START-UP COSTS GROUP HOME #1 November 28, 2023 COST ITEMS MONTHS COST/ MONTH ONETIME COST TOTAL COST Advertising] marketing Employee salaries Employee payroll taxes and benets Rent/lease payments/utilities Postage/shipping ESTIMATED STARTUP BUDGET SD