Cost Based Designing

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

Objectives:

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

 

 

10.00
Unit I: 
Costing and Pricing Strategies, Objectives & Pricing formula
  1. 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
  1. 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
  1. 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.

 

References: 
  1. The Crafter's Guide to Pricing Your Work - by Dan Ramsey
  2. Gold & Platinum Jewelry Buying Guide by Renee Newman

 

Academic Year: 
2014-2015
  • Printer-friendly version
  • PDF version