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/

13487671-397799.jpeg

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

13487671-397799.jpeg

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 profit 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...

Top Answer

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

Sign up to 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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question