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 rol per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From То Price per Roll 1 100 $215 101 200 $195 201 400 $175 401 and up $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. $ 614091 8 (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1. 100 $215 11 101 200 $195 59 201 400 $175 100 401 and up $155 2 172

5

4) Rane Brake Linings gathered information for its brake lining components as presented in the table below. How would the firm classify these items according to an ABC classification system?   Initial Information Part # Unit Cost Annual Demand 10 10 200 11 30 125 12 9 100 13 12 5000 14 50 195 15 6 300 16 100 70

1. What is the economic order quantity for BBE in units? In pounds?  4.What is the total cost for using air carrier transportation?

Explore the concept of Vendor-Managed Inventory (VMI) and its synergy with the Wilson approach.

Bradley Solutions and Alexander Limited are two well-established suppliers of inexpensive tools. Weekend Projects is a national chain of retail outlets that caters to the occasional fixer-upper who would prefer to get the job done fast rather than investing in a well-appointed tool box. Weekend Projects wants to find a supplier for a particular tool set that promises to be a big seller. Expected annual sales are 100,000 units (D). Weekend's warehouses operate 50 weeks a year. Management collected data on the two suppliers, which are contained in the table below: Annual Freight Costs Shipping Quantity (Q) Price/Unit Annual Holding Lead Time (L) Annual Supplier Bradley Alexander 50.000 $18,000 $17.000 Cost/Unit (H) $1.43 $1.43 10,000 25,000 (p) $7.15 (wks) Administrative Cost $40,000 $30,000 $26.000 $25.000 $15,000 S7.15 6 $10.000 a. Which of the two suppliers would provide the lowest annual cost to Weekend Projects? What shipping quantity would you suggest? Using and a shipping quantity…

Please do not give solution in image format thanku The purchasing department can reduce order quantity and work wtih suppliers to deliver purchases items more frequently. This should lower total inventory.   Make option Buy option   fixed cost $125,000 Fixed Cost $5,000   Variable Cost $15 Variable Cost $17   Find the break-even quantity and the total cost at the break-even point.