{"product_id":"excel-models-for-business-and-operations-management-paperback-softback-9780470015094","title":"Excel Models for Business and Operations Management (Paperback \/ softback) 9780470015094","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eExcel Models for Business and Operations Management\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eJohn Barlow (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780470015094, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 22 April 2005\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e432 pages\u003cbr\u003e23.8 x 19.2 x 2.4 cm, 0.765 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003eThe popularity of spreadsheets in both business and academia has increased considerably over the past five years. This new edition of a successful textbook will be thoroughly updated to reflect changing practices and technology.  \u003cp\u003eThis text adopts an active learning approach with the emphasis being placed on the utilization of software tools to help build models. The book’s primary approach is to help the reader put theory into practice. The ‘learn by example’ approach used throughout the book guides the user through the complexities of model building. Every day examples from business and operations management form the basis of the book’s ‘hands on’ development models that help the reader to appreciate Excel’s power and flexibility.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003ePreface xiii\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 A systems view of business 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 1\u003c\/p\u003e \u003cp\u003eA systems view of business operations 2\u003c\/p\u003e \u003cp\u003eA manufacturing business model 3\u003c\/p\u003e \u003cp\u003eFinance and cost accounting 3\u003c\/p\u003e \u003cp\u003eThe marketing function 5\u003c\/p\u003e \u003cp\u003eThe production function 5\u003c\/p\u003e \u003cp\u003eManagement decision-making 12\u003c\/p\u003e \u003cp\u003eEnterprise resource planning (ERP) 15\u003c\/p\u003e \u003cp\u003eReferences and further reading 16\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Model-building tools 17\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 17\u003c\/p\u003e \u003cp\u003eModelling characteristics 18\u003c\/p\u003e \u003cp\u003eRisk and uncertainty in decision-making 20\u003c\/p\u003e \u003cp\u003eLinear programming (LP) 21\u003c\/p\u003e \u003cp\u003eUsing Excel’s ‘Analysis ToolPak’ 26\u003c\/p\u003e \u003cp\u003eStatistical methods 27\u003c\/p\u003e \u003cp\u003eDecision analysis 34\u003c\/p\u003e \u003cp\u003eSimulation 42\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 46\u003c\/p\u003e \u003cp\u003eExercises 49\u003c\/p\u003e \u003cp\u003eReferences and further reading 51\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1 Business Models 53\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Financial models 55\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 55\u003c\/p\u003e \u003cp\u003eFinancial statements 56\u003c\/p\u003e \u003cp\u003eRatio analysis 56\u003c\/p\u003e \u003cp\u003eNet present value (NPV) 59\u003c\/p\u003e \u003cp\u003eInvestment appraisal 61\u003c\/p\u003e \u003cp\u003ePortfolio management 64\u003c\/p\u003e \u003cp\u003eCapital budgeting using decision trees 68\u003c\/p\u003e \u003cp\u003eCash flow analysis 69\u003c\/p\u003e \u003cp\u003eInvestment financing: a simulation model 74\u003c\/p\u003e \u003cp\u003eFinancial planning 78\u003c\/p\u003e \u003cp\u003eCommercial add-in products for Excel 82\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 82\u003c\/p\u003e \u003cp\u003eExercises 86\u003c\/p\u003e \u003cp\u003eReferences and further reading 88\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Investment analysis models 89\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 89\u003c\/p\u003e \u003cp\u003eRisk preference attitudes 90\u003c\/p\u003e \u003cp\u003eUtility theory 91\u003c\/p\u003e \u003cp\u003ePortfolio theory: the Markowitz model 94\u003c\/p\u003e \u003cp\u003ePortfolio analysis: the efficient frontier 97\u003c\/p\u003e \u003cp\u003eSingle index model (SIM) 101\u003c\/p\u003e \u003cp\u003eThe capital asset pricing model (CAPM) 106\u003c\/p\u003e \u003cp\u003eBond valuation 108\u003c\/p\u003e \u003cp\u003eDuration and bond volatility 113\u003c\/p\u003e \u003cp\u003eThe Black–Scholes option pricing model 117\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 120\u003c\/p\u003e \u003cp\u003eExercises 124\u003c\/p\u003e \u003cp\u003eReferences and further reading 126\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Worksheet applications in cost accounting 127\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 127\u003c\/p\u003e \u003cp\u003eCost-volume-profit analysis 128\u003c\/p\u003e \u003cp\u003eDepreciation 130\u003c\/p\u003e \u003cp\u003eEquipment replacement 132\u003c\/p\u003e \u003cp\u003eStatistical replacement analysis 136\u003c\/p\u003e \u003cp\u003eSimulation model for replacement\/repairs 140\u003c\/p\u003e \u003cp\u003eComparison between simulation and statistical results 144\u003c\/p\u003e \u003cp\u003eBudgeting 144\u003c\/p\u003e \u003cp\u003eJob costing 150\u003c\/p\u003e \u003cp\u003eThe learning curve 155\u003c\/p\u003e \u003cp\u003eChecking the accuracy of learning curves 158\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 160\u003c\/p\u003e \u003cp\u003eExercises 163\u003c\/p\u003e \u003cp\u003eReferences and further reading 166\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Marketing models 167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 167\u003c\/p\u003e \u003cp\u003eOrganising and presenting data 167\u003c\/p\u003e \u003cp\u003eCorrelation analysis and linear regression 170\u003c\/p\u003e \u003cp\u003eForecasting – time series and exponential smoothing 174\u003c\/p\u003e \u003cp\u003eForecasting – exponential smoothing 178\u003c\/p\u003e \u003cp\u003eSalesforce models 186\u003c\/p\u003e \u003cp\u003eGoal programming 190\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 200\u003c\/p\u003e \u003cp\u003eExercises 201\u003c\/p\u003e \u003cp\u003eReferences and further reading 205\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Purchase order processing: a database application 206\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 206\u003c\/p\u003e \u003cp\u003eCreating a simple macro 207\u003c\/p\u003e \u003cp\u003ePurchase order processing 209\u003c\/p\u003e \u003cp\u003eCreating the title screen 210\u003c\/p\u003e \u003cp\u003eProducts and suppliers worksheets 214\u003c\/p\u003e \u003cp\u003eCreating the purchase order form 215\u003c\/p\u003e \u003cp\u003eCreating the database and its associated macros 219\u003c\/p\u003e \u003cp\u003eMacros for transferring data into the database 221\u003c\/p\u003e \u003cp\u003eAdding macros to buttons 224\u003c\/p\u003e \u003cp\u003eAmending purchase orders 225\u003c\/p\u003e \u003cp\u003ePrinting purchase orders 230\u003c\/p\u003e \u003cp\u003eProtecting the POP database application 232\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 236\u003c\/p\u003e \u003cp\u003eExercises 237\u003c\/p\u003e \u003cp\u003eReferences and further reading 239\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2 Models for Operations Management 241\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Statistical applications in quality control 243\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 243\u003c\/p\u003e \u003cp\u003eProbability distributions 244\u003c\/p\u003e \u003cp\u003eAcceptance sampling 249\u003c\/p\u003e \u003cp\u003eEstimation – drawing conclusions from samples 253\u003c\/p\u003e \u003cp\u003eHypothesis testing – checking out a claim! 257\u003c\/p\u003e \u003cp\u003eAnalysis of variance (ANOVA) 258\u003c\/p\u003e \u003cp\u003eStatistical process control 263\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 272\u003c\/p\u003e \u003cp\u003eExercises 275\u003c\/p\u003e \u003cp\u003eReferences and further reading 278\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 Inventory control models 279\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 279\u003c\/p\u003e \u003cp\u003eGlossary of inventory terms 280\u003c\/p\u003e \u003cp\u003eCharacteristics of inventory models 281\u003c\/p\u003e \u003cp\u003eDeterministic models 282\u003c\/p\u003e \u003cp\u003eProduction order quantity model 284\u003c\/p\u003e \u003cp\u003eInventory models with constraints 291\u003c\/p\u003e \u003cp\u003eProbabilistic models 293\u003c\/p\u003e \u003cp\u003eInventory control: a simulation approach 304\u003c\/p\u003e \u003cp\u003eMaterial requirements planning 307\u003c\/p\u003e \u003cp\u003eLot-sizing methods 315\u003c\/p\u003e \u003cp\u003eJust-in-time (JIT) approach to inventory management 318\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 318\u003c\/p\u003e \u003cp\u003eExercises 319\u003c\/p\u003e \u003cp\u003eReferences and further reading 323\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Models for production operations 324\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 324\u003c\/p\u003e \u003cp\u003eLogistics models 325\u003c\/p\u003e \u003cp\u003eOther network flow applications 331\u003c\/p\u003e \u003cp\u003eProduction planning and scheduling 339\u003c\/p\u003e \u003cp\u003eQueuing models 353\u003c\/p\u003e \u003cp\u003eExcel functions used in model-building 362\u003c\/p\u003e \u003cp\u003eExercises 364\u003c\/p\u003e \u003cp\u003eReferences and further reading 369\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Project management 370\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview 370\u003c\/p\u003e \u003cp\u003eProject management techniques 371\u003c\/p\u003e \u003cp\u003eThe project network 371\u003c\/p\u003e \u003cp\u003eSimulation model for project management 392\u003c\/p\u003e \u003cp\u003eExercises 396\u003c\/p\u003e \u003cp\u003eReferences and further reading 399\u003c\/p\u003e \u003cp\u003eAppendix Excel refresher notes 400\u003c\/p\u003e \u003cp\u003eBasic Excel commands 400\u003c\/p\u003e \u003cp\u003eDrawing charts with ChartWizard 405\u003c\/p\u003e \u003cp\u003eObject linking and embedding (OLE) 407\u003cbr\u003e Index 409\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Business \u0026amp; management [\u003ca title=\"See our other books on Business \u0026amp; management\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Business%20\u0026amp;%20management%20%5BKJ%5D%22\"\u003eKJ\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52255783125272,"sku":"9780470015094","price":54.75,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9780470015094.jpg?v=1781274132","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/excel-models-for-business-and-operations-management-paperback-softback-9780470015094","provider":"Freshly Printed Books","version":"1.0","type":"link"}