Cost Based Designing

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

Course Objectives:

This course will enable the students to –

  1. Understand costing process of jewellery design.
  2. 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 an 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: 

 BOOKS RECOMMENDED:

 

 

Academic Year: 
2021-2022
  • Printer-friendly version
  • PDF version