...CHAPTER 14 THE PRODUCTION CYCLE SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 14.1. When activity-based cost reports indicate that excess capacity exists, management should either find alternative revenue-enhancing uses for that capacity or eliminate it through downsizing. What factors influence management’s decision? What are the likely behavioral side effects of each choice? What implications do those side effects have for the long-run usefulness of activity-based cost systems? It will often be easier to identify opportunities to downsize and eliminate jobs than to find creative value-adding activities for excess capacity. Thus, management may be more likely to eliminate excess capacity than to redirect it to new tasks. This can have serious negative effects on both employee morale and the long-run survival of the firm. When employees are let go, their knowledge and customer relationships go with them. Some consultants argue that such soft knowledge is a company’s most valuable asset and, therefore, that downsizing is likely to have negative long-run consequences. If management uses ABC systems to justify downsizing, there is likely to be a backlash against and distrust of such systems by many managers. Instead, managers should seek to find new opportunities to productively make use of excess capacity....
Words: 5234 - Pages: 21
...Advanced Modelling in Finance using Excel and VBA Mary Jackson and Mike Staunton JOHN WILEY & SONS, LTD Chichester ž New York ž Weinheim ž Brisbane ž Singapore ž Toronto Copyright 2001 by John Wiley & Sons, Ltd, Baffins Lane, Chichester, West Sussex PO19 1UD, England National 01243 779777 International (C44) 1243 779777 e-mail (for orders and customer service enquiries): cs-books@wiley.co.uk Visit our Home Page on http://www.wiley.co.uk or http://www.wiley.com All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except under the terms of the Copyright, Designs and Patents Act 1988 or under the terms of a licence issued by the Copyright Licensing Agency, 90 Tottenham Court Road, London W1P 9HE, UK, without the permission in writing of the publisher. Other Wiley Editorial Offices John Wiley & Sons, Inc., 605 Third Avenue, New York, NY 10158-0012, USA Wiley-VCH Verlag GmbH, Pappelallee 3, D-69469 Weinheim, Germany John Wiley & Sons Australia Ltd, 42 McDougall Street, Milton, Queensland 4064, Australia John Wiley & Sons (Asia) Pte Ltd, 2 Clementi Loop #02-01, Jin Xing Distripark, Singapore 129809 John Wiley & Sons Canada Ltd, 6045 Freemont Blvd, Mississauga, ONT, L5R 4J3, Canada British Library Cataloguing in Publication Data A catalogue record for this book is available from the British...
Words: 57326 - Pages: 230
...Volatility Forecasting Candidate number: Abstract This paper constructs a hedged portfolio with a long positon in S&P 500 index and a short position in FTSE 100 index. To calculate the time-varying hedge ratio, we use four methods, rolling window, EWMA, GARCH model and B-S model. Firstly, we explain the methods we used, including the assumptions, formulas and implications. Also, we implement the methods in the Excel to get the value of hedge ratios. Finally, we show the advantages and disadvantages of every method by comparing between every two methods. We evaluate the methods both in theory and practical application. Introduction: We want to hold a long position in S&P 500 index, at the same time we want to minimum-variance. As this reason, we introduce to hedge the long position in S&P 500 index with a short position in the FTSE 100 index. We suppose that the return on the hedged portfolio is: rp,t=rS&P-htrFTSE Then the variance of hedged profile will be: δF2=δS&P2+h2δFTSE2-2hδS&P,FTSE If we want to minimum the variance of the hedged portfolio, we must derivate of h in this function and let the equal to zero. Where ht is the time-varying hedge ratio, given by: ht=δS&P,FTSE,tδS&P2 Because we want to get the result only focus on the two-index, we ignore the currency flotation by assume that the currency rate is perfectly hedged. At very beginning, risk manager have assumed that the volatility is constant...
Words: 4782 - Pages: 20
...pricing 215–219 Currency trading 220 Capital budgeting 290–295 Estimating stock betas 396–401 Hedging risk with put options 407–408 Stock hedging 407–408 Asset management 409–410 New product development 503–504, 574, 673–676, 715–722 Bidding for a government contract 513–518, 523–533, 653–657 Investing with risk aversion 557–560 Land purchasing decision 575 Risk analysis 582–583 Liquidity risk management 651–653 Estimating warranty costs 657–661 Retirement planning 681–685 Modeling stock prices 685–686 Pricing options 686–689, 691–693 Investing for college 732 Bond investment 733 HUMAN RESOURCES AND HEALTH CARE Fighting HIV/AIDS 23–24 DEA in the hospital industry 184–189 Salesforce allocation problems 454–456 Assigning MBA students to teams 462 Selecting a job 484–492 Selecting a health care plan 519–521 Drug testing for athletes 535–538, 539–542 MARKETING Determining an advertising schedule 133–141, 373–376, 465–471, 480–483 Estimating an advertising response function 369–373 Retail pricing 422–427 Estimating a sales response function 437–441 Cluster analysis of large cities 445–449 Classifying subscribers of the WSJ 450–453 New...
Words: 68271 - Pages: 274
...MS-EXCEL FOR CHARTERED ACCOUNTANTS SUNIL B GABHAWALLA CHARTERED ACCOUNTANT WESTERN INDIA REGIONAL COUNCIL OF THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA TABLE OF CONTENTS 1 2 Basics & Beyond......................................................................................................... 4 1.1 Introduction......................................................................................................... 4 1.2 The EXCEL Screen............................................................................................. 4 1.3 Moving Around................................................................................................... 5 Data Entry ................................................................................................................... 8 2.1 Text ..................................................................................................................... 8 2.2 Number (including date, time, percent) .............................................................. 8 2.3 Formulae ............................................................................................................. 8 2.4 Functions............................................................................................................. 9 2.5 AutoComplete ..................................................................................................... 9 2.6 AutoCorrect........................................................................................
Words: 16077 - Pages: 65
...CHAPTER 1 What Is Financial Modelling? here are all sorts of complicated definitions of financial modelling, and in my experience there is quite a bit of confusion around what a financial model is exactly. A few years ago, we put together a Plum Solutions survey about the attitudes, trends, and uses of financial modelling, asked respondents “What do you think a financial model is?” Participants were asked to put down the first thing that came to mind, without any research or too much thinking about it. I found the responses interesting, amusing, and sometimes rather disturbing. Some answers were overly complicated and highly technical: n T n n n n “Representation of behaviour/real-world observations through mathematical approach designed to anticipate range of outcomes.” “A set of structured calculations, written in a spreadsheet, used to analyse the operational and financial characteristics of a business and/or its activities.” “Tool(s) used to set and manage a suite of variable assumptions in order to predict the financial outcomes of an opportunity.” “A construct that encodes business rules, assumptions, and calculations enabling information, analysis, and insight to be drawn out and supported by quantitative facts.” “A system of spreadsheets and formulas to achieve the level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future.” Some philosophical: n “A numerical...
Words: 17366 - Pages: 70
...functions, charts, worksheets, and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis, Goal Seeking, external database files, and pivot tables • Develop custom functions, program with VBA, and create UserForms • Try new slice-and-dice tools to dynamically filter your data Preview how your copied text will look www.wiley.com/compbooks Spot trends in your data with Sparklines John Walkenbach aka “Mr. Spreadsheet” is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com. ® • All the examples and workbook files used in the book Microsoft® Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM: Excel 2010 What’s on the CD-ROM? • Get up to speed on everything new in Excel 2010 • Perform magic with array formulas—and even more with Sparklines CD-ROM Included John Walkenbach If Excel can do it, John Walkenbach can show you how What better way to learn Excel 2010 than from “Mr. Spreadsheet” himself? Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel...
Words: 167105 - Pages: 669
...Excel 2010 Microsoft ® ® ® Formulas John Walkenbach BONUS CD-ROM! Includes all Excel workbook files used in the book, plus the complete book in a searchable PDF file Excel® 2010 Formulas by John Walkenbach Excel® 2010 Formulas Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2010 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 7486011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks...
Words: 49651 - Pages: 199
...How to go to your page This eBook includes two bonus chapters, which are paginated separately from the rest of the book. The pagination of the bonus chapters consists of the identifer “BC” followed by the page number. For example, to go to page 5 of the bonus chapters, type BC5 in the “page #” box at the top of the screen and click “Go.” To go to page 15, type BC15… and so forth. Get More and Do More at Dummies.com ® Start with FREE Cheat Sheets Cheat Sheets include • Checklists • Charts • Common Instructions • And Other Good Stuff! To access the Cheat Sheet created specifically for this book, go to www.dummies.com/cheatsheet/excelvbaprogramming Get Smart at Dummies.com Dummies.com makes your life easier with 1,000s of answers on everything from removing wallpaper to using the latest version of Windows. Check out our • Videos • Illustrated Articles • Step-by-Step Instructions Plus, each month you can win valuable prizes by entering our Dummies.com sweepstakes. * Want a weekly dose of Dummies? Sign up for Newsletters on • Digital Photography • Microsoft Windows & Office • Personal Finance & Investing • Health & Wellness • Computing, iPods & Cell Phones • eBay • Internet • Food, Home & Garden Find out “HOW” at Dummies.com *Sweepstakes not currently available in all countries; visit Dummies.com for official rules. Excel VBA Programming ® FOR DUMmIES 2ND ‰ EDITION by John Walkenbach Excel® VBA Programming For Dummies®, 2nd Edition Published...
Words: 98776 - Pages: 396
