Assignment#1 Problem 1: Table 1 contains data for the number of pedestrians that were killed in the United States in 1994 in motor vehicle crashes. Table 1: Perform the following procedures in Excel. 1. Create an Excel file with the above data (worksheet’s name is “Pedestrians”). 2. Calculate the total number of pedestrian fatalities that occurred during weekdays. Calculate the percent of all weekday fatalities that occurred during each of the given times of day. 3. Calculate the total number
Premium Prime number Time SQL
2. Costing aircraft components A British Aerospace case study Introduction When we think about the cost of an aircraft‚ we tend to think of the cost of buying the product rather than the costs of running it! British Aerospace’s service to the customer does not stop at the aircraft acquisition stage‚ when the aeroplane is sold to the customer. If anything‚ this is when the customer relationship begins. This case study focuses upon the processes involved in costing aircraft components. Given the
Premium Cash flow Cost
On the morning of April 15‚ 1912‚ the sinking of the Titanic the previous night shocked the world. The year had dawned bright with promise and the maiden voyage of the Titanic was a symbol of the advances mankind had made in the last few years. The ship was considered to have been so well constructed it was believed she could sustain any amount of damage and still remain afloat. Late on the night of April 14‚ 1912‚ the sinking of the Titanic proved this idea wrong in a horribly tragic way. The
Premium RMS Titanic
MECH 8250 – Building Systems Module 1 - Heating Load Calculations Module 1 Heating Load Calculations The amount of heat is required for the building heating system to maintain a balance of the building heat loss. The amount of heat and moisture are gained from the building internal and external heat sources that is required to be removed by the building cooling system. Both heating and cooling loads form the basis in designing the HVAC systems for the building and occupied spaces to achieve both
Premium Heat transfer HVAC Heat
Transaction Num. - Date Cash&Eq. + Other Assets = Liabilities + Beg. Balance a b 0 30.000 15.000 0 c d -8.400 -7.000 4.200 6.883 e f g h i j k -20.000 23.000 40.000 -10.000 -2.000 33.000 3.000 -8.500 5.000 -9.000 -3.000 15.000 75 Comments. One nespaper advertisement is 300 58.100 20.000 300 3.000 -8.500 6.000 9.000 1 2 End. Balance 0 Ret. Other + Eernings + Com. Beg. Income 0 0 0 30.000 Paid-in Capital 34.083 44.875 30.000 17.308 17.308 0 + Income - Expenses 0 -6
Premium Generally Accepted Accounting Principles Asset Depreciation
Date: 06-01-2011 Word Count: 3710 Bachelor of Business (Marketing) Program Table of Contents Executive Summary 1. Literature Review 1.1 Sustainability 1.2 Store Design 1.3 Sustainable Store Design 2. Introduction of The Body Shop 3. Case Study: The Body Shop 3.1 Current Store Design 3.1.1 Store Infrastructure 3.1.2 Store Layout 3.1.3 Merchandise spatial planning 3.1.4 Visual Merchandising 4. Recommendation 5. Conclusion 6. References 1 2 2 3 6 7 8 8 9 11 12 13 14 23 24 Appendices
Premium Retailing Sustainability Marketing
FINANCIAL ANALYSIS OF PAKISTAN INTERNATIONAL AIRLINES Submitted by Chemical Engineer Adnan Khalid Submitted to : Dr rashid Ahmed Institute Of Business and Management‚ UET‚ Lahore. PAKISTAN INTERNATION AIRLINES Back ground and History Airline Industry General Environmental Analysis The airline industry is very stable and unlikely to change in the near future. There are many reasons for this. Air travel continues to grow and will continue in this fashion as long as the economy stays in an
Premium Generally Accepted Accounting Principles Pakistan International Airlines Airline
APPENDIX B Excel Template Instructions for the Glo-Brite Payroll Project (Using Excel 2010) The Excel template for the Payroll Project is an electronic version of the books of account and payroll records. This is not an automated payroll system‚ but an example of how you might use a spreadsheet program to keep payroll records and account for payroll transactions. You will need to follow the instructions in the textbook to complete the project. The instructions provided below will enable
Premium Spreadsheet Bookkeeping
Acid-Base Calculations The Ion-Product Constant for Water‚ Kw Water undergoes ionization to a small extent: H20(l) H+(aq) + OH–(aq) The equilibrium constant for the reaction is the ion-product constant for water Kw: (1) This is a key equation in acid-base chemistry. Note that the product of [H+] and [OH–] is a constant at a given temperature (Eq(1) value is for 25oC). Thus as the hydrogen ion concentration of a solution increases‚ the hydroxide ion concentration decreases
Premium Acid dissociation constant Acid PH
------------------------------------------------- Excel Assignment #1 Exercise 1: Student Grade Book (expected time – less than 45 minutes) Please download the spreadsheet Excel Assignment 1.xlsx from Blackboard. Click on worksheet E1 (you may be in Worksheet E1 by default). This spreadsheet keeps track of students’ grades. There are two exams – Exams 1 and Exam 2. Please do the following: (a) Find the total weighted score for the semester based on Exam 1 and Exam 2 and their respective weights
Premium Spreadsheet Microsoft Excel