Hello,
Let's say I am selling a weekly newspaper @ $1 each (retail), and I purchase 10 newspapers at the wholesale price of $0.25 each. During the 7 day week — Wednesday through Tuesday — I sold 8 newspapers, leaving me with 2 leftover papers from that week. So, when the new newspaper comes out on Wednesday I will purchase a new batch of papers to sell. However, I also want to sell the remaining 2 newspapers from the previous week at a discount.
Another example, but as a spreadsheet:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Current Week's Papers Purchased
[/TD]
[TD]No. of Current Week's Papers Sold
[/TD]
[TD]No. of Previous Week's Papers Sold
[/TD]
[TD]Total Current Week's Papers In Stock
[/TD]
[TD]Total Previous Week's Papers In Stock
[/TD]
[TD]Notes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/2
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]9
[/TD]
[TD]4
[/TD]
[TD]To start, I had 5 prev. week's papers left over.
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/3
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]7
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/4
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/5
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/6
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]Since I was down to 2 cur. week's paper's left I got 4 more = 6, but I sold 1 = 4 in stock
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/7
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/8
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/9
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]9
[/TD]
[TD]3
[/TD]
[TD]New week: purchased 10 current week's papers & sold 1 = 9 left in stock. Moved the 3 papers remaining in the current week's papers column into the prev. week's newspaper column, and lost the 1 paper that was in the prev. week's paper column.
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How can I get Excel to move the papers that are in the current week's papers column into the past week's papers column where they will be tracked and sold at a reduced rate?
Thanks for your help!
Warmly,
Hy with Guide Dog, "Fleetwood"
Let's say I am selling a weekly newspaper @ $1 each (retail), and I purchase 10 newspapers at the wholesale price of $0.25 each. During the 7 day week — Wednesday through Tuesday — I sold 8 newspapers, leaving me with 2 leftover papers from that week. So, when the new newspaper comes out on Wednesday I will purchase a new batch of papers to sell. However, I also want to sell the remaining 2 newspapers from the previous week at a discount.
Another example, but as a spreadsheet:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Current Week's Papers Purchased
[/TD]
[TD]No. of Current Week's Papers Sold
[/TD]
[TD]No. of Previous Week's Papers Sold
[/TD]
[TD]Total Current Week's Papers In Stock
[/TD]
[TD]Total Previous Week's Papers In Stock
[/TD]
[TD]Notes
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/2
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]9
[/TD]
[TD]4
[/TD]
[TD]To start, I had 5 prev. week's papers left over.
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/3
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]7
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/4
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/5
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/6
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]Since I was down to 2 cur. week's paper's left I got 4 more = 6, but I sold 1 = 4 in stock
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/7
[/TD]
[TD]0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/8
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/9
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]9
[/TD]
[TD]3
[/TD]
[TD]New week: purchased 10 current week's papers & sold 1 = 9 left in stock. Moved the 3 papers remaining in the current week's papers column into the prev. week's newspaper column, and lost the 1 paper that was in the prev. week's paper column.
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
How can I get Excel to move the papers that are in the current week's papers column into the past week's papers column where they will be tracked and sold at a reduced rate?
Thanks for your help!
Warmly,
Hy with Guide Dog, "Fleetwood"