# Generate Projected Production Cost Sheet Report

**YouTube:** [How to Generate Projected Production Cost Sheet Report?](https://www.youtube.com/watch?v=Ql9Yq0eTeUg)

## How to Generate Projected Production Cost Sheet Report?

In this tutorial, we will learn how to generate a **Production Cost Sheet Report** in Logic ERP. This report helps analyze all costs incurred during the complete production cycle, including raw materials, processes, and final product cost.

***

### **Accessing Reports and Configuration**

* Navigate to Production\Production Reports/Queries\Production Raw Material Reports and then select **"Cost Sheet".**
* Click on **Configuration**.
* Create a **new report setup** and enter a suitable **configuration name**.

<figure><img src="/files/fPbaz6YD0DAEtDrOn0KM" alt=""><figcaption></figcaption></figure>

***

### **Set Print Options**

* Under **Print Options**, enable the following based on your requirement:
  * **Transaction Types Totals**
    * Displays totals grouped by each transaction type within a job order.
  * **Job Order Totals**
    * Shows the overall total cost per job order, consolidating all related transaction types.
* Set **Control Break = Job Order Wise**
  * This groups and displays data separately for each job order for a clear cost overview.

<figure><img src="/files/r8Nu4jqhd1Q28Zs9P3ON" alt=""><figcaption></figcaption></figure>

***

### **Configure Report Options**

* In the **Report Options** section:
  * Select the required **Raw Material Rates** from the dropdown (this rate type will be used for cost calculation).
  * Use the **Markup MRP As** option to define how markup MRP rates should appear in the report.
  * In the **Report Order** section, use the arrow buttons to arrange components in the desired sequence for a clean and organized layout.
  * Enable **Quantity Produced Net Cost from Issue** if you want a more detailed cost analysis.

<figure><img src="/files/1UMO0sYLOtTHXYjdPQ43" alt=""><figcaption></figcaption></figure>

* After completing all settings, **save the configuration**.
* Your report setup is now created.

***

### **Generate the Report**

* Click on **Create** to generate the cost sheet report.
* The report will display **all available columns** by default.

<figure><img src="/files/ABZUC2dtr6awixxpJSNz" alt=""><figcaption></figcaption></figure>

***

### **Customize Report Columns**

* Open **Setup Column Attributes**.
* First, **Unselect All** columns.
* Then, select only the columns you want included in the report.
* Rearrange the columns using the arrow buttons for proper sequence.

<figure><img src="/files/uw2PQgStzF8jwuNFm086" alt=""><figcaption></figcaption></figure>

* Save your changes.

***

### **View the Final Cost Sheet**

* Press **F2 (Refresh)** to update the report.
* The refreshed report will now display your customized columns and the latest data.
* This report helps you analyze:
  * Total production cost
  * Raw material consumption cost
  * Process-wise cost
  * Job order–wise production cost
  * Final product cost

<figure><img src="/files/ZvvzsuIjJFsz6XCBSTMG" alt=""><figcaption></figcaption></figure>

It provides a **complete and consolidated view** of all production expenses for the selected period.

***

### **Conclusion**

With these steps, you can easily configure and generate a detailed Production Cost Sheet Report in Logic ERP. This report is essential for understanding cost flow, evaluating profitability, and making informed decisions related to production planning and cost control.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/production/generate-projected-production-cost-sheet-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.