Please do not answer all questions, I need help on how to complete NUMBER 7 on excel. thank you

SPREADSHEET PROBLEMS 1. The revenue for a firm is $2,500,000. Its cost of revenue is $850,000, and its average inventory for the year is $62,000. What is the inventory turnover? 2. Given the following information, what is the annual inventory turnover ratio? Revenue Cost of Revenue Quarter 1 Ending Inventory Quarter 2 Ending Inventory Quarter 3 Ending Inventory Quarter 4 Ending Inventory $22,000,000 $1,250,000 $85,000 $98,000 $125,000 $68,000 3. Given the following information, compute the economic order quantity, annual holding cost, annual order cost, and annual total inventory cost. Annual requirements (R) Order cost (5) Holding rate (k) Unit cost ( = 50,000 units = $150 per order = 15% = $100 per unit a 4. The annual requirement of a part is 360,000 units. The order cost is $120 per order, the holding rate is 12 percent, and the part cost is $2,500 per unit. What are the (a) EOQ, (b) annual holding cost, (c) annual order cost, and (d) annual total inventory cost? 5. The weekly requirement of a part is 950 units. The order cost is $85 per order, the holding cost is $5 per unit per year, and the part cost is $250 per unit. The firm operates fifty-two weeks per year. Compute the (a) EOQ, (b) annual holding cost, (c) annual order cost, and (d) annual total inventory cost. 6. The monthly demand for a part is 1,500 units. The order cost is $285 per order, the holding cost is $56 per unit per year, and the part cost is $850 per unit. The firm operates twelve months per year. Compute the (a) EOQ, (b) annual holding cost, (c) annual order cost, and (d) annual total inventory cost. 7. Icy Snowmobile, Inc., has an annual demand for 1,200 snowmobiles. Their purchase cost for each snowmobile is $2,500. It costs about $250 to place an order, and the holding rate is 35 percent of the unit cost. Compute the (a) EOQ, (b) annual holding cost, (c) annual order cost, and (d) total annual inventory cost