Can someone help me calculate this. This is probably simple, but for some reason it didn't seem right when I did this.
What I need to do is to find the Amount of Reduction Per one dollar of that specific item. Thanks.
What I need to do is to find the Amount of Reduction Per one dollar of that specific item. Thanks.
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Total Sales For Last Week | |||||||
2 | Item | Retail Price | Units | Sales | Reductions | Reduction Per 1.00 Dollar | ||
3 | Hamburger | $3.00 | 750 | $2,000.00 | $500.00 | |||
4 | Cheesburger | $4.00 | 1,450 | $5,000.00 | $1,500.00 | |||
5 | Hotdog | $2.00 | 850 | $1,400.00 | $200.00 | |||
Sheet1 |