Please show all work on excel, show all formulas and concepts on how you got your numbers. Will rate thumbs up, thank you.

Solve the following problems on separate Excel worksheets. Show all your work. Use formulas for all calculations. Provide notation for all outside sources. 1. The Lazenby Corporation sells on a cash-only basis (no credit) and has current sales of $15,000,000 Currently, variable costs are 70% of sales and no new fixed costs will be incurred if sales increase. The firm is considering a 30-day credit period, which it expects will increase sales to $17,500,000 but bad debt would be 1% of sales. Cash customers would receive a 1% discount. The firm's cost of capital is 12%. Calculate the change in investment in receivables and the change in profitability if Lazenby enacts this new credit policy. 2. The Dalton Company sells cello cases at a price of $250 each. When Dalton orders new cases, it pays a $750 fixed cost per order, and its annual carrying cost is 15%. If Dalton sells 10,000 cases per year, what is the Economic Order Quantity? What is Dalton's Total Inventory Cost? Solve the following problems on separate Excel worksheets. Show all your work. Use formulas for all calculations. Provide notation for all outside sources. 1. The Lazenby Corporation sells on a cash-only basis (no credit) and has current sales of $15,000,000 Currently, variable costs are 70% of sales and no new fixed costs will be incurred if sales increase. The firm is considering a 30-day credit period, which it expects will increase sales to $17,500,000 but bad debt would be 1% of sales. Cash customers would receive a 1% discount. The firm's cost of capital is 12%. Calculate the change in investment in receivables and the change in profitability if Lazenby enacts this new credit policy. 2. The Dalton Company sells cello cases at a price of $250 each. When Dalton orders new cases, it pays a $750 fixed cost per order, and its annual carrying cost is 15%. If Dalton sells 10,000 cases per year, what is the Economic Order Quantity? What is Dalton's Total Inventory Cost