Cost Sheet Project

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.