E. Violet's team thinks that the next big projects are recreation room interior design; she thinks...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
Activity Cost Month Month Month Month Month Month 2 6 A $100 B $30 C $40 D $80 E $20 F $50 $70 H $30 $200 K $60 L $20 After two months, Activities A, B. half of C, and half of F are completed, for a...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
A stock is currently priced at $39.3. Its dividend is expected to grow at a rate of 5.9% per year indefinitely. The stock's required return is 8.4%. The stock's predicted price 7 years from now, P7,...
-
Suppose that there are p = 2 quality characteristics, and in correlation form both variables have variance unity and the correlation coefficient is 0.8. The in-control value of the process mean...
-
Briefly describe the four psychological factors influencing consumer buyer behavior. Explain their importance to marketers?
-
The internal auditors of Brown Electrical Company report to the controller. Due to changes made in the past year to several of the transaction processing programs, the internal auditors created a new...
-
The Eco Pulse survey from the marketing communications firm Shelton Group asked individuals to indicate things they do that make them feel guilty (Los Angeles Times, August 15, 2012). Based on the...
-
Factor out the GCF from the polynomial. 2 48xy-147x
-
what is income statement year ended July 31 2021. Skysong Inc. has recorded all necessary adjusting entries, except for income tax expense, at its fiscal year end, July 31, 2021. The following...
-
1. Define "Risk management". 2. Differentiate between a risk averse entrepreneur and a risk seeking entrepreneur. 3. Give four categories of hazard-based risks and provide an example of each. 4....
-
1. This question concerns the dynamic programming algorithm for computing a binary tree, discussed in class in and in the notes. Suppose we are given the following data, consisting of 8 key values...
-
https://youtu.be/Dy9EqjHf2zw ( Nike's Rise of the Kids | Sport Is Never Done | Nike) Commercial. 1) Discuss what makes this advertisement special, and why did you choose it? 2)How does it connect...
-
The historical background of the term human resource in the last 80 years of the twentieth century, both the scientific management and the human relation approach have appeared and declined." Provide...
-
Briefly differentiate between a tradeshow and consumer show. Provide an example of each that you or a family member may have attended. Exhibiting in a tradeshow can be very costly. Over and above the...
-
During the past 10 years, the percent returns on two mutual funds (aggressive and passive) expressed in percentages were as follows: Aggressive Fund Year Passive Fund -10 1% 3% -9 18% 4% -8 1% 3% -7...
-
Consider the sections of two circuits illustrated above. Select True or False for all statements.After connecting a and b to a battery, the voltage across R1 always equals the voltage across R2.Rcd...
-
SnoBoard Companys year-end balance in its Allowance for Doubtful Accounts is a credit of $440. By aging accounts receivable, it estimates that $6,142 is uncollectible. Prepare SnoBoards year-end...
-
Calculate the amount recorded as the cost of a new machine given the following payments related to its purchase: gross purchase price, $700,000; sales tax, $49,000; purchase discount taken, $21,000;...
-
Wecker Companys year-end unadjusted trial balance shows accounts receivable of $89,000, allowance for doubtful accounts of $500 (credit), and sales of $270,000. Uncollectibles are estimated to be...
Study smarter with the SolutionInn App