SunPower Solutions is a business that installs solar panels. Fixed costs are $1200. Each panel costs $150.00 to install and generates revenue of $350.00.
The spreadsheet below models the business's costs and revenue for different numbers of panels installed.
- Calculate the spreadsheet values for the installation of 4 panels (cells B9, C9, D9) and 6 panels (cells B10, C10, D10). (2 marks)
--- 4 WORK AREA LINES (style=lined) ---
- Using the spreadsheet, identify the break-even point and explain what it means for the business. (2 marks)
--- 3 WORK AREA LINES (style=lined) ---
- SunPower Solutions has received a large order that will see them make a profit of $4200. Calculate the number of solar panels \((x)\) they will be installing. (2 marks)
--- 5 WORK AREA LINES (style=lined) ---





