æ¯æåºäº¤ä¸ªäººæå¾ç¨æ个人工èµèªé计ç®äº¤çº³ç个人åºäº¤çç¨é¢ï¼ä»¥æ¯ææ¶å
¥é¢åé¤å
ç¨çåºä¸ªäººè´æ
çâäºé©ä¸éâç项ç®ï¼ååå»å
许æ£é¤è´¹ç¨3500å
ï¼å¤ç±äººåæ4800å
ï¼åçä½é¢,为åºçº³ç¨æå¾é¢ã
å
¬å¼ï¼æ¯æåºäº¤ä¸ªäººæå¾ç¨é¢=åºçº³ç¨æå¾é¢*éç¨ç¨ç-éç®æ£é¤æ°ã
æ¯æåºäº¤ä¸ªäººæå¾ç¨é¢=ï¼å·¥èµ-个人交äºé©ä¸ééé¢-个人æå¾ç¨æ£é¤é¢3500ï¼å
ï¼*ç¨ç-éç®æ£é¤æ°ï¼
æ交社ä¿ãå
¬ç§¯éåçéé¢è®¡ç®ï¼
ä¾ï¼äº¤ä¸ªäººæå¾ç¨é¢=ï¼å·¥èµ85000å
-个人交äºé©ä¸ééé¢0å
-个人æå¾ç¨æ£é¤é¢3500ï¼å
ï¼*ç¨ç45%-éç®æ£é¤æ°13505å
=23170å
ã
ç¨åå·¥èµæ¶å
¥=85000-23170=61830å
ã
追é®è¯·é®å¯ä»¥æä¾EXCELå
¬å¼åï¼
追ç=MAX((C6-3500)*{0.03,0.1,0.2,0.25,0.3,0.35,0.45}-{0,105,555,1005,2755,5505,13505},0)
C6æ¯åé¤ä¸ªäººäº¤äºé©ä¸ééé¢çå·¥èµèªééé¢ã