MT455 Unit 9 Pipeline Forecast Review Example

Reviewed by Chester Goodwin, MBA Strategic Management of Sales Purdue University Global Free custom sample in 24 to 48h

A pipeline worth 3.10 times the remaining target that still falls short is explained in this MT455 Unit 9 pipeline forecast review for a composite access control company. With $2.30 million booked and $5.09 million to go, 96 open deals worth $15.77 million weight to only $4.73 million at the team's historical stage close rates, a weighted coverage of 0.93. Fourteen deals worth $1.96 million are more than sixty days past their close dates and are discounted by half. The likely quarter is about $6.70 million, $689,000 short of $7.39 million, with a range of $6.25 to $6.89 million that turns mostly on one $560,000 hospital contract. Kahneman and Lovallo explain the gap with the sellers' $7.42 million roll-up. Purdue Global MT 455 assigns the review for Keystrand Access in the BS in Business Administration.

CourseMT455 Strategic Management of Sales
UnitUnit 9
Paper typePipeline forecast review
LengthAbout 1,100 words, 6 pages double-spaced
FormatAPA 7 student paper
SchoolPurdue University Global
ProgramBS in Business Administration
UpdatedOctober 2026

Free sample paper for MT455 Unit 9

1

Three Times Covered, Still Short: An MT455 Unit 9 Pipeline Forecast Review for a Quarter's Bookings

[Student Name]

Purdue University Global

MT455: Strategic Management of Sales

Unit 9 Pipeline Forecast Review

[Instructor Name]

[Date]

Keystrand Access, its pipeline, its deals and every figure are composite; the sources cited are real.

What this part is doingAnswering the question in the lead, with the likely figure and the range, follows how a vice president reads a forecast.
2

The Answer First

To: Vice President of Sales, Keystrand Access. The likely result for the third quarter is about $6.70 million in bookings, against a target of $7.39 million, a gap of about $689,000. The range runs from $6.25 million to $6.89 million, and most of that range depends on one hospital system contract now in security and legal review. The sellers' own roll-up of committed and best-case deals totals $7.42 million. This review explains why the two numbers differ and which one to plan on.

Where the Quarter Stands

With five weeks left, $2.30 million is already booked. That leaves $5.09 million to reach target. The open pipeline expected to close this quarter holds 96 deals worth $15.77 million.

Raw Coverage and Weighted Coverage

Raw coverage, the open pipeline divided by what remains, is 3.10. Many sales teams treat three times coverage as safe, which is why the quarter looks healthy on the dashboard. But raw coverage counts every pipeline dollar the same, whether a deal is a first conversation or a signed contract awaiting legal review.

Weighted coverage applies each stage's historical close rate. The stage table shows each stage's deal count, value, close rate over the last four quarters and weighted value. Qualified: 38 deals worth $5.80 million, closing at 12 percent, weighted $0.70 million. Discovery: 27 deals, $4.20 million, 22 percent, $0.92 million. Proposal: 17 deals, $2.85 million, 38 percent, $1.08 million. Negotiation: 9 deals, $1.62 million, 61 percent, $0.99 million. Security and legal review: 5 deals, $1.30 million, 80 percent, $1.04 million. The weighted pipeline totals $4.73 million, a weighted coverage of 0.93.

Most of the pipeline's value sits in early stages that rarely close, which is why three times coverage still falls short.

What this part is doingShowing where the value sits by stage explains the disagreement between the two coverage ratios.
3

The close rates come from the team's own history, which is their strength, but they carry a caveat. They measure whether deals at each stage were eventually won, not whether they were won inside the quarter. Some deals that will close eventually will not close in five weeks, so the weighted figure may still be generous for early-stage deals. Zoltners et al. (2004) caution that stage probabilities are useful only when stages are defined by what the customer has done, not by what the seller hopes, and Keystrand's stages meet that test for proposal and later stages but not for qualified deals.

How the Stage Rates Were Built

