Lopez Garage Doors manufactures a premium garage door. Currently, the price and cost data associated with the premium garage door are as follows: Selling price per premium garage door $1,300 Variable manufacturing cost per door $550 Variable selling cost per door $150 Total annual fixed costs $240,000 Q1. The company sold 430 doors in the current year. Based on the cost information, prepare a contribution margin income statement for Lopez Garage Doors. (You can use the table on page 3 as a template.) Q2. What is the company's contribution margin per unit? What is its contribution margin ratio (rounded to two decimal places)? Q3. What is the company's current break-even point in units and dollars (rounded to the nearest dollar)? Q4. If the company expects to sell 450 premium garage doors in the upcoming year, what is its expected operating income (rounded to the nearest dollar)? Q5. If the company hopes to have a target profit of $200,000 in the upcoming year, how much sales revenue would the company have to generate (rounded to the nearest dollar)? Lopez Garage Doors has undertaken several sustainability projects over the past few years. Management is currently evaluating whether to develop a comprehensive software control system for its manufacturing operations that would significantly reduce scrap and waste generated during the manufacturing process. If the company were to implement this software control system in its manufacturing operations, the use of the software control system would result in an increase of $61,000 in its annual fixed costs while the average variable manufacturing cost per door would drop by $100. Q6. If the company were to implement the software control system, what would be the company's new contribution margin per unit AND contribution margin ratio (rounded to two decimal places)? Q7. If the company were to implement the software control system, what would be the company's new break-even point in units and dollars (rounded to the nearest integer)? Q8. If the company expects to sell 450 premium garage doors in the upcoming year, do you think the company should implement the software control system? Why or why not