analyze the company's cost structure and provide a pricing strategy for this year. currently the firm is locked in to 450 units of advertising for the first quarter of the year but the advertising becomes a variable after that point. the owners would like recommendations for the years fourth quarter as well, factoring in the effect of the holiday season
(Quarterly data including quantity sold, own price charged, prices charged by other sellers Acme, Bezo, and Consolidated, and advertising units purchased) Quant OwnPr Revenue Costs 1st 43,682 700 500 650 200 26,209,200 17,920,273 2009 2nd 44,887 700 520 650 200 26,932,200 17,896,317 9,035,883 3rd 40.500 625 700 SAO 600 200 25,312,500 17,785,714 4th 72,800 700 490 600 300 45,500,000 22,545,000 22,955,000 2010 1st 54,957 650 700 490 565 350 35,722,050 20,759,905 14,962,145 2010 2nd 59.904 675 750 490 565 350 40,435,200 20,730,442 19,704,758 2010 3rd 56,358 695 750 490 565 400 39,168,810 20,940,783 18,228,027 2010 4th 63,704 695 750 525 565 400 44,274,280 22,650,440 21,623,840 1.st $1,765 725 750 525 500 400 37,529,625 20,723,189 2nd 40,427 725 595 525 500 350 9,789,299 3rd 40,500 700 595 525 350 28,350,000 19,585,714 4th 60,912 595 SAS 525 550 350 36,242,640 21,602,467 14,640,173 1 st 34,947 595 495 525 590 250 20,793,465 18,077,152 2,716,313 2nd 495 495 475 590 250 24,156,000 18,803,041 5,352,959 3rd 49,206 495 475 590 250 24,386,670 18,774,688 4th 38,481 600 335 475 590 250 23,088,600 18,256,079 4,832,521 1st 25,284 595 475 590 250 15,043,980 17,050,354 -2,006,374 2nd 33,915 590 250 18,483,675 17,835,951 647,724 Brd 495 29% 575 200 14,632,695 16,853,239 -2,220,544 4th 36,578 49% 575 200 18,106,110 17,610,112 495,998 64,178 350 575 200 15,462,300 17,986,208 -2,523,908 2nd 250 150 10,724,700 16,377,083 -5,652,383 3rd 37,292 375 175 13,984,500 -3,254,675 &th 400 350 350 29,108,000 23,779,969 5,328,031 56,122 460 350 350 24,693,680 20,322,128 4,371,552 2015 2nd 495 400 350 23,284,800 20,014,635 3,270,165 2015 ard 495 450 350 24,829,200 20,228,326 4,600,874 2015 4th 495 495 500 27,519,030 22,166,212 5,352,818 2016 495 500 20,854,845 21,366,481 -511,636 2nd 475 500 19,950,000 21,480,683 -1,530,683 ard 500 450 24,324,300 21,117,749 3,206,551 2010 500 450 28,518,000 22,002,197 6,515,803 2017 99,615 500 450 20,797,875 20,845,497 47,622 and 525 555 400 24,655,950 20,353,764 2017 550 400 23,152,375 20,278,754 2,873,621 2017 600 539 425 31,263,085 21,235,878 10,027,207 2018 $25 579 425 20,585,810 20,047,188 538,622 2018 and 579 425 20,673,275 20,005,546 667,729 ard 649 400 19,335,715 19,595,183 ath 450 21,489,615 20,604,615 885,000
