# Fruit Wholesaler

This season a fruit wholesaler has 1000 lb of fresh strawberries for sale. Previous experience shows that demand is a function of the price it charges and is given by Demand = 1000 – 150 * Price For instance, when the price is \$1.00 per lb, demand is equal to 1000 – 150*1 = 850 lb. Any left-over straberries will be purchased by a food processing plant at a price of \$0.10 per lb.

a. Develop a spreadsheet model for the total revenue (consisting of the revenue from sale of fresh and left-over strawberries). For example, when the price is set to \$1.00 per lb, total revenue should be: 850 * \$1.00 + (1000-850) * \$0.10 = \$865. When the price is set to \$2.00 per lb, total revenue should be: 700* \$2.00 + (1000-700) * \$0.10 = \$1430.

b. Develop a one-way data table to evaluate revenue as a function of price. The price range should go from \$0.00 to \$5.00 in increments of \$0.20.

c. Use Solver to find the price that maximizes revenue.
Maximum revenue is \$1717.04 when price is \$3.38