Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving of linear equation
Hello All,
Let me describe my problem first: I have an array (X) in column which is net salary of a staff and need to caculate gross for further calculation of witholdes from salary and social taxes from employer. Thus I need to calculate Y - gross in another array. The equation for X is folowing: X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%) the equations also has constraint: if Y=4960, then Y should be substituted with 4960 in equation, because it is maximum taxable amount. So I need to solve linear equation for Y Could somebody give an advice how i can do this. I'll be appreciated for any help... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving of linear equation
Y=X/0.83955
maximizing Y: X=MIN(X/0.83955,4960) Regards, Stefi €žStan€ť ezt Ă*rta: Hello All, Let me describe my problem first: I have an array (X) in column which is net salary of a staff and need to caculate gross for further calculation of witholdes from salary and social taxes from employer. Thus I need to calculate Y - gross in another array. The equation for X is folowing: X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%) the equations also has constraint: if Y=4960, then Y should be substituted with 4960 in equation, because it is maximum taxable amount. So I need to solve linear equation for Y Could somebody give an advice how i can do this. I'll be appreciated for any help... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving of linear equation
Thank you, Stefi,
but I have some hesitation about solution that you give, because after Y =limited amount for taxes, which are substracted (0,5%, 2%, 1%), profit tax (13%) is applied to difference between gross salary and gross withholdes. Net=Gross-(Gross-(limit*2%)-(limit*1%)-(limit*0,5%))*13%-(limit*2%)-(limit*1%)-(limit*0,5%) So we have here not asolute line dependence.... It will be line till gross doesn't exceed limit for withhold taxes. Sorry if I express not very clear. Hope you'll get my idea Stefi wrote: Y=X/0.83955 maximizing Y: X=MIN(X/0.83955,4960) Regards, Stefi ,,Stan" ezt írta: Hello All, Let me describe my problem first: I have an array (X) in column which is net salary of a staff and need to caculate gross for further calculation of witholdes from salary and social taxes from employer. Thus I need to calculate Y - gross in another array. The equation for X is folowing: X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%) the equations also has constraint: if Y=4960, then Y should be substituted with 4960 in equation, because it is maximum taxable amount. So I need to solve linear equation for Y Could somebody give an advice how i can do this. I'll be appreciated for any help... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving of linear equation
Thank you, Stefi,
but I have some hesitation about solution that you give, because after Y =limited amount for taxes, which are substracted (0,5%, 2%, 1%), profit tax (13%) is applied to difference between gross salary and gross withholdes. Net=Gross-(Gross-(limit*2%)-(limit*1%)-(limit*0,5%))*13%-(limit*2%)-(limit*1%)-(limit*0,5%) So we have here not asolute line dependence.... It will be line till gross doesn't exceed limit for withhold taxes. Sorry if I express not very clear. Hope you'll get my idea Stefi wrote: Y=X/0.83955 maximizing Y: X=MIN(X/0.83955,4960) Regards, Stefi ,,Stan" ezt írta: Hello All, Let me describe my problem first: I have an array (X) in column which is net salary of a staff and need to caculate gross for further calculation of witholdes from salary and social taxes from employer. Thus I need to calculate Y - gross in another array. The equation for X is folowing: X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%) the equations also has constraint: if Y=4960, then Y should be substituted with 4960 in equation, because it is maximum taxable amount. So I need to solve linear equation for Y Could somebody give an advice how i can do this. I'll be appreciated for any help... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving of linear equation
net:A1
limit:C1 then gross=(A1+0.03045*C1)/0.87 Regards, Stefi €žStan€ť ezt Ă*rta: Thank you, Stefi, but I have some hesitation about solution that you give, because after Y =limited amount for taxes, which are substracted (0,5%, 2%, 1%), profit tax (13%) is applied to difference between gross salary and gross withholdes. Net=Gross-(Gross-(limit*2%)-(limit*1%)-(limit*0,5%))*13%-(limit*2%)-(limit*1%)-(limit*0,5%) So we have here not asolute line dependence.... It will be line till gross doesn't exceed limit for withhold taxes. Sorry if I express not very clear. Hope you'll get my idea Stefi wrote: Y=X/0.83955 maximizing Y: X=MIN(X/0.83955,4960) Regards, Stefi ,,Stan" ezt Ă*rta: Hello All, Let me describe my problem first: I have an array (X) in column which is net salary of a staff and need to caculate gross for further calculation of witholdes from salary and social taxes from employer. Thus I need to calculate Y - gross in another array. The equation for X is folowing: X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%) the equations also has constraint: if Y=4960, then Y should be substituted with 4960 in equation, because it is maximum taxable amount. So I need to solve linear equation for Y Could somebody give an advice how i can do this. I'll be appreciated for any help... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
solving of linear equation
ok, thank you Steffi
frankly saying i supposed to get any ideas about solution of of such equation not in a way of simplication but more detailed. any way again thanks for assistance Stan wrote: Thank you, Stefi, but I have some hesitation about solution that you give, because after Y =limited amount for taxes, which are substracted (0,5%, 2%, 1%), profit tax (13%) is applied to difference between gross salary and gross withholdes. Net=Gross-(Gross-(limit*2%)-(limit*1%)-(limit*0,5%))*13%-(limit*2%)-(limit*1%)-(limit*0,5%) So we have here not asolute line dependence.... It will be line till gross doesn't exceed limit for withhold taxes. Sorry if I express not very clear. Hope you'll get my idea Stefi wrote: Y=X/0.83955 maximizing Y: X=MIN(X/0.83955,4960) Regards, Stefi ,,Stan" ezt írta: Hello All, Let me describe my problem first: I have an array (X) in column which is net salary of a staff and need to caculate gross for further calculation of witholdes from salary and social taxes from employer. Thus I need to calculate Y - gross in another array. The equation for X is folowing: X = Y - (Y-(Y*2%)-(Y*1%)-(Y*0,5%))*13%-(Y*2%)-(Y*1%)-(Y*0,5%) the equations also has constraint: if Y=4960, then Y should be substituted with 4960 in equation, because it is maximum taxable amount. So I need to solve linear equation for Y Could somebody give an advice how i can do this. I'll be appreciated for any help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linear Predictive Equation | Excel Worksheet Functions | |||
Linear trendline:wrong equation | Charts and Charting in Excel | |||
Linear Trendline Equation Question | Charts and Charting in Excel | |||
how do I graph a linear equation? | Charts and Charting in Excel | |||
calculate non linear equation lines using excel | Excel Discussion (Misc queries) |