Answered step by step
Verified Expert Solution
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
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
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