Posted: May 14th, 2015
Cost Sheet Project
Initial Cost Sheet Project:
You are estimating the cost of a 500 piece order for girls dresses. This is a small run for a test of this new style available online only.
Fill In the Cost Sheet here: this one has Excel formulas built in, so be sure to use this document. Cost Sheet_With Formulas.xlsx
Use the below data to start filling in your initial cost sheet.
Description: Girls Victorian-Style Party Dress with Collar and Bow
Date: May 1, 2015
Style #: 10926
Size Range: XS, S, M, L, XL
Size Scale: 1-2-3-3-3
Fabric Mill: FabriCo, Taiwan
Manufacturer: Calanco, Hong Kong
Fabric Width: 36 Inches
Estimated Marker Yardage: 24 Yards
Material: Printed Broadcloth, ____ yards, cost $1.48 per yard after shipping from Taiwan to Hong Kong.
NOTE: The yardage for one garment is determined by estimating the total yardage for a one-dozen run and then dividing by 12. So 24 total yards /12 pieces = _____ yards for one garment, which is entered in the cost sheet
Lining: Each collar uses 0.25 yards at $1.19 per yard
Zipper: Each dress uses 1 zipper at $0.12 each
Bow: Each dress uses 2.5 yards of trim for the bow at $0.54 per yard
Marking and Grading Costs are combined. They are listed as $285.00 based on a 500 piece minimum order.
NOTE: This means to divide $285.00/500 to determine the cost for one piece.
Cutting costs: $175.00 based on a 500 piece minimum order
NOTE: This means to divide $175.00/500 to determine the cost for one piece.
Construction costs: $48 per dozen Note: this is for all 12; calculate what is it for one: $48/12
Hangtag: $0.10 per hangtag
Brand Label: $0.12 per label
Care Label: $0.06 per label
Hanger: $0.34 per hanger
Duties/Shipping Costs: Quoted as combined: $1.05 per garment
Wholesale price: $15.00
Retail price: $30.00
Question: Based on this data to see if the Margin for this dress for Kelly B. Designs, will be over 30%. If not, how could pricing be improved? When you upload your Excel sheet, add this info in the comments section.
Kelly B. Designs
Cost Sheet
Sketch/Fabric Swatch
Date: Style Number:
Description:
Fabric Mill:
Manufacturer:
Size Range:
Size Scale:
Fabric Width:
Estimated Marker Yardage:
Actual Marker Yardage:
MATERIALS
Yardage Price Per Yard Total Ammount
Fabric $0.00
Fabric $0.00
Lining $0.00
Total Cost of Materials: $0.00
TRIMS
Ammounts Cost Per Piece Total Ammount
Buttons $0.00
Zippers $0.00
Belts $0.00
Other $0.00
Total Cost of Trims: $0.00
LABOR
Costs
Marking + Grading
Cutting
Construction
Other
Total Cost of Labor: $0.00
PACKAGING
Costs
Hangtag
Brand Label
Care Label
Packaging/Hanger
Total Cost of Packaging: $0.00
SHIPPING & DUTY
Costs
Duties + Shipping
Total Shipping Costs: $0.00
Total Cost of Goods: $0.00
To Be Filled out by Product Manager:
In USD Margin %
Suggested Wholesale Price: #DIV/0!
Suggested Retail Price: #DIV/0!
Cost Sheet Project
Initial Cost Sheet Project:
You are estimating the cost of a 500 piece order for girl’s dresses. This is a small run for a test of this new style available online only.
Fill In the Cost Sheet here: this one has Excel formulas built in, so be sure to use this document. Cost Sheet_With Formulas.xlsx
Use the below data to start filling in your initial cost sheet.
Description: Girl’s Victorian-Style Party Dress with Collar and Bow
Date: May 1, 2015
Style #: 10926
Size Range: XS, S, M, L, XL
Size Scale: 1-2-3-3-3
Fabric Mill: FabriCo, Taiwan
Manufacturer: Calanco, Hong Kong
Fabric Width: 36 Inches
Estimated Marker Yardage: 24 Yards
Material: Printed Broadcloth, ____ yards, cost $1.48 per yard after shipping from Taiwan to Hong Kong.
[NOTE: The yardage for one garment is determined by estimating the total yardage for a one-dozen run and then dividing by 12. So 24 total yards /12 pieces = _____ yards for one garment, which is entered in the cost sheet]
Lining: Each collar uses 0.25 yards at $1.19 per yard
Zipper: Each dress uses 1 zipper at $0.12 each
Bow: Each dress uses 2.5 yards of trim for the bow at $0.54 per yard
Marking and Grading Costs are combined. They are listed as $285.00 based on a 500 piece minimum order.
[NOTE: This means to divide $285.00/500 to determine the cost for one piece.]
Cutting costs: $175.00 based on a 500 piece minimum order
[NOTE: This means to divide $175.00/500 to determine the cost for one piece.]
Construction costs: $48 per dozen [Note: this is for all 12; calculate what is it for one: $48/12]
Hangtag: $0.10 per hangtag
Brand Label: $0.12 per label
Care Label: $0.06 per label
Hanger: $0.34 per hanger
Duties/Shipping Costs: Quoted as combined: $1.05 per garment
Wholesale price: $15.00
Retail price: $30.00
Question: Based on this data to see if the Margin for this dress for Kelly B. Designs, will be over 30%. If not, how could pricing be improved? When you upload your Excel sheet, add this info in the comments section.
Place an order in 3 easy steps. Takes less than 5 mins.