TE_CA_06-27 _OS_Appendix_S-2_-_Labor_Model_Template.xlsx

XLSX spreadsheet 65 KB Posted

Attached to
BASE OPERATIONS SUPPORT SERVICES, U. S. ARMY GARRISON KWAJALEIN ATOLL (USAG-KA)
Solicitation number
W9124J_16_R_KWAJALEIN
Issued by

About this file

From the source

APPENDIX S-2

View the file

Other files

File Type Posted
TE_CA_06-30 _OS_Appendix_U_-_PIP_Action_Plan_(2_Mar_15).xlsx XLSX spreadsheet
TE-KWAJ_006_Kwaj_Financial_Requirements_Manual_ver_5_0__6_Apr_2016.docx DOCX document
TE_CA_06-37 _OS_Appendix_V-7_-_Annex_F_-_BIC_Criteria_and_Nomination_Packet.docx DOCX document
TE_CA_04-00 _ACRRO_2.0_Baseline_Standstandards_Resource_Driver.pdf PDF
TE_CA_06-08 _OS_Appendix_D-3_Golf_Internal_Control.xls XLS spreadsheet
TE_CA_03-01_IMCOM_PR_G9_Internal_Controls_-_Cash_Management_Updated_11.04.15.docx DOCX document
TE-DOL_005_Annex_A_Appendix_1_to_OPORD_16-060.docx DOCX document
TE_CA_06-17 _OS_Appendix_J_-_Golf_Course_Dashboard_on_Golf_Initiatives.xlsx XLSX spreadsheet
TE_CA_06-33 _OS_Appendix_V-3_-_Annex_B_-_Award_Categories.docx DOCX document
TE_CYS-40_MDTI_Training_CY15_Checklist_v1_20140224.xls XLS spreadsheet
TE_CA_03-03 _IMCOM_PR_G9_-_Safe_Security_Updated_06.24.15.docx DOCX document
TE_CA_06-19 _OS_Appendix_L_-_Management_Control_Checklist_for_Nonappropriated_Fund_Projects.docx DOCX document
TE_CA_06-34 _OS_Appendix_V-4_-_Annex_C_-_Timeline.docx DOCX document
TE-DPW_003_Mission_Critical_Facilities.pdf PDF
TE_CA_06-05 _OS_Appendix_C_-_Program_Scorecards__5_Mar_15_v3.xlsx XLSX spreadsheet
TE_CA_06-06 _OS_Appendix_D-1_FBE_Internal_Control.xls XLS spreadsheet
TE-DPW_005_Master_USAG-KA_Meter_Inventory.pdf PDF
TE_CYS-41_MDTI_Parent_CY15_Checklist_v1_20140224.xls XLS spreadsheet
TE_CYS-10_Annex_I_ArmyFamilyAssistanceFamilyHandbook_Oct_14.pdf PDF
TE_CYS-37_MDTI_Financial_Management_CY15_Checklist_v1_20140224.xls XLS spreadsheet
TE_CYS-48_AHHInspectionCriteriaforCY15Inspections_v4_20150507.xls XLS spreadsheet
TE-DPW_018_KMISS_Final_DEP_Effective_9_Jul_14.pdf PDF
TE_CA_06-25 _OS_Appendix_R_-_Example_-_Client_Contact_Report.docx DOCX document
TE_CA_02-00 _Pacific_Region_Business_Plan_Format.xlsx XLSX spreadsheet
TE_CA_06-31 _OS_Appendix_V-1_-_EIM_Awards_Explanation_and_Process.docx DOCX document
TE_CYS-46_MDTI_Command_Rep_CY15_Checklist_v1_20140224.xls XLS spreadsheet
TE_CYS-21_CY15_Facility_Comprehensive_v_15_1_.xlsx XLSX spreadsheet
TE_CYS-04_AnnexC_REPORTSUSPENSELIST_v19_2015SEP29_(2).xlsx XLSX spreadsheet
TE-DPW_024_SO_BACKLOG_April_2016.xlsx XLSX spreadsheet
TE_CA__06-38 _Equipment_Rental_Items.xlsx XLSX spreadsheet
TE-FES_004_Annex_M_to_OPORD_16-001.docx DOCX document
TE_CA_06-22 _OS_Appendix_O_-__Example_-_Catering_General_Rules.pdf PDF
TE_CA_08-00__420-10_PM_Control_and_Maintenance_of_Private_Boats_and_Boat_Storage_Lots_on_USAG-KA.pdf PDF
TE_CA_12-00_Examples_of_Food_Menus.xlsx XLSX spreadsheet
TE_CA_01-00 _FMWR-DS_HB_Nov15.pdf PDF
TE_CA_06-03 _OS_Appendix_B-1_Pricing_Methodology.doc DOC document
TE_CA_06-20 _OS_Appendix_M_-_Action_Plan_Template.xlsx XLSX spreadsheet
TE_CA_06-07 _OS_Appendix_D-2_Bowling_Internal_Control.xls XLS spreadsheet
TE_CYS-35_MDTI_Facility_CY15_Checklist_v1_20140224.xls XLS spreadsheet
TE_CYS-12_GenericBleachSolutionRecommendations_v1_20150417.pdf PDF
TE_CYS-36_MDTI_Fire_CY15_Checklist_v1_20140224.xls XLS spreadsheet
TE_CA_06-04 _OS_Appendix_B-2_Pricing_Methodology_Worksheet.xls XLS spreadsheet
TE_CA_06-32 _OS_Appendix_V-2_-_Annex_A_-_Awards_Implementing_Instructions.docx DOCX document
TE_CYS-06_Annex_E_MoreaboutthetopicFireDrills_v1_20150421.pdf PDF
TE-GFP_001_GFP_-_CAP_list.xlsx XLSX spreadsheet
TE_CA_06-29 _OS_Appendix_T-2_-_m-NEAT_Tool.xlsx XLSX spreadsheet
TE_CYS-15_AR40_562_Immunnizations.pdf PDF
TE_CA_07-00_DoD_MWR_Library_Standards.pdf PDF
TE-DOL_009_Annex_D_to_OPORD_16-060.docx DOCX document
TE_CYS-02_Annex_A_CYSServicesStandardofConductandAccountabilitySOPsignedanddated_20150306.pdf PDF
Show 40 more

Latest 50 of 155 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions: There are 3 templates tabbed on this workbook:
Labor Template $$ Input - Year = This is the template use in the DCO training. Numbers are inputted in any of the grey shaded cells. All numbers inputted are whole numbers except for the cell where you input the Standard Labor Cost Percentage.
Labor Template %% Input - Year = This is an additional template you can use. This template allows you to input a percentage for COGS, Labor and OOE. In the first template you inputted whole numbers and the template calculated the percentages, this template allows you to input percentages and the template then calculates the dollar cost. Numbers are inputted in any of the grey shaded cells.
Labor Act v Bud Variance = This template allow you to input Budgeted Financials and compared them to Actual Financials for the month and year-to-date. Numbers are inputted in any of the grey shaded cells.

Labor Template $$ Input - Year

Labor Model - Budget
Operation:FY14 Budget OctFY14 Budget NovFY14 Budget DecFY14 Budget JanFY14 Budget FebFY14 Budget MarFY14 Budget AprFY14 Budget MayFY14 Budget JunFY14 Budget JulFY14 Budget AugFY14 Budget SepFY14 Budget Total
Net Sales Revenue246,859246,859
Cost of Goods Sold89,88189,881
Cost of Goods Sold %36.4%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!36.4%
Gross Income from Sales156,97800000000000156,978
UFM Payroll & Non Pay00
ARM EXP REIMB00
Other Operating Revenue24,92024,920
Tot Other Income00
Total Revenue271,77900000000000271,779
Total Net Revenue271,77900000000000271,779
Total Labor156,897156,897
Total Labor Percent57.7%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!57.7%
Other Operating Expenses36,84236,842
Other Operating Expenses Percent13.6%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!13.6%
Total Other Expense00
Total Operating Exp193,73900000000000193,739
NIBD(11,841)00000000000(11,841)
NIBD Percent of Net Revenue-4.4%ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!-4.4%
Productive Hours from TLMS7,084000000000007,084
Labor Cost Per Productive Hour$22.15ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!$22.15
Revenue Per Productive Hour$38.37ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!$38.37
Labor Cost135,89000000000000135,890
Standard Labor Cost50.0%50.0%50.0%50.0%50.0%50.0%50.0%50.0%50.0%50.0%50.0%50.0%50.0%
Allowable Hours of Labor6,135ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!6,135
Over / Under(949)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!(949)

