Title: Management Science using Excel: Harnessing Excel's advanced features for business optimization (English Edition)
Publisher: BPB Publications
Publication Date: 2023
Language: English
ISBN 10: 9355518811
ISBN 13: 9789355518811
Binding: Soft cover
Condition: As New

About this title

Synopsis

A practical guide to using Excel for decision making, forecasting, optimization, and more

Key Features

● Solve a wide range of decision-making problems in operations, finance, and statistics.

● Build and use Excel models to analyze data and make informed decisions.

● Use the Excel Solve function to find the optimal solution to a problem.

Description

This book on management science serves as a valuable resource for enhancing problem-solving and decision-making skills across various domains, including organizations and business. By reading this book, you will acquire the ability to tackle complex decisions that would otherwise be challenging. The book covers a wide array of techniques, such as profit and performance maximization, Return on Investment (ROI) optimization, as well as cost, time, and risk minimization through tools like Monte Carlo simulations and sensitivity analysis.

Throughout the book, you'll come across numerous real-life examples and case studies from diverse fields such as banking, finance, transportation, manufacturing, manpower assignment, scheduling, inventory management, and even food and product mix. The book demonstrates both linear and nonlinear techniques, utilizing Excel Solver for finding solutions. Once you grasp the usage of Solver, you'll be able to apply the learned tools effectively to address problems relevant to your background, experience, and preferences.

What sets this book apart is its hands-on approach, leveraging Excel as the primary tool for problem-solving. Rather than relying on complex mathematical formulations and algorithms, you'll learn how to set up and solve problems in a straightforward manner using Excel.

What you will learn

● Learn how to set up decision making models on Excel.

● Solve optimization problems in the areas of business and operations.

● Harness the power of the Excel Solver add-in.

● Apply Monte Carlo simulations of risky investments using Excel.

● Learn how to predict future values using Excel forecasting features.

Who this book is for

This book is for any business or operations practitioner, regardless of their role or experience level. Whether you are an analyst, a business professional, or a student, this book can help you to improve your problem-solving and decision-making skills.

Table of Contents

1. Making Better Decisions with Management Science

2. Exploring Management Science Optimization Techniques

3. Unleash the Power of Excel’s Solver for Optimizations

4. Optimize Product Mix

5. Investment and Portfolio Optimization with Excel’s Solver

6. The Assignment Problem Challenges and Solutions

7. Solving Transportation Supply Chain Problems

8. Marketing Applications of Optimal Media Mix

9. Integer and Binary Optimization

10. The Scheduling Puzzle

11. Nonlinear Optimization Applied to Inventory and Facility Location

12. Monte Carlo Simulations

13. Simplifying Forecasting Using Excel’s Forecast Sheet Feature

14. Queuing and Waiting Time

"About this title" may belong to another edition of this title.

Store Description

GreatBookPrices.com is your top source for finding new books at the absolute lowest prices, guaranteed ! We offer big discounts - everyday - on millions of titles in virtually any category, from Architecture to Zoology -- and everything in between. Discover great deals and super-savings, on professional books, text book titles, the newest computer guides, or your favorite fiction authors. You'll find it all - at HUGE SAVINGS - at GreatBookPrices. Browse through our complete online product catalog today. Serving customers around the world for years, we help thousands find just the books they're looking for -- at incredibly low, bargain prices.

Visit Seller's Storefront

Seller's business information

Far Corner Europe Limited
19-20 Bourne Court, 19-20 Bourne Court, Woodford Green, IG8 8HD, United Kingdom

Sale & Shipping Terms

Terms of Sale

Company Name: GreatBookPricesUK
Legal Entity: Far Corner Europe Limited
Address: 19-20 Bourne Court, Southend Road, Woodford Green Essex, UK IG8 8HD
Registration #: 10691061
Authorized representative: Danielle Hainsey

Shipping Terms

Our warehouses across the globe are fully operational without substantial delays. We are working hard and continue to overcome the daily challenges presented by COVID-19. There have been reports that delivery carriers are experiencing large delays resulting in longer than normal deliveries to customers. See USPS's website for further detail. We would like to apologize in advance if your item arrives later than the expected delivery due date.

Internal processing of your order will take about 1-2 business days. Please allow an additional 4-14 business days for Media Mail delivery. We have multiple ship-from locations - MD,IL,NJ,UK,IN,NV,TN & GA

Shipping rates from United Kingdom to U.S.A.

Shipping rates from United Kingdom to U.S.A.
Order quantity	10 to 30 business days	10 to 27 business days
First item	US$ 20.13	US$ 20.13

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.