Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Sandhya Your Own Question

Sandhya, Tutor

Category: Homework

Satisfied Customers: 3715

Experience: I have several years of teaching experience.

14910578

Type Your Homework Question Here...

Sandhya is online now

Hello,
I need help answering this question including the spreadsheet

This answer was rated:

★★★★★

Hello, I need help answering this question including the spreadsheet used. Thank you.

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 a regular mix of candy made up of equal parts of cashews, raisins, caramels, and chocolates, and a deluxe mix that is one-half cashews and one-half chocolates, which will be sold in one-pound boxes. In addition, the candy counter will offer individual one-pound boxes of cashews, raisins, caramels, and chocolates.

major attraction of the candy counter is that all candies are made fresh at the counter. However, storage space for supplies and ingredients is limited. Bins are available that can hold the amounts shown in the table:

In order to present a good image and to encourage purchases, the counter will make at least 20 boxes of each type of product each day. Any leftover boxes at the end of the day will be removed and given to a nearby nursing home for goodwill.

The profit per box for the various items has been determined as follows:

b. Solve for the optimal values of the decision variables and the maximum profit. (Round your answer to the nearest whole number. Omit the "$" sign in your response.)

I submitted the answers and while some are correct most are not. I have attache the file for you to see. Note that on the value for X4 I believe I typed 61 instead of .61 so I'm pretty sure .61 is the correct answer. Thank you. Please disrerard my previous email a few minutes ago.