FTC.xlsx - Selling Price variable cost surplus selling Fixed Avg SD Production Trial 42 34 10 100000 60000 15000 Average Profit sd max loss Prob shrt

FTC.xlsx - Selling Price variable cost surplus selling...

This preview shows page 1 - 6 out of 104 pages.

Selling Price 42 Average Profit 201601.7 variable cost 34 sd 81539 surplus selling 10 max 220000 Fixed 100000 loss 0.029 Avg 60000 Prob shrt 0.913 SD 15000 Production 40000 Trial Production Demand sales Surplus sales rev sur rev fixed variable 1 40000 76539.772177 40000 0 1680000 0 100000 1360000 2 40000 60103.870097 40000 0 1680000 0 100000 1360000 3 40000 69947.109389 40000 0 1680000 0 100000 1360000 4 40000 58963.004139 40000 0 1680000 0 100000 1360000 5 40000 61307.736607 40000 0 1680000 0 100000 1360000 6 40000 61366.615772 40000 0 1680000 0 100000 1360000 7 40000 47776.831998 40000 0 1680000 0 100000 1360000 8 40000 64437.042016 40000 0 1680000 0 100000 1360000 9 40000 42794.505807 40000 0 1680000 0 100000 1360000 10 40000 82587.315419 40000 0 1680000 0 100000 1360000 11 40000 64370.598372 40000 0 1680000 0 100000 1360000 12 40000 40291.951385 40000 0 1680000 0 100000 1360000 13 40000 65149.939502 40000 0 1680000 0 100000 1360000 14 40000 66949.422281 40000 0 1680000 0 100000 1360000 15 40000 74128.11964 40000 0 1680000 0 100000 1360000 16 40000 73668.749942 40000 0 1680000 0 100000 1360000 17 40000 41893.214328 40000 0 1680000 0 100000 1360000 18 40000 51210.604957 40000 0 1680000 0 100000 1360000 19 40000 85619.265045 40000 0 1680000 0 100000 1360000 20 40000 83742.70155 40000 0 1680000 0 100000 1360000 21 40000 67478.298136 40000 0 1680000 0 100000 1360000 22 40000 35800.511042 35800.511042 4199.489 1503621 41994.89 100000 1360000 23 40000 65076.462197 40000 0 1680000 0 100000 1360000 24 40000 52247.375764 40000 0 1680000 0 100000 1360000 25 40000 49742.568169 40000 0 1680000 0 100000 1360000 26 40000 53931.464441 40000 0 1680000 0 100000 1360000 27 40000 58845.465479 40000 0 1680000 0 100000 1360000 28 40000 72232.922548 40000 0 1680000 0 100000 1360000 29 40000 33185.433481 33185.433481 6814.567 1393788 68145.67 100000 1360000 30 40000 69820.042643 40000 0 1680000 0 100000 1360000 31 40000 46861.497733 40000 0 1680000 0 100000 1360000 32 40000 60688.942628 40000 0 1680000 0 100000 1360000
Image of page 1
33 40000 56980.46406 40000 0 1680000 0 100000 1360000 34 40000 39040.813916 39040.813916 959.1861 1639714 9591.861 100000 1360000 35 40000 47829.597993 40000 0 1680000 0 100000 1360000 36 40000 68075.894201 40000 0 1680000 0 100000 1360000 37 40000 74867.574235 40000 0 1680000 0 100000 1360000 38 40000 62217.249548 40000 0 1680000 0 100000 1360000 39 40000 21905.21875 21905.21875 18094.78 920019.2 180947.8 100000 1360000 40 40000 62110.742383 40000 0 1680000 0 100000 1360000 41 40000 57948.70162 40000 0 1680000 0 100000 1360000 42 40000 62215.670127 40000 0 1680000 0 100000 1360000 43 40000 51398.825285 40000 0 1680000 0 100000 1360000 44 40000 63888.305691 40000 0 1680000 0 100000 1360000 45 40000 61977.624727 40000 0 1680000 0 100000 1360000 46 40000 81336.140687 40000 0 1680000 0 100000 1360000 47 40000 33694.385816 33694.385816 6305.614 1415164 63056.14 100000 1360000 48 40000 63682.15692 40000 0 1680000 0 100000 1360000 49 40000 46140.932436 40000 0 1680000 0 100000 1360000 50 40000 66713.959477 40000 0 1680000 0 100000 1360000 51 40000 76991.695267 40000 0 1680000 0 100000 1360000 52 40000 68838.411475 40000 0 1680000 0 100000 1360000 53 40000 74840.98895 40000 0 1680000 0 100000 1360000 54 40000 25692.174107 25692.174107 14307.83 1079071 143078.3 100000 1360000 55 40000 79169.237607 40000 0 1680000 0 100000 1360000 56 40000 48256.629311 40000 0 1680000 0 100000 1360000 57 40000 72567.912393 40000 0 1680000 0 100000 1360000 58 40000 83362.43477 40000 0 1680000 0 100000 1360000 59 40000 33628.668949 33628.668949 6371.331 1412404 63713.31 100000 1360000 60 40000 55009.750137 40000 0 1680000 0 100000 1360000 61 40000 62497.629861 40000 0 1680000 0 100000 1360000 62 40000 89604.175562 40000 0 1680000 0 100000 1360000 63 40000 54822.258006 40000 0 1680000 0 100000 1360000 64 40000 59583.870684 40000 0 1680000 0 100000 1360000 65 40000 34482.314794 34482.314794 5517.685 1448257 55176.85 100000 1360000 66 40000 61523.133495 40000 0 1680000 0 100000 1360000 67 40000 45118.452095 40000 0 1680000 0 100000 1360000 68 40000 81327.171744 40000 0 1680000 0 100000 1360000 69 40000 48937.941024 40000 0 1680000 0 100000 1360000 70 40000 44625.898547 40000 0 1680000 0 100000 1360000 71 40000 59056.430725 40000 0 1680000 0 100000 1360000 72 40000 63437.550697 40000 0 1680000 0 100000 1360000 73 40000 56687.685784 40000 0 1680000 0 100000 1360000 74 40000 58605.074841 40000 0 1680000 0 100000 1360000 75 40000 66941.181382 40000 0 1680000 0 100000 1360000 76 40000 40012.179267 40000 0 1680000 0 100000 1360000 77 40000 57520.24025 40000 0 1680000 0 100000 1360000
Image of page 2
78 40000 35278.299349 35278.299349 4721.701 1481689 47217.01 100000 1360000 79 40000 51856.154244 40000 0 1680000 0 100000 1360000 80 40000 58911.544852 40000 0 1680000 0 100000 1360000 81 40000 58527.860724 40000 0 1680000 0 100000 1360000 82 40000 63334.478205 40000 0 1680000 0 100000 1360000 83 40000 47409.764744 40000 0 1680000 0 100000 1360000 84 40000 54431.166047 40000 0 1680000 0 100000 1360000 85 40000 55130.116063 40000 0 1680000 0 100000 1360000 86 40000 78864.126118 40000 0 1680000 0 100000 1360000 87 40000 74404.694447 40000 0 1680000 0 100000 1360000 88 40000 67618.295361 40000 0 1680000 0 100000 1360000 89 40000 44052.977038 40000 0 1680000 0 100000 1360000 90 40000 83321.962759 40000 0 1680000 0 100000 1360000 91 40000 52322.950946 40000 0 1680000 0 100000 1360000 92 40000 89650.160892 40000 0 1680000 0 100000 1360000 93 40000 24753.881888 24753.881888 15246.12 1039663 152461.2 100000 1360000 94 40000 58281.242126 40000 0 1680000 0 100000 1360000 95 40000 55540.341267 40000 0 1680000 0 100000 1360000 96 40000 57395.413848 40000 0 1680000 0 100000 1360000 97 40000 39305.682168 39305.682168 694.3178 1650839 6943.178 100000 1360000 98 40000 63303.925624 40000 0 1680000 0 100000 1360000 99 40000 48998.725177 40000 0 1680000 0 100000 1360000 100 40000 34376.929729 34376.929729 5623.07 1443831 56230.7 100000 1360000 101 40000 65611.728218 40000 0 1680000 0 100000 1360000 102 40000 88065.595709 40000 0 1680000 0 100000 1360000 103 40000 42315.046434 40000 0 1680000 0 100000 1360000 104 40000 69869.559752 40000 0 1680000 0 100000 1360000 105 40000 17716.691022 17716.691022 22283.31 744101 222833.1 100000 1360000 106 40000 49401.065693 40000 0 1680000 0 100000 1360000 107 40000 59254.028918 40000 0 1680000 0 100000 1360000 108 40000 47006.860839 40000 0 1680000 0 100000 1360000 109 40000 56398.076179 40000 0 1680000 0 100000 1360000 110 40000 64948.845216 40000 0 1680000 0 100000 1360000 111 40000 78039.219226 40000 0 1680000 0 100000 1360000 112 40000 45415.480873 40000 0 1680000 0 100000 1360000 113 40000 52858.232055 40000 0 1680000 0 100000 1360000 114 40000 44443.544823 40000 0 1680000 0 100000 1360000 115 40000 71940.949027 40000 0 1680000 0 100000 1360000 116 40000 53344.025431 40000 0 1680000 0 100000 1360000 117 40000 63576.762944 40000 0 1680000 0 100000 1360000 118 40000 81593.781905 40000 0 1680000 0 100000 1360000 119 40000 75239.436263 40000 0 1680000 0 100000 1360000 120 40000 60993.07158 40000 0 1680000 0 100000 1360000 121 40000 93582.851423 40000 0 1680000 0 100000 1360000 122 40000 68570.346034 40000 0 1680000 0 100000 1360000
Image of page 3
123 40000 74691.250732 40000 0 1680000 0 100000 1360000 124 40000 41625.140211 40000 0 1680000 0 100000 1360000 125 40000 67584.538968 40000 0 1680000 0 100000 1360000 126 40000 37065.045366 37065.045366 2934.955 1556732 29349.55 100000 1360000 127 40000 46723.476525 40000 0 1680000 0 100000 1360000 128 40000 79840.356497 40000 0 1680000 0 100000 1360000 129 40000 68797.570594 40000 0 1680000 0 100000 1360000 130 40000 89017.65653 40000 0 1680000 0 100000 1360000 131 40000 47493.737207 40000 0 1680000 0 100000 1360000 132 40000 79266.108089 40000 0 1680000 0 100000 1360000 133 40000 45133.331884 40000 0 1680000 0 100000 1360000 134 40000 64354.302285 40000 0 1680000 0 100000 1360000 135 40000 58881.035223 40000 0 1680000 0 100000 1360000 136 40000 61881.502031 40000 0 1680000 0 100000 1360000 137 40000 56590.469046 40000 0 1680000 0 100000 1360000 138 40000 51722.969895 40000 0 1680000 0 100000 1360000 139 40000 44009.152744 40000 0 1680000 0 100000 1360000 140 40000 85696.334475 40000 0 1680000 0 100000 1360000 141 40000 59819.037169 40000 0 1680000 0 100000 1360000 142 40000 58085.382108 40000 0 1680000 0 100000 1360000 143 40000 52739.095551 40000 0 1680000 0 100000 1360000 144 40000 49821.329034 40000 0 1680000 0 100000 1360000 145 40000 59498.209499 40000 0 1680000 0 100000 1360000 146 40000 57246.531417 40000 0 1680000 0 100000 1360000 147 40000 77966.0957 40000 0 1680000 0 100000 1360000 148 40000 56790.996219 40000 0 1680000 0 100000 1360000 149 40000 59353.165517 40000 0 1680000 0 100000 1360000 150 40000 62151.41762 40000 0 1680000 0 100000 1360000 151 40000 39927.924288 39927.924288 72.07571 1676973 720.7571 100000 1360000 152 40000 72110.143989 40000 0 1680000 0 100000 1360000 153 40000 47886.48083 40000 0 1680000 0 100000 1360000 154 40000 56344.797596 40000 0 1680000 0 100000 1360000 155 40000 42922.446584 40000 0 1680000 0 100000 1360000 156 40000 56685.963873 40000 0 1680000 0 100000 1360000 157 40000 49673.518434 40000 0 1680000 0 100000 1360000 158 40000 49126.56185 40000 0 1680000 0 100000 1360000 159 40000 63449.352985 40000 0 1680000 0 100000 1360000 160 40000 70560.376011 40000 0 1680000 0 100000 1360000 161 40000 76868.245789 40000 0 1680000 0 100000 1360000 162 40000 79008.623936 40000 0 1680000 0 100000 1360000 163 40000 41345.62314 40000 0 1680000 0 100000 1360000 164 40000 71180.605638 40000 0 1680000 0 100000 1360000 165 40000 84180.271988 40000 0 1680000 0 100000 1360000 166 40000 66144.041994 40000 0 1680000 0 100000 1360000 167 40000 54852.986765 40000 0 1680000 0 100000 1360000
Image of page 4
168 40000 86443.746096 40000 0 1680000 0 100000 1360000 169 40000 43656.63732 40000 0 1680000 0 100000 1360000 170 40000 52643.580211 40000 0 1680000 0 100000 1360000 171 40000 55556.023231 40000 0 1680000 0 100000 1360000 172 40000 45574.845461 40000 0 1680000 0 100000 1360000 173 40000 59403.170555 40000 0 1680000 0 100000 1360000 174 40000 71996.359082 40000 0 1680000 0 100000 1360000 175 40000 65812.201607 40000 0 1680000 0 100000 1360000 176 40000 64462.04717 40000 0 1680000 0 100000 1360000 177 40000 33679.354229 33679.354229 6320.646 1414533 63206.46 100000 1360000 178 40000 98548.353462 40000 0 1680000 0 100000 1360000 179 40000 56757.343784 40000 0 1680000 0 100000 1360000 180 40000 71546.301329 40000 0 1680000 0 100000 1360000 181 40000 42373.813002 40000 0 1680000 0 100000 1360000 182 40000 60122.489731 40000 0 1680000 0 100000 1360000 183 40000 49565.783127 40000 0 1680000 0 100000 1360000 184 40000 83243.063321 40000 0 1680000 0 100000 1360000 185 40000 74320.549795 40000 0 1680000 0 100000 1360000 186 40000 61815.207032 40000 0 1680000 0 100000 1360000 187 40000 48259.999253 40000 0 1680000 0 100000 1360000 188 40000 44874.705873 40000 0 1680000 0 100000 1360000 189 40000 45227.712482 40000 0 1680000 0 100000 1360000 190 40000 42815.110596 40000 0 1680000 0 100000 1360000 191 40000 57527.43755 40000 0 1680000 0 100000 1360000 192 40000 69833.799969 40000 0 1680000 0 100000 1360000 193 40000 54328.33567 40000 0 1680000 0 100000 1360000 194 40000 57875.127087 40000 0 1680000 0 100000 1360000 195 40000 85491.172602 40000 0 1680000 0 100000 1360000 196 40000 44821.215323
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 104 pages?

  • Spring '13
  • MelanieRaby

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes