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

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

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter11: Differential Analysis And Product Pricing

Section: Chapter Questions

Problem 2CMA

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 table shows the price per roll depending on order size: Quantity Ordered To From 1 30 31 60 61 120 121 and up Price per Roll $215 $195 $175 $155 Click on the datafile logo to reference the data. DATA file (a) Use the XLOOKUP function with the preceding pricing table to determine the total revenue from these orders. Hint: Xlookup is an Excel function available in Excel 2021 and above and in Microsoft 360. VLOOKUP, in this case will result in the same answer. $ 32260 (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 30 $215 40 31 60 $195 50 61 120 $175 60 121 and up $155 22 * * * *
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
2
Need experts solution only, Don't use AI.
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
How to solve this question?
Har
Outdoor Luggage, Incorporated, makes high-end hard-sided luggage for sports equipment. Data concerning three of the company’s most popular models appear below. Ski Guard Golf Guard Fishing Guard Selling price per unit $ 260 $ 270 $ 305 Variable cost per unit $ 130 $ 130 $ 180 Plastic injection molding machine processing time required to produce one unit 4 minutes 6 minutes 9 minutes Pounds of plastic pellets per unit 9 pounds 16 pounds 7 pounds Required: 1. If we assume that the total time available on the plastic injection molding machine is the constraint in the production process, how much contribution margin per minute of the constrained resource is earned by each product? 2. Which product offers the most profitable use of the plastic injection molding machine? 3. If we assume that a severe shortage of plastic pellets has required the company to cut back its production so much that its new constraint has become the total available pounds of plastic…
Drone Concepts, Inc. (DCI) manufacturers a line of drones that are distributed to large retailers. The line consists of four models of drones. The following data is available regarding the models: DCI Selling Price Variable Cost Demand/Year Model per Unit per Unit (units) Model D1 $735 $115 1,535 Model D2 $515 $110 2,865 Model D3 $625 $105 3,535 Model D4 $765 $135 3,300 Drone Concepts is considering the addition of a fifth model to its line of drones. This model would be sold to retailers for $950. The variable cost of this unit is $415. The demand for the new Model D5 is estimated to be 2,000 units per year. Sixty percent of these unit sales of the new model is expected to come from other models already being manufactured by Drone Concepts (10 percent from Model D1, 30 percent from Model D2, 40 percent from Model D3, and 20 percent from Model D4). Drone Concepts will incur a fixed cost of $350,000 to add the new model to the line. Based on the preceding data, should DCI add the new…
TB MC Qu. 9-61 (Algo) Data related to the inventories of Alpine... Data related to the inventories of Alpine Ski Equipment and Supplies is presented below: Selling price Cost Replacement cost Sales commission Multiple Choice $48,350. $47,350. $51,350. Skis $ 179,000 130,000 116,000 $71,100. 10% Boots $ 155,000 142,000 128,000 10% In applying the lower of cost or net realizable value rule, the inventory of supplies would be valued at: Apparel $ 105,000 73,500 93,500 10% Supplies $ 79,000 51,350 47,350 10%
Please see the attachment, thank you! Cheers!
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 ?