The owners want to understand the total dollar amount of customs duty they will owe the U.S. government for the year. They have asked you to perform descriptive analytics to understand the purchases from vendors located in each country. Your company makes purchases from vendors located in several countries, such as China, Mexico, the United States, Japan, South Africa, Israel, Greece, and Egypt. You and your team have designed a data analysis strategy. You have been asked to consider the risks and related controls in the development of that strategy. Complete the following chart.

Automated Transportation, Inc. is a medium-sized manufacturer of remote-controlled cars, boats, and drones. The company was established five years ago when two brothers decided to build and sell remote control cars to enthusiasts. As the company grew, they expanded their product offerings to include remote control cars, boats, and drones. The brothers serve as the president and CEO of the company, and they now have over 70 employees. They have two key customer groups, hobbyists and businesses interested in incorporating drones into their business process and supply chain. These two customer bases provide a variety of opportunities for growth. Management values internal control, but since they are busy running the company they have employed accounting personnel to help design the company's processes, policies, and internal controls: \begin{tabular}{|c|c|c|} \hline Data Field Label & Field Name in Datahase & Field Description \\ \hline Invoice number & InvoiceNO & \begin{tabular}{l} The invoice number, which is hand-keyed into the ALs by the AP derk \\ from a manual imvoice mailed to the campany by the wendor. \end{tabular} \\ \hline Invoice arount & tnvoiceAmt & \begin{tabular}{l} The amount of the invoioe, which is hand-keyed into the AIS by the AP derk \\ from a manual imvoice mailed to the company by the vendor. \end{tabular} \\ \hline Shioment date & ShipDate & The date the product was shipped from the shipping location. \\ \hline Invoice date & InvaiceDate & \begin{tabular}{l} The date of the invoice, which handkeyed into the AIS by the AP clerk \\ from a manual invoice mailed to the compony by the vendor. \end{tabular} \\ \hline Vender identication number & VendoriD & Unique vendor identication number. \\ \hline Vendor name & VendorName & Name of the vendor. \\ \hline Product purchased & Product:D & \begin{tabular}{l} Product code for the product purchased from the vendor. This product code \\ is consistert with the cotalog from the vendor. \end{tabular} \\ \hline Unit cost & UnitCost & The cost per unit of the product purchased from the vendor. \\ \hline Shoping cost & Shipcost & Total shipping costs. \\ \hline Flat duty & Flatouty & The flat duty rate applies to article that are dutiable. \\ \hline Tariff & Tariffant & The total dollar amount of a tariff applied to the goods shipped. \\ \hline Shioping location & Shiplocation & The couritry in which the goods are shipped from. \\ \hline Payment terms & PeymentTerma & \begin{tabular}{l} The agreed-cpon payment terms with the vender. These terms are negotiated by the \\ purchesing maneger end keyed into the vendor master file by the purchasing supervisar. \end{tabular} \\ \hline Shipping terma & ShipTerms & Shipping terma-typically FOB deatination or FOB shipping. \\ \hline Payment address & PoyAddress & The vendors address where paymert is to be mailed. \\ \hline Purchase order number & PONumber & The unique identifying number assigned to each purchese order issued by the company. \\ \hline Purchasa arder date: & poDate & The date the purchase order is issued by the campary. \\ \hline Receiving report number & ReceivingNumber & The unique identifying number assigned to each receiving report created by the company's receiving qroup. \\ \hline Receiving report date & ReceivingDate & The date the product is received by the company's receiving department. \\ \hline Quantity received & QtyReceived & The total quanity of items received. \\ \hline Quant ty purchased & Qtypurchased & The total quantity of items on the Purchase Order. \\ \hline Invoiced quantity & QtyInvoice & \begin{tabular}{l} The total quartity of items on the invoice, this amount is hand keved into the \\ AIS by the AP clerk from the manual imvoice mailed to the company by the vend \end{tabular} \\ \hline Treasurer Approval & Approved & The initials of the Treasurer indicating their aporoval if the invoice was greater th \\ \hline \end{tabular}