{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Forecasted Staffing Schedule","Current Staffing Schedule"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Forecasted Staffing Schedule","index":0,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,0,1,9],[63,1,63,4],[64,1,64,4],[65,1,65,4],[62,1,62,4],[53,1,53,2],[54,1,54,2],[55,1,55,2],[60,1,60,4],[61,1,61,4],[56,1,56,4],[57,1,57,4],[45,1,45,2],[46,1,46,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[47,1,47,4],[48,1,48,4],[38,1,38,4],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[0,1,0,5],[21,1,21,4],[30,1,30,4],[39,1,39,4],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[20,1,20,4],[29,1,29,4],[7,1,7,5],[3,2,3,5],[4,2,4,5],[5,2,5,5],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[18,1,18,2],[19,1,19,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]],"flags":["formulas_cached_only"]}
[]
["Public reporting burden for this collection of information is estimated to average 1 hour.  This includes the time for collecting, reviewing, and reporting the data.  The information is being collected to obtain the supportive documentation which must be submitted to HUD for approval, and is necessary to ensure that viable projects are developed and maintained.  The Department will use this information to determine if properties meet HUD requirements with respect to development, operation and/or asset management, as well as ensuring the continued marketability of the properties. This agency may not collect this information, and you are not required to complete this form, unless it displays a currently valid OMB control number. \n\nWarning: Any person who knowingly presents a false, fictitious, or fraudulent statement or claim in a matter within the jurisdiction of the U.S. Department of Housing and Urban Development is subject to criminal penalties, civil liability, and administrative sanctions.  "]
[]
[null,"Project Name  ","Enter Name"]
[null,"FHA Project No. ","000-00000"]
[null,"Address ","Enter Address"]
[]
[null,"Instructions: Only light blue cells can be edited. Enter the staffing positions and salary projections for the subject as of the date when stabilized occupancy is realized. This tab is to be completed for both New Construction and for Substantial Rehab and 241a loans.  For Substantial Rehabilitation and 241a loans also fill out the second tab (Current Staffing Schedule) with the subject's current staffing and salary information. "]
[]
[null,"Indicate the year in which stabilized occupancy will be reached.",null,null,"enter year"]
[]
[]
[null,"Job Title",null,"# of Employees","Combined Hours Per Week","Combined Annual Salaries"]
[null,"Administrative"]
[null,"e.g. Administrator"]
[null,"e.g. Business Office"]
[null,"e.g. Receptionist"]
[null,"e.g. Marketing Manager"]
[null,"e.g. Marketing Assistant"]
[]
[null,"Administrative - Payroll Taxes & Benefits"]
[null,"Total - Administrative",null,null,null,0]
[null,"Building & Grounds"]
[null,"e.g. Maintenance Supervisor"]
[null,"e.g. Housekeeping Manager"]
[null,"e.g. Housekeepers"]
[]
[]
[]
[null,"Building & Grounds - Payroll Taxes and Benefits"]
[null,"Total - Building & Grounds",null,null,null,0]
[null,"Activities & Other"]
[null,"e.g. Activities Director"]
[null,"e.g. Activities Assistant"]
[null,"e.g. Transportation"]
[]
[]
[]
[null,"Activities & Other - Payroll Taxes and Benefits"]
[null,"Total - Activities & Other",null,null,null,0]
[null,"Personal Care"]
[null,"e.g. Registered Nurses"]
[null,"e.g. LPN’s"]
[null,"e.g. CNAs"]
[]
[]
[]
[null,"Personal Care - Payroll Taxes and Benefits"]
[null,"Total - Personal Care",null,null,null,0]
[null,"Dietary"]
[null,"e.g. Chef/Manager"]
[null,"e.g. Cooks"]
[null,"e.g. Assistants"]
[]
[]
[]
[null,"Dietary - Payroll Taxes and Benefits"]
[null,"Total - Dietary",null,null,null,0]
[]
[null,"Totals"]
[null,"Combined Number of Hours",null,null,null,0]
[null,"Full Time Equivalents Total (total # of hours divided by 40)",null,null,null,0]
[null,"Total Number of Employees (full time and part time)",null,null,null,0]
[null,"Total Annual Salaries Paid",null,null,null,0]
[null,"Total Annual Taxes & Benefits",null,null,null,0]
[null,"Total Annual Salaries with Benefits",null,null,null,0]

