The Assignment: A. Using the supplied Excel template, fill in the BOM for the "Jewelry Box project" drawing. B. All of the columns should be filled in for each unit part. Do not leave any columns empty with exemption of the "remarks" column. C. All columns that have a white background are meant for you to type in information. Such as the prepared by, qty, parts per unit, finished sizes, Rough thickness, material, units of measure, waste and price for each part. D. All columns that are shaded light blue will require a calculation (or write a formula to calculate if you are good with spreadsheets) for the rough sizes (length \& width), board footage per unit, board footage with waste, cost per unit, total cost per unit and total cost per run E. Calculate the total cost of this unit and total cost per run. F. Submit a PDF of your BOM to the BOM assignment folder found on e-conestoga/math 1227/course tools/assignments Due date: Beginning of class Dec 6 th, 2021. Late assignments will be deducted 5% per day. If your assignment is more than 5 days late, it will not be graded and you will receive a mark of zero. See the attached rubric for the marking criteria. Information: - The quantity of units will be 5 . - Solid wood waste factor 50% - Sheet goods waste factor 20% - Species of lumber: Black Cherry (4/4)@ \$3.40/bdft - 1/4 Luan @ \$0.56/ sqft (part \#5 only) Math1227 - Excel BOM Assignment Notes: - Ensure you fill in your name in the "prepared by" line. - Include for the lumber allowances for length and width as per standard woodworking practices. - Sheet stock items are cut to finished size (Finished and rough sizes are the same). - All solid parts will use 4/4 material. - Assume 4/4 material for parts 8 to 13 (no resawn parts). - Do not combine any parts in length, width or thickness. - There should be 2 tray support cleats and 2 tray dividers on this project. - The remarks column can be left empty or used to make notes such as "miter 2 ends" or "sheet stock". - Use common abbreviations such as BDFT, SQFT, I will also accept BM for "Board Measure". - Please make sure you double check your measurements (length with the grain, width across the grain) for every part. Formatting: - All text cells to be centered horizontally (middle alignment) - All measurements to be "fraction" up to 2 two digits. - All board foot calculations to be "number" to two decimal places. - All waste figures to be "percent" with zero decimal places. - All dollar values should be "currency" to two decimal places. - Board foot per unit, board foot w/waste, material price, \& cost per unit columns should be alignment right. Marking Your mark will be based on the following criteria: - Correct calculation of total unit cost and total run cost. - Completeness of the BOM - Correct use of rough wood allowances. - Correct formatting. Math 1227 Numerical Woodworking Applications Student: Duanenad Rare The Assignment: A. Using the supplied Excel template, fill in the BOM for the "Jewelry Box project" drawing. B. All of the columns should be filled in for each unit part. Do not leave any columns empty with exemption of the "remarks" column. C. All columns that have a white background are meant for you to type in information. Such as the prepared by, qty, parts per unit, finished sizes, Rough thickness, material, units of measure, waste and price for each part. D. All columns that are shaded light blue will require a calculation (or write a formula to calculate if you are good with spreadsheets) for the rough sizes (length \& width), board footage per unit, board footage with waste, cost per unit, total cost per unit and total cost per run E. Calculate the total cost of this unit and total cost per run. F. Submit a PDF of your BOM to the BOM assignment folder found on e-conestoga/math 1227/course tools/assignments Due date: Beginning of class Dec 6 th, 2021. Late assignments will be deducted 5% per day. If your assignment is more than 5 days late, it will not be graded and you will receive a mark of zero. See the attached rubric for the marking criteria. Information: - The quantity of units will be 5 . - Solid wood waste factor 50% - Sheet goods waste factor 20% - Species of lumber: Black Cherry (4/4)@ \$3.40/bdft - 1/4 Luan @ \$0.56/ sqft (part \#5 only) Math1227 - Excel BOM Assignment Notes: - Ensure you fill in your name in the "prepared by" line. - Include for the lumber allowances for length and width as per standard woodworking practices. - Sheet stock items are cut to finished size (Finished and rough sizes are the same). - All solid parts will use 4/4 material. - Assume 4/4 material for parts 8 to 13 (no resawn parts). - Do not combine any parts in length, width or thickness. - There should be 2 tray support cleats and 2 tray dividers on this project. - The remarks column can be left empty or used to make notes such as "miter 2 ends" or "sheet stock". - Use common abbreviations such as BDFT, SQFT, I will also accept BM for "Board Measure". - Please make sure you double check your measurements (length with the grain, width across the grain) for every part. Formatting: - All text cells to be centered horizontally (middle alignment) - All measurements to be "fraction" up to 2 two digits. - All board foot calculations to be "number" to two decimal places. - All waste figures to be "percent" with zero decimal places. - All dollar values should be "currency" to two decimal places. - Board foot per unit, board foot w/waste, material price, \& cost per unit columns should be alignment right. Marking Your mark will be based on the following criteria: - Correct calculation of total unit cost and total run cost. - Completeness of the BOM - Correct use of rough wood allowances. - Correct formatting. Math 1227 Numerical Woodworking Applications Student: Duanenad Rare