Ask Question
BusinessBusiness
16 November, 19:25

A sporting goods store discounts every item in its store based on the original price of the item. An item is discounted: 10% if its original price is less than $20, 20% if its original price is greater than or equal to $20 but less than or equal to $75, 25% if its original price is greater than $75. Which function represents the discount of an item, expressed in dollars, with an original price of x dollars?

+5
Answers (1)
  1. 16 November, 22:02
    0
    The function to be used in excel represents the discount of an item expressed in dollars, with an original price of x dollars, is as below:

    =if (x$75,25%*x, 20%*x)

    in which

    10%*x is discount of any items with original price is less than $20 20%*x is discount of any items with original price is greater than or equal to $20 but less than or equal to $75) is 20% discounted 25%*x is discount of any items with original price is greater than $75

    Explanation:

    We define easy conditions first, then the most complicated at the end

    An item is discounted: 10% if x is less than $20 An item is discounted 25% if x is greater than $75 The rest which not any of above (greater than or equal to $20 but less than or equal to $75) is 20% discounted)
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “A sporting goods store discounts every item in its store based on the original price of the item. An item is discounted: 10% if its ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
Finding the required interest rate: Your parents will retire in 18 years. They currently have $250,000, and they think they will need $1,000,000 at retirement.
Answers (1)
Prepaid insurance. the prepaid insurance account has a $4,700 debit balance to start the year. a review of insurance policies and payments shows that $900 of unexpired insurance remains at year-end
Answers (1)
Which of the following items does not result in an adjustment in the merchandiseinventory account under a perpetual system? a. A purchase of merchandise. b. A return of merchandise inventory to the supplier c.
Answers (1)
The income statement shows amounts for: Group of answer choices revenues, expenses, losses, and liabilities revenues, expenses, gains, and fair value per share. revenues, assets, gains, and losses. revenues, gains, expenses and losses.
Answers (1)
A company acquires goods or products from another country and sells them in domestic markets. this is an example of
Answers (1)
New Questions in Business
On January 1, 20X8, Package Company acquired 80 percent of Stamp Company's common stock for $280,000 cash.
Answers (1)
Tombert Decorating uses a job order cost system to collect the costs of its interior decorating business. Each client's consultation is treated as a separate job. Overhead is applied to each job based on the number of decorator hours incurred.
Answers (1)
Suppose that cookie producers create a positive externality equal to $2 per dozen. What is the relationship between the equilibrium quantity and the socially optimal quantity of cookies to be produced? a. They are equal. b.
Answers (1)
Comfort Cloud manufactures seats for airplanes. The company has the capacity to produce 100,000 seats per year, but currently produces and sells 75,000 seats per year.
Answers (2)
In 2016, teller company sold 3,000 units at $600 each. variable expenses were $420 per unit, and fixed expenses were $240,000. what was tellers 2016 net income?
Answers (1)
Home » Business » A sporting goods store discounts every item in its store based on the original price of the item. An item is discounted: 10% if its original price is less than $20, 20% if its original price is greater than or equal to $20 but less than or equal to
Sign Up Forgot Password?