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
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
2
Need experts solution only, Don't use AI.
Do not give answer in image and hand writing
Saved Mary has received a special order for 3300 units of tis product at a special price of $162. The product normally sells for $210 and has te bilowing marufacturing costs 29 Per unit $ 67 10 Diract muterials irect Inbor 25 Fazible mtacturing overbaad Tind naufacturing Orezhead it cart 12 $144 Assume that Mercy has suficient capacity to fl the order without harming normal production and sales and all fixed overhead is uravoidable LFlary accepts the order,what effect wilthe order have on the company's short-term profit? & What minimum price should Marcy charge to achieve a $115,500 incremental profit?
Please Correct solution with Explanation And Do not Give solution in image format
Har
Bria Furniture sells bed frames and mattresses. One of its products is a premium therapeutic bed set produced by OmniSleep, which comes with a mattress and a bed frame. Bria offers a package consisting of the mattress, the frame, and on-site installation by its staff. All of these components can be sold separately, as often done by other vendors, so Bria concludes that these are separate performance obligations. Bria sells the OmniSleep package for $3,000. The mattress and the frame are sold separately for $2,000 and $900, respectively. Other vendors in the same area typically charge $200 for on-site installation. Bria does not sell on-site installation separately. On average, the prices charged by Bria are 10% higher than those of its competitors. Bria estimates that it incurs about $100 of compensation and other costs to provide the installation service. The profit margin over cost is estimated to be approximately 35%. Required: (a) Estimate the stand-alone selling price of the…
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%