LanceCasteau
New Member
- Joined
- Dec 15, 2018
- Messages
- 2
[TABLE="width: 480"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Store[/TD]
[TD]Average Daily Sales[/TD]
[TD]Inventory[/TD]
[TD]Days On Hand (Inv/Sales)[/TD]
[/TR]
[TR]
[TD]New York, NY[/TD]
[TD]20[/TD]
[TD]40[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Seattle, WA[/TD]
[TD]25[/TD]
[TD]200[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Detroit, MI[/TD]
[TD]75[/TD]
[TD]225[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Dallas, TX[/TD]
[TD]5[/TD]
[TD]50[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]125[/TD]
[TD]515[/TD]
[TD]4.12[/TD]
[/TR]
</tbody>[/TABLE]
How to calculate what each stores weight is in the aggregate Days On Hand (4.12)?
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Store[/TD]
[TD]Average Daily Sales[/TD]
[TD]Inventory[/TD]
[TD]Days On Hand (Inv/Sales)[/TD]
[/TR]
[TR]
[TD]New York, NY[/TD]
[TD]20[/TD]
[TD]40[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Seattle, WA[/TD]
[TD]25[/TD]
[TD]200[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]Detroit, MI[/TD]
[TD]75[/TD]
[TD]225[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Dallas, TX[/TD]
[TD]5[/TD]
[TD]50[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]125[/TD]
[TD]515[/TD]
[TD]4.12[/TD]
[/TR]
</tbody>[/TABLE]
How to calculate what each stores weight is in the aggregate Days On Hand (4.12)?