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 30 $215 31 60 $195 61 120 $175 121 and up $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 1 30 $215 40 x 31 60 $195 50 61 120 $175 60 121 and up $155 22

Do not give answer in image and hand writing

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]

Cherry Blossom Products Inc. produces and sells yoga-training products: how-to DVDs and a basic equipment set (blocks, strap, and small pillows). Last year, Cherry Blossom Products sold 17,880 DVDs and 4,470 equipment sets. Information on the two products is as follows:   DVDs Equipment Sets Price $7.90 $25.30 Variable cost per unit 4.00 14.60   Total fixed cost is $89,420.   Required: 1. What is the sales mix of DVDs and equipment sets? 2. Compute the break-even quantity of each product. 1. What is the sales mix of DVDs and equipment sets?     2. Compute the break-even quantity of each product. The break-even quantity for DVDs is    The break-even quantity for equipment sets is

Cherry Blossom Products Inc. produces and sells yoga-training products: how-to DVDs and a basic equipment set (blocks, strap, and small pillows). Last year, Cherry Blossom Products sold 13,590 DVDs and 4,530 equipment sets. Information on the two products is as follows:   DVDs Equipment Sets Price $7.70 $24.80 Variable cost per unit 4.10 15.00   Total fixed cost is $76,220.   Required: 1. What is the sales mix of DVDs and equipment sets? 2. Compute the break-even quantity of each product.

Please avoid solutions in an image format thanks

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…

Har

Need answer without using Excel... I vll upvote if you get it correct.

The I-75 Carpet Discount Store in North Georgia stocks carpet in its warehouse and sells it through an adjoining showroom. The store keeps several brands and styles of carpet in stock; however, its biggest seller is Super Shag carpet. The store wants to determine the optimal order size and total inventory cost for this brand of carpet given an estimated annual demand of 10,000 yards of carpet, an annual carrying cost of $0.75 per yard, and an ordering cost of $150. The store would also like to know the number of orders that will be made annually and the time between orders (i.e., the order cycle) given that the store is open every day except Sunday, Thanksgiving Day, and Christmas Day (which is not on a Sunday) (311 days/yr). Determine the following: A. Determine the optimal order quantity. B. Determine the number of orders per year.C. Determine the time between orders.D. Determine the annual set-up cost.E. Determine the annual holding cost.F. What is the total inventory cost of the Q*…