E. Violet's team thinks that the next big projects are recreation room interior design; she thinks...

Transcribed Image Text:

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. 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.