- Costing and Pricing Strategies, Objectives & Pricing formula : 10 Hrs.
- Costing of a Jewellery Piece
- Wastage
- Labour Cost
- Determination of Profit
- Selling Prices
- Jewellery Purchasing
- Cost of inputs
- Cost-Based Designing: 20 hrs
- 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
- Costing in MS Excel 5hrs
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 Functions in excel (SUM, AVERAGE, COUNT, MAX, MIN, IF) .Data sort, Renaming sheet, Printing worksheet.
Insert Picture, Rate of Metal & Gem stones, Labour, Wastage, Determination of Profit and selling price.