to impart in-depth knowledge of manual & computerized cost estimation of jewellery
40.00
Unit I:
costing and pricing strategies, objectives & pricing formula
costing of a jewellery piece
wastage
labour cost
determination of profit
selling prices
jewellery purchasing
cost of inputs
40.00
Unit II:
cost-based designing
designing a pendant and earring set for a particular cost-price
designing a ring for a particular cost-price
designing a earring for a particular cost-price
40.00
Unit III:
costing in MS Excel
MS Excel , introduction, spreadsheet, workbooks, saving a file, opening an existing worksheet, rows and columns, cell entries (numbers, labels, formulas)
various tools & functions, filling series, functions and its parts, some useful function in excel (SUM, AVERAGE, COUNT, MAX,MIN, IF). data sort, renaming sheet, printing worksheet.
costing, insert picture, rate of metal & gem stones, labour, wastage, determination of profit and selling price.