Answered step by step
Verified Expert Solution
Question
1 Approved Answer
E. Violet's team thinks that the next big projects are recreation room interior design; she thinks her team can break out on their own.
E. Violet's team thinks that the next big projects are recreation room interior design; she thinks her team can break out on their own. For an average job: the cost of parts is $13500 with the average amount of team effort equal to 60hrs and average revenue at $22000. Violet will need to invest $50,000 to start out on her own (i.e. fixed cost). Use Goal Seek as well as the net profit calculation and hourly cost cited in A for the following question: Given the detail provided for this average job, how many total jobs will Violet's team need to do in order to break even? Provide a pivot of Room (rows), Work Completed (columns) and Profit; consider using a conditional format: HomeConditional FormattingColor Scales. In light of your analysis, briefly comment on Violet's ambitions for recreation room interior design. As you consider the information provided, think in terms of what information is important. You will need to use the existing data to create new information.
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