do it buy excel........................................asap thank you

Computer lab Exercise question-07: Week 11 Spumante Manufacturer Ltd had provided a list of adjusted ledger account balances at the end of financial year of 30 June 2014. All ledger balances are normal balances. Advertising expense Sales travel expense Depreciation-factory machinery Depreciation-office equipment Direct labour Factory power Factory rent Factory supplies Finished goods, 1/7/2013 Finished goods, 30/6/2014 Freight inward (materials) Indirect labour Machinery repairs $ 60,000 18,300 19,200 7,200 195,000 18,000 120,000 148,000 130,000 125,000 8,700 64,000 38,900 Administrative office rent Office salaries Rates-factory Discounts received on raw materials Raw materials inventory 1/7/2013 Raw materials inventory 30/6/2014 Raw materials purchases Sales revenue Sales returns Sales commissions Work in process, 1/7/2013 Work in process, 30/6/2014 $ Using Microsoft Excel you are required to: A. Prepare a cost of goods manufactured statement for the year ended 30 June 2014. B. Prepare an income statement for the year ended 30 June 2014. 30,000 211,200 24,000 4,000 57,600 62,400 640,000 1,900,000 31,400 57,300 27,000 30,000