AllAround Vision Care Insurance Billings in Dollars 2nd Quarter Chicago Average Rate Week 1 Week 2 Week 3 Week 4 Univers Health General 79% 10,000 12,000 12,000 12,000 Received 7,900 9,480 9,480 9,480 Microsoft Excel 9. Cook Coi 10 11 This workbook contains one or more links that cannot be updated. To change the source of links, or attempt to update values again, dick Edit Links. To leave the links as is, dick Continue. 12 Vision A Continue 14 Bill to patient Edit Links... 1,300 1,300 1,500 1,450 2016 2015 2014 2013 Sales (thousands) 15,225 $ 14,025 $ 12,375 $ 11,400 CGS (thousands) 9,835 8,948 7,846 7,205 Gross margin Percent 5,390 5,077 35.4 36.2 4,529 $ 36.6 4,195 36.8 A discussion with Madison Amberson, the controller, brings to light two possible explanations. She informs you that the industry gross profit percent in the retail drug industry declined fairly steadily for three years, which accounts for part of the decline. A second factor was the declining percent of the total volume resulting from the pharmacy part of the business. The pharmacy sales represent the most profitable portion of the business, yet the competition from discount drugstores prevents it from expanding as fast as the nondrug items such as magazines, candy, and many other items sold. Amberson feels strongly that these two factors are the cause of the decline. More Info Print Done Jonier Drugs ($ in thousands) Drug Cost of Nondrug Cost Industry Gross Profit Percent for Retailers of Drugs Drug Sales Nondrug Sales Goods Sold of Goods Sold and Related Products 2016 5,085 $ 10,140 3,010 $ 6,915 32.8 2015 5,140 8,885 2,955 6,060 32.9 2014 4,894 7,481 2,829 5,117 33.2 2013 4,788 6,612 2,758 4,529 33.4 1 New Car Loan 2 3 Sticker price 4 Trade in 5 Cash back offer 6 Loan amount 7 8 Loan term (months) 9 Loan interest (APR) 10 Loan payment 11 12 Total cost of the car 13 Loan Inputs $ +A $ +A $ +A $ 24,595 3,500 21,095 24 1.90% $ 896.46 $21,515.0