Ch14+Homework

Year Quarter Winery Appellation Cost Per Case Cases Sold Sales 1991 Q1 Beaulieu Cabernet Sauvignon $165 450 1991 Q2 Beaulieu Cabernet Sauvignon $165 550 1991 Q3 Beaulieu Cabernet Sauvignon $165 575 1991 Q4 Beaulieu Cabernet Sauvignon $165 650 1992 Q1 Beaulieu Cabernet Sauvignon $165 310 1992 Q2 Beaulieu Cabernet Sauvignon $165 625 1992 Q2 Beaulieu Cabernet Sauvignon $165 314 1992 Q4 Beaulieu Cabernet Sauvignon $165 670 1991 Q1 Beaulieu Chardonnay $163 230 1991 Q2 Beaulieu Chardonnay $163 425 1991 Q3 Beaulieu Chardonnay $163 460 1991 Q4 Beaulieu Chardonnay $163 450 1992 Q1 Beaulieu Chardonnay $163 170 1992 Q1 Beaulieu Chardonnay $163 230 1992 Q2 Beaulieu Chardonnay $163 175 1992 Q2 Beaulieu Chardonnay $163 232 1992 Q3 Beaulieu Chardonnay $163 208 1992 Q3 Beaulieu Chardonnay $163 180 1992 Q3 Beaulieu Chardonnay $163 219 1992 Q4 Beaulieu Chardonnay $163 220 1992 Q4 Beaulieu Chardonnay $163 175 1992 Q4 Beaulieu Chardonnay $163 225 1991 Q1 Beaulieu Merlot $160 180 1991 Q1 Beaulieu Merlot $160 320 1991 Q2 Beaulieu Merlot $160 325 1991 Q2 Beaulieu Merlot $160 190 1991 Q3 Beaulieu Merlot $160 195 1991 Q4 Beaulieu Merlot $160 200 1991 Q1 Duckhorn Merlot $148 275 1991 Q2 Duckhorn Merlot $148 660 1991 Q2 Duckhorn Merlot $148 481 1991 Q2 Duckhorn Merlot $148 280 1991 Q3 Duckhorn Merlot $148 485 1991 Q4 Duckhorn Merlot $148 499 Total

Discount Net 26.50% 30% Directions Determine the Sales amounts by multiplying the cost per case times the cases sold. If the cost per case is greater than or equal to $160, the Disco is 26.5% (cell K3) times the sale. Otherwise the Discount is 30 (cell K4) times sales . Be sure to use an absolute reference in t formula (for K3 and K4) Determine the Net by subtracting the discount from the Sales Determine the Totals fo the columns F, G, H and I.