Each close rate was calculated from the deals that entered a stage in the last four quarters. Of the 112 deals that reached proposal in that period, 43 were eventually won, a rate of 38 percent; of the 31 that reached negotiation, 19 were won, 61 percent. Deals still open were left out of the calculation rather than counted as losses, which slightly overstates the rates. Security and legal review has the smallest history, only 15 deals, of which 12 closed, so its 80 percent rate is the least certain number in the table. The rates also mix segments: health system deals move more slowly than mid-market deals at every stage, and a pipeline heavy in health systems, as this one is, will convert more slowly than the blended rates suggest.

Stale Deals

The aging list names 14 deals worth $1.96 million that are more than sixty days past the close dates their sellers originally set. Deals that have slipped once tend to slip again, so the review halves their weighted value, about $0.67 million, removing about $0.33 million from the forecast. The largest of them, a $310,000 university campus deal, has had no customer contact recorded in 41 days.

The likely quarter is therefore $2.30 million booked, plus $4.73 million weighted, minus $0.33 million for stale deals, about $6.70 million.

One Contract Examined Alone

A single deal moves the range more than any other. A regional hospital system's $560,000 contract has been in security and legal review for three weeks. It is weighted at 80 percent, $448,000. If it closes this quarter, and two of the stale deals also close, the quarter reaches about $6.89 million. If it slips to next quarter, the quarter falls to about $6.25 million. The review recommends that the vice president call the hospital's chief information officer this week to ask what remains in the security review and whether anything Keystrand can provide would shorten it.

The Sellers' Roll-Up

The sellers' roll-up of $7.42 million includes every deal a seller has marked as committed or best case. It differs from the method's result in two ways. It includes several stale deals at full value, and it treats many proposal-stage deals as likely, although proposals have closed only 38 percent of the time. Kahneman and Lovallo (1993) describe the tendency of people close to a plan to forecast from its specific details and neglect the base rates of similar past cases, and the gap between the roll-up and the weighted forecast is largely that pattern. The review does not overrule the sellers. It asks each seller with a committed deal at proposal stage to name the next customer action and its date.

What to Do

Plan on about $6.70 million. Pursue the hospital contract directly. Ask sellers to update or close the 14 stale deals by next Friday, so the next forecast starts from cleaner data. And for future quarters, report weighted coverage beside raw coverage on the dashboard, so the gap is visible before the last five weeks. ## What Changes Next Quarter

Three process changes would make the next forecast more reliable. First, stage definitions should require a customer action to enter each stage: a meeting with more than one buyer for discovery, a written request for pricing for proposal and a redline of terms for negotiation. Second, close dates should be updated by the seller every two weeks, with any date moved twice flagged automatically for the manager. Third, close rates should be calculated separately for health systems, apartment operators and mid-market deals, since their cycles differ so much. None of these changes requires new software; all can be built into the existing customer records and the weekly pipeline call.

Johnston and Marshall (2021) recommend combining a historical, stage-weighted forecast with seller judgment rather than relying on either alone, and this review is built to support that combination.

What this part is doingClosing with actions that improve the next forecast shows the review is meant to change process, not just report a number.
4

References

Johnston, M. W., & Marshall, G. W. (2021). Sales force management: Leadership, innovation, technology (13th ed.). Routledge.

Kahneman, D., & Lovallo, D. (1993). Timid choices and bold forecasts: A cognitive perspective on risk taking. Management Science, 39(1), 17-31. https://doi.org/10.1287/mnsc.39.1.17

Zoltners, A. A., Sinha, P., & Lorimer, S. E. (2004). Sales force design for strategic advantage. Palgrave Macmillan.

The Purdue Global MT455 Unit 9 instructions

MT455 Unit 9 asks for a review of a sales pipeline and a forecast for the period. Give the answer first: a likely figure, the gap to target and a range. Report where the period stands, then compare raw coverage with coverage weighted by stage close rates from the team's own history, and explain the difference. State how close rates were built and their limits. Identify stale deals and adjust for them with a stated rule. Examine the largest deal individually if it moves the range. Compare your result with the sellers' own roll-up and explain why they differ without dismissing the sellers' judgment. Close with actions for this period and process changes for the next. About four pages for a sales leader, with a stage table and an aging list, is typical. Each figure should follow from the stage table.

