Need solution for problem 1.6 in Excel Solver.

The problem is from the above book.

18 INTRODUCTION TO SPREADSHET MODEES FOR ORTSEFE 19 (a) Determine the location that minimizes 1.4 Siting a Warchouse: An appliance desler offers free delivery in any coe of fuethe cost 51 million/month. Texas cities, which will be serviced by a single warehouse. The thistanke from (a) Determine the number of months thar collection efforts shoula ke coentinused warchouse site to a given city is conssidered to be a good proxy for the athesial so from the warcholise to the five cities. The cities are treated as if they were theoly single point located at a specific latitude and longitude, as listed in itus.. tebeth (b) Unser the eptimal policy in (a), what pereentage of accounts receivable if the objective is to maximive the net collections of When locations are specified in terms of latitude (Lat) and longitude ileaf a good approx following: where x=69.1 (Lat, Lat 1) and y=69.1( Lon 2 Lon 2)[cos( Lat 1/57.3)] 1.7 Allocating Plant Output: A firm owns five manuficturing plants that are responsible for the quarterly prodaction of 50,000 pounds of an industrial solvest. The prodaction process exhibits diseconomies of scale. At plant p. the cost of making x thousand pounds of the -solvent is approximated by the quadratic function f(x)=(1/c)x2. The parameters c, are plaat dependent, as What is the best location (latitude and longitude) for the warehouse? How should production be allocated among the five plants in order to minimize to locate the sunken plane, at least approximately. What is its xy-locatice? 1.8 Determining Production Lot Sizes: Four products are routed through a machining center that is notorious for its delays. Each product has had down. When the weather cleared, searchers went out in three different bow over a 3-6 months' time frame. However, in the short run, demand flactuthe transmitter. The locations of the three boats on an xy grid and iskif distance estimates (in miles) are shown in the table below. These quantities are shown, along with other relevast information, in the following table. 1.6 Collecting Credit Card Debt: A bank offers a credit card that can be used is various locations. The bank's analysts believe that the pereentage P of accousto With the current lot sizes, the machining center is running at a utilieation of receivable collected by f months after credit is issued increases at a decreaing about 76%, but long lead times, sometimes over 2 weeks, have discourased prorate. Historical data suggest the following function: duction platners from increasing its load. (A week contains 120 prodoctive P=0.9(1exp(0.6t)] Optimization Modeling with Spreadsheets (20)