OnlineSales Online Sales During Buy 1 Get 1 Free Sale DateQuantityItemState 7/30/1913Old BayMD 7/30/199Original BlendOH 7/30/1928Original BlendCA 7/30/199Sea Salt and CaramelMO...

1 answer below »
here


OnlineSales Online Sales During Buy 1 Get 1 Free Sale DateQuantityItemState 7/30/1913Old BayMD 7/30/199Original BlendOH 7/30/1928Original BlendCA 7/30/199Sea Salt and CaramelMO 7/30/1921Sea Salt and CaramelNJ 7/30/199TruffleVA 7/30/1929TruffleDC 7/30/1920Original BlendAL 7/30/1917Old BayMD 7/30/1920TruffleDC 7/30/1916Sea Salt and CaramelMS 7/30/1924Original BlendNC 7/30/1914Original BlendVA 7/30/1924Old BayNJ 7/30/199Old BayNJ 7/30/1932Sea Salt and CaramelNY 7/31/1911Old BayID 7/31/1912Sea Salt and CaramelOH 7/31/1933TruffleNY 7/31/1928Original BlendAL 7/31/1917Old BayMD 7/31/1931Original BlendNC 7/31/1930Sea Salt and CaramelMS 7/31/1921Original BlendVA 7/31/1921Old BayMD 7/31/199Old BayMD 7/31/199Old BayVA 7/31/1927Original BlendWV 7/31/1913Sea Salt and CaramelCA 7/31/1911Sea Salt and CaramelMO 7/31/1916Sea Salt and CaramelMS 7/31/1934TruffleNY 7/31/1935TruffleNY 7/31/1928Original BlendOH 8/1/1926TruffleNY 8/1/1931Old BayMD 8/1/199Old BayDC 8/1/1912Sea Salt and CaramelMS 8/1/1921Sea Salt and CaramelAL 8/1/1915Sea Salt and CaramelNC 8/1/1925Original BlendAL 8/1/1916Original BlendDC 8/1/1930Original BlendNY 8/1/1917Original BlendWV 8/1/1925Original BlendOH 8/1/1922TruffleVA 8/1/1913Old BayVA 8/1/1916Sea Salt and CaramelDC 8/1/1917Old BayMD 8/1/1911Old BayWV 8/1/1920Original BlendAL 8/1/1910Original BlendSC 8/1/1916TruffleSC 8/2/1933Original BlendOH 8/2/1933Original BlendNY 8/2/1916Sea Salt and CaramelNJ 8/2/1920Sea Salt and CaramelNJ 8/2/1913Old BayNY 8/2/1924TruffleNY 8/2/1922Old BayOH 8/2/1910TruffleDC 8/2/1916Old BayCA 8/3/1925Original BlendAL 8/3/1924Original BlendMS 8/3/1934Sea Salt and CaramelOH 8/3/1911Old BayCA 8/3/1934Old BayDC 8/3/1922Original BlendCA 8/3/1929TruffleVA 8/3/1929Sea Salt and CaramelNJ 8/3/1923Sea Salt and CaramelWV 8/4/1928Old BayMD 8/4/1931Old BayDC 8/4/1934Sea Salt and CaramelNJ 8/4/1921Sea Salt and CaramelNY 8/4/1921Original BlendMD 8/4/1933Original BlendAL 8/4/1914TruffleVA 8/4/1912Old BayMD 8/4/1932Old BayMD 8/4/1920Old BayVA 8/4/199TruffleNY 8/4/1924Original BlendOH 8/4/1931Sea Salt and CaramelCA 8/4/1918Original BlendCA 8/4/1921TruffleCA 8/4/1935Old BayMD 8/4/1926Original BlendMD 8/4/1916Old BayVA 8/4/1932Original BlendVA 8/4/1932Sea Salt and CaramelMS 8/4/1922Original BlendNC 8/4/1914Original BlendWV 8/4/1923Old BayWV 8/4/1916TruffleOH 8/5/1912Old BayMD 8/5/1928TruffleOH 8/5/1921Original BlendCA 8/5/1910Original BlendMD 8/5/1917Sea Salt and CaramelVA 8/5/1924TruffleMD 8/5/1930TruffleVA 8/5/1931Sea Salt and CaramelAL 8/5/1913Old BayMD 8/5/1934Old BayWV 8/5/1911Original BlendWV 8/5/1924TruffleCA 8/5/199TruffleCA 8/5/1914TruffleMO 8/5/1916Original BlendWV 8/5/1929Sea Salt and CaramelDC 8/5/1932Old BayDC 8/5/1915Sea Salt and CaramelMD 8/5/1928Sea Salt and CaramelVA 8/5/1918TruffleAL 8/5/1935Sea Salt and CaramelMS 8/5/199Old BayNC BOGOSale2018 Online Sales During Buy 1 Get 1 Free Sale DateQuantityItemState 7/30/1821Old BayMD 7/30/1816Original BlendOH 7/30/1825Original BlendCA 7/30/1819Sea Salt and CaramelMO 7/30/1814Sea Salt and CaramelNJ 7/30/1821TruffleVA 7/30/185TruffleDC 7/30/1811Original BlendAL 7/30/1823Old BayMD 7/30/1813TruffleDC 7/30/1810Sea Salt and CaramelMS 7/30/1811Original BlendNC 7/30/186Original BlendVA 7/30/1818Old BayNJ 7/30/1818Old BayNJ 7/30/1820Sea Salt and CaramelNY 7/31/1818Old BayID 7/31/1824Sea Salt and CaramelOH 7/31/1811TruffleNY 7/31/1816Original BlendAL 7/31/1814Old BayMD 7/31/1820Original BlendNC 7/31/1814Sea Salt and CaramelMS 7/31/189Original BlendVA 7/31/1819Old BayMD 7/31/1825Old BayMD 7/31/1820Old BayVA 7/31/1815Original BlendWV 7/31/185Sea Salt and CaramelCA 7/31/187Sea Salt and CaramelMO 7/31/187Sea Salt and CaramelMS 7/31/1812TruffleNY 7/31/1811TruffleNY 7/31/186Original BlendOH 8/1/185TruffleNY 8/1/1812Old BayMD 8/1/188Old BayDC 8/1/1820Sea Salt and CaramelMS 8/1/1813Sea Salt and CaramelAL 8/1/1823Sea Salt and CaramelNC 8/1/1812Original BlendAL 8/1/189Original BlendDC 8/1/1820Original BlendNY 8/1/187Original BlendWV 8/1/1821Original BlendOH 8/1/1816TruffleVA 8/1/1814Old BayVA 8/1/1824Sea Salt and CaramelDC 8/1/1823Old BayMD 8/1/1817Old BayWV 8/1/1811Original BlendAL 8/1/1825Original BlendSC 8/1/186TruffleSC 8/2/1819Original BlendOH 8/2/1822Original BlendNY 8/2/1825Sea Salt and CaramelNJ 8/2/1813Sea Salt and CaramelNJ 8/2/1822Old BayNY 8/2/1818TruffleNY 8/2/1814Old BayOH 8/2/185TruffleDC 8/2/185Old BayCA 8/3/1810Original BlendAL 8/3/1812Original BlendMS 8/3/1811Sea Salt and CaramelOH 8/3/1822Old BayCA 8/3/1811Old BayDC 8/3/1818Original BlendCA 8/3/1822TruffleVA 8/3/1813Sea Salt and CaramelNJ 8/3/1821Sea Salt and CaramelWV 8/4/185Old BayMD 8/4/185Old BayDC 8/4/1814Sea Salt and CaramelNJ 8/4/1811Sea Salt and CaramelNY 8/4/1815Original BlendMD 8/4/186Original BlendAL 8/4/1817TruffleVA 8/4/1820Old BayMD 8/4/187Old BayMD 8/4/1817Old BayVA 8/4/1819TruffleNY 8/4/186Original BlendOH 8/4/1813Sea Salt and CaramelCA 8/4/1817Original BlendCA 8/4/1822TruffleCA 8/4/1818Old BayMD 8/4/1817Original BlendMD 8/4/1812Old BayVA 8/4/1813Original BlendVA 8/4/1821Sea Salt and CaramelMS 8/4/186Original BlendNC 8/4/1824Original BlendWV 8/4/1817Old BayWV 8/4/1818TruffleOH 8/5/1819Old BayMD 8/5/1816TruffleOH 8/5/1817Original BlendCA 8/5/1810Original BlendMD 8/5/1816Sea Salt and CaramelVA 8/5/1822TruffleMD 8/5/1816TruffleVA 8/5/1823Sea Salt and CaramelAL 8/5/1812Old BayMD 8/5/1821Old BayWV 8/5/188Original BlendWV 8/5/1822TruffleCA 8/5/187TruffleCA 8/5/1819TruffleMO 8/5/1824Original BlendWV 8/5/1812Sea Salt and CaramelDC 8/5/1822Old BayDC 8/5/1817Sea Salt and CaramelMD 8/5/187Sea Salt and CaramelVA 8/5/1813TruffleAL 8/5/1822Sea Salt and CaramelMS 8/5/1821Old BayNC TysonsStore2019 DateOld BayBlack TruffleSea Salt and CaramelDaily Total (# sold)Daily Total ($)Sales Goal Met?with Price IncreaseCurrent price per box:$6 1-Aug23983209531$ 3,186Daily sales goal:$1,500 2-Aug22518577487$ 2,922Average daily sales: 3-Aug45165156366$ 2,196Lowest daily sales: 4-Aug24093177510$ 3,060Highest daily sales: 5-Aug195215110520$ 3,120 6-Aug25133251409$ 2,454Average sales with price increase$ 2,762 7-Aug12653196375$ 2,250New price per box:$6 8-Aug26314137441$ 2,646 9-Aug26174204404$ 2,424Lookup date: 10-Aug296229120$ 720Sales goal met? 11-Aug21023898546$ 3,276 12-Aug26970273612$ 3,672 13-Aug15086224460$ 2,760 14-Aug7018955314$ 1,884 15-Aug221182240643$ 3,858 16-Aug3043206279$ 1,674 17-Aug53143259455$ 2,730 18-Aug27416927470$ 2,820 19-Aug166121101388$ 2,328 20-Aug2116669346$ 2,076 21-Aug11424072426$ 2,556 22-Aug81132267480$ 2,880 23-Aug273241194708$ 4,248 24-Aug26623342541$ 3,246 25-Aug168237273678$ 4,068 26-Aug54265255574$ 3,444 27-Aug16585189439$ 2,634 28-Aug2743855367$ 2,202 29-Aug25222188435$ 2,610 30-Aug121119245485$ 2,910 31-Aug11491257462$ 2,772 TysonsStore2018 DateOld BayBlack TruffleSea Salt and CaramelDaily Total (# sold) 8/1/184211592249 8/2/184242117201 8/3/1810512464293 8/4/181418376300 8/5/1813773109319 8/6/18684460172 8/7/188258145285 8/8/181259692313 8/9/1820263985 8/10/18673821126 8/11/18121124132377 8/12/181407625241 8/13/181477777301 8/14/188612859273 8/15/185012296268 8/16/188092139311 8/17/18416959169 8/18/182638125189 8/19/189341133267 8/20/1884144146374 8/21/1825124145294 8/22/1810760142309 8/23/18116115128359 8/24/1846129145320 8/25/184411299255 8/26/181129631239 8/27/187310297272 8/28/1810089109298 8/29/18553075160 8/30/1813711797351 8/31/181253980244
444-vwsnuiph.png 4444-lavqkztx.png 444444-30aml04m.png 444444444-4bl521xw.png zaidoon-wasulaiman-ex2019-capstone-level3-w-vlookup-zzkoi3o4.xlsx
Answered Same DayNov 24, 2021

Answer To: OnlineSales Online Sales During Buy 1 Get 1 Free Sale DateQuantityItemState 7/30/1913Old BayMD...

Shivani answered on Dec 02 2021
145 Votes
MobileSales
    Top't Corn Mobile Sales (July)
        Truck Location
        Farragut Square    GW    Georgetown    K Street
    Old Bay    $ 2,500    $ 800    $ 600    $ 900
    Truffle    $ 3,200    $ 600    $ 1,200    $ 1,500
    Sea Salt and Caramel    $ 4,200    $ 1,500    $ 1,400    $ 1,200
    Total    $ 9,900    $ 2,900    $ 3,200    $ 3,600
Old Bay    
Farragut Square    GW    Georgetown    K Street    2500    800    600    900    
July Sales by Popcorn Type
Old Bay    
Farragut Square    GW    Georgetown    K Street    2500    800    600    900    Truffle    
Farragut Square    GW    Georgetown    K Street    3200    600    1200    1500    Sea Salt and Caramel    
Farragut Square    GW    Georgetown    K Street    4200    1500    1400    1200    
TruckLoan
    Price    $55,000.00
    Interest (annual)    3%
    Loan term (in months)    24
    Monthly Payment    $2,363.97
    Total payments    Interest Paid
    $56,735.20    $1,735.20
    Average sales    $4,900.00
    Buy new truck?    Yes
OnlineSales
    Online Sales During Buy 1 Get 1 Free Sale
    Date    Quantity    Item    State
    7/30/19    13    Old Bay    MD
    7/30/19    17    Old Bay    MD
    7/30/19    24    Old Bay    NJ
    7/30/19    9    Old Bay    NJ
    7/31/19    11    Old Bay    ID
    7/31/19    17    Old Bay    MD
    7/31/19    21    Old Bay    MD
    7/31/19    9    Old Bay    MD
    7/31/19    9    Old Bay    VA
    8/1/19    31    Old Bay    MD
    8/1/19    9    Old Bay    DC
    8/1/19    13    Old Bay    VA
    8/1/19    17    Old Bay    MD
    8/1/19    11    Old Bay    WV
    8/2/19    13    Old Bay    NY
    8/2/19    22    Old Bay    OH
    8/2/19    16    Old Bay    CA
    8/3/19    11    Old Bay    CA
    8/3/19    34    Old Bay    DC
    8/4/19    28    Old Bay    MD
    8/4/19    31    Old Bay    DC
    8/4/19    12    Old Bay    MD
    8/4/19    32    Old Bay    MD
    8/4/19    20    Old Bay    VA
    8/4/19    35    Old Bay    MD
    8/4/19    16    Old Bay    VA
    8/4/19    23    Old Bay    WV
    8/5/19    12    Old Bay    MD
    8/5/19    13    Old Bay    MD
    8/5/19    34    Old Bay    WV
    8/5/19    32    Old Bay    DC
    8/5/19    9    Old Bay    NC
    7/30/19    9    Original Blend    OH
    7/30/19    28    Original Blend    CA
    7/30/19    20    Original Blend    AL
    7/30/19    24    Original Blend    NC
    7/30/19    14    Original Blend    VA
    7/31/19    28    Original Blend    AL
    7/31/19    31    Original Blend    NC
    7/31/19    21    Original Blend    VA
    7/31/19    27    Original Blend    WV
    7/31/19    28    Original Blend    OH
    8/1/19    25    Original Blend    AL
    8/1/19    16    Original Blend    DC
    8/1/19    30    Original Blend    NY
    8/1/19    17    Original Blend    WV
    8/1/19    25    Original Blend    OH
    8/1/19    20    Original Blend    AL
    8/1/19    10    Original Blend    SC
    8/2/19    33    Original Blend    OH
    8/2/19    33    Original Blend    NY
    8/3/19    25    Original Blend    AL
    8/3/19    24    Original Blend    MS
    8/3/19    22    Original Blend    CA
    8/4/19    21    Original Blend    MD
    8/4/19    33    Original Blend    AL
    8/4/19    24    Original Blend    OH
    8/4/19    18    Original Blend    CA
    8/4/19    26    Original Blend    MD
    8/4/19    32    Original Blend    VA
    8/4/19    22    Original Blend    NC
    8/4/19    14    Original Blend    WV
    8/5/19    21    Original Blend    CA
    8/5/19    10    Original Blend    MD
    8/5/19    11    Original Blend    WV
    8/5/19    16    Original Blend    WV
    7/30/19    9    Sea Salt and Caramel    MO
    7/30/19    21    Sea Salt and Caramel    NJ
    7/30/19    16    Sea Salt and Caramel    MS
    7/30/19    32    Sea Salt and Caramel    NY
    7/31/19    12    Sea Salt and Caramel    OH
    7/31/19    30    Sea Salt and Caramel    MS
    7/31/19    13    Sea Salt and Caramel    CA
    7/31/19    11    Sea Salt and Caramel    MO
    7/31/19    16    Sea Salt and Caramel    MS
    8/1/19    12    Sea Salt and Caramel    MS
    8/1/19    21    Sea Salt and Caramel    AL
    8/1/19    15    Sea Salt and Caramel    NC
    8/1/19    16    Sea Salt and Caramel    DC
    8/2/19    16    Sea Salt and Caramel    NJ
    8/2/19    20    Sea Salt and Caramel    NJ
    8/3/19    34    Sea Salt and Caramel    OH
    8/3/19    29    Sea Salt and Caramel    NJ
    8/3/19    23    Sea Salt and Caramel    WV
    8/4/19    34    Sea Salt and Caramel    NJ
    8/4/19    21    Sea Salt and Caramel    NY
    8/4/19    31    Sea Salt and Caramel    CA
    8/4/19    32    Sea Salt and Caramel    MS
    8/5/19    17    Sea Salt and Caramel    VA
    8/5/19    31    Sea Salt and Caramel    AL
    8/5/19    29    Sea Salt and Caramel    DC
    8/5/19    15    Sea Salt and Caramel    MD
    8/5/19    28    Sea Salt and Caramel    VA
    8/5/19    35    Sea Salt and Caramel    MS
    7/30/19    9    Truffle    VA
    7/30/19    29    Truffle    DC
    7/30/19    20    Truffle    DC
    7/31/19    33    Truffle    NY
    7/31/19    34    Truffle    NY
    7/31/19    35    Truffle    NY
    8/1/19    26    Truffle    NY
    8/1/19    22    Truffle    VA
    8/1/19    16    Truffle    SC
    8/2/19    24    Truffle    NY
    8/2/19    10    Truffle    DC
    8/3/19    29    Truffle    VA
    8/4/19    14    Truffle    VA
    8/4/19    9    Truffle    NY
    8/4/19    21    Truffle    CA
    8/4/19    16    Truffle    OH
    8/5/19    28    Truffle    OH
    8/5/19    24    Truffle    MD
    8/5/19    30    Truffle    VA
    8/5/19    24    Truffle    CA
    8/5/19    9    Truffle    CA
    8/5/19    14    Truffle    MO
    8/5/19    18    Truffle    AL
    Total    353
BOGOSale2018
    Online Sales During Buy 1 Get 1 Free Sale
    Date    Quantity    Item    State
    7/30/18    21    Old Bay    MD
    7/30/18    16    Original Blend    OH
    7/30/18    25    Original Blend    CA
    7/30/18    19    Sea Salt and Caramel    MO
    7/30/18    14    Sea Salt and Caramel    NJ
    7/30/18    21    Truffle    VA
    7/30/18    5    Truffle    DC
    7/30/18    11    Original Blend    AL
    7/30/18    23    Old Bay    MD
    7/30/18    13    Truffle    DC
    7/30/18    10    Sea Salt and Caramel    MS
    7/30/18    11    Original Blend    NC
    7/30/18    6    Original Blend    VA
    7/30/18    18    Old Bay    NJ
    7/30/18    18    Old Bay    NJ
    7/30/18    20    Sea...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?