Mathematics
Intermediate
60 mins
Teacher/Student led
+70 XP
What you need:
Chromebook/Laptop/PC or iPad/Tablet
IWB/Projector/Large Screen

Building the Project Budget (1): Line Items

Populate a project budget with at least 15 line items using real researched prices from earlier lessons. Learn to calculate line totals by multiplying quantity by unit price, and ensure units match correctly throughout.

Teacher Class Feed

Load previous activity

    1 - Getting Started

    Illustration for Getting StartedImagine the project goes ahead, the supplies arrive, and on day two of the work you realise nobody costed the brushes. That's €23 of brushes, paid out of the contingency. A week later it turns out the skirting boards weren't on the list either. By the time the project is done, four small forgotten items have eaten the whole contingency line and the project is €87 over budget.

    That is what a missing line item looks like. Today you start building Project Budget v1 — your first real, priced-up budget for the project the class picked back in Lesson 1. You'll work from the supplier prices you researched in Lessons 9 to 12, and by the end of class you'll have at least 15 line items populated with real researched figures.

    This is the artifact that goes into your Maths Portfolio as evidence for the Collecting, Comparing and Calculating stage of your Key Assignment case study. It has to be honest, it has to use real prices, and every line has to be checkable.

    2 - What You'll Learn

    Illustration for What You'll LearnEvery budget you'll ever build, on this course or in life, is made of line items. Get the line right and the budget is right. Get the line wrong and the whole total drifts.

    ConceptWhy it mattersExample
    Line item — one row on the budget showing description, quantity, unit price, and line totalEach line is an honest, checkable promise; if the line is missing or sloppy the project runs over and cannot be verified later.Magnolia emulsion paint, 4 tins, €18.50 per tin, €74.00 — anyone can pick up the page and see where the €74.00 came from
    Quantity × Unit price = Line totalThis is the only arithmetic on the line; get it right consistently and the rest of the budget is just adding-up.Skirting board: 9 metres × €4.20 per metre = €37.80. Type it, double-check it on the calculator, move on.
    Unit — what the price is attached to (per tin, per metre, per pack, per kg, per hour)If the quantity unit does not match the price unit the line total is wrong before you even multiply.Carpet at €22/m² needs an area in m², not a length in metres
    Researched real price — a price you've actually seen on a catalogue, website, or quote, with source and date recordedThe Key Assignment rubric grades whether your prices are real and traceable; a made-up €20 will not pass.€18.50 magnolia from Woodies' website, recorded 14 March in your supplier prices sheet — that's evidence; "roughly €20" is not

    Quick example: carpet area
    For a 7 m × 5 m floor the area is 7 × 5 = 35 m². So the quantity you need is 35 m² of carpet, not 7 m or 12 m.

    3 - Walk Through One Line Together

    Before you populate your own budget, work one line right through with the class. The teacher will model on the board; you follow along in your maths copy with the same figures.

    The line: Magnolia emulsion paint for the project room. The Lesson 9 supplier research showed €18.50 per tin from Woodies' website on 14 March. The room needs 4 tins.

    Set up four columns in your copy: Description, Quantity, Unit price, Line total. Fill in what you know — description, quantity, unit price — and then do the multiplication.

    Project Budget v1 — Line 1: Magnolia emulsion paint

    4 - Build Your Project Budget V1

    Now do your own. Open your supplier research from Lessons 9 to 12 and your starter budget template from Lesson 15. Populate at least 15 line items using real researched prices. For each line, fill in description, quantity, unit price (with the unit), and line total.

    The widget below shows a worked example for a 'decorate a room' project — nine line items already populated so you can see the shape and the discipline, and so every unit type you'll meet (per tin, per metre, per pack, per roll, per square metre, per hour) is in front of you. Look at it once, then build your own budget in your spreadsheet or on paper using your project's researched prices. Save as 16_project_budget_v1.xlsx in your Maths Portfolio folder when you're done.

    Don't worry if your v1 total comes in over your project ceiling — that's normal at this stage, and the sample budget below is deliberately over its ceiling for the same reason. Lesson 17 covers categories, contingency, and trimming the total back to your ceiling. Right now your only job is honest line items at real prices.

    If you are working on paper, simply write the amounts with two decimal places (e.g. €74.00). Spreadsheet currency formatting will be covered in Lesson 18.

    Success criteria for this artifact:

    • At least 15 line items populated.
    • Every line shows description, quantity with unit, unit price with unit, and line total.
    • Every unit price is a real researched figure with a source you could point to in your Lesson 9 data sheet.
    • Every line total is the quantity multiplied by the unit price, double-checked on a calculator.
    • Currency is shown to two decimal places (€74.00, not €74 and not €74.0).

    Project Budget v1: worked example to start from

    Your turn:
    1. Look at the carpet line: 35 m² × €22.00 = €770. Where did the 35 come from for a 7m × 5m room?
    2. The worked example has 9 lines and totals €1,078.80 against a €600 ceiling. Your own budget needs at least 15 lines — what's the first thing you'd cut from this sample if it were yours, and why?
    3. The painter labour line is priced per hour. If you instead saw a quote of '€140 for the day', how would you decide which figure to put in your budget for the same 4 hours of work?

    5 - Think About It

    Think about

    • Which of your 15 lines was the hardest to nail down — the one where you went back and changed the figure once or twice before you were happy with it? What made it hard?
    • Looking at your budget so far, which single line is going to dominate the total when categories and totals come up next lesson? Is that line the one you'd expect to dominate, or has it surprised you?

    6 - What's Next

    What you banked today

    • Project Budget v1 with at least 15 line items at real researched prices — saved as 16_project_budget_v1.xlsx in your Maths Portfolio.
    • A working method for any future budget line: Description, Quantity-with-unit, Unit-price-with-unit, Line total, traceable source.
    • Evidence for the Collecting, Comparing and Calculating stage of the MA1 Key Assignment case study.

    Coming up: Lesson 17

    Right now your budget is one long flat list, and it may well be over your ceiling — that's fine. Next lesson you'll group the lines into categories (materials, labour, consumables, delivery, contingency), calculate subtotals, add a 10% contingency line for the things you haven't thought of, and produce a grand total at the right level of accuracy. That'll be Project Budget v2 — the version you carry into the spreadsheet work in Lesson 18.

    Before next lesson: bring Project Budget v1 to class. If you didn't quite hit 15 lines today, finish the rest from your supplier research before Lesson 17 — categories don't work if half the lines are missing.

    Unlock the Full Learning Experience

    Get ready to embark on an incredible learning journey! Get access to this lesson and hundreds more on our learning platform.

    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more