Solve all using Excel, please show all formulas in addition to final answers

Dog-Ann is a pet supplies company serving in Midwest. It sells pet supplies and provides pet grooming and training services. Table 1 shows the income statement of Dog-Ann for the previous year. Sales Cost of Goods Fixed Assets Variable Expenses Fixed Expenses Inventory Accounts Receivable Other Current Assets $250,000 $150,000 $105,000 $25,000 $35,000 $10,000 $5,000 $5,000 a) Develop the strategic profit model of this organization and draw the diagram. b) What is the firm's profit margin? c) What is the firm's ROA Suppose the firm undertakes a supply chain improvement project. It improves its service level to customers by opening more warehouses which means it will be able to deliver more quickly to customers. The result is a 10% increase in sales. Assume cost of goods sold increases by 6%. The new warehouse requires additional new asset investment of $40,000. Fixed expenses increase by $1,000 because of the expense of operating the warehouses. Assume other variables do not change. Answer the following three questions based on this information. d) Show the new strategic profit model. e) What is the new asset turnover? f) What is the firm's new return on assets? Dog-Ann is a pet supplies company serving in Midwest. It sells pet supplies and provides pet grooming and training services. Table 1 shows the income statement of Dog-Ann for the previous year. Sales Cost of Goods Fixed Assets Variable Expenses Fixed Expenses Inventory Accounts Receivable Other Current Assets $250,000 $150,000 $105,000 $25,000 $35,000 $10,000 $5,000 $5,000 a) Develop the strategic profit model of this organization and draw the diagram. b) What is the firm's profit margin? c) What is the firm's ROA Suppose the firm undertakes a supply chain improvement project. It improves its service level to customers by opening more warehouses which means it will be able to deliver more quickly to customers. The result is a 10% increase in sales. Assume cost of goods sold increases by 6%. The new warehouse requires additional new asset investment of $40,000. Fixed expenses increase by $1,000 because of the expense of operating the warehouses. Assume other variables do not change. Answer the following three questions based on this information. d) Show the new strategic profit model. e) What is the new asset turnover? f) What is the firm's new return on assets