Question: based on the first question i have create the data solver in excel. no excel work is needed to be done its all done based

based on the first question i have create the data solver in excel. no excel work is needed to be done its all done
based on the second and third data solver write a page or two three paragraph report on variable cells and constraints.
just need a paper on variable ans constraints data from sensitivit report that i have attached.
thank you
based on the first question i have create the data solver in
excel. no excel work is needed to be done its all done
based on the second and third data solver write a page or

1) Mrs. Moody sells cookies that she bakes in her kitchen and gives the profits to charities. She sells two types of cookies - regular chocolate chip and extra chocolate chip. To bake a pound of regular chocolate chip cookies, she uses two eggs, \\( 0.15 \\mathrm{lbs} \\). of chocolate chips, \\( 0.20 \\mathrm{lbs} \\). of sugar, \\( 0.40 \\mathrm{lbs} \\). of butter, and \\( 0.25 \\mathrm{lbs} \\). of flour. To bake a pound of extra chocolate chip cookies, she uses two eggs, \\( 0.25 \\mathrm{lbs} \\). of chocolate chips, \\( 0.15 \\mathrm{lbs} \\). of sugar, \\( 0.35 \\mathrm{lbs} \\). of butter, and \\( 0.25 \\mathrm{lbs} \\). of flour. She makes a \\( \\$ 7 \\) profit on a pound of regular chocolate chip cookies and \\( \\$ 9 \\) profit on extra chocolate chip cookies. She purchased. six dozen (72) eggs, eight lbs, of chocolate chips, seven lbs. of sugar, \\( 15 \\mathrm{lbs} \\). of butter, and \\( 10 \\mathrm{lbs} \\) of flour. How much should she bake of each type of cookie to maximize her profit? 12 Constraints Mrs. Moodey Cookies

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!