Help with setting this problem up in Microsoft Excel step by

in /by

Help with setting this problem up in Microsoft Excel step by

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 Urgent Nursing Help.
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 "Urgent Nursing Help". 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 admin@cipdpro.co.uk

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper