Excel solver word problem

Question

1. Hi there I need help modeling this problem. I cant figure out how to set it up in excel solver.
2. Norman Bates is the General Manager of the Bates Motel. Each evening, he visits people in their rooms and offers complimentary Peanut Butter (PB) and Peanut Butter andJelly (PBJ)sandwiches to tired travelers who didn’t go into town for dinner. He also tried to indulge them inconversation to help pass the time. Each day, Norman wants to make at least 25 sandwiches of both kinds combined. Based onknown past demand, he also wishes that however many he should make, at least 60% of themmust be PBJ’s. For this day, he has 60 slices of bread, and each sandwich requires 2 slices. Norman measures his peanut butter and his jelly by ‘units’, of which for this day, he has 40 unitsof peanut butter and 20 units of jelly available to make sandwiches. Each PB sandwich uses 1.5units of peanut butter, and each PBJ uses 1 unit of peanut butter and 1 unit of jelly. Finally, based upon the effort to create the sandwiches and their respective ingredients, Normanassesses the per unit cost of a PB sandwich to be $0.25, while the PBJ sandwich is estimated tocost $0.40. Find the optimal number of sandwiches of each kind to make that satisfy the requirements of thissituation and minimize cost.

Answer 1

I've never used Solver before, so this problem was a fun exercise in learning to use it.  Thank you. 

 

 

https://www.wyzant.com/resources/files/498788/setting_up_a_problem_in_excel_solver