Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Project Three: You are the manager of a local grocery store located in a strip mall on the outskirts of Tallahassee. The small store
Excel Project Three: You are the manager of a local grocery store located in a strip mall on the outskirts of Tallahassee. The small store next to you (which you own) has been vacant for a half year, and you have been approached by a potential tenant who wants to buy the vacant store for $100,000 in order to put a tattoo parlor in the space. However, you have been thinking that it would be a great idea to add a bakery to your grocery store, which would be located in that space instead. You will then provide fresh baked goods to your customers, as well as a delivery and catering service. You have done some initial analysis and think that your first year's revenue would approach $440,000, and you expect that it will grow at average annual rate of 10% over the first five years. You will need to hire two managers at a cost of $60,000 per year total compensation each, and four workers who will each be paid $30,000 per year in total compensation. Your variable expenses are expected to be 30% of revenue. You will need to spend around $25,000 initially in advertising and training costs
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started