the excel sheet is " the cost calculator "

Using the "Cost calculator - Forging" estimate the cost of the ROTOR POLE: 3000 units Carbon and alloy steels - Group B Number of surfaces = 79 Hammer equipment & precision type 5 parts per cycle Hot trimming temperature . 1. Try forging a few rectangular parts that have the same volume, but different ratios. Do they cost the same? Why or why not? 2. Do the slots on the underside add much to the cost? 1. Veach = 0.22385cm 2. # of surfaces (each) = 12 3. Review the cost vs quantity plot. Is the curve smooth? Why or why not? 4. How does part complexity (as measured by number of faces), quantity, and production cost relate? Is the effect larger or smaller than for sand casting? Why? 5. At what production volume does it make sense to start making multicavity dies? 4 (not including time) Number of dessed Analysis of Hot Forging Cost Drivers $8.50 100 Part Information Material Volume Length Part Envel Width Heigh Projected Area of part Perimeter of projected area Area of holes Perimeter of holes Quantity to make Number of surfaces 100% Aluminum-Group 448 cm 15.5 cm 1.5 cm 6 om 54.8 cm 45.4 cm 4.57lom 13. 80 cm 15000 units 71 82 65 50% 40% 50.60 Press Precision So. 50.26 50.15 50.30 50.00 10% FALSE 3003 00 TRUE TRUE FALSE Part Material Proced Die.com Trim Trini Manufacturing Information Video Scale loss for material Equipment type for forging Forging type Processing cost per operation of a 1000lb hammer Part is bent Parting lines flat There are side depression There is a dielock Number of parts made perde Operating cost Angle of the folders to the die face Density of tool steel Price of tool steel Multicavity Index Die manufacturing pay rate Basic resink quantity Number of resinks possible Trimming factor of safety Yield stress of tool steel Trimming temperature Direct Part Cost vs Quantity $30.000 $85 / 15 degrees 7.83 cm $20 g 0.7 SAS /h 40000 S1000 The plotted line includes consideration of optimal number of party de Cost Parti $100 15% $10 97 Mpa Hot Current 31 1 10 100000 100 1000 Production Quantity Solution Using the "Cost calculator - Forging" estimate the cost of the ROTOR POLE: 3000 units Carbon and alloy steels - Group B Number of surfaces = 79 Hammer equipment & precision type 5 parts per cycle Hot trimming temperature . 1. Try forging a few rectangular parts that have the same volume, but different ratios. Do they cost the same? Why or why not? 2. Do the slots on the underside add much to the cost? 1. Veach = 0.22385cm 2. # of surfaces (each) = 12 3. Review the cost vs quantity plot. Is the curve smooth? Why or why not? 4. How does part complexity (as measured by number of faces), quantity, and production cost relate? Is the effect larger or smaller than for sand casting? Why? 5. At what production volume does it make sense to start making multicavity dies? 4 (not including time) Number of dessed Analysis of Hot Forging Cost Drivers $8.50 100 Part Information Material Volume Length Part Envel Width Heigh Projected Area of part Perimeter of projected area Area of holes Perimeter of holes Quantity to make Number of surfaces 100% Aluminum-Group 448 cm 15.5 cm 1.5 cm 6 om 54.8 cm 45.4 cm 4.57lom 13. 80 cm 15000 units 71 82 65 50% 40% 50.60 Press Precision So. 50.26 50.15 50.30 50.00 10% FALSE 3003 00 TRUE TRUE FALSE Part Material Proced Die.com Trim Trini Manufacturing Information Video Scale loss for material Equipment type for forging Forging type Processing cost per operation of a 1000lb hammer Part is bent Parting lines flat There are side depression There is a dielock Number of parts made perde Operating cost Angle of the folders to the die face Density of tool steel Price of tool steel Multicavity Index Die manufacturing pay rate Basic resink quantity Number of resinks possible Trimming factor of safety Yield stress of tool steel Trimming temperature Direct Part Cost vs Quantity $30.000 $85 / 15 degrees 7.83 cm $20 g 0.7 SAS /h 40000 S1000 The plotted line includes consideration of optimal number of party de Cost Parti $100 15% $10 97 Mpa Hot Current 31 1 10 100000 100 1000 Production Quantity Solution