Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Samantha is in charge of the local doughnut shop. She has calculated that for ea

ID: 404567 • Letter: S

Question

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.

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. Set up in Excel and solve the problem using Solver.

Explanation / Answer

There is no problem? You are not asking us to solve anything?

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote