1920-1-acco 20073- Payroll Worksheet.xlsx

ANNEX A Melindo, Inc. Payroll worksheet For the payroll cut-off July 1 to 15, 2019 1st shif 2nd shif

Employee name

Jayson Joane Ced Jouie You Maureen Billy Chad James

7:30am-4:30pm 6:00pm-3:00am

Position

Production Manager Admin& Finance Manager Production Supervisor Production Supervisor Acctg. Staff 1 Production Staff 2 Production Staff 1 Production Staff 2 Production Staff 1

Shif

Hourly rate

1 45,000/mo. 1 27,500/mo. 1 19,000/mo. 2 23,400/mo. 1 14,800/mo. 2 114.00 2 86.50 1 83.00 1 79.75

Hrs. worked* 80 76 80 80 96 90 80 84 86

Over(under) time 0 -4 0 0 16 10 0 4 6

Gross Pay

22,500.00 13,750.00 9,500.00 11,700.00 7,400.00 9,120.00 6,920.00 6,640.00 6,380.00 93,910.00

Deductions (absences, tardiness) (687.50) (687.50)

Overtime pay (a) 1,140.00 332.00 478.50 1,950.50

Notes: (a) Overtime premium is 10% of the hourly rate when rendered on weekdays and 30% of the hourly rate when rendered on weekends. (b) Night differential is 10% of the hourly rate. *Standard working hours is eight (8) hours per day, or a total of eighty (80) hours in a payroll cut-off period. **ER = employer's share; EE = employee's share *** Statutory deductions are deducted from employees' payroll during the first cut-off period of the month. These are treated as overhead cost, if relating to production workers. ****Employee's Compensation. Borne by the employer.

SSS Overtime premium 114.00 33.20 47.85 195.05

to production workers.

Night differential (b) 585.00 513.00 342.93 1,440.93

Gross pay before statutory deductions 22,500.00 13,062.50 9,500.00 12,285.00 7,400.00 10,887.00 6,920.00 7,005.20 7,249.28 96,808.98

Withholding Tax 2,708.25 529.10 373.60 94.00 3,704.95

ER**

1,600.00 1,600.00 1,600.00 1,600.00 1,200.00 1,440.00 1,120.00 1,080.00 1,040.00 12,280.00

EE**

800.00 800.00 800.00 800.00 600.00 720.00 560.00 540.00 520.00 6,140.00

Statutory Deductions*** Philhealth

EC****

30.00 30.00 30.00 30.00 10.00 30.00 10.00 10.00 10.00 190.00

ER**

550.00 378.13 261.25 321.75 203.50 250.80 190.30 182.60 175.45 2,513.78

Pag-ibig

EE**

550.00 378.13 261.25 321.75 203.50 250.80 190.30 182.60 175.45 2,513.78

ER**

900.00 550.00 380.00 468.00 296.00 364.80 276.80 265.60 255.20 3,756.40

Pag-ibig

EE**

900.00 550.00 380.00 468.00 296.00 364.80 276.80 265.60 255.20 3,756.40

Overhead: Indirect materials Indirect labor Manufacturing support: Depreciation of plant assets Factory rent Utilities Maintenance Other fixed factory overhead

Month January February March April May June

Budgeted cost Remarks P3.50/bag of cement P38,200 + 1.75x x = bag of cement 39,000 43,125 ? 1500 + 0.28x x = machine hours 5,000

X Machine hours 898 910 985 921 944 967

Change in Y Divided by: change in X Variable cost/unit Fixed cost: Total cost VC

Y Cost (PHP) 22,503.80 22,649.70 23,252.00 22,679.90 22,899.40 23,311.45

748 87 8.60 @ 985 MH

@ 898 MH 23,252.00 8,471.00 14,781.00

22,503.80 7,722.80 14,781.00

Budgeted production for July 2019 is 1,170 bags of cement. It is estimated that each bag of cement takes about 0.8 machine hours to produce.

Prime cost Applied OH 931 hrs. x P166.73

406,127.50

Actual overhead Applied overhead Overapplied overhead

118,992.63 155,225.63 (36,233.00)

155,225.63 561,353.13

Base

VC/u 1170 1170

936 936

Predetermined OH rate

Fixed 3.5 1.75

38,200.00

39,000.00 43,125.00 8.6 14,781.00 0.28 1,500.00 5,000.00 141,606.00

Total 4,095.00 40,247.50 39,000.00 43,125.00 22,830.60 1,762.08 5,000.00 156,060.18 166.73

Demand

5000

No. of units 2000 1000 600 250 100

Carrying cost Average inventory CC/unit 1000 25 500 25 300 25 125 25 50 25

TCC No. of orders 25,000.00 2.5 12,500.00 5 7,500.00 8.333333333 3,125.00 20 1,250.00 50

Ordering cost Cost per order 900 900 900 900 900

ering cost TOC 2,250.00 4,500.00 7,500.00 18,000.00 45,000.00

Total cost 27,250.00 17,000.00 15,000.00 21,125.00 46,250.00