Spreadsheet: 769111d1645302230-planned-vs-actual-weeks-behind-or-ahead-calculation-planned-vs-actual-week-status-rev-pcb-2
Sheet: Sheet1

 |  |  |  |  |  |  |  | Planned | Cumulative |  |  | Planned | Cumulative |  |  |  |  | weekly | cumulative | weekly | cumulative |  |  | Period | Actual | Delta |  |  | Attention: There are 2 charts of the same size on top of each other. The chart with green bars are shifted down approx. 3 rows
Date | Planned Week | Actual Week | Planned Cumulative | Actual Cumulative | Status (Weeks behind or ahead) | Column F should read: |  | Product. | Productivity | Forecast1 |  | Product. | Productivity | Forecast1 |  |  |  | planned prod. Time / item | planned prod. Time / item | actual prod. Time / item | actual prod. Time / item |  |  | Time | Time | Time | Planned | Actual
2022-01-03 00:00:00 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  | 0 | 0 |  |  | wk01 | 2022-01-03 00:00:00 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0
2022-01-10 00:00:00 | 14 | 7 |  |  |  | -0.5 |  | 12.83333 |  |  |  | 12.83333 |  |  |  | wk02
2022-01-17 00:00:00 | 14 | 14 |  |  |  | -0.5 |  | 12.83333 |  |  |  | 12.83333 | 1 |  |  | wk03
2022-01-24 00:00:00 | 14 | 7 |  |  |  | -1 |  | 12.83333 |  |  |  | 12.83333 |  |  |  | wk04
2022-01-31 00:00:00 | 21 | 7 |  |  |  | -1.5 |  | 12.83333 |  |  |  | 12.83333 | 2 |  |  | wk05
2022-02-07 00:00:00 | 21 | 21 |  |  |  | -1.33 |  | 12.83333 |  |  |  | 12.83333 |  |  |  | wk06
2022-02-14 00:00:00 | 14 | 21 |  |  |  | -1.33 |  | 12.83333 |  | 77 |  | 12.83333 | 3 | 77 |  | wk07
2022-02-21 00:00:00 | 14 | 21 |  |  |  | -1 |  | 12.83333 |  |  |  |  |  |  |  | wk08
2022-02-28 00:00:00 | 7 | 21 |  |  |  | 0 |  | 12.83333 |  |  |  |  |  |  |  | wk09
2022-03-07 00:00:00 | 7 | 21 |  |  |  | 1 |  | 12.83333 |  |  |  |  |  |  |  | wk10
2022-03-14 00:00:00 | 14 | 21 |  |  |  | 1.5 |  | 12.83333 |  |  |  |  |  |  |  | wk11
2022-03-21 00:00:00 | 14 | 7 |  |  |  | 1 |  | 12.83333 |  |  |  |  |  |  |  | wk12
2022-03-28 00:00:00 | 14 | 7 |  |  |  | 0.5 |  | 12.83333 |  |  |  |  |  |  |  | wk13
2022-04-04 00:00:00 | 14 | 7 |  |  |  | 0 |  | 12.83333 |  |  |  |  |  |  |  | wk14
2022-04-11 00:00:00 | 14 | 7 |  |  |  | -0.5 |  | 12.83333 |  |  |  |  |  |  |  | [NAME]
2022-04-18 00:00:00 | 21 | 7 |  |  |  | -1 |  | 12.83333 |  |  |  |  |  |  |  | wk16
2022-04-25 00:00:00 | 21 | 7 |  |  |  | -1.67 |  | 12.83333 |  |  |  |  |  |  |  | wk17
2022-05-02 00:00:00 | 7 | 7 |  |  |  | -2.33 |  | 12.83333 |  |  |  |  |  |  |  | wk18
2022-05-09 00:00:00 | 7 | 7 |  |  |  | -3 |  | 12.83333 |  |  |  |  |  |  |  | wk19
2022-05-16 00:00:00 | 14 | 7 |  |  |  | -3.67 |  | 12.83333 |  |  |  |  |  |  |  | wk20
2022-05-23 00:00:00 | 14 | 7 |  |  |  | -4.33 |  | 12.83333 |  |  |  |  |  |  |  | wk21
2022-05-30 00:00:00 |  |  |  |  |  |  |  | 12.83333 |  |  |  |  |  |  |  | wk22
2022-06-06 00:00:00 |  | 21 |  |  |  |  |  | 12.83333 |  |  |  |  |  |  |  | wk23
 |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | wk24
 |  | 21 |  |  |  |  |  | 77 item earned |  |  |  |  | assuming that after 6 weeks |  |  | wk25
 |  | 21 |  |  |  |  |  | 280-77=203 items to go |  |  |  |  | we can produce according the planned
 |  | 7 |  |  |  |  |  | it took 6 weeks to do 77 |  |  |  |  | from week 7 until the end
 |  | 7 |  |  |  |  |  | that is 77/6=12,83 items per week |  |  |  |  | Being 182 items in 14 weeks
 |  | 7 |  |  |  |  |  | under these circumstances it will take |  |  |  |  | gives 182 / 14 = 13 items/week
 |  | 7 |  |  |  |  |  | 203 / 12,83 = |  |  |  | weeks | Time to go is 203 / 13 =
 |  | 7 |  |  |  |  |  | than the total time will come to 6 + 15,8 = 21,8 weeks |  |  |  |  | so after weeks it looks like that we
 |  | 7 |  |  |  |  |  | the planned time was 20 weeks for 280 items |  |  |  |  | need 15,6 weeks to go after
 |  | 7 |  |  |  |  |  | So you could say that after 6 weeks production |  |  |  |  | the first 6 weeks
 |  | 7 |  |  |  |  |  | we are 1,8 weeks behind schedule |  |  |  |  | so 1,6 weeks behind schedule
 |  | 7
 |  | 7