Jewellery Designing
Published on Jewellery Designing (https://www.jewellery.iisuniv.ac.in)

Home > Cost Based Designing ( Practical )I

Cost Based Designing ( Practical )I [1]

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 [2] - by Dan Ramsey

2.      Gold & Platinum Jewelry Buying Guide by Renee Newman [3]

Academic Year: 
2015-2016 [4]

Footer Menu

  • Univ Home
  • Home
  • Contact Us
  • About Us
  • Site Map
  • Feedback
  • Site Login

Follow Jewellery Designing on:

Facebook Twitter YouTube

IIS (Deemed to be University)

Gurukul Marg, SFS, Mansarovar, Jaipur 302020, (Raj.) India Phone:- +91-141-2400160-61, 2397906-07, Fax: 2395494, 2781158


Source URL: https://www.jewellery.iisuniv.ac.in/courses/subjects/babcombscjewellrey-design-and-technology-3

Links:
[1] https://www.jewellery.iisuniv.ac.in/courses/subjects/babcombscjewellrey-design-and-technology-3
[2] http://www.amazon.com/exec/obidos/ASIN/1558704353/jewlerymall
[3] http://www.amazon.com/exec/obidos/search-handle-url/ref=ntt_athr_dp_sr_1?%5Fencoding=UTF8&search-type=ss&index=books&field-author=Renee%20Newman
[4] https://www.jewellery.iisuniv.ac.in/academic-year/2015-2016