Assignment:
Power Notebooks plans to manufacture a new line of notebook computers. The screens cost $100 each. To set up assembly process required to produce screens in house would cost $100,000. Company could produce screens for $75. Number of notebooks that eventually will be produced (Q) is unknown at this point.
a) Set up a spreadsheet that will display total cost of both options for value Q.
b) Use a graphical procedure to determine the breakeven point for Q(i.e., the quantity at which both options yield the same cost)
c) Use an algebraic procedure to determine the break-even for Q
Provide complete and step by step solution for the question and show calculations and use formulas.