Calculate the commission rate for the total sale

Assignment Help Operation Management

Reference no: EM13856700

Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references.

Reference no: EM13856700

Questions Cloud

Enefits of organizations-companies and businesses : What are the benefits of organizations, companies, and businesses NOT using a pure organization structure in the work place?

Develop a proposal for a short film or short story : What is your key idea about cities or buildings? and how will it be conveyed and what is the title and how does the title reflect the key idea?

What is the recommended minimum number of vendors : What is the recommended minimum number of vendors to have when you enter the evaluation and negotiation phases?

Shareholder of a corporation : Question 1: Generally, a shareholder of a corporation

Calculate the commission rate for the total sale : Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $..

My assignment is dealing with the balance scoreboard : My assignment is dealing with the Balance scoreboard. I need help. I have to compare and contrast the traditional BSC and how Heathrow Terminal 5 project implemented the BSC and how it was flexible.

Competitor ratios-industry ratios-standards and trends : Analyze the financial statements using 3 years (2 if unavailable) using ratios of debt, liquidity, profitability, investing (e.g. EPS, P/E, etc.), and failure forecasting. Look at common-size analyses and year-to-year changes. Discuss competitor rati..

What rate of return is the annuity fund offering : Raul inherited an annuity worth $7046.13 from his uncle. The annuity will pay him seven equal payments of $1400 at the end of each year. What rate of return is the annuity fund offering?

Expect an increase or decrease in total revenue : To increase revenue and profit, a firm is considering a 4% increase in price and an 11% increase in advertising. If the price elasticity of demand is -1.5 and the advertising elasticity of demand is +0.6, would you expect an increase or decrease in t..

User Account

All Pages