Question: I need the help for this please help me Delicious Candy Company Invoice Register 2021/9/23 17:56 Name Invoice Amount State Zone Discount Sales Tax Shipping
I need the help for this please help me
| Delicious Candy Company Invoice Register | ||||||||
| 2021/9/23 17:56 | ||||||||
| Name | Invoice Amount | State | Zone | Discount | Sales Tax | Shipping | Total Invoice Amount | |
| M & M Candies | $ 874.50 | NM | E | $ 43.73 | ||||
| Office Depot | $ 545.35 | MO | B | $ 21.81 | ||||
| Walmart | $ 354.65 | KS | C | $ 10.64 | ||||
| Mints & More | $ 300.00 | MO | A | $ 9.00 | ||||
| Mars Candy | $ 482.00 | AK | B | $ 14.46 | ||||
| Sweet Tooth Inc. | $ 226.00 | CO | C | $ 4.52 | ||||
| Yummy Gummies | $ 759.00 | KS | A | $ 37.95 | ||||
| Godiva Chocolates | $ 642.00 | KY | D | $ 32.10 | ||||
| Toberlone | $ 785.00 | AK | B | $ 39.25 | ||||
| Jelly Belly Inc. | $ 426.00 | MO | A | $ 12.78 | ||||
| Hershey, Inc. | $ 852.00 | KS | C | $ 42.60 | ||||
| LAI | $ 1,250.00 | MO | B | $ 75.00 | ||||
| Totals | $ 7,496.50 | $ 343.84 | $ - | $ - | $ - | |||
| Instructions: | ||||||||
| Be sure all formulas are copyable. | ||||||||
| On Row 16 add the data "your lastname Candy Co.", 1250.00, MO, B. | ||||||||
| Build all the necessary tables on the ShippingZoneRates, SalesTaxPercent, and DiscountPercent worksheets. | ||||||||
| Discount is the Invoice Amount times the Invoice Amount lookup value from the DiscountPercentTable on the Discount Percent worksheet. | ||||||||
| Sales Tax is the Invoice Amount minus the Discount times the State lookup value from the StatePercentTable on the SalesTaxPercent worksheet. | ||||||||
| Shipping is the Zone lookup amount from the ZoneRateTable on the ShippingZoneRates worksheet. | ||||||||
| Total Invoice Amount is the Invoice Amount less the Discount, plus the Sales Tax and Shipping. | ||||||||
| Total all relevant columns. | ||||||||
| Upload the completed workbook file. | ||||||||
| State | Tax Rate | ||||||||
| AK | 3.00% | | |||||||
| CO | 6.00% | ||||||||
| KS | 5.00% | ||||||||
| KY | 7.00% | ||||||||
| MO | 4.00% | ||||||||
| NM | 7.50% | ||||||||
| Instructions: | |||||||||
| Name the appropriate table range required for the Vlookup as StatePercentTable. | |||||||||
| DiscountPercentTable | |||||
| Sales Amount | Discount % | ||||
| 0 to $299.99 | $ - | 2.00% | |||
| $300.00 - $499.99 | $ 300.00 | 3.00% | |||
| $500.00 - $599.99 | $ 500.00 | 4.00% | |||
| $600.00 - 899.00 | $ 600.00 | 5.00% | |||
| $900.00 - up | $ 900.00 | 6.00% | |||
| Instructions: | |||||
| Complete column B of the table using the descriptive information from column A. | |||||
| Name the appropriate table range required for the Vlookup as DiscountPercentTable. Remember that the data I put in Column A is descriptive only and not part of the table. | |||||
| Zone | Shipping | | ||||||
| A | $ 12.50 | |||||||
| B | $ 14.00 | |||||||
| C | $ 13.75 | |||||||
| D | $ 8.50 | |||||||
| E | $ 15.00 | |||||||
| Instructions: | ||||||||
| Name the appropriate table range required for the Vlookup as ZoneRateTable. | ||||||||
| | ||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help