Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Facilities Managers Reference Management Planning Building Audits Estimating

Authors: Harvey H. Kaiser

1st Edition

0876291426, 978-0876291429

More Books

Students also viewed these Accounting questions