Question
Currently, Fluffys salespeople are responsible for creating and sending orders to customers. All salespeople have access to the Excel file that contains the sales tax
Currently, Fluffys salespeople are responsible for creating and sending orders to customers. All salespeople have access to the Excel file that contains the sales tax rates for each state. They use that information to manually determine the sales tax of an order and enter it in the accounting system. An illustration of a table titled, Sales Tax Rate, consists of two columns. The column headers are: State; and Sales Tax Rate. The data from the table are presented as follows: State, Connecticut; Sales Tax Rate, 6.35;State, Delaware; Sales Tax Rate, Non Applicable; State, Hawaii; Sales Tax Rate, 4.17;State, Kentucky; Sales Tax Rate, 6;State, Maryland; Sales Tax Rate, 6;State, Michigan; Sales Tax Rate, 6;State, Rhode Island; Sales Tax Rate, 7. At the end of each week, Fluffys accounting system generates a list of all orders called Sales Orders. As Fluffys accountant, you must collect sales taxes and remit them to applicable states. You must check whether the sales tax amounts are accurate. A sample with ten orders from the sales orders file is shown next. An illustration of a table titled, Sales Order, consists of four columns. The column headers are: Order Number; Amount; Sales Tax; and State. The data from the table are presented as follows: Order Number, 1; Amount, $791; Sales Tax, $47.46; State, K Y;Order Number, 2; Amount, $88; Sales Tax, $12.03; State, R I; Order Number, 3; Amount, $231; Sales Tax, $14.67; State, C T;Order Number, 4; Amount, $3,488; Sales Tax, $144.16; State, R I; Order Number, 5; Amount, $365; Sales Tax, $21.90; State, M D;Order Number, 6; Amount, $723; Sales Tax, $30.15; State, H I; Order Number, 7; Amount, $611; Sales Tax, $0.00; State, D E;Order Number, 8; Amount, $55; Sales Tax, $8.00; State, M D;Order Number, 9; Amount, $1,412; Sales Tax, $84.72; State, M I; Order Number, 10; Amount, $187; Sales Tax, $7.80; State, H I. It would help if you could combine the information in both tables to automatically calculate the sales tax per order and compare the tax information by state. Are there any data issues that would prevent this? List the patterns you used to identify the issues.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started