You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Chirag Manocha (JIRA)" <ji...@apache.org> on 2008/05/28 16:17:45 UTC
[jira] Updated: (OFBIZ-194) Implement sales forecast analysis
[ https://issues.apache.org/jira/browse/OFBIZ-194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chirag Manocha updated OFBIZ-194:
---------------------------------
Attachment: mrp.patch
Work done in the patch
Step 1: Through the parameters, searched in Facility entity with facilityID and created a List.
Step 2: Through the List, got one partyId, kept it in parameters with the key organizationPartyId.
Step 3: With the organizationPartyId searched in SalesForecast entity and fetched salesForecastId.
Step 4: Iterate on the list with salesForecastId.
Step 5: Fetched for customTimePeriodId for particular salesForecastId.
Step 6: Searched for customTimePeriodId in CustomTimePeriod entity.
Step 7: Checked thrudate with current date if it is before than current date then go back to step 4 for next salesForecastId.
Step 8: Fetched a list of salesForecastDetailId from SalesForecastDetail entity with salesForecastId.
Step 9: Iterate the list and fetched productId and quantity.
Step 10: Called the method createOrUpdateMrpEvent with parameters(mrpId", mrpId, "productId", productId,
"eventDate", customTimePeriod.getDate("fromDate"), "mrpEventTypeId", "SALES_FORECAST"), and eventQuantityTmp).
> Implement sales forecast analysis
> ---------------------------------
>
> Key: OFBIZ-194
> URL: https://issues.apache.org/jira/browse/OFBIZ-194
> Project: OFBiz
> Issue Type: New Feature
> Components: manufacturing
> Reporter: Jacopo Cappellato
> Assignee: Jacopo Cappellato
> Priority: Minor
> Attachments: mrp.patch
>
> Original Estimate: 120h
> Remaining Estimate: 120h
>
> At the beginning of the simulation process, the MRP algorithm collects information about real purchase orders, sales orders, production runs and stock levels.
> We should add to these the sales forecasts; this issue involves:
> * ui and services to manage (create/edit/delete) sales forcasts
> * mods to the MRP process
> Some of the implementation details (taken from a mail I've recently sent to the user list):
> let's say that your forecast is to sell 10000 t-shirt of type "A" in the next 2 months; the t-shirt "A" are virtual product that are available in two sizes, S and L.
> You would like to simulate (materials and resources needed) the manufacturing process to create 10000 t-shirt of type "A", regardless of their sizes.
> I'd recommend to implement something different:
> 1) introduce the concept of a "family of products"; this could be a special type of Product that is only used as a planning tool; in the example above, you could create a new product of type "family of products" to represent your type "A" t-shirts
> 2) create a bom for your family of products where each component is a variant product; for example: family "A" has two components, the variant product "t-shirt A size S" and "t-shirt A size L"; the bom coefficient is used here to forecast the number of sizes that will be sold (for example, 0.4 for S and 0.6 for L)
> 3) then you'll create one production run for the family "A" of 10000 units with start date in the future; the production run will never be executed (i.e. its components, the variant products, will not be taken from warehouse)
> 4) by running the MRP you'll get a simulation of the materials needed (to manufacture 4000 t-shirt of size S and 6000 t-shirt of size L) and it will generate the *requirements* for them (that once approved will become new production runs for real variant products).
> Comment by Jacopo Cappellato [01/Sep/06 02:59 AM]
> [ Permlink ]
> A follow-up to the above comment to specify some of the design details:
> a) a new product type for the family of products
> b) a new status for the requirements generated from MRP to specify that they are a "simulation"
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.