Financial Modeling & Forecasting Flashcards

A procurement analyst is rolling up spend forecasts from multiple business units using a bottom-up approach. Which risk should be flagged when consolidating these forecasts?

Answer: Double-counting shared service costs allocated across multiple units

When aggregating business unit forecasts, shared or allocated costs (e.g., IT, facilities) may appear in multiple unit budgets, causing double-counting that inflates the total forecast.

Which financial concept explains why a $1,000 payment received one year from now is worth less than $1,000 received today?

Answer: Time value of money

The time value of money states that money available now is worth more than the same amount in the future due to its potential earning capacity.

In a procurement budget variance report, a favorable price variance combined with an unfavorable usage variance most likely indicates:

Answer: Suppliers charged less per unit but the company consumed more units than planned

A favorable price variance means actual cost per unit was lower than budgeted, while an unfavorable usage variance means more units were consumed than planned, often due to quality issues or process inefficiency.

When a procurement model uses 'cost-plus' pricing logic to validate a supplier quote, the primary input required beyond direct costs is:

Answer: The supplier's target profit margin or markup percentage

Cost-plus pricing adds the supplier's costs to a markup or profit margin to arrive at the selling price, so the margin percentage is the key additional input needed.

A forecast shows a Mean Absolute Percentage Error (MAPE) of 8%. This means the model's predictions are on average:

Answer: 8% away from actual values (above or below)

MAPE measures the average absolute percentage difference between forecasted and actual values regardless of direction, so 8% MAPE means predictions deviate by 8% on average.

Which approach is most appropriate for forecasting spend on a newly awarded category with no internal historical data?

Answer: Analogous estimating using data from a comparable category or industry benchmarks

Analogous estimating uses historical data from similar categories, projects, or industry benchmarks as a proxy when no direct internal history exists for the new category.

In a long-term supply contract financial model, which of the following best represents a 'volume commitment' risk to the buyer?

Answer: Buyer's demand falls below the minimum purchase obligation, triggering penalty payments

Volume commitment clauses require the buyer to purchase a minimum quantity; if actual demand falls short, the buyer may owe shortfall penalties, creating a financial liability not captured in base-case forecasts.