Determine the number of orders in each price bin

Assignment Help Finance Basics
Reference no: EM131668815

Question: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size:

                 Quantity Ordered

From              To                 Price per Roll

1                   50                     $215

51                100                     $195

101              200                     $175

201           and up                    $155

The file RSR contains 172 orders that have arrived for the coming six weeks.

a. Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders.

b. Use the COUNTIF function to determine the number of orders in each price bin.

Reference no: EM131668815

Questions Cloud

Price elasticity of demand for physicians : Assume the price elasticity of demand for physicians' services is -0.2. If your marginal cost per visit is $20, what is your profit-maximizing price
How many reservations can be accommodated in rental class : Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business.
What are the ethical implications : What are the ethical implications of these strategies to maximize its profits?
How the idea of quantum mechanics came : 1. How the idea of quantum mechanics came ? 2.Write a short notes on the growth of quantum mechannics.
Determine the number of orders in each price bin : Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses.
Role of managers as decision makers : MGT101-Fundamentals of Management Assignment - In your discussion you must elaborate on each of the steps and the relevant factors (including ethics)
What is the ip address of your dhcp server : What is the IP address of your DHCP server? Explain the purpose of the router and subnet mask lines in the DHCP offer message.
What factors determine whether a restraint is reasonable : How can David and Cathy protect themselves then? What factors determine whether a restraint is reasonable?
One of the greatest uses of the internet is e-mail : One of the greatest uses of the Internet is e-mail, which allows messages and other data to be sent anywhere in the world instantly with no cost.

Reviews

Write a Review

Finance Basics Questions & Answers

  The whole food nutrition center uses grains to blend a

the whole food nutrition center uses grains to blend a natural cereal that it sells by the pound. the cereal has to

  Major categories of operating-investing

Which of the following financial statements is divided into major categories of operating, investing, and financing activities?

  Estimated economic life of the machine

On January 1, Year 8, Von Company entered into two non-cancellable leases of new machines for use in its manufacturing operations. The first lease does not contain a bargain purchase option, and the lease term is equal to 80% of the estimated economi..

  What does the repurchase indicate about stock price trend

Compute the average prices at which the shares in 2007 and 2008 were issued and purchased.

  What is the purpose of pro forma statements

What is the purpose of pro forma statements? What inputs are required for preparing them using the simplified approaches?

  Financial ratios for assigned company financial statements

Calculate the financial ratios for the assigned company's financial statements, and then interpret those results against company historical data as well as industry benchmarks:

  Bond coupon rate-summit cost of capital-dream business

Summit Systems will pay a dividend of $1.50 this year. If you expect Summit's dividend to row by 6% per year. What is its price per share if its equity cost of capital is 11%?

  Risk and return and the capm

Risk and Return and the CAPM.

  What is the current price of the common stock

The company's last dividend, D0, was $1.25, its beta is 1.20, the market risk premium is 5.50%, and the risk-free rate is 3.00%. What is the current price of the common stock?

  How many days are in the cash cycle

Harry Joiner, Inc. currently has an inventory turnover of 15.7, a payables turnover of 9.6, and a receivables turnover of 8.1. How many days are in the cash cycle?

  The preferred stock pays 6 in dividends annually and is

donald carter recently bought 100 shares of imh preferred stock. the preferred stock pays 6 in dividends annually and

  You would like to give your daughter

You would like to give your daughter $183,000 towards her college education 14 years from now.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd