Answered step by step
Verified Expert Solution
Question
1 Approved Answer
which formulas can I use to solve the parts that are in yellow? (plz include comete formula) D B C 3220 Ave. Profit Total Profit
which formulas can I use to solve the parts that are in yellow? (plz include comete formula)
D B C 3220 Ave. Profit Total Profit G H 1 Product No. 2 Sales Price 3 $18.99 4 $22.99 5 6 7 Number of Unsold Products = 8 9 10 11 12 13 14 15 16 17 18 19 20 G H B D E 1 Daily Fixed Cost Total Revenue Variable Cost Fixed Cost Profit/LOSS 2 $419,080.53 $0.00 $0.00 $119,080.53 3 4 5 6 7 8 9 10 11 12 13 4 5 6 7 + 3 H Retail Price Size Volume Invoice Price Quantity Sold Cost of Goods Sold 14.99 750ml 750 $9.86 0.99 50ml 50 $0.71 8.99 750ml 750 $6,03 10.99 1500ml 1500 $7.53 12.99 750ml 750 $8.96 1 Product No Description 28 26403 Mouton Cadet Ryder Cup Red 29 3904 Svedka Cucumber Lime Vodka 30 19790 Anderra Carmenere 31 12258 Rex Goliath Cab Svgn Free R 32 26684 Mark West Pnt Grigio CA 33 34 35 36 37 38 39 30 51 2 age Celes- Coronel Form Cell Formatting - Syles Dosad 09 Font format Sort Fud FW Algiant Date An M ni VLOOKUP, US102PurchaseinvoicePrice $A$:$75433.6FALSE) 0 1. Store Product No Description 1 201 Svedka Citron Vodka 4 1 261 Svedka Citron Vodka 1 261 Svedka Citron Vodka 1 261 Svedka Citron Vodka 7 1 261 Svedka Citron Vodka 1 261 Svedka Citron Vodka 1 261 Svedka Citron Vodka 30 1 261 Svedka Citron Vodka 11 1 536 seda Cherry Vodka 12 1 536 Svedka Cherry Vodka 13 1 536 Svedka Cherry Vodka 14 1 536 Svedka Cherry Vodka 1 536 Svedka Cheery Vodka 6 1 536 Svedra cherry Vodka 1 693 Svedka Vanilla Vodka 1 63 Svedka Vanilla Vodka 1 693 Svedka Vanilla Vodka O 1 693 Svedka Vanilla Vodka 1 1 693 Svedka Vanilla Vodka cond Part Parts Part D G H Size Salesuantity SalesDollars Sales Price SalesDate Volume ExcheTax City M NE uter Location 1 Purchase Wort 12.99 12.99 7/11/2015 1000 LAS HARDERSFIELD HARDERSFELD uiter 38.97 12.39 7/17/2015 1000 3.15 HARDERSFIELD HARDERSFIELD Uter 3. 2 25.98 12.99 8/19/2015 1000 2.1 HARDERSFIELD HARDERSFIELD uter 1 12.99 12.9 W/2015 1000 1.05 HARDERSHID HADERSHID Lite 2 25.98 12,99 10/1/2015 1000 2.1 HARDERSFIELD HANDELSRIDHI . ute 1 12.5 12.9 1/22/2016 1000 1.05 HARDERSFIELD HARDERSHID 19 Liter 2 25. 12.99 4/21/2016 1000 21 HARDERSFIELD HARDERSVELD 999 Liter 1 12.99 12.99 6/6/2016 1000 1.05 HANDHELD HARDERSFIELD uter 1 12. 12.93 7/17/2015 1000 1.05 HARDERSHID HARDERSFIELD 9.90 uter 1 12.99 12. 1/2/2015 1000 1.09 HARDERSFIELD HARDERSVELD uiter 2 25. 12.99 2015 1000 2.1 HARDERSFIELD HARDERSFIELD 9.90 uiter 2 25.98 12. W19/2015 1000 2. HARDERSFIELD HARDESHIDR Liter 1 12.99 12.91 W38/2015 1000 1.05 BURDERSFIELD HARDERSFIELD ter 1 12.99 12.09 4/21/2015 1000 1.05 HARDERSFIELD HARDSHIELD N1 1992 Liter 2 25. 12.97/17/2015 1000 21 HURDERSFIELD HARDERSFIELD 135 uter 1 12. 12.9 1/25/2015 1000 1.05 HARDERSFIED HARDERSFIELD 9.35 uiter 2 12.910/8/2015 1000 2.1 HARDERSFIELD HARDERSFIELD Liter 1 12,99 10/10/2015 1000 1.05 HARDERSFIELD HARCHERSIELD Uiter 1 12.99 10/12/2015 1000 1.05 HARDERSFIELD HARDERSFIELD ww URTE MARTELL BUS102 Sales Data -Purchase ocence Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started