Given the following data on inputs and outputs at a work center, determine the cumulative deviation and the backlog for each time period. The beginning backlog is $7.($Negative amounts should be indicated by a minus sign.$)$

Input

$\backslash$table$[[,$Period$],[,1,2,3,4,5,6,],[$Planned$,200,200,180,190,190,200,],[$Actual$,210,200,179,195,193,194,]]$

Output

$\backslash$table$[[,$Period$],[,1,2,3,4,5,6,],[$Planned$,200,200,180,190,190,200,],[$Actual$,205,194,177,195,193,200,]]$

Click here for the Excel Data File

$\backslash$table$[[$Input$,$Cumulative Deviation,,,,,$],[$Output$,$Cumulative Deviation,,,,,$],[$Backlog$,7,,,,,]]$