FREE PROJECT BUDGETING LEARNING PATH

WikiFree original practice workbook

The cost architect

CASE STATUS: fictional/synthetic teaching material. Do not present the example as real research, employment experience or measured business performance.

OUTCOME
Build a small project cost baseline, distinguish commitments from payments and update a forecast when scope changes.

BEFORE YOU START
Basic arithmetic and a spreadsheet or paper; all currency units are illustrative.

CASE
Pine Learning Hub plans a workshop series. There are no taxes, finance charges or currency conversion in the synthetic case. Build a planning model, not financial advice or a statutory accounting record.

INPUTS
Cost item,Quantity,Unit cost
Venue days,3,200
Materials per learner,40,12
Trainer hours,10,35
Promotion package,1,120


ENTRY CHECK

Question: Is the cheapest estimate always best?

Self-check: No. It must cover the required scope and state its assumptions.

Question: Is a purchase commitment the same as cash paid?

Self-check: No. They describe different stages of the obligation and payment.

Question: Does contingency make the original estimate certain?

Self-check: No. It makes an allowance explicit; uncertainty remains.

STAGE 1: Define the cost boundary

Prerequisite: Basic arithmetic and a spreadsheet or paper; all currency units are illustrative.

Instruction: A budget begins with scope and a consistent cost boundary. Identify what the estimate includes, what someone else pays and what is deliberately excluded. Record quantity, rate and the basis for each assumption. A single lump sum is hard to update because the drivers are hidden. Keep the case currency unit consistent and avoid presenting fictional rates as market prices.

Practice task: Create a cost table from the four inputs and add basis, owner and exclusion columns. State the learner count and workshop duration assumptions.

Deliverable: A cost structure with estimate bases

Acceptance check: All four lines can be recalculated and no fictional rate is described as a live quote.

If stuck: If a cost has no quantity or basis, explain how it was estimated before using it.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 2: Build the baseline

Prerequisite: Bring your previous output: A cost structure with estimate bases

Instruction: Calculate line costs before adding an explicitly defined contingency. Do not mix the baseline, reserve and spending authority. Here the exercise uses a ten-percent contingency on the direct subtotal; this is a case rule, not a universal professional recommendation. Keep the rule in the workbook so a reviewer can distinguish the assumption from the arithmetic.

Practice task: Calculate each cost, the direct subtotal, ten-percent contingency and total planned funding. Independently recompute the total.

Deliverable: A reconciled cost baseline

Acceptance check: Direct costs total 1550; contingency is 155; planned funding is 1705.

If stuck: If the result differs, check quantity × rate first and ensure contingency was added only once.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 3: Track obligations and payments

Prerequisite: Bring your previous output: A reconciled cost baseline

Instruction: Actual payments, unpaid commitments and forecast future work must be tracked without overlap. A paid deposit is part of a contract commitment, not an extra project cost. Use a remaining-commitment column to avoid counting the whole contract and its payment twice. Record dates separately from amounts so a cash timing issue does not disappear in the total-cost view.

Practice task: Assume the venue contract is 600 with a 200 deposit paid, materials of 480 are ordered but unpaid, and trainer/promotion costs are not yet committed. Reconcile paid, committed remaining and uncommitted forecast.

Deliverable: A commitment and payment tracker

Acceptance check: The venue is counted once: 200 paid plus 400 remaining, not 200 plus 600.

If stuck: If the total rises when a bill is paid, inspect whether commitments were reduced consistently.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 4: Forecast a scope change

Prerequisite: Bring your previous output: A commitment and payment tracker

Instruction: A forecast reflects current expectations while the baseline remains the comparison point. If learner count rises, identify which cost drivers change and which stay fixed. An unchanged total can hide an unfunded requirement. Record the decision before quietly spending contingency, and explain whether the original reserve rule is being retained or recalculated in the scenario.

Practice task: Increase attendance from 40 to 50 with all other assumptions unchanged. Calculate the direct-cost change and the revised total under the same ten-percent rule.

Deliverable: A change forecast and funding request

Acceptance check: Direct cost becomes 1670 and total 1837; the total increase is 132.

If stuck: If every line changes with attendance, distinguish fixed costs from per-learner costs.

Record your work, decisions and evidence:




Record your result against the acceptance check:



STAGE 5: Explain the decision

Prerequisite: Bring your previous output: A change forecast and funding request

Instruction: A sponsor needs the forecast, the reason for movement and the decision required. State assumptions and uncertainty rather than hiding them in a formula sheet. Separate a cost saving from removal of scope: canceling materials may lower cost while making the workshop unusable. A short options table should make that trade-off visible.

Practice task: Write a 150-word budget update comparing 40 and 50 learners. Include one scope option, the requested decision and the date by which it is needed.

Deliverable: A sponsor budget note

Acceptance check: Every amount traces to the model and the recommendation preserves the stated learning outcome.

If stuck: If the note only repeats numbers, lead with the decision and the cost driver causing it.

Record your work, decisions and evidence:




Record your result against the acceptance check:



WORKED CASE
The baseline is 600+480+350+120=1550 direct units and 1705 including the case contingency. In the payment scenario, 200 paid + 880 unpaid commitments + 470 uncommitted forecast = 1550 direct units. At 50 learners, materials become 600, direct costs 1670 and total planned funding 1837.

FINAL PROJECT
Build the Pine budget pack: estimate bases, baseline, obligations/payment reconciliation, attendance-change forecast and a concise sponsor decision note.

REQUIRED CRITICAL CHECK
Double-counted commitments, unexplained rates or an unapproved change hidden in the baseline prevent completion.

SCORING
Score each of the five stage acceptance checks from 0–16 (0 missing/incorrect; 8 partially supported; 16 complete and evidenced). Score the final integrated project from 0–20 (0 missing; 10 incomplete handover; 20 complete, reproducible and consistent with the case). Target: at least 80/100 AND the critical check must pass. A total score never overrides a failed critical check.

SCOPE LIMIT
The model omits tax, financing and statutory reporting. It is a project-planning exercise, not a financial recommendation.

SOURCES AND ACCESS
Assigned public videos can be watched free. Complete the original case in a text editor, on paper or in a spreadsheet you already have. No paid course, exam or provider certificate is included.

Free Project Planning Course: Budgets and Risks
WikiFree: https://wikifree.com/courses/google-project-planning-free-video-course/
Official source: https://www.youtube.com/playlist?list=PLTZYG7bZ1u6rleiXxZOifusKwZka2KJRs
Why selected: The detailed budget lesson provides the planning foundation; the tracker, scenario and reconciliation are original practice.

Stage 1 selected lessons:

5. How to Create a Project Budget (49:26)
https://www.youtube.com/watch?v=lO51qhJWvok&list=PLTZYG7bZ1u6rleiXxZOifusKwZka2KJRs&index=5

REUSE
Original WikiFree teaching text and synthetic fixtures are supplied for personal learning and adaptation with attribution. Provider lessons remain on their original sites and retain their own terms. No provider certificate is included.