The Employee Benefits section math is set up the same as the rest of the spreadsheet, but it really should be quite different.
Currently it does the A x B = C math horizontally, and then adding up the totals vertically like everywhere else:
It should be just data fields for Gross, EE Cost and ER Cost, with the 8% calculating automatically, and then the Section Total being the lesser of 8% compared to Employer Cost.
Relates to:
Context
The Employee Benefits section math is set up the same as the rest of the spreadsheet, but it really should be quite different.
Currently it does the A x B = C math horizontally, and then adding up the totals vertically like everywhere else:
It should be just data fields for Gross, EE Cost and ER Cost, with the 8% calculating automatically, and then the Section Total being the lesser of 8% compared to Employer Cost.
Implementation
Pre-work cleanup before adding Employee Benefits UI. Adds fiscal year slug as url param, to make it easier to lookup various data in dashboard tabs. e.g. http://localhost:8080/child-care-centres/1/2023-24/summary/reconciliation or http://localhost:8080/child-care-centres/1/2023-24/worksheets/september Adds fiscal period model for to provide naming and shared location for per-month data. Adds employee benefits model; the current one on http://localhost:8080/child-care-centres/1/2023-24/worksheets/april does not have enough flexibility to handle the requirements.
Screenshots
Testing Instructions
dev up