How do i calculate cost of goods sold & gross profit using formal for excel using the information below.

A25 fx Collections B C D E F G . - J L March July October 1 Wally's Widgets 2 Budgeted Sales in Units 3 Add: Ending Inventory 4 Total Needs 5 Less Beginning Inventory 6 Required Purchases in Units 7 Required Purchases in Dollars 8 Budgeted Sales in Dollars 9 Sales Commissions in Dollars 10 January 10,000 6,150 16,150 6,000 10,150 60,900 120,000 12,000 February 10,250 6,300 16,550 6,150 10,400 62,400 123,000 12,300 10,500 6,450 16,950 6,300 10,650 63,900 126,000 12,600 April 10,750 6,600 17,350 6,450 10,900 65,400 129,000 12,900 May 11,000 6,750 17,750 6,600 11,150 66,900 132,000 13,200 June 11,250 6,900 18,150 6,750 11,400 68,400 135,000 13,500 11,500 7,050 18,550 6,900 11,650 69,900 138,000 13,800 August 11,750 7,200 18,950 7,050 11,900 71,400 141,000 14,100 September 12,000 7,350 19,350 7,200 12,150 72,900 144,000 14,400 12,250 7,500 19,750 7,350 12,400 74,400 147,000 14,700 November 12,500 7,650 20,150 7,500 12,650 75,900 150,000 15,000