Summary of the invention
In order to solve above technical matters, the present invention provides a kind of automatic Calculation Method, Apparatus and system of jewellery cost.
The invention discloses a kind of automatic Calculation Method of jewellery cost, comprising:
S1. grasp the essential information parameter of the whole description formula of jewellery of storing and the accounting information parameter of a plurality of reflection valuation composition; Described essential information parameter comprises consumable quantity and corresponding unit price thereof, and described accounting information parameter comprises a plurality of expenses of labour unit prices;
S2. calculate described jewellery cost according to preset formula, formula is following:
M=G×P+∑(L
1+L
2+……L
N)
Wherein, M is the cost of jewellery, is described consumable quantity, and P is the corresponding unit price of described consumptive material, L
1, L
2... L
NBe described a plurality of expenses of labour unit prices, N is a positive integer;
S3. described essential information parameter, accounting information parameter and jewellery cost are generated form and demonstration.
In the automatic Calculation Method of jewellery cost of the present invention, described jewellery cost also comprises stone value cost, and formula is following:
M=G×P+∑(L
1+L
2+……L
N)+∑(K
1×S
1+K
2×S
2+……K
N×S
R)
Wherein, M is the cost of jewellery, is described consumable quantity, and P is the corresponding unit price of described consumptive material, L
1, L
2... L
NBe described a plurality of expenses of labour unit prices; K
1, K
2... K
NFor a plurality of stones are heavy, S
1, S
2... S
RBe the heavy corresponding unit price of a plurality of stones, N, R are positive integer.
In the automatic Calculation Method of jewellery cost of the present invention; Also comprise step S11; Described essential information parameter is generated essential information parameter form automatically and shows that described essential information form comprises the information of the information that must fill out, auxiliary input, the information of computing automatically and alternative information.
In the automatic Calculation Method of jewellery cost of the present invention; Also comprise step S12; The accounting information parameter of described a plurality of reflection valuation compositions is generated a plurality of accounting information parameter forms automatically and shows that described a plurality of accounting information parameter forms comprise: join stone detail list, expenses of labour detail list, quality detail list.
In the automatic Calculation Method of jewellery cost of the present invention, described jewellery comprise gold.
The invention discloses a kind of device of automatic calculating of jewellery cost, comprising:
The parameter placement unit is used to grasp essential information parameter and the accounting information parameter of a plurality of reflection valuation composition of the whole description formula of jewellery of storage; Described essential information parameter comprises consumable quantity and corresponding unit price thereof, and described accounting information parameter comprises a plurality of expenses of labour unit prices;
Jewellery pricing unit links to each other with described parameter placement unit, is used for calculating described jewellery cost according to preset formula, and formula is following:
M=G×P+∑(L
1+L
2+……L
N)
Wherein, M is the cost of jewellery, is described consumable quantity, and P is the corresponding unit price of described consumptive material, L
1, L
2... L
NBe described a plurality of expenses of labour unit prices, N is a positive integer;
Jewellery cost display unit links to each other with described jewellery pricing unit, is used for described essential information parameter, adjusts information parameter and jewellery cost generation form and demonstration.
In the device of the automatic calculating of jewellery cost of the present invention; The device of the automatic calculating of described jewellery cost also comprises essential information parameter report generation unit; Link to each other with described parameter placement unit; Be used for described essential information parameter is generated essential information parameter form automatically and shows that described essential information form comprises the information of the information that must fill out, auxiliary input, the information of computing automatically and alternative information.
In the device of the automatic calculating of jewellery cost of the present invention; The device of the automatic calculating of described jewellery cost also comprises a plurality of accounting information parameter report generations unit; Link to each other with described parameter placement unit; Be used for the accounting information parameter of described a plurality of reflection valuation compositions is generated a plurality of accounting information parameter forms automatically and shows that described a plurality of accounting information parameter forms comprise: join stone detail list, expenses of labour detail list, quality detail list.
In the device of the automatic calculating of jewellery cost of the present invention, described jewellery comprise gold.
The invention discloses a kind of system of automatic calculating of jewellery cost; The storer that comprises the accounting information parameter of essential information parameter that at least one is used to store the whole description formula of jewellery and a plurality of reflection valuation composition; The display that at least one shows described essential information parameter and adjusts information parameter; The controller of at least one interactive information between described storer and described display is characterized in that, described controller has the device of the automatic calculating of above-mentioned jewellery cost.
Automatic Calculation Method, the Apparatus and system of a kind of jewellery cost of embodiment of the present invention have following beneficial technical effects:
Save accountant's cost accounting workload, increase work efficiency;
Make pricing and production procedure irrelevant, improve the ageing of data acquisition;
Make full use of modernized computing machine and information-based advantage, can the computing bore be unified in dissimilar bullion cost accounting;
Save accounting cost and calculate personnel.
Embodiment
By specifying technology contents of the present invention, structural attitude, realized purpose and effect, give explanation below in conjunction with embodiment and conjunction with figs. are detailed.
See also the automatic Calculation Method of Fig. 1, a kind of jewellery cost, comprising:
S1. grasp the essential information parameter of the whole description formula of jewellery of storing and the accounting information parameter of a plurality of reflection valuation composition;
Described essential information parameter comprises consumable quantity and corresponding unit price thereof, and described accounting information parameter comprises a plurality of expenses of labour unit prices.Finish in jewelry production; We can access some shipment information: first adjusts key element: essential information; Such as: version number, refer to cun, quality, loadage, and jewelry join stone information data such as (stone number, jewel kind, unit price, grain number, weight, color, cleanliness, cuts); Adjust key element for second: price of gold, the proportion of goods damageds (proportion of goods damageds can be provided with the loss parameter list separately) are the parameter values that can acquire; Adjust key element for the 3rd: expenses of labour.Expenses of labour can by enterprise be provided with every operation expenses of labour, can be provided with by enterprise and reckon by the piece, the timing expenses of labour, also can produce the back and calculate total expenses of labour and obtain.
Preferably, have step S11, described essential information parameter is generated essential information parameter form automatically and shows that described essential information form comprises the information of the information that must fill out, auxiliary input, the information of computing automatically and alternative information.
Preferably; Has step S12; The accounting information parameter of described a plurality of reflection valuation compositions is generated a plurality of accounting information parameter forms automatically and shows that described a plurality of accounting information parameter forms comprise: join stone detail list, expenses of labour detail list, quality detail list.
Realize principle:
System acquisition many-one relationship definition list structure.Master record is that the integral body of bullion is described attribute.Sublist is respectively: join stone table (diamond detail list), gold material table (quality detail list), expenses of labour table (expenses of labour detail list).Three sub-table reflect jewelry " stone, gold, worker " valuation composition attribute respectively, utilize the interlock computing, calculate gold number, stone value, expenses of labour respectively, thereby accomplish the cost accounting of jewelry.
1, essential information (master record input)
(1) must fill out part: jewellery version number, classification, part are heavy.
(2) auxiliary importation: input " total expenses of labour " then will increase delegation's expenses of labour record automatically in the expenses of labour detail list; " expenses of labour discount " is to calculate the preferential calculating of expenses of labour of dispatching from the factory for reflection; " proportion of goods damageds " are for confirming that gold heavily is to calculate gold number by the weight before the metal loss; " refer to cun " belongs to the description attribute (being meant that product refers to circle number, specification) of product.
(3) automatic arithmetic section:
Clean gold weight=part is heavy-[it is heavy to join stone: and main stone is heavy+and secondary stone weighs+... + secondary stone is heavy] (annotate: the heavy Ct of stone can be converted into g)
Heavy (contain and consume golden the weight)=clean gold of the preceding gold of loss weighs * (the 1+ proportion of goods damageds) (notes: can be called by the system definition attrition table)
Gold number=contain and consume gold weight * price of gold
The stone value=(main stone weight * unit price+secondary stone weight * unit price+... + secondary stone weight * unit price)
Worker's value=(the ∑ expenses of labour is detailed)
Cost price=gold number+stone value+worker's value
Jewellery title=quality+jewel+ornaments name (annotate, generate title automatically :) like 18K gold diamond ring
Color, cleanliness, cut (diamond 3C): from " main stone " attribute of joining stone, obtain automatically, reduce artificial input.
(4) part is filled out in choosing: certificate number, the place of origin, remarks.
S2. calculate described jewellery cost according to preset formula, formula is following:
M=G×P+∑(L
1+L
2+……L
N)
Wherein, M is the cost of jewellery, is described consumable quantity, and P is the corresponding unit price of described consumptive material, L
1, L
2... L
NBe described a plurality of expenses of labour unit prices, N is a positive integer;
S3. described essential information parameter, accounting information parameter and jewellery cost are generated form and demonstration.
Preferably, described jewellery cost also comprises stone value cost, and formula is following:
M=G×P+∑(L
1+L
2+……L
N)+∑(K
1×S
1+K
2×S
2+……K
N×S
N)
Wherein, M is the cost of jewellery, is described consumable quantity, and P is the corresponding unit price of described consumptive material, L
1, L
2... L
NBe described a plurality of expenses of labour unit prices; K
1, K
2... K
NFor a plurality of stones are heavy, S
1, S
2... S
RBe the heavy corresponding unit price of a plurality of stones, N, R are positive integer.
Preferably, described jewellery comprise gold, diamond and mixing ornaments thereof.
See also the device 1 of the automatic calculating of Fig. 2, a kind of jewellery cost, comprising: parameter placement unit 10, jewellery pricing unit 20, jewellery cost display unit 30.
Parameter placement unit 10 is used to grasp essential information parameter and the accounting information parameter of a plurality of reflection valuation composition of the whole description formula of jewellery of storage; Described essential information parameter comprises consumable quantity and corresponding unit price thereof, and described accounting information parameter comprises a plurality of expenses of labour unit prices;
Jewellery pricing unit 20 links to each other with parameter placement unit 10, is used for calculating described jewellery cost according to preset formula, and formula is following:
M=G×P+∑(L
1+L
2+……L
N)
Wherein, M is the cost of jewellery, is described consumable quantity, and P is the corresponding unit price of described consumptive material, L
1, L
2... L
NBe described a plurality of expenses of labour unit prices, N is a positive integer;
Jewellery cost display unit 30 links to each other with jewellery pricing unit 20, is used for described essential information parameter, adjusts information parameter and jewellery cost generation form and demonstration.
The device 1 of the automatic calculating of these jewellery cost also comprises essential information parameter report generation unit 40; Link to each other with parameter placement unit 10; Be used for described essential information parameter is generated essential information parameter form automatically and shows that described essential information form comprises the information of the information that must fill out, auxiliary input, the information of computing automatically and alternative information.
The device 1 of the automatic calculating of these jewellery cost also comprises a plurality of accounting information parameter report generations unit 50; Link to each other with parameter placement unit 10; Be used for the accounting information parameter of described a plurality of reflection valuation compositions is generated a plurality of accounting information parameter forms automatically and shows that described a plurality of accounting information parameter forms comprise: join stone detail list, expenses of labour detail list, quality detail list.
Wherein, join stone detail list (building stones sublist):
Data source here, software can be called and join stone inventory record and accomplish input.Also can the manual input of user join the input service that the stone detail list is joined in the completion of stone Bale No..
Expenses of labour detail list (expenses of labour sublist):
Data here is by accomplishing expenses of labour and calculate being imported the expenses of labour project by the user.Also can design by software from " version number " archives, call the operation expenses of labour settings of this jewellery version number, accomplish the expenses of labour input and calculate.
Quality detail list (golden material for making clothes table):
This sublist is calculated, valuation requirement that can compatible many quality bullion.Such as, the work-in-process costing of 18K gold+this type of Pt950 diamond ring.This table is divided into: main quality and synthetic quality (inferior quality).Software has been given tacit consent to the calculating of main quality automatically when input, the user can add the input of time quality and accomplish input and calculating.
See also the system of the automatic calculating of Fig. 3, a kind of jewellery cost; The storer 100 that comprises the accounting information parameter of essential information parameter that at least one is used to store the whole description formula of jewellery and a plurality of reflection valuation composition; The display 200 that at least one shows described essential information parameter and adjusts information parameter; The controller 300 of at least one interactive information between described storer and described display, controller 300 have the device 1 of the automatic calculating of above-mentioned jewellery cost.
Wherein, Storer 100 can be hard disk; Also can be database; The accounting information parameter typing in advance of essential information parameter and a plurality of reflection valuation composition wherein grabs in the controller 300 through LAN, on display 200, shows calculate the cost of jewellery through the device 1 of the automatic calculating of the jewellery cost in the controller 300 after.
Automatic Calculation Method, the Apparatus and system of a kind of jewellery cost of embodiment of the present invention have following beneficial technical effects:
Save accountant's cost accounting workload, increase work efficiency;
Make pricing and production procedure irrelevant, improve the ageing of data acquisition;
Make full use of modernized computing machine and information-based advantage, can the computing bore be unified in dissimilar bullion cost accounting;
Save accounting cost and calculate personnel.
Combine accompanying drawing that embodiments of the invention are described above; But the present invention is not limited to above-mentioned embodiment, and above-mentioned embodiment only is schematically, rather than restrictive; Those of ordinary skill in the art is under enlightenment of the present invention; Not breaking away under the scope situation that aim of the present invention and claim protect, also can make a lot of forms, these all belong within protection scope of the present invention.