On 2002-10-24 14:35, Adrae wrote:
Oh right, the price and costs are on a per gallon.
Thanks
Adrae
Juice.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Juice | Limit | Quantity | Price | Cost | Profit | Model: | |||||||
2 | OJ | 50 | 0 | $1.00 | $0.50 | $0.00 | $115.00 | |||||||
3 | GJ | 75 | 25 | $0.90 | $0.40 | $12.50 | 3 | |||||||
4 | PJ | 50 | 0 | $0.80 | $0.35 | $0.00 | TRUE | |||||||
5 | All-in-One | 150 | $1.10 | $0.42 | $102.50 | TRUE | ||||||||
6 | Total | 175 | $115.00 | TRUE | ||||||||||
7 | 30%ofTotal | 52.5 | TRUE | |||||||||||
8 | TRUE | |||||||||||||
9 | 100 | |||||||||||||
10 | ||||||||||||||
Sheet2 |