need #3, 4, & 6-10

4. Use the Internet to research and describe "Brexit" and its latest developments. SPREADSHEET PROBLEMS 1. If a firm's net income (profits before taxes) is $120,000 and it has total assets of $1.5 million, what is its return on assets? 2. If a firm's total assets is $2.5 million and its return on assets is 12 percent, what is its net income? 3. If a firm is able to sustain the same level of operations in terms of sales and administrative expenses but reduces its materials cost by $50,000 through smarter purchases, what is the profit-leverage effect on gross profits? What is the profit- leverage effect on profits before taxes? 4. If a firm's cost of goods sold is $2.5 million and its average inventory is $500,000, what is the inventory turnover? 5. If a firm's cost of goods sold is $5 million and its inventory turnover is ten times, what is the average inventory? 6. If a firm's inventory turnover is eight times and its average inventory is $160,000, what is the cost of goods sold? 7. A retailer in Las Vegas has an ending inventory of $250,000 as of December 31, 2016, and the following accounting information. MONTH ENDING INVENTORY COST OF GOODS SOLD Lanary $225,000 $1.200.000 February $325.000 $1.250.000 Mach $240,000 $1,350,000 April $325,000 $1,500,000 May S460,000 $950,000 one $220.000 $850,000 Joly $85.000 $1,650,000 August $156,000 $1325,000 September $220,000 $1,750,000 October $265,000 $850,000 November $100.000 $2.200.000 December $350,000 $3.500 a. Compute the monthly inventory turnover ratio for each of the twelve months. b. What are the annual cost of goods sold and the average inventory for the year? 6. Compute the annual inventory turnover ratio. How is the retailer's performance compare to the industry standard, assuming its business is similar to Walmart's? MONTH make the components? What is the cost savings for choosing the cheaper option? make the components? What is the cost savings for choosing the cheaper option? Supply issues in Supply Chain Management 8. A small firm has an ending inventory of $52,000 as of December 31, 2016, and the fol lowing accounting information ENDING INVENTORY COST OF GOODS SOLD $75,000 5225.000 February $56.000 $325.000 March $25.000 5200.000 April $85.000 5125.000 May $125,000 SM60.000 lane 595.000 $220,000 $72.000 SI5.000 Mogust $45.000 $150.000 September $52,500 sz20.000 October $120.000 5265.000 November $162,500 $100.000 December $55.000 $150,000 a. Compute the monthly inventory turnover ratio for each of the twelve months. b. What are the annual cost of goods sold and the average inventory for the year? c. Compute the annual inventory turnover ratio. What can the purchasing department do to improve the firm's performance? 9. You are given the following information: COSTS MAKE OPTION BUY OPTION Ford Cost $125.000 55.000 Variable Cost 512 a. Find the break-even quantity and the total cost at the break-even point b. If the requirement is 150,000 units, is it more cost-effective for the firm to buy or make the components? What is the cost savings for choosing the cheaper option? 10. You are given the following information: COSTS MAKE OPTION Fired Cost $25.000 $1.000 Variable Cou $8 512 a. Find the break-even quantity and the total cost at the break-even point. Or 11 Ms Jane Kim, purchasing manager of Kuantan ATV, Inc., is negotiating a BUY OPTION Or