SmarterEd

Aussie Maths & Science Teachers: Save your time with SmarterEd

  • Login
  • Get Help
  • About

Algebra, STD2 A4 EQ-Bank 27

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.
  


  
  1. 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) ---

  2. Using the spreadsheet, identify the break-even point and explain what it means for the business.   (2 marks)

    --- 3 WORK AREA LINES (style=lined) ---

  3. 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) ---

Show Answers Only

a.    \(\text{4 panels: TC (B9) = \$1800.00}\)

\(\text{Revenue (C9) = \$1400.00, Profit/Loss (D9) = }-\$400.00\)

\(\text{6 panels: TC (B10) = \$2100.00}\)

\(\text{Revenue (C10) = \$2100.00, Profit/Loss (D10) = \$0.00}\)

b.    \(\text{Break-even = 6 panels, See worked solution}\)

c.    \(27 \text{ panels}\)

Show Worked Solution

a.    \(\text{4 panels:}\)

\(\text{Total Cost (B9)} = \$1200+4\times\$150 = \$1800.00\)

\(\text{Revenue (C9)} = 4\times\$350 = \$1400.00\)

\(\text{Profit/Loss (D9)} = \$1400.00-\$1800.00 = -\$400.00\)

\(\text{6 panels:}\)

\(\text{Total Cost (B10)} = \$1200+6\times\$150 = \$2100.00\)

\(\text{Revenue (C10)} = 6\times\$350 = \$2100.00\)

\(\text{Profit/Loss (D10)} = \$2100.00-\$2100.00 = \$0.00\)
  

b.    \(\text{When 6 panels are installed:}\)

\(\text{Revenue = Total costs = \$2100.00  (breakeven)}\)

\(\text{This is the point at which the business covers all of its costs and}\)

\(\text{begins to make a profit.}\)

\(\text{OR}\)

\(\text{If fewer than 6 panels are installed the business will make a loss.}\)
  

c.    \(\text{Let } x = \text{the number of solar panels to be installed.}\)

\(\text{Profit}\) \( = \text{Revenue}-\text{Total costs}\)
\(4200\) \( = 350x-(1200+150x)\)
\(4200\) \(= 200x-1200\)
\(5400\) \(=200x\)
\(x\) \(=27\)

  
\(\text{SunPower Solutions will install 27 solar panels.}\)

Filed Under: Simultaneous Linear Equations Tagged With: Band 3, Band 4, Band 5, smc-6920-10-Cost/Revenue, smc-6920-25-Solve Algebraically, smc-6920-35-Spreadsheets, syllabus-2027

Algebra, STD2 A4 EQ-Bank 16

Harmony Arts Festival is a cultural event with fixed costs of $510. Each ticket costs $8.00 to provide and sells for $25.00.

The spreadsheet below models the festival's costs and revenue for different numbers of tickets sold.
  


  
  1. Calculate the values for cells C12 and D12 in the spreadsheet.   (2 marks)

    --- 3 WORK AREA LINES (style=lined) ---

  2. Using the spreadsheet, identify the break-even point and explain what it means for the festival.   (2 marks)

    --- 3 WORK AREA LINES (style=lined) ---

Show Answers Only

a.    \(\text{C12} = \$1250.00 \quad \text{D12} = \$340.00\)

b.    \(\text{See worked solution}\)

Show Worked Solution

a.    \(\text{C12: Revenue} = 50 \times \$25.00 = \$1250.00\)

\(\text{D12: Profit/Loss} = \$1250.00-\$910.00 = \$340.00\)
 

b.    \(\text{When 30 tickets sold:}\)

\(\text{Revenue = Total costs = \$750.00  (Breakeven)}\)

\(\text{This is the point at which the festival covers all of its costs}\)

\(\text{and begins to make a profit.}\)

\(\text{OR}\)

\(\text{If less than 30 tickets are sold the festival will make a loss.}\)

Filed Under: Simultaneous Linear Equations Tagged With: Band 3, Band 4, smc-6920-10-Cost/Revenue, smc-6920-35-Spreadsheets, syllabus-2027

Algebra, STD2 A4 EQ-Bank 3 MC

Beachside Brew is a cafe with fixed weekly costs of $200. Each cup of coffee costs $1.50 to make and sells for $4.00.

The spreadsheet below models the cafe's weekly costs and revenue for different numbers of cups sold.
  

How many cups of coffee must be sold each week to break even?

  1. 60
  2. 80
  3. 100
  4. 160
Show Answers Only

\(B\)

Show Worked Solution

\(\text{Break-even occurs when Revenue = Total costs}\ \rightarrow\ \text{(i.e. Profit = \$0)}\)

\(\text{From the spreadsheet, Revenue = Total costs (\$320.00)}\)

\(\text{when 80 cups are sold.}\)

\(\Rightarrow B\)

Filed Under: Simultaneous Linear Equations Tagged With: Band 3, smc-6920-10-Cost/Revenue, smc-6920-35-Spreadsheets, syllabus-2027

Copyright © 2014–2026 SmarterEd.com.au · Log in