Objectives:
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
Introduction, spreadsheet, workbooks, saving a file, opening an existing worksheet, Rows and columns, cell entries (numbers, labels, formulas),
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.