Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I cannot figure out questions 17.03, 17.06, and 17.07. 17.03: How many cans of soda must be sold each year to breakeven? (Round up to
I cannot figure out questions 17.03, 17.06, and 17.07.
17.03: How many cans of soda must be sold each year to breakeven? (Round up to zero places, ###,### cans)
17.06: If the time value of money is 12% per year what is the net present value? Use the tables on page 18 (the table provided).
17.07: What is the internal rate of return. Pick the closest interest rate from the tables on page 18 (the table provided).
Big Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that a cold soda machine would be appreciated by his workers, and an appreciated worker is a good worker. He has priced a machine at a national member only warehouse for $1,950. The machine should be usable for 6 years, after which it would be inefficient, obsolete and would have to be disposed of at the dump. Big Al believes that 7 cans a day will be purchased. The plant is open five days a week, 50 weeks per year. A case of soda (24 cans) costs $6.00 and Big Al believes that a price of $.70 per can would win him good will. What is the estimated annual sales in cans of soda? 1,750 cans (17.01) What is the contribution margin per can of soda? (rounded to two places, $#.##). 0.45 {17.02) How many cans of soda must be sold each year to breakeven? (Round up to zero places, ### ### cans) {17.03} Annual incremental cash inflows from the soda machine? (rounded to two places, $#.##) 787.50 {17.04) What is the payback period in years? (rounded to two places, #.## years) 2.48 years {17.05) If the time value of money is 12% per year what is the net present value? Use the tables on page 18 {17.06) What is the intemal rate of retum. Pick the closest interest rate from the tables on page 18. {17.07} Interest Periods Interest Periods Rate 2.0% 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% 5.5% 6.0% 6.5% 7.0% 7.5% 8.0% 8.5% 9.0% 9.5% 10.0% 10.5% 11.0% 11.5% 12.0% 12.5% 13.0% 13.5% 14.0% 14.5% 15.0% 15.5% 16.0% 16.5% 17.0% 17.5% 18.0% 18.5% 19.0% 19.5% 20.0% 20.5% 2.884 2.856 2.829 2.802 2.775 2.749 2.723 2.698 2.673 2.648 2.624 2.601 2.577 2.554 2.531 2.509 2.487 2.465 2.444 2.423 2.402 2.381 2.361 2.341 2.322 2.302 2.283 2.264 2.246 2.228 2.210 2.192 2.174 2.157 2.140 2.123 2.106 2.090 3.808 3.762 3.717 3.673 3.630 3.588 3.546 3.505 3.465 3.426 3.387 3.349 3.312 3.276 3.240 3.204 3.170 3.136 3.102 3.070 3.037 3.006 2.974 2.944 2.914 2.884 2.855 2.826 2.798 2.770 2.743 2.716 2.690 2.664 2.639 2.613 2.589 2.564 4.713 4.646 4.580 4.515 4.452 4.390 4.329 4.270 4.212 4.156 4.100 4.046 3.993 3.941 3.890 3.840 3.791 3.743 3.696 3.650 3.605 3.561 3.517 3.475 3.433 3.392 3.352 3.313 3.274 3.236 3.199 3.163 3.127 3.092 3.058 3.024 2.991 2.958 5.601 5.508 5.417 5.329 5.242 5.158 5.076 4.996 4.917 4.841 4.767 4.694 4.623 4.554 4.486 4.420 4.355 4.292 4.231 4.170 4.111 4.054 3.998 3.943 3.889 3.836 3.784 3.734 3.685 3.636 3.589 3.543 3.498 3.453 3.410 3.367 3.326 3.285 Rate 50.5% 51.0% 51.5% 52.0% 52.5% 53.0% 53.5% 54.0% 54.5% 55.0% 55.5% 56.0% 56.5% 57.0% 57.5% 58.0% 58.5% 59.0% 59.5% 60.0% 60.5% 61.0% 61.5% 62.0% 62.5% 63.0% 63.5% 64.0% 64.5% 65.0% 65.5% 66.0% 66.5% 67.0% 67.5% 68.0% 68.5% 69.0% 1.399 1.391 1.383 1.375 1.368 1.360 1.352 1.345 1.337 1.330 1.323 1.315 1.308 1.301 1.294 1.287 1.280 1.273 1.266 1.260 1.253 1.247 1.240 1.234 1.227 1.221 1.214 1.208 1.202 1.196 1.190 1.184 1.178 1.172 1.166 1.160 1.155 1.149 1.594 1.584 1.573 1.563 1.553 1.542 1.532 1.523 1.513 1.503 1.494 1.484 1.475 1.466 1.457 1.447 1.439 1.430 1.421 1.412 1.404 1.395 1.387 1.379 1.371 1.362 1.354 1.347 1.339 1.331 1.323 1.316 1.308 1.301 1.293 1.286 1.279 1.272 1.724 1.711 1.698 1.686 1.674 1.662 1.650 1.638 1.626 1.615 1.604 1.592 1.581 1.570 1.560 1.549 1.539 1.528 1.518 1.508 1.498 1.488 1.478 1.468 1.459 1.449 1.440 1.431 1.422 1.413 1.404 1.395 1.386 1.378 1.369 1.361 1.352 1.344 1.810 1.795 1.781 1.767 1.753 1.740 1.726 1.713 1.700 1.687 1.674 1.662 1.649 1.637 1.625 1.613 1.602 1.590 1.579 1.567 1.556 1.545 1.534 1.524 1.513 1.503 1.492 1.482 1.472 1.462 1.452 1.443 1.433 1.424 1.414 1.405 1.396 1.387 21.0% 21.5% 22.0% 22.5% 23.0% 23.5% 24.0% 24.5% 25.0% 25.5% 26.0%|| | 26.5% 27.0% 27.5% 28.0%) 28.5% 29.0% 29.5% 30.0% 30.5% 31.0% 31.5% 32.0% 32.5%|| 33.0% 33.5% 34.0% 34.5% 35.0% 35.5% 36.0%|| 36.5% 37.0% 37.5% 38.0% 38.5%) 39.0% 39.5% | 40.0% 40.5% 41.0% 41.5% 2.0741 2.540 | 2.926] 3.245 2.058 2.5171 2.895] 3.205 2.042 | 2.494 | 2.864) 3.167 2.027] 2.47112.8331 3.129 2.011 | 2.448 | 2.803] 3.092 1.996] 2.426] 2.774| 3.056 1.981 | 2.404 | 2.7451 13.020 1.9671 2.383 | 2.7171 2.986 1952 | 2.362 | 2.689 2.951 1.9381 2.341] 2.662 2.918 1.923 | 2.320 | 2.635 2.885 1.909] 2.300 1 2.609 | 2.853 1.896 | 2.280) 2.583 2.821 1.88212.260 12.55712.7901 1.868] 2.24112.53212.7591 1.8551 2.222 | 2.5071 2.729 1.842 2.203 | 2.483 2.700 | 1.829 2.185 2.459 | 2.671 1.81612.1661 2.436] 2.643 1.803 2.148 2.412 2.615 1.791 2.130 2.390 2.588 1.779 12.113| 2.367 | 2.561 | 1.766 | 2.096 | 2.345] 2.534 1.754) 2.079 | 2.324] 2.508 1.742| 2.062] 2.302 2.483 1.730] 2.04512.2811 2.458 1.719] 2.029] 2.260 | 2.433 1.7071 2.013| 2.240 | 2.409 1.696] 1997 | 2.220 2.385 1.68511.981 | 2.200 2.362 1.673 | 1.96 | 2.181 2.339 1.662 | 1.951| 2.162] 2.316 1.652 | 1.935 2.143 2.294 | 1.641 | 1.9211 2.124] 2.272 1.630] 1.906 2.106 2.251 1.620| 1.89212.08812.229 | 1.609 | 1.877 | 2.0701 2.209 1.599 | 1.863| 2.052 | 2.188 | 1.589| 1.849] 2.035] 2.168 | 1.579| 1.836] 2.018] 2.148 1.569] 1.822] 2.001] 2.129 | 1.559 1.809 1985 2.109 69.5% 70.0% 70.5% 71.0% 71.5% 72.0% 72.5% 73.0% 73.5% 74.0% 74.5% 75.0% 75.5% 76.0% 76.5% 77.0% 77.5% 78.0% 78.5% 79.0% 79.5% 80.0% 80.5% 81.0% 81.5% 82.0% 82.5% 83.0% 83.5% 84.0% 84.5% 85.0% 85.5% 86.0% 86.5% 187.0%) | 87.5% 88.0% 188.5% 189.0% 89.5% 90.0% 1.143) 1265] 1.336 1.378 | 1.138 | | 1.258] 1.328 | 1369 1.132| 1.251] 1.320 1.361| | 1.1271 1.244 | 1312| 1.352 | 11.121| 1.2371 1.304 | 1344] 1.116| 1.230 | 1.2971 1.335| 1.111| 1.224 | 1289 | 1.3271 11.105 | 1.21711.281 1.319 11.100 1210 1274 1.311 1.095 | | 1.204) 1.267 1.303 1.090 | 1.198| 1.259 | 1.295 | 1.085 | 1.1911 1.252 1.2887 | 1.0791 1.185 | 1.245| 1.279 | 1.07411.179| 1.23811.272 | 1.0691.17211 .23111 .264 | 1.06411.166 | 1.22411.256 | 1.060 1 1.160] 121711249 | 1.05511.154 | 11.2101 1.242 | 1.050 11.1481 1.20411.235 | 1.045 11.1431 1.197 11.227 1.040 1.1371 1.190 11.220 | 1.0361 1.1311 1.184 11.213 1.03111.125| 1.177 11.206 | 1.026| 1.120] 1.171| 11.199 | | 1.02211.114| 1.165| 1.017 1.108| 1.158 | 1.186 | 1.013] 1.103] 1.152 | 1.179 | | 1.008 1.0971 1.146 | 1.173 11.004 1.092] 1.140 | 1.166| 0.999 1.0871 1.134 1.160 | 10.995 | 1.081| 1.128 1.153 || 10.9911 1.076| 1.122 | 1.147 | 10.986 | 1.071| 1.116 1.141 | 10.982 | 1.066 | 1.11111.135 | 0.978| 11.061| 1.105 1.129 | 097411.055 | | 1.09911.123 | 0.969) 1.050 | 1.094 | 1.117| 0.965 1.045 | 1.088 | 1.111| 0.96111.040] 1.082 1.105 0.9571 1.036|| 1.0771 1.099 | 0.953] 1.031| 1.0721 1.093 || 0.949 1026] 1.066 1.0871 35.5% 36.0% 36.5% 37.0% 37.5% 38.0% 38.5% 39.0% 39.5% 40.0% 40.5% 41.0% 41.5% 42.0% 42.5% 43.0% 43.5% 44.0% 44.5% 45.0% 45.5% 46.0% 46.5% 47.0% 47.5% 48.0% 48.5% 49.0% 49.5% 50.0% 1.685 1.673 1.662 1.652 1.641 1.630 1.620 1.609 1.599 1.589 1.579 1.569 1.559 1.549 1.540 1.530 1.521 1.512 1.502 1.493 1.484 1.475 1.467 1.458 1.449 1.441 1.432 1.424 1.416 1.407 1.981 | 2.200 1.966 2.181 1.951 2.162 1.935 2.143 1.921 2.124 1.906 2.106 1.892 2.088 1.877 12.070 1.863 2.052 1.849 2.035 1.836 2.018 1.822 2.001 1.809 1.985 1.795 1.969 1.782 1.953 1.769 1.937 1.757 1.921 1.744 1.906 1.732 1.890 1.720 1.876 1.707 1.861 1.695 1.846 1.684 1 .832 1.672 1.818 1.660 1.804 1.649 1.790 1.638 1.776 1.627 1.763 1.616 1.750 1.605 1.737 2.362 | 2.339 2.316 2.294 2.272 2.251 2.229 2.209 2.188 2.168 2.148 2.129 2.109 2.091 2.072 2.054 2.036 2.018 2.000 1.983 1.966 1.949 1.933 1.917 1.901 1.885 1.870 1.854 1.839 1.824 84.0% 84.5% 85.0% 85.5% 86.0% 86.5% 87.0% 87.5% 88.0% 88.5% 89.0% 89.5% 90.0% 90.5% 91.0% 91.5% 92.0% 92.5% 93.0% 93.5% 94.0% 94.5% 95.0% 95.5% 96.0% 96.5% 97.0% 97.5% 98.0% 98.5% 99.0% 99.5% 100.0% 0.999 0.995 0.991 0.986 0.982 0.978 0.974 0.969 0.965 0.961 0.957 0.953 0.949 0.945 0.941 0.937 0.933 0.930 0.926 0.922 0.918 0.914 0.911 0.907 0.903 0.900 0.896 0.893 0.889 0.885 0.882 0.878 0.875 1.087 1.081 1.076 1.071 1 1.066 1.061 1.055 1.050 1.045 1.040 1.036 1.031 1.026 1.021 1.016 1.012 1.007 1.002 0.998 0.993 0.989 0.984 0.980 0.975 0.971 0.967 0.962 0.958 0.954 0.950 .946 0.942 0.938 1.134 1.160 1.128 1.153 1.122 1.147 1.116 1.141 1.111 1.135 1.105 1.129 1.099 1.123 1.094 1.117 1.088 1.111 1.082 1.105 1.077 1.099 1.072 1.093 1.066 1.087 1.061 1.082 1.056 1.076 1.050 1.071 1.045 1.065 1.040 1.060 1.035 1.054 1.030 | 1.049 1.025 1.044 1.020 1.039 1.015 1.033 1.010 1.028 1.006 1.023 1.0011.018 0.996 1.013 0.992 1.008 0.987 1.003 0.982 0.999 0.978 0.994 0.973 0.989 0.969 0.984 L 0 If off the chart use 100%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started