Labor Template %% Input - Year

Labor Model - Budget
Operation:FY14 Budget OctFY14 Budget NovFY14 Budget DecFY14 Budget JanFY14 Budget FebFY14 Budget MarFY14 Budget AprFY14 Budget MayFY14 Budget JunFY14 Budget JulFY14 Budget AugFY14 Budget SepFY14 Budget Total
Net Sales Revenue0000000000000
Cost of Goods Sold0000000000000
Cost of Goods Sold %0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%ERROR:#DIV/0!
Gross Income from Sales0000000000000
UFM Payroll & Non Pay0000000000000
ARM EXP REIMB0000000000000
Other Operating Revenue0000000000000
Tot Other Income0000000000000
Total Revenue0000000000000
Total Net Revenue0000000000000
Total Labor0000000000000
Total Labor Percent0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%ERROR:#DIV/0!
Other Operating Expenses0000000000000
Other Operating Expenses Percent0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%ERROR:#DIV/0!
Total Other Expense0000000000000
Total Operating Exp0000000000000
NIBD0000000000000
NIBD Percent of Net RevenueERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Productive Hours from TLMS0000000000000
Labor Cost Per Productive HourERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Revenue Per Productive HourERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Labor Cost0000000000000
Standard Labor Cost0.0%0.0%
Allowable Hours of LaborERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Over / UnderERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Labor Act v Bud Variance

=IF(B4=0,0,(IF(D4>=B4,ABS(D4/B4),+IF(D4<=B4,(D4/B4)))))

Operation:Actual vs Budget Labor Report
Community ClubMonthlyYear to Date
FinancialsFY13 Actual MonthFY13 Budget MonthFY13 Actual vs FY13 Budget MonthNet ChangeFY13 Actual YTDFY13 Budget YTDFY13 Actual vs FY13 Budget YTDNet Change
Net Sales Revenue00.0%0000.0%
Cost of Goods Sold00.0%0000.0%
Cost of Goods Sold %ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Gross Income from Sales0000.0%0000.0%
UFM Payroll & Non Pay00.0%00.0%
ARM EXP REIMB00.0%0000.0%
Other Operating Revenue0000.0%0000.0%
Tot Other Income0000.0%0000.0%
Total Revenue0000.0%0000.0%
Total Net Revenue0000.0%0000.0%
Total Labor0000.0%0000.0%
Total Labor PercentERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Other Operating Expenses0000.0%0000.0%
Other Operating Expenses PercentERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Total Other Expense0000.0%0000.0%
Total Operating Exp0000.0%0000.0%
NIBD0000.0%0000.0%
NIBD Percent of Net RevenueERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Productive Hours from TLMS0000.0%0000.0%
Labor Cost Per Productive HourERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Revenue Per Productive HourERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Labor Cost0000.0%0000.0%
Standard Labor Cost0.0%0.0%0.0%0.0%0.0%0.0%
Allowable Hours of LaborERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Over / UnderERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

File details come from the government source that posted it. Updated .