Report on Use of MS Excel in Corporate World

Added on - 04 Jun 2020

  • 15

    Pages

  • 3296

    Words

  • 52

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 15 pages
DEVELOP AND USECOMPLEX SPREADSHEET
Table of ContentsINTRODUCTION...........................................................................................................................2TASK 1............................................................................................................................................2TASK 2............................................................................................................................................6Advanced functions of spreadsheet software applications..........................................................6Impact of formatting and designing on presentation and readability of data...............................7Organizational requirements for ergonomics, work period and breaks and conservationstechniques.....................................................................................................................................7WRITTEN/VERBAL QUESTIONS...............................................................................................91. Steps to develop a spreadsheet.................................................................................................92. Requirements to develop a linked spreadsheet........................................................................93. Steps involved in automating and standardizing spreadsheet..................................................94. Basic process to use spreadsheet............................................................................................105. Steps to present numerical data in graphical form.................................................................106. Relative and absolute cell reference.......................................................................................117. Data entry...............................................................................................................................118. Common type of charts and graphs........................................................................................11CONCLUSION..............................................................................................................................11REFERENCES..............................................................................................................................13
INTRODUCTIONIn real world, managers need to carry out various calculations to examine relevantinformation and data set for the purpose of rationale decisions. The current report aims atidentifying the practical use of MS Excel in the corporate world. The assignment will criticallyinvestigate the use of different features of MS Excel to assess that how it can be use foranalytical purpose and data visualization. Despite this, ergonomics requirements in workplacesettings that every entity must follow will be discuss. In addition, various ways to save excessiveenergy consumption will be present.TASK 1Spreadsheet development: A spreadsheet has been design to examine the informationpresented in the income statement of ABC Ltd. For such purpose, various formulas had used anda column graph had designed to clearly present summarized details.Formula used in Excel creation:Net sales = Sales – Sales return and allowance= F6 – F7Cost of Goods sold = Opening stock + Purchase + Fright inward – closing inventory= F11 + F14 – F15Gross profit (Loss) = Net sales – Cost of goods sold= F8 - F16Total Expenses = Sum (F21:F35)Net Operating Income = Gross profit – Total expensesF18 – F36Earnings before tax = Net operating income + Interest received – Interest paid= F38 + F42 – F4Corporation tax rate = Earnings before tax * 27.5%
Net profit = Earnings before tax – Tax= F45 – F46Macro feature used for computing net profit using the same formula applied for the netsales.Income StatementFor the Year Ended 31st March 2017ParticularsAmountRevenueGross Sales$ 34,000.00Less: sales return andallowance$ 2,600.00Net Sales$ 31,400.00Cost of Goods SoldBeginning Inventory$ 12,000.00Add: Purchase$ 8,000.00Add: Fright inward$ 200.00$ 20,200.00Less: Ending inventory$ 2,000.00Cost of Goods Sold$ 18,200.00Gross Profit (Loss)$ 13,200.00Expenses:Advertising$ 900.00Bank Charges$ 200.00Commissions$ 150.00Delivery Expenses$ 50.00Depreciation$ 1,200.00Insurance$ 1,000.00Maintenance$ 180.00Miscellaneous$ 250.00Office Expenses$ 550.00Postage$ 200.00Rent$ 2,000.00Repairs$ 800.00Telephone$ 200.00Utilities$ 600.00Wages$ 2,500.00Total Expenses$ 10,780.00Net Operating Income$ 2,420.00
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document