Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Materials Management

Authors: J. R. Tony Arnold, Stephen N. Chapman, Lloyd M. Clive

7th Edition

7111455517, 978-0131376700

More Books

Students also viewed these General Management questions

Question

Who will implement and maintain the project after launch?

Answered: 1 week ago

Question

analyze aesthetic enhancing design rules.

Answered: 1 week ago

Question

apply communication design concepts into creative projects.

Answered: 1 week ago