Assessment 1: Online Test Excel Activity Investment advice (Excel task) ACME Stock Broking provides investment advice to clients. To provide accurate and meaningful advice, ACME Stock Broking needs to collate data from many different sources into meaningful information that it can use as advice for its clients. Currently ACME Stock Broking has collected mining data over a short period of time from several mining companies exporting their commodities into the open market. Based on the data collected (in the table), ACME needs to know (work out) several key factors before confidently providing advice to its clients. Copy and paste the data provided into Excel or download the spread sheet from within the online test (Excel format) and answer the questions relating to the data. Export customers Commodity Qty (tons) ton Export Unit cost ($)/per price ($)/per ton Export price totals ($) Unit cost totals ($) Overall profit ($) Rio Tinto Steel 320 45 58 BHP Billiton Steel 350 45 58 GVK Coal 155 21 44 Rio Tinto Coal 1109 21 44 GVK Iron Ore 171 20 29 GVK Lead 166 BHP Billiton Coal 270 29 39 21 44 BHP Billiton Lead 168 29 39 Rio Tinto Iron Ore 718 20 29 BHP Billiton Lead 137 29 39 Yancoal Coal BHP Billiton Iron Ore 165 Yancoal Rio Tinto Iron Ore 470 430 Coal 302 21 44 20 29 21 44 20 29 Yancoal Coal 1025 21 44 BHP Billiton Lead 159 29 39 Yancoal Copper 146 33 19 Yancoal Steel 666 45 58 BHP Billiton Coal 397 21 44 Yancoal Iron Ore 1108 20 29
Spreadsheet data questions (marks) 1. Complete the missing totals and profits in the spread sheet. (4 marks) 2. Which commodity made the most amount of profit? (2 marks) 3. Which commodity sold the most amount of tons? (2 marks) 4. Which company made the most amount of profit? (2 marks) 5. Which company made the least amount of profit? (2 marks) Upload your completed spread sheet into the online test where indicated. Also add your answers to the spread sheet data questions there. Porters Five Forces Activity Haddon's Cafe Bar is located on the Swinburne Uni campus right next to the Engineering building. Open from 7 to 7 five days a week, it's there at the right place and time to grab something to eat whether it be before, during, or after your classes. Both indoor and outdoor seating is available, and along with being a licensed venue to sell alcohol. Haddon's is good for whatever mood you're in. It's also a great place to drop in to discuss uni issues with your friends and colleagues. As with most Cafes their main business is selling a variety of coffees to mainly staff and students at a slightly reduced price compared to cafe outside the uni. But it is not the only café on campus and it's not far from the main street where a large number of commercial cafes like Starbucks, McDonalds and many other boutique