(Answered) : use excel solver to solve this problem: Assume that Apple Tree Chocolate sells 5 main products by the pound. Each product req

use excel solver to solve this problem:

Assume that Apple Tree Chocolate sells 5 main products by the pound. Each product requires some mix of 4 raw ingredients such as cocoa, sugar, coconut oil, and milk from their inventory. Every product is sold for a certain price and costs a certain amount to make. Additionally, for each product, there is a limit than can be produced each week. The owner also feels strongly that all products should be available with some minimum quantities.
All of these values are provided in the Excel document on the sheet entitled “Optimization Data”.
Your task is to