Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones Of Financial Accounting

Authors: Jay Rich, Jefferson Jones, Maryanne Mowen, Don Hansen, Donald Jones, Ralph Tassone

2nd Canadian Edition

0176707123, 978-0176707125

More Books

Students also viewed these Accounting questions

Question

A fair die is tossed. Determine the odds against rolling a 2.

Answered: 1 week ago

Question

How flying airoplane?

Answered: 1 week ago

Question

Distinguish between recruitment sources and recruitment methods.

Answered: 1 week ago

Question

How has social media emerged as an important force in recruiting?

Answered: 1 week ago

Question

5.5 Summarize external recruitment methods.

Answered: 1 week ago