Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please disregard my answer. please show in excel with formulas 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Please disregard my answer. please show in excel with formulas
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Bread Cookies Cake Cost Availability Sugar 120 121 122 123 124 125 126 127 Su ar 1.2 0.8 s 1.70 130 130 Profit 453 453.275 453.55 453.825 454.1 454.375 454.65 454.925 s c Oil 0.1 0.2 0.3 2.40 50 50 Salt 0.2 0.1 s 1.40 30 18.75 Cake 150 151.25 152.5 153.75 155 156.25 157.5 158.75 Flour 0.9 1 1.4 s 1.60 300 Selling Price s s s 2.80 4.60 7.20 238.75 Total Cost Total Sell Profit Number 12.5 162.5 749.25 1205 455.75 You can produce 3 food products that need 4 ingredients each. In the table on the Ian you have the cost of each ingredient, its availability in rows 5-6. In column G you have the selling price. In the table you have the number of each ingredient needed for each food item. Maximize pront by selecting the number of food products to produce. The number of products does not have to be integer. For Question 2 the availability of sugar is between 120 and 130. If you do Question 2 complete the table from line 10 on the left by a VBA code. Report the profit and the number of Breads and Cakes sold. The numbers in column A are the availability of sugar. Save the file in an xlsm mode. Bread 50 46.25 42.5 38.75 35 31.25 27.5 23.75 Instructions Question 1 and 2 Question 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started