yellow boxes abswered
FILE SM2594 (Compatibility Mode] - Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Cut MS Sans Serif -10 AA = Wrap Text E Copy Format Painter + Painter BIUS. AE 33 Et Merge & Center - $ - %, 8% Clipboard Font Alignment aste Number - A B C D E . Capital Decision Making F G H I J Big Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that a 3 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 8 cans a day will be purchased. The plant is open five days a week, 50 2 weeks per year. A case of soda (24 cans) costs $6.24 and Big Al believes that a price of $.90 per 7 can would win him good will. What is the estimated annual sales in cans of soda? CH 1.800 cans (17.01) What is the contribution margin per can of soda? (rounded to five places. S# # ## . Oooo3U $0.64000 (17.02) How many cans of soda must be sold each year to breakeven? (Round up to zero places ### ### cans) 578 cans (17.03) You ente ... 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Present Value Tables ... E - Copy Format Painter Clipboard - S4 A" E . w Wrap Text W. s Merge & Center - Alignment *8.98 Font s $ . % , Number Nu A B C D E F G H I J Annual incremental cash inflows from the soda machine? (rounded to two places, SWN) (1704) What is the payback period in years? (rounded to two places, #.## 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 internal rate of return. Pick the clo sest interest rate from the tables on page 18 ... 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Present Value Tables ... A = LE 2 SM2594 (Compatibility Mode] - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW X Cut MS Sans Serif - 10-AN = = Wrap Text E Copy * Format Painter BIU. D A -EESE Merge & Center - $ - %, 8. Conditu Formatt Clipboard Font Alignment Number A B C D E F G H I What is the internal rate of return. Pick the closest interest rate from the tables on page 18. {1707} . Ui FILE . HOME INSERT INGE LAYOUT SM FORMULA Com DATA e del VW vw Co formu A M a rte S. . . Conditional Forma ing le Styles Delete format - 1023611 297436173 S212340341533 HONE20220220359 123223330361 10023 15 30 61.55 120 1787140164 251221137111513 6017211113 1200 13031421202 1613011 2016 271020199119 ERREBBERO 39058 210 20111003 ANH N 70 11 2010 INDOOR INH10 LINE1181 1 70 EN TOONS 2222202571671 11121112013611 201207128331 102112321301 2011201220312 21 27 0 1 4231996 N 2710 111221297135 24N19017404 210500 PER 1224 SO4 1 235122712161 750 120 121 1311 MEN 1090413 512610 2300122 23 75010111 7 10 11 12 13 14 15 16 17 18 PretValue Table Type here to search A shedelme - Ex Alum 27 H Font Formatting Styles 1219 7555 76010701119 120 1212 ITON106111612201756 Y510601160121711249 7805109 110 110110 109011811704 125 1311 35% 1 2 2 2 210X1.895 2200 201 2021 75122002672790 281058 241259 201 2222 507 272 201642 2203 220 27001 180 2185 285912671 300318162662436 2431 301003210212615 31051791 771302330 2685 151719 2.11323677661 2017662092351234 2 174 2079 2020 114220522302280 2.750 2.729 2.700 T 79531040113711013220 3001036113111114120 1001 11011111205 88353335SSESSEEEEE 3209 401719 2020 203 70 1720122202009 55165161222002 14:54 IN10001097155173 US10001092110011661 HIN 10 1 160 4450910111001 SON1011111 145709 155 20 ON 209 14112016 751102103102 7616111242 N1630100161222311 1601022002 16000 1015156021301 8114001091641203521681 . .. 7 10 11 12 1452 1402 50N 14724 141264 BON 1001 111 NO10611110111 HONOM 101 112) 2911011 OWS 1045 10111 06 1.0 1021105 14 15 16 17 18 Present Value Tables 13 152620 READY Type here to search SMO Com Model - ecel FILE HOME INSERT PAGE LAYOUT FORMAS DATA REVIEW VW thadell michel 9 2. Auto- Copy W BU S A- Format Paint eMega Center - S. Font 885096110101001105 1534 61.5% 4105_1569 4822 2001 2129 4155 1 5 72103 22041 5495795196920911 551 1702 1 20r2 4301530 1769 1 937 2054 BRUSSEBUEESEELEN 8959059101 102 1090 90009491025 1056631 9050951021 1061 102 9100 1016104105 9155093711012 1060 107 1208 09 100 10451055 9259001000101010 985922099010001049 SEOS 0.916 099 100 101 95041400 10.) 0911 500 10151033 450N 1893 1 720 7875198) 460S14151695 1946 1949 2591467164120219 145767213101917 1010 - 490 1424 762777631054 49551416 1 8 10150014 7 10 GOLD 16006010 of the chartse 100% TO 5 9 10 1 2 13 14 15 16 18 Present Value Table Type here to search Comp Madele HOME INSERT ME LAYOUT FORMULAS DATA VIW VIW Ariel 10 SAA Wap Tert S UA . . Conto 1000 869888SSE
