Ocean carriers excel spreadsheet analysis
The fourier analysis tool in microsoft excel douglas a kerr issue 1 march 4, 2009 the excel fourier analysis tool the spreadsheet application microsoft excel will take a suite of data values are entered into a range on an excel spreadsheet. Ocean carriers excel ocean carrier case ocean carriers ocean carriers memo 103260670 case 1 ocean carrier ocena carriers 1 stone container corporation documents similar to ocean carriers spreadsheet ocean carriers reports_final case solution uploaded by nadia virk ocean carriers - final sheet uploaded by androiddownloadonly. Excel formula training formulas are the key to getting things done in excel in this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with vlookup and index & match, count and sum with criteria, dynamically rank values, and create dynamic ranges.
Decision analysis 34 simulation 42 excel functions used in model-building 46 (excel’s term for a spreadsheet) models the book takes a structured view of management decision-making by integrating the ac- 18 excel models for business and operations management =,, a 7. Home news ocean carriers excel spreadsheet only three out of 10 top ocean carriers posted a profit in 2016 ten out of 13 big container carriers posted losses in the second half of 2016, reported the paris-based alphaliner consultancy. Ocean carriers the wal-mart vs sears dilemma i have attached a spreadsheet of financial data and ratios to support my analysis to determine which company will be the true retail superpower in the future although both companies are retailers, they do have some significant differences in the way they do business. Course 1 of 5 in the specialization business statistics and analysis the use of excel is widespread in the industry it is a very powerful data analysis tool and almost all big and small businesses use excel in their day to day functioning this is an introductory course in the use of excel and is.
Ocean carriers case solution, in january 2001, mary linn, vice president of finance of shipping companies, shipping company, with offices in new york and hong kong, was evaluating a pro. Freight calculator nov 16, 2009 i'm building a freight calculator and am considering some professional consulting options, but before i do that i wanted to see if i could overcome this one problem. Excel spreadsheet of pest, overnight couriers, most of ocean carriers epgp healthcare axway solution: financial courses which is the operation and be tumbling, specializing in shipments, keiichiro, case studies air carrier in the what factors view all students except the. These questions relate to the ocean carriers case in your course packet you can find the data for this case on the course website in a spreadsheet named: ocean carriers exhibitsxls this case provides the opportunity to make a capital budgeting decision by using discounted cash flow analysis to make an investment and corporate policy decision. Step open a new excel workbook create a name for your file such as incremental analysis you can perform incremental analysis in one worksheet or spread it across multiple worksheets based on the number of incremental revenue and cost assumptions.
Ocean carriers is a us firm subject to 35% taxation similarly capital budgeting on working 1 at excel worksheet provides undiscounted net free cash flows of about $34 million discounting these to current value at 10% gives positive npv of approximately $14 million. This excel file is useful for familiarizing yourself with the what-if spreadsheet's import mechanism risk assessment matrix document in excel and pdf format this is a handy copy of the default risk worksheet within the what-if spreadsheet. Spreadsheet tutorial that shows how to calculate the per-mile cost of operating a car from a total cost perspective it focuses on formulas and other basic s.
Ocean carriers excel spreadsheet analysis
Spreadsheet to (9-201-068) download only harvard business school harvard business review. Read online now ocean carriers case excel solutions ebook pdf at our library get ocean carriers case excel solutions pdf file for free from our online library. Ocean carriers case analysis, ocean carriers case study solution, ocean carriers xls file, ocean carriers excel file, subjects covered cash flow forecasting present value valuation by erik stafford, angela chao, kathleen s luchs source: hbs premier case collection 6 pages.
Aisc steel manual excel offers a large range of free excel spreadsheets for concrete, steel, masonry and wood design, and lateral analysis deepwater access – waterfront facility delivery by coastal & ocean carrier, truck & rail american institute of steel construction 0 comments leave a reply. Using excel to create freight comparison hi, i am using excel 2007 and i am trying to put together a freight comparison chart and need to add the postcodes for a state so that when i enter the postcode in a cell the suburb, state and freight rate appears in their own cells. Excel dashboards used in logistics environment exactly where service companies have capitalized on an enormous marketplace option organizations that could spend money on their unique particular logistics infrastructure did so, and the people moved on to external companies. Use the excel spreadsheet to create schedules for total cost, fixed cost, variable cost, average variable cost, average cost, and marginal cost make the spreadsheet so that the initial quantity and the increment by which quantity increases can be easily changed.
Ocean carriers assumptions and methodology based on an npv analysis considering multiple scenarios, ocean carriers should commission the construction of a new capesize carrier in the event they are operating with no corporate tax and chartering the ship for its entire 25 year life. Excel spreadsheet small business excel templates bookkeeping find this pin and more on excel spreadsheets for business planning by find this pin and more on freight business by 4 free spreadsheet alternatives to microsoft excel microsoft excel is the world's leading spreadsheet application, and it's the one by which all others are measured. We are now ready to trick excel into simulating 1000 iterations of demand for each production quantity select the table range (a15:e1014), and then in the data tools group on the data tab, click what if analysis, and then select data table.