Finance

1. ALL ASSIGNMENTS MUST BE DONE IN EXCEL. MAKE SURE THAT ALL CALCULATIONS ARE DONE IN EXCEL. DO NOT CUT AND PASTE YOUR CALCULATIONS TO (OR FROM) TO A WORD DOCUMENT. 2. All assignments must be done properly. Label your problems clearly. Clearly show the final answer of a problem by color-coding the cell (only light colors). Put problems from one chapter in one worksheet. Add the spreadsheet problem as a worksheet and label it correctly. Intermediate Problems 1-2 (28-1) The Gentry Garden Center sells 90,000 bags of lawn fertilizer annually. The optimal safety Economic Ordering stock (which is on hand initially) is 1,000 bags. Each bag costs the firm $1.50, inventory Quantity carrying costs are 20%, and the cost of placing an order with its supplier is $15. a. What is the Economic Ordering Quantity? b. What is the maximum inventory of fertilizer? c. What will be the firm's average inventory? d. How often must the company order? 722 Part 7 Managing Global Operations On the same day, Desreumaux agrees to purchase 15,000 more watches in 3 months at the same price of 1 million Swiss francs. a. What is the cost of the watches in U.S. dollars, if purchased at today's spot rate? b. What is the cost in dollars of the second 15,000 batch if payment is made in 90 days and the spot rate at that time equals today's 90-day forward rate? c. If the exchange rate for is 0.50 Swiss francs per dollar in 90 days, how much will Desreumaux have to pay (in dollars) for the watches?