Asked by …
For each item on the person’s list:
1. Screenshot the webpage.
A. Screenshot should include the price before tax, image of product, and information about how much shipping costs are. You might need a separate picture that shows the shipping cost.
2. Highlight the least expensive one (with shipping cost included).
3. Add the tax to the cost.
4. Write the total cost for each item (item cost+shipping+tax = Final Prices
All Answers 1
Answered by
GPT-5 mini
AI
I can’t browse the web or take screenshots for you, but I can (A) walk you through exactly how to capture and annotate the screenshots yourself and compute totals, or (B) compute totals and tell you which is cheapest if you paste the item names/URLs, the displayed price(s), the shipping cost(s), your tax rate, and whether shipping is taxable in your jurisdiction. Which do you want?
Below are clear, actionable instructions and templates so you can finish the task quickly.
1) What I need from you if you want me to compute totals
- For each item: product page URL (or item name), the price shown (before tax), the shipping cost, and the currency.
- Your sales tax rate (as a percent), and whether shipping is taxable where you are (Yes/No).
If you paste that, I’ll compute tax and final totals and tell you which is least expensive.
2) How to take the required screenshots (so each screenshot contains price before tax, product image, and shipping)
- Open the product page in desktop browser.
- Make sure the page shows:
- The listed price (explicitly “price before tax” if possible),
- The product image,
- Shipping cost or a shipping info link/button.
- If the shipping cost is not visible on the main product page (e.g., appears in cart or in a shipping modal), capture two screenshots:
- Screenshot A: product image + price (main product page).
- Screenshot B: shipping cost (cart/checkout/shipping modal) — include whatever identifies the product or page (title or SKU).
- Tools:
- Windows: Snipping Tool / Snip & Sketch — drag to capture, save PNG.
- Mac: Shift-Command-4 to capture selected area; open in Preview for simple markup.
- Chrome: Right-click → Inspect → Toggle device toolbar (if needed) to resize view; or use built-in screenshot in Developer Tools.
- Mobile: standard device screenshot (power+volume or Home+power depending on model).
- Include date/time in the screenshot if you want proof of when price/shipping were checked (open a timestamped area, or take screenshot of browser address bar and visible OS clock).
3) How to annotate/highlight the least expensive one
- After you compute totals:
- Choose the screenshot of the cheapest item.
- Open the screenshot in any image editor (Windows Paint, Snip & Sketch, Mac Preview, or online editors like Pixlr, Canva).
- Add a bold border or rectangle around the price area and shipping line, and insert text “Lowest total = $X.XX” in a large contrasting color (red/yellow).
- Save a copy as e.g., “01_ProductName_lowest.png”.
- If you want a single combined image: make a collage of the product screenshots and add a highlight on the cheapest one.
4) How to calculate tax and final total (spreadsheet-ready)
- Columns you should use:
- A: Item name
- B: Item price (before tax)
- C: Shipping cost
- D: Tax rate (%) — e.g., 8.25
- E: Is shipping taxable? (Yes/No)
- F: Tax amount
- G: Final total (Item + Shipping + Tax)
- Example formulas (Excel / Google Sheets). Put numeric values in row 2:
- If shipping is taxable when E2="Yes":
- F2 (Tax amount) = IF(E2="Yes", (B2 + C2) * (D2/100), B2 * (D2/100))
- G2 (Final total) = B2 + C2 + F2
- If you prefer one formula for G2 only:
- G2 = B2 + C2 + IF(E2="Yes", (B2 + C2) * (D2/100), B2 * (D2/100))
- Rounding to 2 decimals:
- Use ROUND(...,2): e.g., =ROUND(IF(E2="Yes", (B2+C2)*(D2/100), B2*(D2/100)), 2)
- And for total: =ROUND(B2 + C2 + F2, 2) or wrap G2 formula in ROUND(...,2).
5) Example calculation
- Item price = $50.00, Shipping = $6.50, Tax rate = 8.25%, Shipping taxable = No
- Tax = $50.00 * 0.0825 = $4.13
- Final total = 50.00 + 6.50 + 4.13 = $60.63
- If shipping taxable = Yes:
- Tax = (50.00 + 6.50) * 0.0825 = $4.53
- Final total = 50.00 + 6.50 + 4.53 = $61.03
6) File naming and delivery suggestions
- Name each screenshot: NN_ShortName_price_shipping.png (e.g., 01_AnkerPowerBank_$29.99_$4.99.png).
- Create a spreadsheet with the formulas above and attach the images to the spreadsheet or a zip file for delivery.
- In your final deliverable, include one annotated screenshot (or highlight) that indicates which item is the least expensive (with shipping and tax included), and list each item’s breakdown (item, shipping, tax, total).
If you want, paste the item list or the URLs and tax info here and I will compute each item’s tax and final total and indicate which is least expensive. I can also produce the spreadsheet formulas for you filled with your data.
Below are clear, actionable instructions and templates so you can finish the task quickly.
1) What I need from you if you want me to compute totals
- For each item: product page URL (or item name), the price shown (before tax), the shipping cost, and the currency.
- Your sales tax rate (as a percent), and whether shipping is taxable where you are (Yes/No).
If you paste that, I’ll compute tax and final totals and tell you which is least expensive.
2) How to take the required screenshots (so each screenshot contains price before tax, product image, and shipping)
- Open the product page in desktop browser.
- Make sure the page shows:
- The listed price (explicitly “price before tax” if possible),
- The product image,
- Shipping cost or a shipping info link/button.
- If the shipping cost is not visible on the main product page (e.g., appears in cart or in a shipping modal), capture two screenshots:
- Screenshot A: product image + price (main product page).
- Screenshot B: shipping cost (cart/checkout/shipping modal) — include whatever identifies the product or page (title or SKU).
- Tools:
- Windows: Snipping Tool / Snip & Sketch — drag to capture, save PNG.
- Mac: Shift-Command-4 to capture selected area; open in Preview for simple markup.
- Chrome: Right-click → Inspect → Toggle device toolbar (if needed) to resize view; or use built-in screenshot in Developer Tools.
- Mobile: standard device screenshot (power+volume or Home+power depending on model).
- Include date/time in the screenshot if you want proof of when price/shipping were checked (open a timestamped area, or take screenshot of browser address bar and visible OS clock).
3) How to annotate/highlight the least expensive one
- After you compute totals:
- Choose the screenshot of the cheapest item.
- Open the screenshot in any image editor (Windows Paint, Snip & Sketch, Mac Preview, or online editors like Pixlr, Canva).
- Add a bold border or rectangle around the price area and shipping line, and insert text “Lowest total = $X.XX” in a large contrasting color (red/yellow).
- Save a copy as e.g., “01_ProductName_lowest.png”.
- If you want a single combined image: make a collage of the product screenshots and add a highlight on the cheapest one.
4) How to calculate tax and final total (spreadsheet-ready)
- Columns you should use:
- A: Item name
- B: Item price (before tax)
- C: Shipping cost
- D: Tax rate (%) — e.g., 8.25
- E: Is shipping taxable? (Yes/No)
- F: Tax amount
- G: Final total (Item + Shipping + Tax)
- Example formulas (Excel / Google Sheets). Put numeric values in row 2:
- If shipping is taxable when E2="Yes":
- F2 (Tax amount) = IF(E2="Yes", (B2 + C2) * (D2/100), B2 * (D2/100))
- G2 (Final total) = B2 + C2 + F2
- If you prefer one formula for G2 only:
- G2 = B2 + C2 + IF(E2="Yes", (B2 + C2) * (D2/100), B2 * (D2/100))
- Rounding to 2 decimals:
- Use ROUND(...,2): e.g., =ROUND(IF(E2="Yes", (B2+C2)*(D2/100), B2*(D2/100)), 2)
- And for total: =ROUND(B2 + C2 + F2, 2) or wrap G2 formula in ROUND(...,2).
5) Example calculation
- Item price = $50.00, Shipping = $6.50, Tax rate = 8.25%, Shipping taxable = No
- Tax = $50.00 * 0.0825 = $4.13
- Final total = 50.00 + 6.50 + 4.13 = $60.63
- If shipping taxable = Yes:
- Tax = (50.00 + 6.50) * 0.0825 = $4.53
- Final total = 50.00 + 6.50 + 4.53 = $61.03
6) File naming and delivery suggestions
- Name each screenshot: NN_ShortName_price_shipping.png (e.g., 01_AnkerPowerBank_$29.99_$4.99.png).
- Create a spreadsheet with the formulas above and attach the images to the spreadsheet or a zip file for delivery.
- In your final deliverable, include one annotated screenshot (or highlight) that indicates which item is the least expensive (with shipping and tax included), and list each item’s breakdown (item, shipping, tax, total).
If you want, paste the item list or the URLs and tax info here and I will compute each item’s tax and final total and indicate which is least expensive. I can also produce the spreadsheet formulas for you filled with your data.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.