Solved by Expert Tutors
Solved by Expert Tutors
Question

I need to first make the math MODEL then an excel model then I should solve using an excel solver button

1.  What is the optimal decision?

2.  What is the optimal profit based on the decision?

3.  Which constraints are binding?

4.  Which resources have slack, and how much?

OIIISZOS Problem for Homework 1 i can make two types of brownies, Regular and Organic: - Regular Brownie sell for 150 ﬁls each, require 4 grams of sugar, and 3
minutes prepare each one ' Organic Brownie sells for 200 ﬁls each, requires 1 gram of sugar, and 5
minutes to prepare each one Constraints:
1. lhave 300 grams of sugar to use 2. l have 2 workers that are working for 3 hours
[you need to calculate total avallahlemlnutes] 3. Exactlg 80 brownies in total are needed (no more, no less} 4. I want to make sure as well thatl have at least 20 more regular brownies
than organic brownies. How mam;r of the regular and organic brownies should I produce to
maximize proﬁt?

m ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac

, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing eli

acinia pulvi

a rem ipsum dolor sit amet, consectetur dictum vitae odio. Donec alique s ante, dapibus a molestie icitur lao inia pulvin facilisis. Pe ips e ci ffic i co ce dui lectus e vel laoreet a , c Fus

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents