How to Prepare an Estimated Cost Sheet for Future Planning

Before a manufacturer commits to producing a single unit, one fundamental question must be answered: What will it cost? This is exactly where an estimated cost sheet becomes indispensable. Unlike a historical cost sheet – which records expenses after production – an estimated cost sheet is prepared before production begins, using anticipated figures for materials, labor, and overheads. It gives management the financial foresight needed to quote competitive prices, submit tenders, and plan for profitability – all before a single machine is switched on.

What is an estimated cost sheet? 🔗

An estimated cost sheet is a forward-looking statement that predetermines the cost of a product yet to be manufactured. According to GeeksforGeeks, the estimated cost sheet is based on anticipated costs and is prepared just before production, with management using it to quote prices in advance or while submitting tenders for goods to be supplied. It predetermines the cost of direct materials, direct labor, and overheads based on past costs, present market conditions, and anticipated changes in future price levels.

In simpler terms, it takes what you know from past records, adjusts for what you expect to happen – a rise in raw material prices, a change in wage rates – and produces a projected cost figure that management can act on. As Economics Discussion explains, the production cost sometimes needs to be ascertained before commencing the actual production work, particularly when a manufacturer is required to quote an estimated price for receiving customer orders.

Why does management need an estimated cost sheet? 🔗

The primary driver for preparing an estimated cost sheet is price quotation. Manufacturers regularly receive requests to submit tenders or quotations – from government departments, corporations, or private buyers – and they must respond with a price before any production takes place. eGyanKosh (IGNOU) notes that every company needs to know its quotation prices well in advance in order to submit a competitive tender, and an estimated cost sheet helps management anticipate the prices of the products to be manufactured.

Beyond tenders, estimated cost sheets support broader management goals:

• Price fixing: Zoho Books points out that cost sheets are central to fixing the selling price of a product – management cannot determine a profitable selling price without first knowing the estimated cost of production.
• Profit planning: By adding a desired profit margin on top of the total estimated cost, management can set a quotation price that aligns with its financial targets.
• Decision-making: The cost data generated helps in making informed choices about purchasing raw materials, production volumes, and whether to accept or decline a contract.
• Cost control: Even before production starts, the estimated cost sheet acts as a benchmark. Any significant deviation from these estimates during actual production signals a need for corrective action.

Components of an estimated cost sheet 🔗

The structure of an estimated cost sheet follows the same logical flow as any standard cost sheet, moving from raw inputs to the final quoted price. Each layer builds on the previous one.

1. Prime cost 🔗

Prime cost forms the foundation of the entire cost sheet. It is the sum of direct material cost, direct labor (wages), and any direct expenses. Zoho Books defines it as the aggregate of the price of material consumed, the wages involved in production, and the direct expenses – also called basic cost, first cost, or flat cost.

Prime Cost = Direct Materials + Direct Wages + Direct Expenses

In an estimated cost sheet, direct material cost is projected based on expected procurement prices and consumption rates. Direct wages are estimated using current or anticipated wage rates. If raw material prices are expected to rise by 10% in the coming period, that adjustment is built in at this stage.

2. Factory (works) cost 🔗

Factory cost is obtained by adding factory overheads to the prime cost. Factory overheads include indirect wages, factory rent, power, depreciation of machinery, and other manufacturing expenses that cannot be directly traced to a specific product. Since these cannot always be precisely predicted, they are absorbed using a predetermined absorption rate – such as a percentage of direct wages, a percentage of direct materials, or a machine hour rate.

Factory Cost = Prime Cost + Factory Overheads

As noted in BBA cost accounting materials, works overhead is typically charged as a percentage of direct wages, derived from the previous year’s records and adjusted for expected changes.

3. Cost of production (office cost) 🔗

Administration overheads – such as management salaries, office rent, and general administrative expenses – are added to the factory cost to arrive at the cost of production. These are usually absorbed as a fixed percentage of works cost, again based on historical data.

Cost of Production = Factory Cost + Office & Administration Overheads

4. Total cost (cost of sales) 🔗

Selling and distribution overheads – including advertising, sales commissions, delivery expenses, and after-sales costs – are added to the cost of production to arrive at the total cost, also called the cost of sales.

Total Cost = Cost of Production + Selling & Distribution Overheads

5. Profit and tender/quotation price 🔗

Once the total estimated cost is determined, management adds a desired profit margin to arrive at the tender price or quotation price. As Your Article Library explains, estimated cost is increased by the desired profit to ascertain the tender price or quotation. This profit may be expressed as a percentage of cost or as a percentage of the selling price – the two give different absolute values, so it is important to specify which basis is being used.

Tender Price = Total Estimated Cost + Desired Profit

How past data is used and adjusted for the future 🔗

One of the defining features of an estimated cost sheet is how it blends historical figures with forward-looking adjustments. EduRev’s cost accounting notes explain that in ascertaining expected costs, the items from previous cost periods are considered with due regard to expected changes in the future. So the process is not guesswork – it is a structured, evidence-based projection.

Here is how typical adjustments work in practice:

