Cost Based Designing ( Practical )I

Paper Code: 
TJD 202
Credits: 
3
Contact Hours: 
45.00
Max. Marks: 
100.00
Objective: 
  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: 
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: 
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: 
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

Academic Year: