Hi all,
Happy bank holiday from the UK.
I'm trying to create an Excel model which tracks my outbound capacity from a warehouse and identifies where the capacity is forecast to be exceeded, and adjusts the outbound volume to the weeks where there is spare capacity.
[TABLE="width: 1355"]
<tbody>[TR]
[TD]At the moment I have the data as follows..
[TABLE="width: 1355"]
<tbody>[TR]
[TD]week[/TD]
[TD][/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD]Outbound [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"]75000[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD]Outbound Constraint[/TD]
[TD][/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[/TR]
[TR]
[TD]Capacity[/TD]
[TD][/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-25000[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD]Constrained Supply[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-25000[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Cumulative CS[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-30000[/TD]
[TD="align: right"]-55000[/TD]
[TD="align: right"]-55000[/TD]
[/TR]
</tbody><colgroup><col><col span="19"></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Essentially I have breached my outbound capacity in weeks 49,50,51 and 52 and need to make use of spare capacity in the weeks with capacity.
Any thoughts or initial suggestions would be massively appreciated.
Regards [/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col span="19"></colgroup>[/TABLE]
Happy bank holiday from the UK.
I'm trying to create an Excel model which tracks my outbound capacity from a warehouse and identifies where the capacity is forecast to be exceeded, and adjusts the outbound volume to the weeks where there is spare capacity.
[TABLE="width: 1355"]
<tbody>[TR]
[TD]At the moment I have the data as follows..
[TABLE="width: 1355"]
<tbody>[TR]
[TD]week[/TD]
[TD][/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]52[/TD]
[/TR]
[TR]
[TD]Outbound [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]20000[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"]65000[/TD]
[TD="align: right"]75000[/TD]
[TD="align: right"]20000[/TD]
[/TR]
[TR]
[TD]Outbound Constraint[/TD]
[TD][/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[/TR]
[TR]
[TD]Capacity[/TD]
[TD][/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]50000[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]35000[/TD]
[TD="align: right"]30000[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-25000[/TD]
[TD="align: right"]30000[/TD]
[/TR]
[TR]
[TD]Constrained Supply[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-25000[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Cumulative CS[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-15000[/TD]
[TD="align: right"]-30000[/TD]
[TD="align: right"]-55000[/TD]
[TD="align: right"]-55000[/TD]
[/TR]
</tbody><colgroup><col><col span="19"></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Essentially I have breached my outbound capacity in weeks 49,50,51 and 52 and need to make use of spare capacity in the weeks with capacity.
Any thoughts or initial suggestions would be massively appreciated.
Regards [/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody><colgroup><col><col span="19"></colgroup>[/TABLE]