View the step-by-step solution to:

Question

This question was created from SCMT 303 HW 1 Questions https://www.coursehero.com/file/13487671/SCMT-303-HW-1-Questions/

Please explain what the formula is for cell B17 that depends on cells B15 and B16 as stated in the problem.

Now we will determine Betty’s profit if she bakes 14 pies and is able to sell 13. 50 enter 14 in B15 and 13 in
B16. We should be able to enter any numbers in here and then compute the profit. We do that by first finding the
number sold in B17. Enter a formula there that depends upon cells 315 and B16. Obviously the answer is 13 but
do not enter 13. We need a formula. Hint: If we bake=b and demand=d then Min(b,d) is what we sell. In B18 we
need to enter a formula for leftovers. In this case there is a leftover of 1. Hint: If we bake=b and sell=s then b—s
will be the leftovers. But 3 was computed in B17. Now compute the proﬁt in B19. Hint: B*sold-C*leftover. (Do
not literally type B and C). Now you should be able to change the numbers in B15 and B16 and have it compute
the profit in B19. Try it: 12 and 10 will give \$34. Now we will take these profit values and display them in the
table B25:G30. Excel does this by constructing a “Two-way Table.” Follow the directions...

B17 = Minimum of demand and pies... View the full answer

### 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