Cost Based Designing ( Practical I)

Paper Code: 
TJD-202
Credits: 
T 2
Contact Hours: 
45.00
Max. Marks: 
100.00
Objective: 

To understand costing process of jewellery design
To impart in-depth knowledge of manual & computerised cost estimation of jewellery

10.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
     
20.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
     
15.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 Functions 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.

 

Essential Readings: 
  1. The Crafter's Guide to Pricing Your Work - by Dan Ramsey
  2. Gold & Platinum Jewelry Buying Guide by Renee Newman
  • Printer-friendly version
  • PDF version