Question: Can you answer question number 7 for me please ? ATV _ Group Project (2) Q Search in Document Home Insert Design Layout References Mailings

Can you answer question number 7 for me please ?


ATV _ Group Project (2) Q Search in Document Home Insert Design Layout References Mailings Review View "+ Share ~ Calibri 11 A AV AV A AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe AaBbCcDdEe Aa BbCcDdEe AaBbCcDdEe Paste B I U abe X2 X2 A & . A . Normal No Spacing Heading 4 Subtle Emph Emphasis Intense Emp... Styles Pane CUSMA Exercise Group Number: Your company manufactures an "All-Terrain Vehicle" (A.T.V.). You have been given the task of deciding whether your A.T.V. qualifies for CUSMA. By examining the Finished Good, the bill of materials and the details of the materials, answer the following questions and/or instructions. Additional Information (All amounts in CAD$): Factory Overhead: $200.00 Labour: $200.00 Selling Price $6,000.00 1. Using Excel - Make a list of Materials. E.g.: Description HS Code Quantity Unit Cost Total Value COC Material 1 Auto Part 8702.11 2 100 $20 China 2. Calculate Net Cost 3. Calculate the Regional Value Content for your A.T.V. Specify whether the good qualifies and why. (Show all formulas and numbers.) 4. If it does not qualify, can you make use of D-Minimis Rule under CUSMA? 5. Which non originating will you use to apply D-Minimis Rule. 6. Make calculations of D-Minimis and new RVC Calculations to prove that the ATV qualifies. 7. Did you use Tariff Change or Regional Value content to make the good qualify? Explain. Page 1 of 1 170 words X English (Canada) + 131%ITA341Groupassignment Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Calibri (Body) * 11 A- A =1 Wrap Text General Insert E . * Delete AP. Paste B IU . A . E Merge & Center $ ~ % ) 00 Conditional Format Cell Formatting as Table Format Sort & Styles Filter B19 X V fx A B D E H K M N O P Q R 1 OUT A WN I Material No. Description HS Code Quantity Unit Cost Total Value COO 1 Wheels 8708.70 $100 $400 India 2 Tires 4011.99 $150 $600 China 3 Automobile Part 8708.99 $400 $400 USA(CUSMA) 4 Automobile Chassis 8706.00 $400 $800 Mexico(CUSMA) 5 Automobile Chassis 8706.00 $800 $800 China 6 Automobile Part 8708.99 $100 $100 USA(CUSMA) 7 Front Assembly 8706.00 $1,000 $1,000 Russia B Automobile Part 8709.99 HHHHH NAA $150 $150 Mexico(CUSMA) 10 Steering Assembly 8708.99 $150 $150 Canada(CUSMA) 11 12 16 $3,250 $4,400 13 2 Calculating Net Cost. 14 15 Net cost = Cost of all materials + Factory Overhead + Labour 16 = $4400 + $200 +$200 17 $4,800 18 Net Cost = $4800 19 20 21 22 32 33 34 35 36 37 Sheet1 + Ready + 100%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
