Question: 2. Based on your solution (production plan) in the question above, what is the amount of unused cashews (in pounds)? Please round your answer to

2. 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.
Questions 1-2 are based on the following information. 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 Chocolates 160 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. Questions 1-2 are based on the following information. 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 Chocolates 160 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) directlyStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
