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: From Quantity Ordered To 30 Price per Roll 1 31 60 61 120 121 and up $215 $195 $175 $155 Click on the datafile logo to reference the data. DATA file (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. From To Price per Roll Number of Orders 1 31 61 32 80 $215 $195 120 $175 121 and up $155 172 Hint(s) Check My Work

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: From Quantity Ordered To 30 Price per Roll 1 31 60 61 120 121 and up $215 $195 $175 $155 Click on the datafile logo to reference the data. DATA file (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. From To Price per Roll Number of Orders 1 31 61 32 80 $215 $195 120 $175 121 and up $155 172 Hint(s) Check My Work

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 $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 $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
Need experts solution only, Don't use AI.
Pixel Vision Ltd. is a retailer of premium drones .Typically, the company purchases a drone for $750 and sells it for $1,250. What is the gross profit on this drone?
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
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]
Pro Hockey Store is evaluating two supplies of hockey skates: JA skates and Power skates. Pertinent information about each potential supplier follows: Relevant Item JA Skates Power Skates Purchase Price $50.00 $51.20 Ordering cost per order $8.00 $8.00 Carrying cost per year 20% of Purchase price 5% of Purchase price Inspection cost per unit $0.02 $0.00 Insurance, material handling, and so on per unit per year $3.00 $3.50 Annual Demand 12,000 12,000 Average quantity of inventory held during the year 120 units 120 units Required Return on investment 10% 10% Stockout cost per unit $34 $22 Stockout units per year 350 65 Customer Returns 300 25 Customer-return costs per unit $45 $45 a. Calculate the EOQ for both suppliers b. Calculate the relevant costs of purchasing (1) JA Skates and (2) Power Skates. From where should Pro Hockey buy skates ?
K Clan Furniture Company manufactures and sells oak tables and chairs. Price and cost data for the furniture follow: Click the icon to view the price and cost data.) Clan Furniture has three sales representatives: Alfred, Bob, and Cait. Alfred sold 60 tables with 8 chairs each. Bob sold 70 tables with 6 chairs each. Cait sold 100 tables with 4 chairs each. Read the requirements. Sales representative: Alfred Bob Cait Net sales revenue $ 66,000 $ 70,000 $ 90,000 47,700 Variable costs Contribution margin 52,150 69,500 $ 18,300 $ 17,850 $ 20,500 Now calculate the contribution margin ratio for each sales representative. (Round to two decimal places-the nearest hundredth percent-X.XX%.) Contribution margin ÷ Net sales revenue = Contribution margin ratio Alfred $ 18,300 " ÷ 66,000 = 27.73 % Bob $ 17,850 ÷ $ 70,000 = 25.50 % 20,500 + $ 90,000 = 22.78 % Cait $ Requirement 2. Which sales representative has the highest contribution margin ratio? Explain why. is the sales representative with the…
Cesar Rego Computers, a Mississippi chain of computer hardware and software retal outets, supplies both educational and commercial customers wih memory and storage devices ourenty taces the tlowng ordering decision relating to purchases of disks: 35,200 dinks $24 22% 10 87 Purchane proe Discount price $0.02 Quantity needed to qualify for the discount 5,900 disks What is the EO0? EOQ - units (round your response to the nearest whole number)
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?
answer in text form please (without image)