{"sheet":"Current Staffing Schedule","index":1,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[[60,1,60,4],[61,1,61,4],[63,1,63,4],[64,1,64,4],[65,1,65,4],[62,1,62,4],[0,1,0,5],[3,2,3,5],[4,2,4,5],[5,2,5,5],[7,1,7,5],[14,1,14,2],[1,0,1,9],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,4],[21,1,21,4],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,4],[30,1,30,4],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,4],[39,1,39,4],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,4],[55,1,55,2],[56,1,56,4],[57,1,57,4],[48,1,48,4],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2]],"flags":["formulas_cached_only"]}
[]
["Public reporting burden for this collection of information is estimated to average 3 hours.  This includes the time for collecting, reviewing, and reporting the data.  The information is being collected to obtain the supportive documentation which must be submitted to HUD for approval, and is necessary to ensure that viable projects are developed and maintained.  The Department will use this information to determine if properties meet HUD requirements with respect to development, operation and/or asset management, as well as ensuring the continued marketability of the properties. \n\nWarning: Any person who knowingly presents a false, fictitious, or fraudulent statement or claim in a matter within the jurisdiction of the U.S. Department of Housing and Urban Development in subject to criminal penalties, civil liability, and administrative sanctions.  "]
[]
[null,"Project Name  ","Enter Name"]
[null,"FHA Project No. ","000-00000"]
[null,"Address ","Enter Address"]
[]
[null,"Instructions: In addition to the first tab (Forecasted Staffing Schedule), this tab needs to be filled out for substantial rehabilitation & 241a loans. Enter the current staffing & salary levels prior to the construction or rehabiliation taking place."]
[]
[null,"Indicate the year of the current staffing schedule.",null,null,"enter year"]
[]
[]
[null,"Job Title",null,"# of Employees","Combined Hours Per Week","Combined Annual Salaries"]
[null,"Administrative"]
[null,"e.g. Administrator"]
[null,"e.g. Business Office"]
[null,"e.g. Receptionist"]
[null,"e.g. Marketing Manager"]
[null,"e.g. Marketing Assistant"]
[]
[null,"Administrative - Payroll Taxes & Benefits"]
[null,"Total - Administrative",null,null,null,0]
[null,"Building & Grounds"]
[null,"e.g. Maintenance Supervisor"]
[null,"e.g. Housekeeping Manager"]
[null,"e.g. Housekeepers"]
[]
[]
[]
[null,"Building & Grounds - Payroll Taxes and Benefits"]
[null,"Total - Building & Grounds",null,null,null,0]
[null,"Activities & Other"]
[null,"e.g. Activities Director"]
[null,"e.g. Activities Assistant"]
[null,"e.g. Transportation"]
[]
[]
[]
[null,"Activities & Other - Payroll Taxes and Benefits"]
[null,"Total - Activities & Other",null,null,null,0]
[null,"Personal Care"]
[null,"e.g. Registered Nurses"]
[null,"e.g. LPN’s"]
[null,"e.g. CNAs"]
[]
[]
[]
[null,"Personal Care - Payroll Taxes and Benefits"]
[null,"Total - Personal Care",null,null,null,0]
[null,"Dietary"]
[null,"e.g. Chef/Manager"]
[null,"e.g. Cooks"]
[null,"e.g. Assistants"]
[null," "]
[]
[]
[null,"Dietary - Payroll Taxes and Benefits"]
[null,"Total - Dietary",null,null,null,0]
[]
[null,"Totals"]
[null,"Combined Number of Hours",null,null,null,0]
[null,"Full Time Equivalents Total  (total # of hours divided by 40)",null,null,null,0]
[null,"Total Number of Employees  (full time and part time)",null,null,null,0]
[null,"Total Annual Salaries Paid",null,null,null,0]
[null,"Total Annual Taxes & Benefits",null,null,null,0]
[null,"Total Annual Salaries with Benefits",null,null,null,0]