On a daily basis, I track and record sales of different products at different prices and at different geographic locations. On any given day, there may be "multiple" sales (of different volumes of each good) at different prices. For example, on day 1, there may be 3 sales (100 units, 200 units and 300 units) of product A at Point One at $3.50, $3.25 and $3.00, respectively, and 2 sales (400 units and 450 units) of product B at Point Two at $4.75 and $5.00.
What I would like to do is create an "Input Sheet" wherein I would record daily these sales, and the "program" would automatically transfer the daily data over to another worksheet where it would be "posted" by day, and the daily and month-to-date (and year-to-date, if possible) weighted average would be calculated, by product by day.
Any suggestions?
What I would like to do is create an "Input Sheet" wherein I would record daily these sales, and the "program" would automatically transfer the daily data over to another worksheet where it would be "posted" by day, and the daily and month-to-date (and year-to-date, if possible) weighted average would be calculated, by product by day.
Any suggestions?