Help with setting this problem up in Microsoft Excel step by step please. Thank You! 1 answer below »
The owner of Genuine Subs, Inc., hopes to expand the present operation by adding one new outlet. She has studied three locations. Each would have the same labor and materials costs (food, serving containers, napkins, etc.) of $1.76 cents per sandwich. Sandwiches sell for $2.65 each in all locations. Rent and equipment costs would be $5,000 per month for location A, $5,500 per month for location B, and $5,800 per month for location C. a.
Determine the volume necessary at each location to realize a monthly profit of $10,000.
b.
If expected sales at A, B, and C are 21,000 per month, 22,000 per month, and 23,000 per month, respectively, which location would yield the greatest profits?
The post Help with setting this problem up in Microsoft Excel step by step please. Thank You! 1 answer below » appeared first on Best Nursing Tutor.
Help with setting this problem up in Microsoft Excel step by step please. Thank You! 1 answer below » was first posted on May 28, 2023 at 10:29 pm.©2019 "Best Nursing Tutor". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. Please contact me at [email protected]
