How to Prepare a Cost Sheet

In the previous chapter, we looked at how costs behave—whether they are fixed, variable, or mixed when production levels change. But knowing how a cost behaves is only half the battle. If you are running a factory, you eventually need to answer one simple, critical question: "Exactly how much did it cost us to make this product?"

You cannot just look at your bank statement to find the answer. Your bank statement shows cash leaving the business, but it doesn't tell you if that cash was spent on raw materials for today's batch of products, rent for next month, or a new machine that will last ten years.

To find the true cost of a product, we need a structured, logical document that gathers every single expense involved in making and selling that product, and arranges them in a specific order. In cost accounting, this document is called the Cost Sheet.

By the end of this chapter, you will understand exactly how to build a cost sheet from scratch. You will learn the five major "stops" on the journey of a product's cost, and you will master the trickiest part of the process: adjusting for leftover stock (inventory) at different stages of production.

What is a Cost Sheet?

Imagine you are giving a factory tour to a visitor. You wouldn't start the tour in the delivery truck, then jump to the raw material warehouse, and then visit the manager's office. You would walk them through chronologically: starting where the raw materials arrive, moving to the factory floor where the machines are running, stepping into the administrative office where the paperwork is done, and finally ending at the dispatch bay where finished goods are sold.

A Cost Sheet does exactly the same thing, but with numbers.

The Cost Sheet is not just a random list of expenses added together. It is a highly structured narrative. It tells the story of how a raw material transforms into a finished product, picking up different types of costs along the way.

Why do we need it?

1. 1To find the total cost and per-unit cost: This is the baseline for everything else.
2. 2To set the selling price: You cannot know what to charge your customers if you don't know what the product cost you to make.
3. 3To control costs: By comparing this month's cost sheet with last month's, a manager can instantly see if factory electricity or office stationery expenses are suddenly spiking.
4. 4To bid for contracts: If the government asks for a tender to supply 10,000 school desks, you use a cost sheet to estimate your expenses and submit a profitable bid.

The Three Types of Inventory (Stock)

Before we look at the format of the cost sheet, we have to address the elephant in the room: Inventory Adjustments. This is where most students get confused, but it is actually very intuitive if you think about it in real-world terms.

When you calculate the cost of goods produced in a specific month (say, March), you only want to include the costs of the materials actually used in March.

If you bought 1,000 kg of raw cotton in March, but only used 800 kg to make shirts, you cannot charge the cost of all 1,000 kg to March's production. The remaining 200 kg is your Closing Stock for March, and it will become your Opening Stock for April.

In a manufacturing business, inventory doesn't just exist in one form. It exists in three distinct stages of completion, and we have to adjust for each of them at different points in the cost sheet.

1. 1Raw Materials (RM): The basic inputs that have not yet been touched by the manufacturing process. (e.g., sheets of wood, unspun cotton, blocks of steel).
2. 2Work-in-Progress (WIP): Goods that are halfway through the manufacturing process. They are no longer raw materials, but they are not yet finished products. They are sitting on the factory floor. (e.g., a chair without legs, a shirt without buttons).
3. 3Finished Goods (FG): Fully completed products that have passed quality control and are sitting in the warehouse, waiting to be sold to a customer.

Think of your refrigerator. If you want to know how many eggs you ate this week:

• You started the week with 2 eggs (Opening Stock).
• You bought a carton of 12 eggs (Purchases).
• At the end of the week, you have 4 eggs left (Closing Stock).
• Eggs consumed = 2 + 12 - 4 = 10 eggs.

We will use this exact logic three times in the cost sheet: once for Raw Materials, once for Work-in-Progress, and once for Finished Goods.

The Five Stages of the Cost Sheet

The cost sheet is built by calculating five major subtotals. Think of these as five checkpoints on a highway.

Let's walk through each stage in detail, exactly as you will write it in an exam.

Stage 1: Prime Cost

Prime Cost is the absolute foundational cost of the product. It consists only of direct costs—the costs that you can easily and specifically trace to a single unit of the product.

To find the Prime Cost, we add three things together:

• Direct Material Consumed
• Direct Labour
• Direct Expenses

Calculating Direct Material Consumed: As we discussed, we don't just look at what we purchased; we look at what we actually used.

