Need help creating analysis in excel.

Mr. Greg has expanded his operations and now sells his T-shirts in various locations. He intends to sell each T-shirt for $4; however, he has to purchase more than 1000 T-shirts to attain the low price of $1.5 from the manufacturer. There are different levels of prices, and the discount table that the manufacturer uses is shown below. QUANTITY PRICE DISCOUNT MEGreg is uncertain about the demand for his T-shirts; the demand range from 100 to 2000 Tshirts a week. If he has any left over, he may sell all excess inventory to a discount store for $1 per T-shirt. The xed costs {rent and labor costs) is $175 a week. Prepare an analysis table to help Mr. Greg decide how manyTshirts should he order from the manufacturer. Note: Units sold at regular price is the minimum between the ordered quantityr and demand ; =MINiordered quantity, demand} Units sold at discounted price is the excess between the ordered quantity and demand; = owered quantity> demand, Ordered quantitv- demand,0]