Question
Joanna owns a green building supply company that focuses on providing environmentally sustainable building products for home renovation. She has been open for many years
Joanna owns a green building supply company that focuses on providing environmentally sustainable building products for home renovation. She has been open for many years with hours from 8am to 4 pm(8 hours per day). Her commercial clients would like her to open earlier and her retail customers want evening hours. After evaluating her market she prepared revenue estimates and staffing estimates assuming she is open from 6am to 10pm (16 hours) as well as being open 24 hours per day. Assignment: Create. Model that will evaluate each choice listed in the problem Evaluate each choice and recommend a solution. Please help I have no idea what Im doing.
| Expanding Business |
|
|
|
| February 9, 2018 |
|
|
|
|
|
|
|
|
|
| Daily Revenue |
|
|
| Choices | Retail | Commercial | Employees |
| 8 hours | $ 1,160 | $ 2,240 | 9 |
| 16 hours | $ 1,720 | $ 2,430 | 13 |
| 24 hours | $ 2,160 | $ 2,675 | 17 |
|
|
|
|
|
| Expenses |
|
|
|
| Salaries | $ 32,000 | per employee, per year |
|
| Mortgage & Utilities | $ 5,600 | per month |
|
|
|
|
|
|
| Property Tax |
|
|
|
| $ 28,000 | per year, if | 15 | or less employees |
| $ 14,000 | per year, if | 16 | or more employees |
|
|
|
|
|
| Material costs |
|
|
|
| Retail | 30% | of Retail Revenue |
|
| Commercial | 50% | of Commercial Revenue |
|
|
|
|
|
|
| Open |
|
|
|
| Days | 250 | per year |
|
| Months | 12 | per year |
|
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