How this MT455 Unit 9 example is built

The Keystrand review opens with the likely quarter, the gap, the range and the sellers' higher roll-up. A short section gives the booked and remaining figures. Raw and weighted coverage are then compared stage by stage, under a highlighted line on early-stage value that rarely closes, with a caveat that historical rates measure eventual wins. A section explains how the stage rates were built and why the security review rate is least certain, with Zoltners and colleagues on customer-defined stages. Stale deals are halved, naming the largest. The hospital contract is examined alone, with a suggested call to its chief information officer. The sellers' roll-up is compared with the method, citing Kahneman and Lovallo on neglected base rates. Three process changes for next quarter and the actions for this one close the review, with Johnston and Marshall on combining methods.

Where the points sit in the MT455 Unit 9 rubric

Forecast reviews are marked on clarity and on the reasoning behind the number. Instructors credit an answer stated first, with a range, because sales leaders plan on ranges. Explaining the difference between raw and weighted coverage is often the central marking point. Close rates drawn from the team's history, with their limits stated, show care. A stated rule for stale deals is rewarded over silent adjustments. Examining the deal that moves the range shows judgment about where attention should go. Comparing the method with the sellers' roll-up respectfully, and explaining the gap, shows understanding of forecasting as a social process as well as a calculation. Process improvements for future periods show the review aims to make forecasting better, not just to report. Tables should reconcile so the grader can follow every figure.

MT455 Unit 9 help: mistakes that cost points

Weak Unit 9 reviews report raw pipeline and declare the quarter safe because coverage exceeds three. Another frequent problem applies generic stage probabilities rather than the team's history. Stale deals are often ignored or removed without a rule. Students sometimes overrule the sellers' forecast entirely, which a real sales leader would reject. The largest deal is rarely examined on its own. Reviews tend to end with the number and no actions. Before submitting, rebuild your likely figure from the stage table and stale-deal adjustment alone, and check that it matches your opening paragraph. Then identify the single deal whose outcome would move the quarter most, and make sure the review says what someone should do about it this week.

Get an MT455 Unit 9 example written to your instructions

Pipeline data from your Unit 9 case, stages, values and any history of close rates, is what to send, along with the rubric. If the case gives no conversion history, say so, and the assumptions will be stated openly. A custom forecast review with weighted pipeline, both coverage ratios and a range takes 24-48h; your first is free. The paper above is an original model document written by our desk, not a submitted student paper and not an official Purdue University Global document.

More MT455 papers and BS in Business Administration samples

MT455 Unit 9 questions, answered

What is a pipeline coverage ratio?

Open pipeline value divided by the amount still needed to reach target. A ratio of three means the pipeline holds three dollars for every dollar of remaining quota. Many teams treat about three as healthy, but the right figure depends on close rates and deal stages. Comparing raw coverage with weighted coverage shows whether the pipeline is actually sufficient.

Where do stage probabilities come from?

Ideally from the team's own history: of the deals that reached each stage in recent quarters, what share eventually closed. CRM systems often supply default percentages, but those may not match your team's reality. If your case gives no history, state assumed rates and explain them. Graders tend to prefer historical rates with a stated source over unexplained round numbers.

Should the review adjust the sellers' forecast?

The review should test it, not overrule it by decree. Compare the sellers' call with the weighted result, identify where they differ, and ask for evidence on the biggest gaps, such as a dated next step or confirmed budget. Managers usually combine judgment with the weighted method, and explaining how you would reconcile them shows forecasting maturity.

Where can I find a free MT455 Unit 9 sample paper?

The whole MT455 Unit 9 review appears on this page, weighting a composite access control company's pipeline by stage and forecasting the quarter with a range.

Why is weighted coverage only 0.93 in the MT455 Unit 9 sample?

Most of the $15.77 million pipeline sits in qualified and discovery stages that close 12 and 22 percent of the time, so it weights to $4.73 million against $5.09 million needed.