Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Yellow
Created By: Shannon Scoffield
Created Date/Time: 4/13/2015 4:49 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
 
Time Id: 3742
Template/Type: Other Documentation
Title/Caption: Advanced Edit Cart Line Scenarios
Start Date: 12/27/2014
Main Status: Active

click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -
click to enlarge - photo by: Shannon Scoffield -


Notes:
Advanced Edit Cart Line Scenarios:
- Tax cat:
o $0
o + tax [normal]
o w/tax included [back calc]
- Qty:
- Cost:
- Mark-up:
- Price per:
- Total Price:
o Unknown price per
o Unknown quantity
- Discount:
o % off
o $ off
o Use in-line discount
o Use standalone
o Remove – use price per
o Remove – use original

Known Scenarios:
1. Normal:
- Tax = 0 or normal
- Known qty
- Known cost
- Known price per
2. Normal with an unknown [use mark-up]
- Tax = 0 or normal
- Known qty
- Known cost
- Use mark-up to get price per
- Unknown price - ?
3. Single back calc [with tax included]
- Tax = w/tax included
- Known qty
- Known cost
- Price is variable - ?
4. Single back calc – special total unknown price per
- Tax = 0 or normal
- Known qty
- Know cost
- Unknown price per - ?
- Known total or goal
5. Single back calc – special total unknown qty
- Tax = 0 or normal
- Unknown qty - ?
- Known cost
- Known price per
- Known total or goal
6. Single back calc – simple discount
- Tax = 0 or normal
- Known qty
- Known cost
- Unknown price per - ?
- Known discount % or $ off
- Known original
7. Double back calc – use mark-up and with tax included
- Tax = w/tax included [2]
- Known qty
- Known cost [1]
- Known mark-up [1]
- Unknown price per - ?
8. Double back calc – with tax included, special total, unknown price per
- Tax = with tax included [2]
- Known qty
- Known cost
- Unknown price per - ?
- Known total or goal [1]
9. Double back calc – with tax included, special total, unknown quantity
- Tax = with tax included [2]
- Unknown qty - ? [1]
- Known cost
- Known price per
- Known total or goal
10. Double back calc – with tax included, simple discount
- Tax = with tax included [2]
- Known qty
- Known cost
- Unknown price per - ?
- Known discount % or $ off [1]
- Known original
11. Double back calc – special total, unknown price per, simple discount
- Tax = 0 or normal
- Known qty
- Known cost
- Unknown price per - ?
- Known total [1]
- Known discount % or $ off [2]
- Known original
12. Double back calc – special total, unknown quantity, simple discount
- Tax = 0 or normal
- Unknown qty - ? [1]
- Known cost
- Known price per
- Known total
- Known discount % or $ off [2]
- Known original
13. Triple back calc – with tax included, special total, unknown price per, simple discount
- Tax = with tax included [2]
- Known qty
- Known cost
- Unknown price per - ?
- Known total [1]
- Known discount % or $ off
- Known original
- Goal – [minus] discount = new total
- New total / [divide] with tax included = 2nd new total
- Second new total * [times] tax rate = new total
- Second new total / [divide] qty = price per
o Tax – with tax included
o Qty = 400
o Cost = $1.50
o Total = 2,000
o Discount = 10%
o Original = 5.16
o 2000 – 10% = 1800 [new total]
o 1800 / 1.064 = 1691.73 [2nd new total]
o 1691.73 * 6.4% tax = 108.27 tax total
o 1691.73 [2nd new total] + 108.27 [tax total] = 1800 [new total]
o Price per 4.22933 after % discount, ending discount = 18.04%
14. Triple back calc – with tax included, special total, unknown quantity, simple discount
- Tax = with tax included
- Unknown qty - ? [2]
- Known cost
- Semi known price - ?
- Known total [1]
- Known discount % or $ off - ?
- Known original
Option 14 – Scenario #1:
- Tax = with tax included
- Qty = ? 364.28294 [5]
- Total = 2000
- Discount = 10% [original]
- Original price = 5.16
- Cost per = 1.50
- Original extended = 1879.70 [6]
- Cost extended = 546.42 [7]
- Price per = 5.16 – 10% = 4.644 [4]
- Price extended = 1691.73 [2]
- Discount per = 0.516 [8]
- Discount extended = 187.97 [9]
- New discount = 10% [same as original - 10]
- End goal as a total = 1800 [1]
- Total tax = 108.27 [3]
Option 14 – Scenario #2:
- Tax = with tax included
- Qty = 15.86471 [5] – price extended / price per
- Total = 844
- Discount = 15% [original]
- Original = $50
- Cost per = $2.50
- Original extended = 793.24 [6] – qty * original
- Cost extended = 39.66 [7] – qty * cost
- Price per = 42.50 [4] – original = discount
- Price extended = 674.25 [2] – new end after discount / 1.064 [with tax included]
- Discount per = 7.50 [8] – original – new price per
- Discount extended = 118.99 [9] – qty * discount per
- New discount = 15% [10] – discount extended / original extended
- End goal as a total = 717.40 [1] – goal - discount
- Total tax = 43.15 [3] – price extended * 6.4% tax
Options 14 – Scenario #3:
- Tax = with tax included
- Qty = 2.95867 [5]
- Total = 85
- Discount = 5%
- Original price = $27
- Cost per = $20
- Original extended = 79.88 [6]
- Cost extended = 59.17 [7]
- Price per = 25.65 [4]
- Price extended = 75.89 [2]
- Discount per = 1.35 [5]
- Discount extended = 3.99 [9]
- New discount = 5% [10]
- End goal as a total = 80.75 [1]
- Total tax = 4.86 [3]
[Samples with numbers & order or operations notated for each number – please see scan in photo gallery]