Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to solve Page 2 of 2 Detail CALCULATIONS Customer Login id - Add together the following: a . the FIRST 3 letters of the

How to solve
Page 2 of 2
Detail CALCULATIONS
Customer Login id-Add together the following:
a. the FIRST 3 letters of the last name
b. the FIRST 2 letters of the first name
c. The manager name
d. AND the State of Origin
Final amount due
a. Add the tax amount due to the Yarn Amount Due
Applicable Yarn Rate
a. For RED yarn
i. Where the yarn gross weight is between 1-50, it is set to the RED YARN RATE.
ii. Where the yarn gross weight is between 50.01-60, is found by adding $5.00 to the RED YARN RATE.
iii. Where the yarn gross weight is between 60.01-80, is found by adding $8.00 to the RED YARN RATE.
iv. Where the yarn gross weight is OVER 80 is found by adding $10.00 to the RED YARN RATE.
b. For BLACK yarn
i. Where the yarn gross weight is between 1-40, it is set to the BLACK YARN RATE.
ii. Where the yarn gross weight is between 40.01-62, is found by adding $5.00 to the BLACK YARN RATE.
iii. Where the yarn gross weight is between 62.01-84, is found by adding $8.00 to the BLACK YARN RATE.
iv. Where the yarn gross weight is OVER 84 is found by adding $10.00 to the BLACK YARN RATE.
c. For ORANGE yarn
i. Where the yarn gross weight is between 1-35, it is set to the ORANGE YARN RATE.
ii. Where the yarn gross weight is between 35.01-75, is found by adding $15.00 to the ORANGE YARN RATE.
iii. Where the yarn gross weight is between 75.01-91, is found by adding $16.00 to the ORANGE YARN RATE.
iv. Where the yarn gross weight is OVER 91 is found by adding $14.00 to the ORANGE YARN RATE
Net lbs-Multiply the yarn weight by the Tare Rate
Yarn amount due
a. Multiply the Net Ibs by the Applicable Yarn Rate
TAX Amount due-MULTIPLY the Yarn Amount due by APPLICABLE TAX RATE.
APPLICABLE TAXRATE
a. For those in ALABAMA,
i. With a customer id number of 1,000-5,000 use the Alabama tax rate
ii. With a customer id number of 5,001-8,000 use the Alabama tax rate PLUS 1.2%
iii. With a customer id number that is larger than 8000 use the Alabama tax rate PLUS 2.4%
b. For those in GEORGIA,
i. With a customer id number of 1,000-4,000, use the GA tax rate PLUS 12%(one-half percent)
ii. With a customer id number of 4,001-7,000, use the GA tax rate PLUS 1%
iii. With a customer id number LARGER than 7,000, use the GA tax rate PLUS 2%
c. For those in MISSISSIPPI, use the MS tax rate
Page 2 of 2
Detail CALCULATIONS
Customer Login id-Add together the following:
a. the FIRST 3 letters of the last name
b. the FIRST 2 letters of the first name
c. The manager name
d. AND the State of Origin
Final amount due
a. Add the tax amount due to the Yarn Amount Due
Applicable Yarn Rate
a. For RED yarn
i. Where the yarn gross weight is between 1-50, it is set to the RED YARN RATE.
ii. Where the yarn gross weight is between 50.01-60, is found by adding $5.00 to the RED YARN RATE.
iii. Where the yarn gross weight is between 60.01-80, is found by adding $8.00 to the RED YARN RATE.
iv. Where the yarn gross weight is OVER 80 is found by adding $10.00 to the RED YARN RATE.
b. For BLACK yarn
i. Where the yarn gross weight is between 1-40, it is set to the BLACK YARN RATE.
ii. Where the yarn gross weight is between 40.01-62, is found by adding $5.00 to the BLACK YARN RATE.
iii. Where the yarn gross weight is between 62.01-84, is found by adding $8.00 to the BLACK YARN RATE.
iv. Where the yarn gross weight is OVER 84 is found by adding $10.00 to the BLACK YARN RATE.
c. For ORANGE yarn
i. Where the yarn gross weight is between 1-35, it is set to the ORANGE YARN RATE.
ii. Where the yarn gross weight is between 35.01-75, is found by adding $15.00 to the ORANGE YARN RATE.
iii. Where the yarn gross weight is between 75.01-91, is found by adding
image text in transcribed

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

DB2 11 The Ultimate Database For Cloud Analytics And Mobile

Authors: John Campbell, Chris Crone, Gareth Jones, Surekha Parekh, Jay Yothers

1st Edition

1583474013, 978-1583474013

More Books

Students also viewed these Databases questions