Generating Reports

The system does not generate forecasts in currency values. However, Detail Forecast Report (22.7.9) lets you review forecast quantities along with the production cost and sales price by month. You must specify the cost set, site, price list, and currency in which to display the monetary amounts.

If both the cost and price are in the same currency, the report displays the profit margin, calculated as price minus cost. The number of units, the extended cost value, and the extended price value are also totaled for the entire 12-month reporting period.

Sample Forecast Report illustrates a sample forecast report, assuming the forecasted item has a unit cost of $15.36 and a unit price of $25.00.


Forecast ID	Year	Item No.	Mo.	Units	Ext Cost	Ext Price	Margin
j205095	2002	j2050	Jan	1336	20,520.96	33,400.00	12,879.04
			Feb	1568	24,084.48	39,200.00	15,115.52
			Mar	1839	28,247.04	45,975.00	17,727.96
			Apr	1970	30,259.20	49,250.00	18,990.80
			May	2182	33,515.52	54,625.00	21,109.48
			Jun	1995	30,643.20	49,875.00	19,231.80
			Jul	2003	30,766.08	50,075.00	19,308.92
			Aug	2134	32,778.24	53,350.00	20,571.76
			Sep	1984	30,474.24	49,600.00	19,125.76
			Oct	1781	27,356.16	44,525.00	17,168.84
			Nov	1634	25,098.24	40,850.00	15,751.76
			Dec	1457	22,379.52	36,425.00	14,045.48
			Total	21883	336,122.88	547,075.00	210,952.12