Cyber Text

K B C D E F G H 1 ] 12 13 Big Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that a 14 cold sada machine would be appreciated by his workers, and an appreciated worker is a good worker 19 He has priced a machine at a national member only warehouse for $1,900. The machine should be usable for 3 years, after which it would be inefficient, absolete and would have to be disposed of at the 21 dump. Big Al believes that 10 cars a day will be purchased. The plant is open five days a week. 50 22 weeks per year. A case of soda (24 cans) costs $6.00 and Big Al believes that a price of S.85 per 23 can would win him good wil. 29 30 What is the estimated annual sales in cans of soda? (17.01) %B 32 37 What is the contribution margin per can of soda? (rounded to two places, St. 39 (17.02) How many cans of soda must be sold each year to breakeven? (Round up to zero places, ### ### cans) 41 46 47 48 49 50 55 (17.03) Annual incremental cash inflows from the soda machine? (rounded to two places. $#) (17.04) What is the payback period in years? (rounded to two places, #.years) 83 84 (17.05) 8888888888888888888889 If the time value of money is 12% per year what is the net present value? Use the tables on page 18 91 (17.05) What is the internal rate of return. Pick the closest interest rate from the tables on page 18 99 100 (17.07) = A1 A2 A3 A4 A5 A6 LP A 8 Calculation Mode: Automatic Workbook Statistics