Production counter with history database

Hello.

We are trying to create a simple production counter which should count number of pcs produced and also measure how well we perform according to plan.
I need to create a History table that updates it self once a day at a specific time.
I have attached a file that explains what the macro should update.

Every morning at 05:41, add a new row to the history table and add date, planned parts, produces parts, and calculate backlog status.

More details in the attached file.

I really hope you can help me...

/Anders