getCost: Compute Personnel Cost

In basilrabi/mansched: Manpower Scheduler and Personnel Cost Calculator for Taganito Mine

Compute Personnel Cost

Description

Calculates monthly personnel cost for each cost center Personnel costs are comprised by:

60300000

Payroll - Salaries (Regular)

60300001

Payroll - Salaries (Seasonal)

60300004

Payroll - Overtime (Regular)

60300005

Payroll - Overtime (Seasonal)

60300008

Payroll - 13th Month and Other Bonuses (Regular)

60300009

Payroll - 13th Month and Other Bonuses (Seasonal)

60300011

Payroll - Leave Commutation (Regular)

60300012

Payroll - Leave Commutation (Seasonal)

60300014

Payroll - De Minimis Benefits (Regular)

60300015

Payroll - De Minimis Benefits (Seasonal)

60300017

SSS Contributions (Regular)

60300018

SSS Contributions (Seasonal)

60300020

PHIC Contributions (Regular)

60300021

PHIC Contributions (Seasonal)

60300023

HDMF Contributions (Regular)

60300024

HDMF Contributions (Seasonal)

60300029

Other Employee Allowances

60300033

Hospital and Medical Expenses - Employees

60300036

Awards and Prizes

60900000

Life and Medical Insurance - Employees

61100000

Contract Fee - Agency Services

Usage

getCost(
  mhDB,
  listR,
  wage,
  forecast = FALSE,
  bonusFactorYearEnd = 1.5,
  absentee = NA,
  monthStart = 1L,
  leaveConversionFactor = 0.5
)

Arguments

mhDB	a data.frame similar to mhDB return by getmhDB
listR	a list of Employee-class objects representing the employee pool
wage	a data.frame composed of two columns: ID character string representing a unique identifier of an employee s integer value representing the salary of an employee For rank and file, this value represents the daily salary at the beginning of the year. For non-rank and file, this value represents the monthly salary at the beginning of the year.
forecast	logical value Compute cost for forecast?
bonusFactorYearEnd	a numeric value for the salary multiplier for the year-end bonus
absentee	a data.frame composed of at least two columns: ID character string representing a unique identifier of an employee costCenter Cost centers wherein the leave commutation or the holiday pays are distributed whenever the employee does not report for work for a month.
monthStart	an integer representing the month of start of forecasting
leaveConversionFactor	numeric value for the monthly salary fraction assumed as leave conversion

Value

a list containing the following:

1. a data.frame with 16 columns

   The last 12 columns represents the cost per month. The 1st column is the activity cost center. The 2nd column is the description of the general ledger code. The 3rd column is the equipment type used. The 4th column is the general ledger code.

2. tabulated total man hours per month per cost center

3. tabulated 13th month pay per month per cost center

4. tabulated bonus cost per month per cost center

5. a data.frame with 16 columns similar to the first element of the returned list but with an additional column indicating the employment status

basilrabi/mansched documentation built on May 18, 2023, 1:29 p.m.