excel

Enable Macros

asdf

Candy

Enable Macros to Begin Assignment This assignment file relies on a set of macros to handle submission and scoring. Before you may begin the assignment, you must enable macros in this workbook. Depending the version of Excel and the security settings, you may see a prompt similar to those below. If you have already dismissed the prompt, you may need to close this workbook and open it again.

Unable to Begin Assignment This assignment is not currently available. Please contact your instructor for further information.

Unable to Begin Assignment To begin this assignment, this workbooks needs to verify that the assessment is currently open. You must have an active internet connection to enable this verification.

Please wait, exam initializing.

Assignment is Active You may begin work on the assignment now. Actually, you should not be seeing this message. If everything worked correclty, this will be invisible and the worksheets with the assignment will be showing.

Candy

Candy Bars	You are in charge of manufacturing for a candy bar plant. Your facility manufactures four types of candy bars (Milky Ways, Snickers, Nut Rolls, and 3 Musketeers). You must maximize the profit for your facility by making the right number of each type of candy bar. There are four main ingredients used in the candy bars: chocolate, nougat, nuts, and caramel. You have created a spreadsheet model on the “Candy” worksheet to help you in your decision-making. The table at the top of the “Candy” worksheet details how many units of each ingredient are used in making each type of candy bar and the costs for these ingredients. The demand and prices you can charge for each type of candy bar are also listed in the spreadsheet model. Finally, the model calculates the ingredient used and total profit for the candy bars you plan to make. Use solver to complete the assignment tasks.
Ingredients	Milky Way	Snickers	Nut Roll	3 Musketeers	Cost
Chocolate	1	1	0	1	$0.15
Nougat	1	1	1	1	$0.15
Nuts	0	1	1	0	$0.20
Caramel	1	1	1	0	$0.15
Demand	2,000,000	2,500,000	1,000,000	1,500,000
Total to Make	1	1	1	1
Price/Bar	$0.90	$0.90	$1.05	$0.90
Cost/Bar	$0.45	$0.65	$0.50	$0.30
Gross Profit/Bar	$0.45	$0.25	$0.55	$0.60	Given the problem constraints which number in the drop-down list in cell N14 is closest to the maximum profit possible for this problem?
Gross Profit/Type	$0	$0	$1	$1
Total Gross Profit	$2	Production would fall short of demand for which of the candy bars (select your answer from the drop-down list in cell 18)?
Material Totals
Ingredients	Used	Available	If you could buy 1,000,000 more units of nuts for $100,000 (in addition to the variable cost of nuts already built into the model), should you (select your answer from the drop-down list in cell N21)?
Chocolate	3	6,000,000
Nougat	4	7,000,000
Nuts	2	2,500,000
Caramel	3	5,500,000

Options

Question 1
$ 2,500,000
$ 2,600,000
$ 2,700,000
$ 2,800,000
$ 2,900,000
$ 3,000,000
Question 2
Milky Way
Snickers
Nut Rolls
3 Musketeers
Question 3
Yes
No