Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete parts A and B on separate worksheets. Part A: Buckeye Company sells four products and offers quantity discounts to the customers. Buckeye Company

image text in transcribed

Complete parts A and B on separate worksheets. Part A: Buckeye Company sells four products and offers quantity discounts to the customers. Buckeye Company wants you to make a worksheet that will allow the salesperson (the user) to input the item and the quantity of the item that their customer wants to purchase. The worksheet will then calculate a price quote that the salesperson can give to the customer. The four products and selling price are as follows: Item Fender Windshield Tire Unit Price $750.00 $500.00 $175.00 $25.00 Antenna Enter this data in the exact order listed above. The quantity discount is based on the number of the item purchased. The discount rates are as follows: If the customer wants 1 or 2, then there is no discount If the customer wants 3 or 4, then there is a 5% discount If the customer wants 5, 6, or 7, then there is a 10% discount If the customer wants 8 or more, then there is a 20% discount The sales tax rate is 10.00% and is calculated on the total price of the order after the discount The price quote must state the item's Unit Price, total price before the discount, the discount percentage, the dollar amount of the discount, the total price of the order after the discount, the sales tax, and the final price quote You MUST use VLOOKUP to determine the unit price and the discount rate for the order. You MAY use a number for the col-badex-men in VLOOKUP No data validation is required

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

Accounting

Authors: Carl warren, James Reeve, Jonathen Duchac, Sheila Elworthy,

Volume 1, 2nd canadian Edition

176509739, 978-0176509736, 978-0176509743

More Books

Students also viewed these Accounting questions