Category : Tutorials + Patches
Archive   : QPRODOC.ZIP
Filename : TI696.ASC

 
Output of file : TI696.ASC contained in archive : QPRODOC.ZIP







PRODUCT : Quattro Pro NUMBER : 696
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 1/3

TITLE : Computing Overtime and Tax on Salary




This sheet describes how to calculate taxes up to a certain
maximum amount and how to calculate overtime pay with the
appropriate tax deductions.

The following is a list of named cells:

SALARY The salary for the current pay period without
overtime included. Our formula assumes a weekly
pay period.

YTD_SAL The year-to-date pretax salary total.

CUR_CHECK The taxable amount of paycheck for the current
period after nontaxable deductions.

FICA_MAX The maximum amount that can be deducted for FICA
tax.

FICA_RTE The current FICA tax rate.

SDI_MAX The maximum amount that can be deducted for state
disability insurance.

SDI_RATE The current SDI tax rate.

CUR_FICA The amount of FICA taxes being withheld from the
current paycheck.

CUR_SDI The amount of SDI taxes being withheld from the
current paycheck.

CUR_TAX The total amount of taxes being withheld.

YTD_FICA The total year-to-date FICA deductions.

YTD_SDI The total year-to-date SDI deductions.

YTD_TAX The total taxes deducted year-to-date.

PAY_CHECK The amount of the current paycheck including
overtime pay after taxes have been deducted.















PRODUCT : Quattro Pro NUMBER : 696
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 2/3

TITLE : Computing Overtime and Tax on Salary




HOURS The total number of hours worked for the current
period.

Referencing the following table, the formulas should be placed in
their corresponding cells. Once the labels have been entered
into column A, use /Edit | Names | Labels | Right and choose
A1..A15 as the block.

A B C
|--------------------------------------
1 | SALARY $1000.00
2 | YTD_SAL 24000.00
3 | CUR_CHECK 1075.00
4 | FICA_MAX 66967.32
5 | FICA_RTE 7.65%
6 | SDI_MAX 31767.00
7 | SDI_RATE 1.00%
8 | CUR_FICA 82.24
9 | CUR_SDI 10.75
10 | CUR_TAX 92.99
11 | YTD_FICA 1836.00
12 | YTD_SDI 240.00
13 | YTD_TAX 2076.00
14 | HOURS 42
15 | PAY_CHECK 982.01


B3: @IF(HOURS>40,@IF(HOURS>44,(((SALARY/40)*(HOURS-44))*2)+
(((SALARY/40)*4)*1.5)+SALARY,(((SALARY/40)*(HOURS-40))*1.5)+
SALARY),SALARY)

B8: @IF(YTD_FICA<(FICA_MAX*FICA_RTE),@IF(((FICA_RTE*CUR_CHECK)+
YTD_FICA)>(FICA_MAX*FICA_RTE),(FICA_MAX*FICA_RTE)-YTD_FICA,
(FICA_RTE*CUR_CHECK)),0)

B9: @IF(YTD_SDI<(SDI_MAX*SDI_RATE),@IF(((SDI_RATE*CUR_CHECK)+
YTD_SDI)>(SDI_MAX*SDI_RATE),(SDI_MAX*SDI_RATE)-YTD_SDI,
(SDI_RATE*CUR_CHECK)),0)

B10: +CUR_FICA+CUR_SDI

B11: +FICA_RTE*@MIN(FICA_MAX,YTD_SAL)














PRODUCT : Quattro Pro NUMBER : 696
VERSION : All
OS : DOS
DATE : September 11, 1991 PAGE : 3/3

TITLE : Computing Overtime and Tax on Salary




B12: +SDI_RATE*@MIN(SDI_MAX,YTD_SAL)

B13: +YTD_FICA+YTD_SDI

B15: +CUR_CHECK-CUR_FICA-CUR_SDI

The remainder of the cells require input from the user. This
includes current pay period salary/pay, year-to-date salary/pay,
maximum annual FICA and SDI deductions, current FICA and SDI
deduction rates, and total hours worked for the current pay
period.

The CUR_CHECK formula (cell B3) computes regular pay up to 40
hours, time and a half for 4 hours of overtime, and double time
for any hours worked above 44. When computing for a set salary
amount, total hours worked should be 40.

The CUR_FICA (cell B8) and CUR_SDI (cell B9) formulas compute the
taxes up to the maximum allowable deductions.
































  3 Responses to “Category : Tutorials + Patches
Archive   : QPRODOC.ZIP
Filename : TI696.ASC

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/