Question

Sheet1 Sheet2 Sheet3 Cell A1: Suggested Retail Price ($9800) $9,800 0.3 0.2 0.05 $6,860 5488 5213.6 Cell B1: Basic Wholesale Discount (30%) Cell C1: Additional Discount for purchasing over $5000 (20%) Cell D1: Introductory Offer Discount for ordering two masks (5%) 30120 0.02 30120 602 20000 10-Apr 19397.6 Invoice amount ($30,120)= Cell A7 Early payment discount (2%)= Cell B7 the amount to fully pay the invoice: C7 2% discount amount= D7 Amount to reduce debt by $20,000-Cell E7 Date of payment=Cell F7 Amount to pay on or before April 10 = Cell G1

          Sheet1
Sheet2
Sheet3
Cell A1: Suggested Retail Price ($9800)
$9,800 0.3 0.2 0.05 $6,860 5488 5213.6 Cell B1: Basic Wholesale Discount (30%)
Cell C1: Additional Discount for purchasing over $5000 (20%)
Cell D1: Introductory Offer Discount for ordering two masks (5%)
30120 0.02 30120 602 20000 10-Apr 19397.6 Invoice amount ($30,120)= Cell A7
Early payment discount (2%)= Cell B7
the amount to fully pay the invoice: C7
2% discount amount= D7
Amount to reduce debt by $20,000-Cell E7
Date of payment=Cell F7
Amount to pay on or before April 10 = Cell G1

Show more…

Sheet1
Sheet2
Sheet3
Cell A1: Suggested Retail Price (9800)9,800 0.3 0.2 0.05 6,860 5488 5213.6 Cell B1: Basic Wholesale Discount (30%)
Cell C1: Additional Discount for purchasing over5000 (20%)
Cell D1: Introductory Offer Discount for ordering two masks (5%)
30120 0.02 30120 602 20000 10-Apr 19397.6 Invoice amount (30,120)= Cell A7
Early payment discount (2%)= Cell B7
the amount to fully pay the invoice: C7
2% discount amount= D7
Amount to reduce debt by20,000-Cell E7
Date of payment=Cell F7
Amount to pay on or before April 10 = Cell G1

Added by Bego-A M.

Elementary Statistics a Step by Step Approach

Allan G. Bluman 9th Edition

Instant Answer

Solved by Expert Frank Deng

Step 1

- The Basic Wholesale Discount is 30%. - To calculate the discount amount: $9,800 * 0.3 = $2,940. - To calculate the price after the Basic Wholesale Discount: $9,800 - $2,940 = $6,860. Show more…

Show all steps

lock

Thanks for your feedback!

please solve this excel file of maths😑 Sheet1 Sheet2 Sheet3 Cell Al:Suggested Retail Price(S9800) 5488 5213.6Cell B1:Basic Wholesale Discount (30% Cell C1:Additional Discount for purchasing over S5000(20%) Cell D1:Introductory Offer Discount for ordering two masks (5%) $9,800 0.3 0.2 0.05 $6,860 30120 0.02 30120 602 20000 10-Apr 19397.6Invoice amount$30,120=Cell A7 Early payment discount(2%=Cell B7 the amount to fully pay the invoice:C7 2% discount amount=D7 Amount to reduce debt by $20.000=Cell E7 Date of payment=Cell F7 Amount to pay on or before April 10=Cell Gl

Play audio

Feedback

Powered by NumerAI

Frank Deng and 86 other subject Intro Stats / AP Statistics educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later