Most employers expect business graduates to be Excel proficient, so it is vital that you learn to use this tool effectively during your time at MSU Denver. Whilst many of you may already use Excel, others might have limited knowledge of the software. Excel is a core instrument in the arsenal of all business professionals, and this project is a self-directed learning exercise that introduces you to how a spreadsheet can be used to calculate, model, and present complex financial information. Your instructor will not give you a lecture on how to complete this project but may provide advice and direction if you encounter difficulties. Excel knowledge and proficiency primarily comes from using and learning the package, but there are many useful YouTube videos and Excel sites that provide illustrative examples of how to use Excel. If you get 'stuck on the basic functionality of Excel explained with this assignment briefing, consult the help facility in Excel or use Google to find a solution. This Excel project tests your basic accounting knowledge by asking you to prepare the periodic management accounts for Plastic Manufacturing, a manufacturing entity. You will use some basic Excel features (formula, formatting options, comment boxes and worksheet links) to prepare the followings accounting statements for Plastic Manufacturing: I A. Cost of goods manufactured for the year ended June 30, 2021 B. Cost of goods sold for the year ended June 30, 2021 C. Income statement for the year ended June 30, 2021 D. Yearly pre-tax expense analysis report for the year ended June 30, 2021 See the relevant chapter of your textbook and the instructions provided in this document for illustrative examples of the format and layout for these accounting statements. Emphasis A A Data Section 1 Plastic Manufacturing 2. For the year ended June 30, 2021 3 Data Section 4 Inventories July 1, 2020 June 30, 2021 5 Beginning raw materials inventory 92.000 6 Ending raw materials Inventory 95,000 7 Beginning work in process Inventory 88,000 Ending work in process inventory 75,000 9. Beginning finished Goods Inventory 95,000 10 Ending finished Goods inventory 110,000 11 Total inventories 275.000 280.000 12 11 Direct factory costs incurred during period: 14 Raw materials purchased 310,000 15 Direct labor 280,000 16 17 Other costs incurred during period 18 Rent factory 50,000 19 Rent corporate office 22.000 20 Utility costs corporate office 10.500 21 Utility costs - factory 40,000 22 insurance and property taxes - Factory 24,000 23 Advertising expenses 52.000 24 Equipment maintenance costs-factory 45.000 25 indirect labor costs. 172.000 26 Corporate office personells salaries 162,000 27 Sales Mesenative salaries BR.000 20 Depreciation expense factory equipment 110,000 29 Depreciation Expense office equipment 25.000 interest expense 20.000 11 Tot costs and expenses 13 Sales revenus 1.850,000 34 Trade i reakinton/profit is less than 400.000 20N 35 Tarratei pe to income at least 400.000 B01 indude theory anductions and factory maintenance Focus English (United States Privacy Report 19 tv A