• Material cost: If raw material prices are expected to increase by 15% due to supply chain pressures, the historical material cost per unit is inflated by that percentage in the estimate.
• Labor cost: An anticipated wage revision or increase in productive hours is factored into the direct wages figure.
• Fixed overheads: Since fixed overheads do not change with production volume, the per-unit overhead cost changes when production volume changes. If output is expected to rise, fixed costs spread over more units, reducing the per-unit cost.
• Variable overheads: These are adjusted proportionally based on the expected level of activity.

Overhead absorption rates themselves are typically calculated from the previous period’s records. For instance, if factory overheads were 22% of direct wages last year, and no significant change is expected, that 22% rate is applied to the estimated wages in the new cost sheet.

Estimating the tender price: a worked example 🔗

Consider a manufacturing company that produced a product last year with the following actual costs per unit: direct materials ₹20,000, direct wages ₹12,000. From those records, factory overheads were 22% of wages, and office overheads were approximately 6.66% of factory (works) cost. For the next period, the company needs to quote a tender price while targeting a profit of 25% on cost.

The estimated cost sheet would look like this:

This clean, layered build-up – from prime cost through to the final quoted price – is the essence of an estimated cost sheet. It gives the manufacturer confidence that the quoted price covers all costs and delivers the targeted profit margin.

Key considerations when preparing an estimated cost sheet 🔗

Profit calculation: on cost vs. on selling price 🔗

A critical point in preparing an estimated cost sheet is how profit is expressed. If profit is stated as a percentage of cost, the base is the total cost. If it is stated as a percentage of selling price, the selling price is treated as 100, and cost is derived as the balance. Intactone’s accounting resources set out the distinction clearly: Tender Price = Direct Cost + Indirect Cost + Profit Margin, where the profit margin basis must be explicitly stated to avoid miscalculation.

Market competition and pricing strategy 🔗

The estimated cost sheet is not prepared in a vacuum. Tata nexarc’s tendering guide highlights that pricing should be competitive enough to win the bid while remaining sustainable for the business – the lowest bid does not always win. Buyers assess quality standards, certifications, and credibility alongside price. This means the profit margin added in the estimated cost sheet must reflect both the business’s financial needs and the competitive landscape.

Accuracy of overhead absorption rates 🔗

Since overheads are not directly traceable to products, they are absorbed using rates derived from past data. If those rates are outdated or based on an atypical period, the estimated cost sheet will be inaccurate. GeeksforGeeks notes that while preparing an estimated cost sheet, management must analyze past data related to cost, current market conditions, and price trends to ensure that assumptions are grounded in the current operational reality.

Treatment of fixed vs. variable costs 🔗

Fixed costs – such as factory rent, insurance, and depreciation – remain constant regardless of output volume. When the estimated production volume changes, only the per-unit fixed cost changes, not the total. Variable costs like raw materials and direct labor move in proportion to output. Keeping this distinction clear prevents over- or under-costing in the estimate, which can make a significant difference in competitive tender submissions.

Estimated cost sheet vs. historical cost sheet 🔗

It helps to understand how the two types differ in purpose and timing:

As Akounto’s accounting blog notes, estimated cost sheets are widely used in service industries and construction businesses where contract revenue is determined based on projected costs, and can also be prepared before the start of a business based on accurate data collected by the concerned department.

Role in financial planning and market competitiveness 🔗

An estimated cost sheet is not merely a pricing tool – it is a planning instrument. When management regularly prepares estimated cost sheets, it builds a discipline of forward thinking into the financial planning process. By projecting costs before committing to production, businesses can identify potential cost pressures early, adjust their sourcing or production methods proactively, and avoid the trap of under-quoting on contracts – which erodes profitability – or over-quoting, which costs them the business altogether.

For industries where contracts are won through competitive bidding – construction, manufacturing supply chains, government procurement – the quality of the estimated cost sheet directly determines market competitiveness. A well-prepared estimate that accurately anticipates future costs and builds in a realistic profit margin gives the business the best chance of submitting a winning, sustainable bid. EnKash points out that a cost sheet assists businesses in undertaking cost reduction and price optimization measures, increasing profitability – and this is equally true of the estimated variant used in forward planning.

What do you think? If material costs are expected to rise significantly before a tender deadline, how should a manufacturer balance competitiveness with the need to protect profit margins? And to what extent should a business rely on past overhead rates when market conditions are changing rapidly?

References

1. https://www.zoho.com/books/academy/accounting-principles/cost-sheet.html
2. https://www.geeksforgeeks.org/cost-sheet-meaning-importance-types-components-format-example/
3. https://www.economicsdiscussion.net/cost-accounting/cost-sheet/32626
4. https://www.egyankosh.ac.in/bitstream/123456789/104840/1/Unit%2010.pdf
5. https://www.studocu.com/in/document/university-of-calicut/bachelor-of-business-administration/cost-sheet-tenders-and-quotation-with-examples-and-solutions-bba-notes/47396490
6. https://www.yourarticlelibrary.com/cost-accounting/quotations/how-to-calculate-tender-price-or-quotations/58075
7. https://edurev.in/t/114941/Calculation-of-Tender-or-Quotation-Overheads–Cost
8. https://intactone.com/preparation-of-cost-sheet-and-tender-price-calculation-of-tender-quotation-and-estimated-price/
9. https://blog.tatanexarc.com/tenders/price-calculation/
10. https://www.akounto.com/blog/cost-sheet
11. https://www.enkash.com/resources/blog/cost-sheet-meaning-types