• Take the Opening Stock of Raw Materials.
• Add Purchases of Raw Materials.
• Add any Carriage Inwards or Freight Inwards (the transportation cost paid to bring the raw materials to your factory—this is considered a part of the material's purchase cost).
• Subtract the Closing Stock of Raw Materials.
• The result is your Direct Material Consumed.

Once you have the Direct Material Consumed, you simply add the wages paid to the workers who actually make the product (Direct Labour) and any special expenses tied directly to production, like hiring a special machine for a specific job (Direct Expenses).

Stage 2: Factory Cost (or Works Cost)

Now that we have the core direct costs (Prime Cost), we step into the factory. The factory has a lot of general expenses that cannot be traced to one single unit of product, but are absolutely necessary for production. These are Factory Overheads (also called Works Overheads or Production Overheads).

Examples of Factory Overheads include:

• Factory rent and property taxes
• Electricity and power for machines
• Depreciation of factory machinery
• Salary of the factory supervisor or foreman
• Consumables like lubricating oil, cotton waste, and grease

When we add Factory Overheads to the Prime Cost, we get the Gross Factory Cost.

But wait—we are inside the factory. What else lives on the factory floor? Work-in-Progress (WIP). We must adjust for the half-finished goods. We add the Opening Stock of WIP (because we finished working on them this month) and subtract the Closing Stock of WIP (because they are not yet finished and shouldn't be counted in this month's completed factory cost).

• Gross Factory Cost = Prime Cost + Factory Overheads
• Net Factory Cost = Gross Factory Cost + Opening Stock of WIP - Closing Stock of WIP

Stage 3: Cost of Production

The product is now fully manufactured and leaves the factory floor. But the business has other costs. It has an administrative office that handles accounting, legal compliance, management, and general running of the business. These are Office and Administration Overheads.

Examples include:

• Office rent and lighting
• Salaries of accountants, managers, and clerks
• Office stationery and printing
• Depreciation of office computers and furniture
• Legal and audit fees

When we add Office and Administration Overheads to the Factory Cost, we get the Cost of Production.

This figure represents the total cost of manufacturing the goods that were fully completed during this period.

Stage 4: Cost of Goods Sold (COGS)

At this stage, the goods are fully produced and ready to be sold. They are moved to the finished goods warehouse.

But just because we produced 1,000 units this month doesn't mean we sold 1,000 units. We might have sold some units from last month's leftover stock, and we might be keeping some of this month's production in the warehouse for next month.

Because we ultimately want to find the cost of the goods we actually sold (so we can compare it against our sales revenue to find our profit), we must adjust for Finished Goods (FG).

• Take the Cost of Production.
• Add the Opening Stock of Finished Goods (goods produced previously but sold now).
• Subtract the Closing Stock of Finished Goods (goods produced now but kept in the warehouse for later).
• The result is the Cost of Goods Sold (COGS).

Stage 5: Cost of Sales (Total Cost)

We have the cost of the goods we sold, but we haven't accounted for the effort it took to actually sell them. We need to add Selling and Distribution Overheads.

Selling overheads are costs incurred to create demand and get orders. Distribution overheads are costs incurred to deliver the product to the customer.

Examples include:

• Salesmen's salaries and commissions
• Advertising and marketing expenses
• Showroom rent
• Carriage Outwards / Delivery van expenses
• Free samples and catalogs
• Packing charges (secondary packing for transport)

When we add Selling and Distribution Overheads to the Cost of Goods Sold, we arrive at the final destination: the Cost of Sales (also known as the Total Cost).

The Final Step: Profit and Sales

The Cost Sheet usually ends by showing the profit made and the final sales revenue. The formula is simple: Cost of Sales + Profit = Sales

If the problem gives you the Sales figure, Profit is the balancing figure (Sales - Cost of Sales). If the problem gives you a profit percentage, you calculate the profit, add it to the Cost of Sales, and the result is your Sales figure.

Items Strictly Excluded from the Cost Sheet

This is a favorite area for examiners to set traps. A cost sheet only includes costs related to manufacturing, administering, and selling a product. It does not include purely financial expenses, purely financial incomes, or appropriations of profit.

If you see any of the following items in a question, ignore them completely. Do not put them anywhere in the cost sheet:

• Purely Financial Expenses: Interest paid on bank loans, interest on debentures, discount on issue of shares, fines and penalties.
• Purely Financial Incomes: Interest received on bank deposits, dividend received on investments, rent received from letting out a building.
• Appropriations of Profit: Income tax paid, dividends paid to shareholders, transfers to general reserves, donations to charity.
• Abnormal Losses: Loss of materials by fire or theft, abnormal idle time wages. (Normal losses are absorbed into the cost, but abnormal losses are charged directly to the financial Profit & Loss account, not the cost sheet).

Worked Example: Building a Complete Cost Sheet

Let’s put all this theory into practice with a comprehensive numerical example.

The Problem: From the following information provided by Himalaya Manufacturers for the month of March, prepare a Cost Sheet and calculate the total profit.

• Opening Stock of Raw Materials: ₹ 20,000
• Purchases of Raw Materials: ₹ 1,50,000
• Carriage Inwards: ₹ 5,000
• Closing Stock of Raw Materials: ₹ 25,000
• Direct Labour (Wages): ₹ 80,000
• Direct Expenses: ₹ 10,000
• Factory Rent & Power: ₹ 30,000
• Depreciation on Factory Machines: ₹ 15,000
• Opening Stock of Work-in-Progress: ₹ 12,000
• Closing Stock of Work-in-Progress: ₹ 17,000
• Office Salaries & Rent: ₹ 40,000
• Opening Stock of Finished Goods: ₹ 35,000
• Closing Stock of Finished Goods: ₹ 45,000
• Advertising & Salesmen Commission: ₹ 20,000
• Delivery Van Expenses: ₹ 10,000
• Income Tax Paid: ₹ 50,000 (Trap!)
• Sales Revenue: ₹ 4,00,000

The Solution (Step-by-Step):

1. Calculate Direct Material Consumed:

• Opening Stock of RM: ₹ 20,000
• Add: Purchases: ₹ 1,50,000
• Add: Carriage Inwards: ₹ 5,000
• Less: Closing Stock of RM: (₹ 25,000)
• Direct Material Consumed = ₹ 1,50,000

2. Calculate Prime Cost:

• Direct Material Consumed: ₹ 1,50,000
• Add: Direct Labour: ₹ 80,000
• Add: Direct Expenses: ₹ 10,000
• Prime Cost = ₹ 2,40,000

3. Calculate Factory Cost:

• Prime Cost: ₹ 2,40,000
• Add: Factory Overheads (Rent/Power ₹30k + Depreciation ₹15k): ₹ 45,000
• (This gives Gross Factory Cost of ₹ 2,85,000)
• Add: Opening WIP: ₹ 12,000
• Less: Closing WIP: (₹ 17,000)
• Factory Cost = ₹ 2,80,000

4. Calculate Cost of Production:

• Factory Cost: ₹ 2,80,000
• Add: Office & Admin Overheads (Salaries & Rent): ₹ 40,000
• Cost of Production = ₹ 3,20,000

5. Calculate Cost of Goods Sold (COGS):

• Cost of Production: ₹ 3,20,000
• Add: Opening Finished Goods: ₹ 35,000
• Less: Closing Finished Goods: (₹ 45,000)
• Cost of Goods Sold = ₹ 3,10,000

6. Calculate Cost of Sales:

• Cost of Goods Sold: ₹ 3,10,000
• Add: Selling & Distribution Overheads (Advertising ₹20k + Delivery ₹10k): ₹ 30,000
• Cost of Sales = ₹ 3,40,000

7. Calculate Profit:

• Sales Revenue: ₹ 4,00,000
• Less: Cost of Sales: ₹ 3,40,000
• Profit = ₹ 60,000

(Note: The Income Tax Paid of ₹ 50,000 was completely ignored because it is an appropriation of profit, not a cost of production.)

Quick Revision

• Cost Sheet Purpose: A logical, step-by-step statement showing the total and per-unit cost of a product.
• Prime Cost: Direct Material Consumed + Direct Labour + Direct Expenses.
• Direct Material Consumed: Opening RM + Purchases + Carriage Inwards - Closing RM.
• Factory Cost: Prime Cost + Factory Overheads + Opening WIP - Closing WIP.
• Cost of Production: Factory Cost + Office/Admin Overheads.
• Cost of Goods Sold (COGS): Cost of Production + Opening FG - Closing FG.
• Cost of Sales (Total Cost): COGS + Selling & Distribution Overheads.
• Inventory Logic: Raw materials are adjusted at the start, WIP is adjusted in the factory, and Finished Goods are adjusted after production is complete.
• Excluded Items: Never include income tax, dividends, interest on loans, donations, or abnormal losses in a cost sheet.