Exam 8: Nonlinear Programming and Evolutionary Optimization

The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 - 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft² of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem. The spreadsheet implementation of this formulation applies to the following questions. -Refer to Exhibit 8.2. What formula would you place into cell B5 to calculate Total Floor Area?

An investor wants to determine how much interest he must earn to be able to make the payments on a 10-year mortgage which has increasing annual payments. The problem is summarized in the accompanying spreadsheet. The investor has enough money to make an initial investment of $9,000 and hopes he can earn 12%, compounded quarterly, on his investments. He would like to know how low his annual return can be and still allow him to make his payments from interest income. What formula goes in cell C7 of the spreadsheet?

The GRG algorithm operates by

An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local businesses. Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. The following spreadsheet has been set up to solve the problem. What cell is the variable cell in this problem?

A company makes products A and B from 2 resources, labor and material. The company wants to determine the selling price which will maximize profits. A unit of A costs 30 to make and demand is estimated to be 50 - 0.09 * Price of A. A unit of B costs 20 to make and demand is estimated to be 30 -0.14 * Price of B. The utilization of labor and materials and the available quantity of resources is shown in the table. A reasonable price for the products is between 90 and 140. Let X₁ = demand for As and X₂ = demand for Bs. Let P₁ = price for As and P₂ = price for Bs. The NLP for the problem is: What values should go in cells B3:E18 of the spreadsheet for this problem?

A company wants to locate a new warehouse to minimize the longest distance travelled by any of its delivery trucks. It has four stores and their coordinates are listed in the below. Let X and Y represent the X, Y coordinates of the new warehouse. The NLP for this problem and solution is the following. Solution is (X, Y) = (120.0, 117.4). What values should go in cells B2:D9 of the spreadsheet for this problem?

The following questions pertain to the problem and spreadsheet below. A construction company just purchased a 300 - 300 foot lot upon which they plan to build an office building. They need at least 60,000 ft² of office floor space. Zoning regulations require each floor be 10 feet high and the building not exceed 65 ft in height. Further, parking space must equal at least 30% of the total floor space available. The company's cost accountant uses a 60% factor of the building height and a 1% factor of any story's floor area to calculate the total building cost (in millions of dollars). The following is the NLP formulation for the problem. The spreadsheet implementation of this formulation applies to the following questions. -Refer to Exhibit 8.2. The company wishes to have a relatively square building. Thus, they wish neither the building length nor the building width exceed the other by more than 25%. Add constraint(s) to enforce this design constraint.

An office supply company is attempting to determine the order quantity for laser printer toner cartridges which are sold to local businesses. Annual demand is 20,000 units and each cartridge costs the store $25. It costs $30 to place an order and the inventory carrying cost rate is 25% of the value of the item. The following spreadsheet has been set up to solve the problem. What cell is the objective cell in this problem?

How many local minimum solutions are there on this graph of a function Mark their locations on the graph.