Answered step by step
Verified Expert Solution
Link Copied!

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.

image

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

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

Fundamentals of Management

Authors: Robbins, DeCenzo, Coulter

7th Edition

132996855, 0-13-610982-9 , 9780132996853, 978-0-13-61098, 978-0136109822

More Books

Students also viewed these General Management questions