A chocolate maker has contracted to operate a small candy counter in a fashionable store. To start with, the selection of offerings will be intentionally limited. The counter will offer (1) product 1 with a mix of one-half cashews and one-half caramels, (2) product 2 with a mix of one-half of caramels and one-half chocolate, and (3) product 3 with a mix of one-fourth cashews, one-fourth caramels, and one-half chocolates. All three products are sold in boxes. Each box contains 1 pound of the product.
The current inventory is shown in the table below: Ingredient Capacity (pounds per day)
Cashews 200
Caramels 160
Chocolates 100
The profit per box for the various items has been determined as follow:
Item Profit per Box
Product 1 $ .80
Product 2 $ .90
Product 3 $ .70
The chocolate maker would like to know the production quantity (in boxes) of each product. The goal is to maximize the total profit. Solve the problem using Excel and round the solution to the closest integer. Based on your solution, how many boxes of product 1 should the chocolate maker produce? Please type your answer (number) directly.
Based on your solution (production plan) in the question above, what is the amount of unused cashews (in pounds)? Please round your answer to the closest integer and type it (the number) directly.
