1) analyzing transactional data on suppliers based on several different criteria to select the best suppliers for the company, and 2) modeling profit to estimate the price for which profit is maximized.

You must submit two files for this assignment: 1) an Executive Summary of your analysis and recommendations, and 2) your Excel file with your analysis, modeling, calculations, and such.

Profit Analysis

The Moto 300 currently retails for $7295. Dirt Bikes USA analysts have determined that demand for the Moto 300 is dependent on the retail price, and they formulated that Moto 300 demand can be represented by:

Demand = 16,000 2 * Price

The accountants estimate that the total cost for the Moto 300 can be represented by:

Total Cost = $750,000 + 4 * Demand^2

(Note that Demand^2 is Demand squared, or Demand * Demand)

Develop a mathematical model for Total Profit from the Moto 300 in terms of the price of the Moto 300. Assume the number of units sold equals demand.

In the Excel file provided with this assignment, on the ProfitModel worksheet, implement the model developed above and construct a what-if data table to estimate the price for which total profit is maximized. Some basic entries have been made for you to get you started. Be sure to follow the guidelines for good spreadsheet design and quality (formatted, understandable, verified, etc.).

Suppose also that Dirt Bikes USA management is hesitant to change the price of the Moto 300 too much, but they want to increase the total profit by 15%. Use Excel what-if analysis to determine the retail price of the Moto 300 needed to achieve this profit goal.

Profit Model
Data
Price	$ 7,295.00
Model