ukbk tules that prevent it from using AutoSave. Please save your workbook manually reals hian Moustain Waee Company the inwible sales suwwss of Pewier bothed water in the U.S bverags market enation with wt, Vernal elayed es planatiom she bad given him bo the mpul l3v in Vemal to loak into the psasihility of hoaling and wlting water from a National Scwic Trail The beautifal, orysial cloar streawms in the moundains wre a delight to oves l 2 mill v.siton each year and venal 'mpwd to capitaliae on tin 'yys.tunity Ahhough the business was not inmedialely proitahble, novetheless, his powluct was e asnably well receiveld by sone beverage distrihutors in the south and Midwest primanty 0 are couraging wnd Vernal expects to be in the bottled w ater business for some years in 1the cncournging and Vernal expets to be in the botked water business for sone yea in ary Whe most pessing current problem, bowever, is whether or not a new boting y siem INisiiness w as started Cilf Cleave, a sales repeeseeialive from an equipment company in Cincinnati, Ohios has presented plans to Vernal that he believes will accommodate prosluct demansd for the est five years Basically, the re are two choices-Design A and Design B. liach has the same botling capacity and the primary difle rence between the 8 : .degree of aunmation versus hand lah." The mirv autonaed installation. INan H, ost 0 unfortunalely, mainienance costs tend to increase rapidly over the egaipment's life. A 2preniod in Table 1 move, of coune, but is capable of reducing lahor costs during its in-service year listing of the eceomic characteristics of each, along with those of the peesent sysiem, is Three Different Botuling Installatios percent lax bracket over the nest five years and believes he can earn a 12 percent retun on alternative investments during this period He has a slight preference for Design H 26 since, acconding to his cakculations, the cost of the installation is weoovered through Year redhaed operating costs in about 15 months; with A, it takes about 19 months, Vemal admits the difleence is probably trivial and he is not even sure that his approach is valid ear 29 30 TRxoking for help, he then the information to both his public accountant and his bookkeeper and asked each to make a recommendation. Their nesponses coefused him even more. The public accountant indicated that she employed a net present valu (NTV) 2.000 13 3s 37 1. Estimate the design A's Net Operating Cash Flows (NCF) using a given Excel workshec 19 41 Conplete the worksheet given along with this assignunent. (Click the tab of Design B) s Conplete the work sheet given along with this assignment. (Click the tab of Design A) ao 2 Estimate the design B's Net Operating Cash Flows (NCF) using a given Excel worksheet o 3 Calculate NPV of the two smuthually exdlusive designs. Which design should be chosen? 45 as Note Plcase answer the problems above by completing the work sheet named Applachian Design A" and "Applachian Design B