Estimates vs Actuals - best way to store data?

[mommyof4kids]

I need to track estimates of overtime hours & the associated costs for multiple fiscal years. (we use for planning purposes the next year)

Currently I have a table with actuals for this FY (hours and the associated costs), along with other data (employee, date, etc.)



For the estimates, we only care about the hours & the estimated costs for those hours for that particular reason (ie vacation).

Each reason (ie vacation leave) will have an estimated # of hours, estimated cost, then eventually will have actual hours & costs.

We have been tracking this info in Excel and linking all the cells (which is a nightmare) back to higher level reports.

I'm running into a brain block for the estimates vs the actuals. I currently have a table for actuals and another table for estimates. I want to be able to display them on the screen for review and updates (to the estimates only)...in Excel the managers are used to seeing reports with many multiple columns and in Access 2010 you can't really do that...so I thought maybe I would trick it and name the fields FY15ActHrs, FY15EstHrs, etc. so that I could display them side by side (as in columns)..works fine in a report, however, how can I display this so they can make updates? (in a form?) ActHrs (Actual Hours) EstHrs (Estimated Hours), etc. Or display the results on the screen, do a pop up form for them to make changes? Obviously the only estimates they really need to update will be for FY18 and beyond.

OT Code: Vacation Leave

PP01 FY15EstHrs FY15EstCost FY15 Act Hrs FY15 ActCost then would have years FY16, FY17, FY18
PP02
PP03


Hope that makes sense.

[ranman256]

Your structure is wrong. Use:
FY, code, EstHrs,EstCost,ActualHrs,ActualCost

[orange]

i'm not sure of the level of detail needed, but in general terms you have

-Employees
-Employee Years of Service??
-Employee Salary
-Employee Reg Hrs
-Employee OT Hrs
-Employee Entitlements (hrs vacation etc)

-Employees work in Departments/Areas

-Potential Hirings

etc.