Question

The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera B Price: 300). The sales of these products are not independent of each other, but rather if the price of one increase, the sales of the other will increase. In economics, these two camera models are called substitutable products. The store wishes to establish a pricing policy to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model:

   N_A = 195 - 0.5P_A + 0.25P_B

   N_B = 301 + 0.07P_A - 0.5P_B

Construct a model for the total revenue and implement it on a spreadsheet. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. Vary each price from $250 to $500 in increments of $10.

Max profit occurs at Camera A price of $ .

Max profit occurs at Camera B price of $ .

Answer 1

No; Th toro doy dale tale to estimat ensVasy meta Ahop Se ct Sales odu

0กา тот Co 160

PAPB 250 260 270 28020300 31320 33034035030 37030 390400410420 430 44040460 470 480 490 00 교| 250 g6875 8H350 g9725 91010 92175 g3250 94225 95100 95875 95550 971 25 y7600 97975 98250 98425 98500 9S475 9E350 98125 97800 97375|96850 96225 95500 94675 93750 3 260 87300 88316 90232 91548 92764 93880 94895 95812 96628 97344 97960 98476 98892 99208 99424 99540 99556 99472 9928 99004 98620 98136 97552 96868 95084 952O0 4 270 87625 8182 906399199693253 94410 95467 9642497281 9803898c9599252 99709 100066 100323 100480 100537 100494 100351 100108 99765 99322 98779 98136 97393 96550 ב|2SO g7850 89448 90946 92344 93642 94840 95938 96936 g7834 98632 99330 99928 100426 100824 101122 101320 101418 101416 101314 101112 100810|10040目99906 99304 98602 97800 6 290 7975 89614 91153 92592 9391 95170 96309 97348 98287 99125 99H65 100504 1 4 100933 I00372 99711 98950 7 300 S8000 89680 91260 92740 94120 95400 5580 97660 98640 99520 100300 100980 101560 102040 102420 02700 102880 102960 102940 102820 102600 1022 01043 101482 101921 102050 102199 102238 102177 102016 101755 10139 310 87925 89646 91267 92788 9420995530 9673197872 9889399814100635 101356 101977 102498 102919 103240 103461 103582 103603 103524 103345 1 篲| 320 87750 89512 91171 92736 91198 95560 96822 97984 99016 100008100870 101632 102291 102856 103318 1036b0 103912 104 101 101166 101 128 103990 103752 10341-1 102976 102138 101800 0 330 87475 892H 90981 2584 94087 95490 95793 97996 99099 100102 R5 101SOR 102511 10114 103517 4020 10432104526 104629 10463 4535 104338 104041 103644 103147 02550 11丨 340 87100 88944 90688 92332 93876 95320 96664 97908 99052 100096 101040101884 102628 103272 1038 16104260 104604 104848 104992 105036 104980104824 104568104212 103756103200 12 350 86625 88510 90295 91980 93565 95050 9643597720 98905 99990100975 101860 102645 103330 103915 104400 104785 103070 105255 105340 105325 105210 10499 104680 104265 103750 13| 360 H6050 87979 鬄9802 91528 93154 91680 96106 97432 98658 99784 100810 101736102562 103288 103914 104440104866 105192 105118 105544 105570-1051 370 85375 8734 89209 90976 92643 94110 95677 97044 9831 99478 100545 101512 102379 103146 103813 104380 104847105214 105481 105548 105715 1ㆁ | 390 g3725 85774 S7723 呂9572 91321 92970 94519 95968 97317 98566 997 15 100764 101713 102562 103311 103960 104509 10495S 105307 105556 105705 105754 | 105703 105552 105301 104950 17 4400 2750 4340 S6H30 B8720 9051 92200 9379 9520 96670 9796 99150 101240 101230 10120 102910 360 10419 10460 15070 10536D 105550 10 8 410 81675 83805 85837 87768 89599 91330 92961 94492 959239725498485 99616 100647 101578 102409 103140 10377 104302 04733 105064 I0595 105426 105457 05383 105219 04950 19 | 420 80500 82672 s4744 86716 88588 90360 92032 93604 950陌 96448 97720 98892 99964 100936 101808102580103252 103824 104296 104668 104940 105 0 201 430 79225 81438 g3551 5561 87477 89290 91003 92616 g4129 95512 96b55 98068 991s1 100191 101107 101920 102633 103246 103759 101172 101185 101698: 10-1811 101824 104737 104550 21| 440 77850 黥104 82258 R4312 S6266 881 20 R9874 91528 g3082 945⅓ 95B90 97144 98298 99352 100306 101150101914 102568103122 103576 103930 104184|104338 104392 104346104200 22 450 76375 78670 S0865 82960 84955 S6850 88645 90340 91935 9343094825 9120 91315 98410 99405 00300 101095 101790 102385 102880 103275 1035 2 460 74800 77136 79372 81508 83544 83480 87316 89052 90688 9222493660 9499696232 97368 98404 99340 100176 100912 101548 102084 102320 102836 103092 103228 103264 103200 24| 470 73125 75502 77779 79956 82033 84010 85887 87661 H9341 9091H 92395 93772 95049 g6226 97303 98280 99157 99934 1 5 450 71350 3768 76086 78304 80422 82440 84358 86176 87894 89512 91030 92448 93766 94984 95102 97120 98038 98856 99574 100191 00710 101128 101446 10166 101782 01800 26 490 69475 71934 74293 76552 78711 80770 82729 84588 86347 88008956591024 92383 93642 94801 95860 96819 97678 98437 9909699655 100114 100473 00732 100891 100950 2/1 500 67500 70000 72400 74700 拍900 79000 81000 $2900 84700 86400 S8000 89500 90900 92200 93400 94500 95500 96400 97200 97900 98500 99000 99400 99700 99900 100000 99964 100936 101808 102380 103252 103824 104296 104668 104940 112 103184 105156 105028 10480 611 101188 101665 102012102319 10296 102573 102550