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

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 ?

Do not give answer in image and hand writing

answer in text form please (without image)

USE GOOGLE SHEET   Use the template below and create your own invoice for purchased products of a VAT registered customer. The products are enumerated below with unit price at gross of VAT, a 3% discount has been given to the customer. Do all formulas required. Format the invoice for clarity.

Saints Sports Gear has the following information relative to each basketball it sells:             Selling price                                  $28.00               Variable costs                               $14.00             Allocated fixed costs                       $6.00             Total costs                                     $20.00               The company recently received a special order for 1,000 basketballs at $13.50 each. Assuming the company has sufficient excess capacity, should they accept the order? Show your work to justify your answer

Uy.5.

Please see the attachment, thank you! Cheers!

How do I complete the table on question 2.2 ?

Keep or Drop AudioMart is a retailer of vintage vinyl records and equipment. The store carries two popular sound systems-System A and System B. System A, of slightly higher quality than System B, costs $18 more. With rare exceptions, the store also sells a specialized headset when a system is sold. The headset can be used with either system. Variable-costing income statements for the three products follow: System A System B Headset Sales $44,800 $32,900 $8,100 Less: Variable expenses 20,000 25,000 3,100 Contribution margin $24,800 $7,900 $5,000 Less: Fixed costs * 9,900 18,100 2,700 Operating income (loss) $14,900 $(10,200) $2,300 *This includes common fixed costs totaling $18,100, allocated to each product in proportion to its revenues. The owner of the store is concerned about the profit performance of System B and is considering dropping it. If the product is dropped, sales of System A will increase by 31%, and sales of headsets will drop by 24%. Round all answers to the nearest…