Please solve using excel and show the solver steps used in the problem

Ordering Fuels. Three liquid fuels are stored in tanks for use in a blending process. Each fuel is characterized by a demand rate, a fixed replenishment cost, and a unit cost. Inventory carrying costs are assessed at the rate of 12 percent per year. In order to save money on insurance rates, the operating policy is to limit the average value of stock on hand to no more than $7,500.

Fuel	Demand	Fixed Cost	Unit Cost
1	1,000/year	$100	$150
2	250/year	$175	$100
3	500/year	$150	$120

What are the optimal order quantities for the three items when they are ordered jointly, assuming that the fixed ordering costs are incurred for each item? What is the average annual cost for the three items combined? b. Suppose that the items are managed separately, but the overall limit on stock value still holds. What are the order quantities for the individual items? What is the average annual cost for the three items combined? c. Suppose the stock limit in the base case is relaxed. If the limit is raised by $500, what is the impact on the optimal average annual cost?