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 $210 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 75 $210 76 125 $185 126 225 $170 226 and up $145 The file RSR contains 172 orders that have arrived for the coming six weeks. (e) Use the VLOOKUP function with the preceding pricing table to determine the total revenue (in dollars) from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. Quantity Ordered From To Price per Roll Number of Orders 3 75 $210 76 125 $185 126 225 $170 226 and up $145

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 $210 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 75 $210 76 125 $185 126 225 $170 226 and up $145 The file RSR contains 172 orders that have arrived for the coming six weeks. (e) Use the VLOOKUP function with the preceding pricing table to determine the total revenue (in dollars) from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. Quantity Ordered From To Price per Roll Number of Orders 3 75 $210 76 125 $185 126 225 $170 226 and up $145

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints

Section: Chapter Questions

Problem 7E: Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The...

See similar textbooks

Similar questions

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 Activity Frame e per roll depending on order size: Quantity Ordered Το From Price per Roll 1 30 $215 31 60 $195 61 120 $175 121 and up $155 Click on the datafile logo to reference the data. DATA fil (a) Use the XLOOKUP 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. From To Price per Number of Roll Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172
2
Fitness Express sells three different types of elliptical machines. They have manufactured 50 of each machine for a special sale. The store already ha orders for 46 of machine A and 16 of machine B. Use the following information to determine how many of machine C the store needs to sell to break even? Show your work on a separate sheet of paper. Manufacturing Cost $105.00 $140.00 $175.00 Elliptical Machine Machine A Machine B Machine C Total costs of all machines: $ Total revenue: $ Number of machine Cs to sell to break even: Retail Cost $250.00 $305.00 $420.00
Rugged Outfitters purchases one model of mountain bike at a wholesale cost of $520 per unit and resells it to end consumers. The annual demand for the company’s product is 49,000 units. Ordering costs are $500 per order and carrying costs are $100 per bike per year, including $40 in the opportunity cost of holding inventory. QWhat is the cost impact on the company of excluding the opportunity cost of carrying inventory when making EOQ decisions? Why do you think the company currently excludes the opportunity costs of carrying inventory when evaluating the manager’s performance? What could the company do to encourage the manager to make decisions more congruent with the goal of reducing total inventory costs?
Need answer without using Excel... I vll upvote if you get it correct.
Sports Extreme advertised a Freestyle XL Stand Up Paddleboard for a regular price of $710. Sports Extreme bought the board from its supplier for $510 less a trade discount of 25%. The Sports Extreme's overhead expenses are 20% of cost. a. What operating profit or loss will Sports Extreme realize if the paddleboard is sold at the regular price? (Round your answer to 2 decimal places.) (Click to sele v b. What operating profit or loss will Sports Extreme realize if the paddleboard is sold during a "20% off" weekend sale? (Round your answer to 2 decimal places.) (Click to sele c. What rate of markdown can Sports Extreme advertise if it is willing to just break even on the sale of the paddle board during an end of season sale? (Round your answer to 2 decimal places.) Rate of markdown
Snow Now sells snowboards. Snow Now knows that the most people will pay for the snowboards is $129.99. Snow Now is convinced that it needs a 45% markup based on cost. The most that Snow Now can pay to its supplier for the snowboards is: A. $88.65 B. $98.65 C. $96.65 D. None of these E. $87.65
Sunland Appliance Co. manufactures low-price, no-frills appliances that are in great demand for rental units. Pricing and cost information on Sunland's main products are as follows. Item Refrigerator Range Stackable washer/dryer unit Stand-Alone Selling Price (Cost) $520 ($245) $610 ($330) $780 ($440) Customers can contract a purchase either individually at the stated prices or for a three-item bundle with a price of $1,950. The bundle price includes delivery and installation. Sunland provides delivery and installation as a stand-alone service for any of its products for $90. The company follows IFRS. Respond to the requirements related to the following independent revenue arrangements for Sunland. (a) On June 1, 2023, Sunland sold 90 washer/dryer units without installation to Sandhill Rentals for $70,200 (on credit). Sandhill is a newer customer and is unsure of how this product will work in its older rental units. Sunland offers a 60-day return privilege and estimates, based on prior…
Q1. Murray furniture store sells couches as a retailer. The wholesale cost to them of their most popular model of couch varies depending on how many they purchase for sale. For the first 200 couches the cost is $299 each; for the next 200 couches it drops to $250 each; and for every couch after that it costs $225. Create an excel function using the IF function to show the gross profit under the following scenarios: a. b. It sells at a price of $650 and 350 units are purchased for sale and sold It sells at a price of $625 and 300 units are purchased for sale and sold It sells at a price are $700 and 1,000 units are purchased for sale and sold C.
SportsHaven’s garden department produces bags of mulch. Fixed cost is $17,300. Each bag sells for 3.21 with units cost of $1.48. How much bags of mulch must be sold to breakeven? Use the breakeven worksheet, press [2nd] [BRKEVN]
Epic Rentals would like to take advantage of the bundle price for its 370-unit project; on February 1, 2020, Cheyenne signs a contract with Epic for 370 bundles. Under the agreement, Cheyenne will hold the appliance bundles in its warehouses until the new rental units are ready for installation. Epic pays 10% cash at contract signing. On April 1, 2020, Cheyenne completes manufacture of the appliances in the Epic bundle order and places them in the warehouse. Cheyenne and Epic have documented the warehouse arrangement and identified the units designated for Epic. The units are ready to ship, and Cheyenne may not sell these units to other customers. Prepare journal entries for Cheyenne on (1) February 1, 2020, and (2) April 1, 2020. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter O for the amounts.) Date Account Titles and Explanation Debit Credit Feb. 1, 2020…
Do not give answer in image and hand writing