Spreadsheet: 33980d1230952817-how-to-do-a-progressive-add-with-an-if-clause-that-is-interrupted-copy-of-scratch-1-
Sheet: MainBoard

Period   5       Week   4 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total
L.Y.'s Sales/Last Weeks Sls |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Planned Sales / Accum | 200 | 200 | 200 | 400 | 200 | 600 |  | 600 | 200 | 800 | 200 | 1000 | 300 | 1300 | 1300
Actual Sales/Accum | 250 | 250 | 250 | 500 | 250 | 750 |  | 750 | 100 | 850 |  | 850 |  | 850 | 850
Daily Sales Var/Accum Sales Var | 50 | 50 | 50 | 100 | 50 | 150 | 0 | 150 | -100 | 50 | -200 | -150 | -300 | -450 | -450
Admininistration Hours | 100 | 100 | 100 | 100 | 100 | 100 | 32 | 32 | 100 | 100 | 100 | 100 | 100 | 100 | 632 | 632
FE Hours | 100 | 100 | 100 | 100 | 100 | 100 | 24 | 24 | 100 | 100 | 100 | 100 | 100 | 100 | 624 | 624
Merchandising Hours | 100 | 100 | 100 | 100 | 100 | 100 | 40 | 40 | 100 | 100 | 100 | 100 | 100 | 100 | 640 | 640
Major [NAME] | 100 | 100 | 100 | 100 | 100 | 100 | 8 | 8 | 100 | 100 | 100 | 100 | 100 | 100 | 608 | 608
Memberservice Hours | 100 | 100 | 100 | 100 | 100 | 100 |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 600 | 600
Marketing Hours | 110 | 110 | 110 | 110 | 110 | 110 | 8 | 8 | 110 | 110 | 110 | 110 | 110 | 110 | 668 | 668
Receiving Hours | 100 | 100 | 100 | 100 | 100 | 100 | 8 | 8 | 100 | 100 | 100 | 100 | 100 | 100 | 608 | 608
Tire Center Hours | 100 | 100 | 100 | 100 | 100 | 100 |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 600 | 600
[NAME] | 100 | 100 | 100 | 100 | 100 | 100 |  |  | 100 | 100 | 100 | 100 | 100 | 100 | 600 | 600
Total Hours (Plan/Actual) | 910 | 910 | 910 | 910 | 910 | 910 | 120 | 120 | 910 | 910 | 910 | 910 | 910 | 910 | 5580 | 5580
Daily Hours Var./Acc. [NAME]. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Planned Payroll $'s/ Act. Payroll $ | 19110 | 19110 | 19110 | 19110 | 19110 | 19110 | 2520 | 2520 | 19110 | 19110 | 19110 | 19110 | 19110 | 19110 | 117180 | 117180
Planned Payroll %/Act. Payroll % | 0.09555 | 0.07644 | 0.09555 | 0.07644 | 0.09555 | 0.07644 |  |  | 0.09555 | 0.1911 | 0.09555 |  | 0.0637 |  | 0.09013846153846154 | 0.1378588235294118
Planned Prod./Act. Prod.  (Total) | 219.7802197802198 | 274.7252747252747 | 219.7802197802198 | 274.7252747252747 | 219.7802197802198 | 274.7252747252747 | 0 | 0 | 219.7802197802198 | 109.8901098901099 | 219.7802197802198 | 0 | 329.6703296703297 | 0 | 232.9749103942652 | 152.3297491039426
Planned Prod./Act. Prod. (Merch) | 219.7802197802198 | 274.7252747252747 | 219.7802197802198 | 274.7252747252747 | 219.7802197802198 | 274.7252747252747 | 0 | 0 | 219.7802197802198 | 109.8901098901099 | 219.7802197802198 | 0 | 329.6703296703297 | 0 | 232.9749103942652 | 152.3297491039426
Projected Week average salary | 21 |  |  |  |  |  |  |  |  | Holiday(s) & Inventories |  | Plan  Hrs | Act Hrs | Plan $'s | Act $'s
 | . |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Holiday average wage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan $'s with Hol | Act $'s with Hol | Prod with Hol
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 117180 | 117180 | 152.3297491039426
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09013846153846154