please show excel formulas

A company produces a product called A, the price it can charge its customers depends on the quantity of the product produced. When the company floods the market with their products (produce too much), the price drops because the products are everywhere. When the company produces just a few, the price rises because of scarcity. The relationship between price and production quantity is approximated based on historical data: Price = 1000 - 4*Quantity Step 1: given the production quantity shown in cell 317, calculate the price and revenue. Step 2: calculate the Revenue Maximizing Quantity using Excel solver. Remember to chose nonlinear solver in the drop list. Quantity Price Revenue