Please solve using excel. Please include formular

Juan Carlos Coffee Shop blends coffee on the premises for its customers. It sells three basic blends in one-pound bags: Special, Dark, and Regular. It uses four different types of coffee to produce the blends: Brazilian, Kenyan, Colombian, and Sumatran. The shop uses the following blend recipe requirements: The cost of Brazilian coffee is $2.00 per pound, the cost of Kenyan is $2.75 per pound, the cost of Colombian is $2.90, and the cost of Sumatran is $1.70 per pound. The shop has 110 pounds of Brazilian coffee, 70 pounds of Kenyan, 80 pounds of Colombian, and 150 pounds of Sumatran coffee available each week. The shop wants to know the amount in each blend it should prepare each week to maximize profit using the above mix requirements. (7 points)