Resolve Pricing Workbook Uncertainty Before Submission

A pricing workbook puts figures into a familiar grid, yet a figure without a source leaves a proposal exposed. A rate, volume, month, or total rests on an assumption about delivery or commercial treatment. The proposal lead brings those assumptions into view early. Finance needs a route for arithmetic and pricing treatment. Delivery needs space to test staffing, travel, timing, and scope against planned work. Commercial approval needs context rather than a total with no explanation.

Start with a clean copy of the buyer workbook. Preserve tab names, labels, formulas, locked areas, and stated instructions. Create a working note beside the file. For every priced line, record source, owner, current status, and related request section. A source might be a buyer schedule, approved internal rate material, a formal buyer answer, a supplier quotation, or a delivery estimate. Ownership means a named person brings source material, explains an assumption, and routes an unresolved point. Ownership does not mean silent authority to choose a figure.

Read the request beside the workbook. Mark scope, pricing format, optional work, expenses, currency, service period, extensions, and submission rules. Then connect each relevant sentence to a workbook tab, row, or cell range in your note. Suppose a fictional request calls for a twelve month service period and supplies four quarterly columns. The delivery lead needs to state whether staffing stays constant, whether onboarding changes effort, and whether a final month creates a handover task. Finance needs to inspect formulas across every quarter. A mapping note turns a vague concern into work someone owns.

Separate facts from assumptions. A fact comes from a named record. An assumption fills a gap after review. Write both in direct language. “Buyer schedule states 400 requests per month” identifies a fact. “Pricing uses steady monthly volume from January through December” identifies an assumption. A reviewer seeing both statements has material for a decision. A reviewer seeing only a total has no route to judge volume, timing, or scope.

Inspect blank cells with equal care. An empty expense field might mean expense belongs inside a fee, belongs elsewhere, or stays at zero. An empty rate field might signal a fixed fee. A zero result might hide an empty quantity cell. Trace formulas row by row. Check copied references, percentage bases, period totals, and subtotals. Finance should review calculations after an initial source check. A fresh reader often finds a reference moved one row during a copy action.

Use a question log from your first pass. Each entry needs request section, workbook location, issue, decision impact, proposed wording, owner, and deadline. Describe a gap without arguing for a preferred result. “Travel treatment is absent from pricing instructions” gives the buyer a direct question. “Please approve travel as extra” asks for a commercial outcome before buyer intent is known. Where delivery and finance read an issue differently, record both internal views and send one neutral question through the authorized process.

Build an operating schedule from the question deadline. In a fictional schedule, buyer questions close Tuesday at 3:00 p.m. Plan internal issue review before noon Monday. Leave a separate block for delivery, finance, and commercial review. An item with no answer needs a reviewed fallback before submission. Follow available instructions and approved terms. Do not hide uncertainty in an unexplained total. Where assumptions are permitted, state one in plain words and make each affected formula follow from those words.

Here is a fictional practice situation. Proposal lead Lien reviews a support workbook. The travel row is blank. Finance lead George says, “Put in an estimate and move on. We need a total for today’s review.” Lien opens the expense section and finds no travel direction. She says, “There is no direction for fixed fee treatment, a separate price line, or zero travel. Each route changes delivery planning and approval. I am logging a question and preparing two internal views for review.” George asks what he needs. Lien requests an expected site visit estimate from delivery, an approved treatment view from commercial, and a question submission date.

Lien writes, “Please confirm requested treatment of travel related to on site work. Should respondents include travel within a fixed fee, enter travel as a separate priced item, or exclude travel from the response?” She sends no speculative amount. Her note labels one view “fixed fee includes planned travel” and another “travel excluded pending buyer direction.” Each view names a delivery assumption and a formula range. The commercial reviewer sees a decision with visible consequences rather than a vague estimate.

Buyer answers do not always resolve every issue. Suppose buyer reply says, “Price according to workbook.” Lien returns to workbook instructions, related request language, and formal response record. No travel field appears and no instruction permits another line. She documents a reviewed assumption in proposal records and avoids adding a new pricing structure. Her narrative uses direct language about any permitted assumption. A buyer reader and internal reviewer should both trace price treatment from source through calculation.

Before upload, reconcile the workbook against cover material, approval record, and any price narrative. Check currency, units, period count, rate labels, decimals, optional work, and clarification changes. Ask delivery to read assumptions as operational commitments. Ask finance to verify formula paths and totals. Ask commercial approval to review departures from ordinary treatment. Each review serves a separate decision, so avoid a rushed meeting where responsibility fades into group agreement.

Save the question log, buyer answers, notes, and approved workbook together under the proposal record. Label drafts by date and review status. Before upload, open the exact selected file. Compare version date, tab count, and total against the approved copy. Inspect hidden rows, comments, and displayed formula values. Follow buyer file naming and portal instructions.

Continue Lien’s fictional exercise after George returns delivery’s estimate. She updates both price views, marks every changed cell, and brings a one page decision note to commercial review before Tuesday noon. After reviewer direction, she enters only supported amounts, traces each subtotal, and opens the selected upload file for a final comparison with her approved total.