8000 [ADD] Manufacturing: Production analysis report · odoo/documentation@17787e6 · GitHub
[go: up one dir, main page]

Skip to content

Commit 17787e6

Browse files
author
John Holton (hojo)
committed
[ADD] Manufacturing: Production analysis report
closes #10155 Signed-off-by: John Holton (hojo) <hojo@odoo.com>
1 parent 7ecaf74 commit 17787e6

File tree

4 files changed

+164
-0
lines changed

4 files changed

+164
-0
lines changed

content/applications/inventory_and_mrp/manufacturing/workflows.rst

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -17,3 +17,4 @@ Workflows
1717
workflows/allocation
1818
workflows/continuous_improvement
1919
workflows/oee
20+
workflows/production_analysis
Lines changed: 163 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,163 @@
1+
===================
2+
Production analysis
3+
===================
4+
5+
.. |MO| replace:: :abbr:`MO (manufacturing order)`
6+
.. |MOs| replace:: :abbr:`MOs (manufacturing orders)`
7+
8+
The *Production Analysis* report provides statistics about products manufactured using Odoo's
9+
*Manufacturing* app. The report is useful when trying to understand production costs, manufacturing
10+
durations, and other important statistics about manufactured products.
11+
12+
To open the Production Analysis report, navigate to :menuselection:`Manufacturing app --> Reporting
13+
--> Production Analysis`.
14+
15+
.. important::
16+
The :guilabel:`Production Analysis` report is one of many reports available across the Odoo app
17+
suite. This documentation only covers the measures specific to the :guilabel:`Production
18+
Analysis` report, along with a few use case examples.
19+
20+
For a full overview of the basic features available in most Odoo reports, see the documentation
21+
on :doc:`reporting essentials <../../../essentials/reporting>`.
22+
23+
Measures
24+
========
25+
26+
*Measures* are the datasets that can be selected in the :guilabel:`Production Analysis` report. Each
27+
dataset represents a specific statistic about |MOs| in the database. Choose a measure by clicking
28+
the :guilabel:`Measures` :icon:`fa-caret-down` button, and selecting one of the options from the
29+
drop-down menu:
30+
31+
The options displayed in the :guilabel:`Measures` :icon:`fa-caret-down` drop-down menu, and the
32+
order they appear in, differ depending on the filters, groupings, and comparisons enabled in the
33+
:guilabel:`Search...` bar. By default, the available measures appear as follows:
34+
35+
- :guilabel:`Average Employee Cost/Unit`: the average cost paid to employees to produce one unit of
36+
the product.
37+
- :guilabel:`By-Products Total Cost`: the total value of all by-products created by manufacturing
38+
the product.
39+
- :guilabel:`Component Cost/Unit`: the average cost of the components required to produce one unit
40+
of the product.
41+
- :guilabel:`Cost/Unit`: the average cost of producing one unit of the product, including component,
42+
employee, operation, and subcontracting costs.
43+
- :guilabel:`Duration of Operations/Unit`: the average total duration of operations required to
44+
produce one unit of the product.
45+
- :guilabel:`Quantity Demanded`: the total number of units of the product included in |MOs|.
46+
- :guilabel:`Quantity Produced`: the total number of units of the product that have actually been
47+
produced.
48+
- :guilabel:`Total Component Cost`: the total amount spent on the product's components, across every
49+
|MO| for the product.
50+
- :guilabel:`Total Cost`: the total amount spent manufacturing every unit of the product produced so
51+
far.
52+
- :guilabel:`Total Duration of Operations`: the cumulative duration of every operation completed
53+
while manufacturing the product.
54+
- :guilabel:`Total Employee Cost`: the cumulative amount paid to employees to manufacture the
55+
product.
56+
- :guilabel:`Total Operation Cost`: the cumulative amount spent on operations required to produce
57+
the product.
58+
- :guilabel:`Total Operation Cost/Unit`: the average cost of the operations required to produce one
59+
unit of the product.
60+
- :guilabel:`Total Subcontracting Cost`: the cumulative amount paid to subcontractors to produce the
61+
product.
62+
- :guilabel:`Total Subcontracting Cost/Unit`: the average cost of engaging a subcontractor to
63+
produce one unit of the product.
64+
- :guilabel:`Yield Percentage (%)`: the total quantity of the product produced versus the total
65+
quantity demanded, represented as a percentage.
66+
- :guilabel:`Count`: the total count of |MOs| created for the product.
67+
68+
.. tip::
69+
Only one measure can be selected at a time when one of the :icon:`fa-area-chart`
70+
:guilabel:`(graph view)` options is enabled. However, multiple measures, and varying group-by
71+
criteria (on the x and y axes), can be selected when using the :icon:`oi-view-pivot`
72+
:guilabel:`(pivot table)`.
73+
74+
Use case: compare products
75+
==========================
76+
77+
One of the best uses for the :guilabel:`Production Analysis` report is comparing statistics about
78+
two or more products. This is accomplished by entering the products into the :guilabel:`Search...`
79+
bar, then selecting the necessary measure, filter, and grouping, to see the desired data.
80+
81+
.. example::
82+
Toy manufacturer *Tommy's Toys* is trying to reduce their manufacturing operation costs. To
83+
accomplish this, they have decided to identify redundant products and cease manufacturing the
84+
ones with higher operational costs.
85+
6D47 86+
Two of the toys that have been singled out for analysis are the *pogo stick* and *moon shoes*.
87+
Tommy's Toys believes these two toys are so similar that they can stop manufacturing one, without
88+
significantly impacting their product offering.
89+
90+
To compare operation costs for the toys, business analyst Mike opens the
91+
:menuselection:`Manufacturing` app, and navigates to the :guilabel:`Production Analysis` page. In
92+
the :guilabel:`Search...` bar, he enters the names of both products. Then, he opens the
93+
:guilabel:`Search...` bar drop-down menu, and clicks :guilabel:`Product` in the :guilabel:`Group
94+
By` section.
95+
96+
Below the :guilabel:`Search...` bar, Mike clicks on the :guilabel:`Measures`
97+
:icon:`fa-caret-down` drop-down menu, and selects the :guilabel:`Total Operation Cost/Unit`
98+
option. Finally, he selects the :icon:`fa-bar-chart` :guilabel:`(bar chart)` graph type.
99+
100+
With these options selected, the :guilabel:`Production Analysis` report shows a bar chart for the
101+
current year, with one bar for each product, signifying the average operation cost for one unit
102+
of the product.
103+
104+
With this data, Mike is able to see that the average operation cost for the moon shoes is 9E81 almost
105+
twice the cost of the pogo stick. Using this insight, Tommy's Toys decides to cease production of
106+
moon shoes, thus lowering their average cost of manufacturing operations.
107+
108+
.. image:: production_analysis/use-case.png
109+
:align: center
110+
:alt: The bar chart comparing the operation costs of the pogo stick and moon shoes.
111+
112+
Use case: compare time periods
113+
==============================
114+
115+
The :guilabel:`Production Analysis` report can also be used to compare data for two different time
116+
periods. This is accomplished using the options in the :guilabel:`Comparison` section of the
117+
:guilabel:`Search...` bar.
118+
119+
.. example::
120+
Furniture company *Fanny's Furnishings* wants to compare their production costs for the first and
121+
second quarters of 2024, to see which products they spent the most money producing in each
122+
quarter.
123+
124+
To compare the two time periods, shop floor supervisor Adam opens the
125+
:menuselection:`Manufacturing` app, and navigates to the :guilabel:`Production Analysis` page. He
126+
begins by selecting the :icon:`fa-pie-chart` :guilabel:`(pie chart)` graph type option at the top
127+
of the page.
128+
129+
.. important::
130+
The :guilabel:`Comparison` feature is meant to be used with the :icon:`fa-pie-chart`
131+
:guilabel:`(pie chart)` graph type, or the :icon:`oi-view-pivot` :guilabel:`(pivot)` view.
132+
133+
A :guilabel:`Comparison` option can still be selected with the other view types enabled, but
134+
doing so does not change the way data is displayed on the report.
135+
136+
Next, Adam selects the :guilabel:`Total Cost` option from the :guilabel:`Measures`
137+
:icon:`fa-caret-down` drop-down menu. This option displays the total amount spent producing each
138+
product.
139+
140+
In the :guilabel:`Search...` bar drop-down menu, he leaves the :guilabel:`2024` filter enabled in
141+
the :guilabel:`End Date` section, and enables the :guilabel:`Q2` filter as well. With both of
142+
these time periods selected, the pie chart shows data for the second quarter of 2024.
143+
144+
Finally, Adam selects the :guilabel:`End Date: Previous Period` option in the
145+
:guilabel:`Comparison` section of the :guilabel:`Search...` bar. Doing so causes the pie chart to
146+
be split into an inner circle, and an outer ring.
147+
148+
The outer ring shows data for the selected time period, quarter two of 2024. The inner circle
149+
shows data for the previous time period, quarter one of 2024.
150+
151+
.. note::
152+
If :guilabel:`End Date: Previous Year` is selected instead of :guilabel:`End Date: Previous
153+
Period`, the inner circle shows data for the selected time period, one *year* previous.
154+
155+
In the case of this example, it would show data for quarter two of 2023.
156+
157+
Using this report, Adam can see that the products with the highest total cost for quarter two are
158+
the *bicycle* and *tricycle*. On the other hand, in quarter one, the *roller skates* had the
159+
highest total cost.
160+
161+
.. image:: production_analysis/comparison.png
162+
:align: center
163+
:alt: The pie chart view of the Production Analysis report, with a comparison filter enabled.

0 commit comments

Comments
 (0)
0