Excel and Solver Problem

Samantha is in charge of the local doughnut shop. She has calculated that for each cup of coffee she sells it earns her $0.20 in profit. She has also calculated that for each cup of tea she sells it earns her $0.25 in profit. Samantha has only 1,000 tea bags available each week and each cup takes 1 bag. One of her challenges is that coffee drinkers are more loyal than tea drinkers. She would limit her business to sell twice as much coffee as she does tea.

A) Set up in Excel and solve the problem using Solver.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now