Full course description
In this Certificate, you learn to use Excel Solver, Crystal Ball and Tree Plan, etc to solve practical business problems.
- Taught by Hiroshi Ochiumi, PhD, MBA.
- Develop critical skills to help optimize business decisions under uncertainty.
- Learn basic techniques of coordinating, integrating and leveraging supply chain elements.
Project, Operations and Supply Chain Management
How to minimize ambiguity in business decision making? How to improve operational efficiency?
This Certificate equips students with a number of critical skills to help optimize business decisions under uncertainty, effectively manage projects and tighten supply chain management to achieve higher profits. Students will learn basic techniques of coordinating, integrating and leveraging supply chain elements, including sourcing, purchasing, forecasting, production, planning and transportation, and a framework for completing projects on time and on budget. Additionally, they will learn to use spreadsheets and simulation models such as Excel Solver, RAND, Crystal Ball and Tree Plan to evaluate the magnitude and likelihood of success of introducing new products into the market.
This Certificate has three Units so you can easily fit the learning into your personal schedule.Download Syllabus
Spreadsheet Applications for Decision Making
In Unit One students learn to maximize Excel as a decision support tool in addition to their current use of Excel to collect, organize and analyze data. Tools taught include Excel Solver, Excel Solver Add-in, Crystal Ball and Tree Plan Decision. Proactive, practical planning for ambiguity and uncertainty is taught through the use of simulation techniques and provide tools that further strengthen business decisions.
When students successfully complete this Unit, they will have the ability to meaningfully use and apply the following Excel tools to strengthen business decisions:
- Excel Solver
- Excel Solver Add-in
- Crystal Ball
- Tree Plan Decision
- And simulation techniques.
Supply Chain Management
In Unit Two students learn about the following supply chain management components through an integrated perspective: purchasing, forecasting, production, planning, and transportation. A practical and in-depth look at the challenges related to coordinating the overall supply chain and maintaining inventory illuminates critical interdependencies and potential opportunities within the supply chain management process.
When students successfully complete this Unit, they will have the ability to:
- Choose one of three possible approaches to coordinating a supply chain that, if properly designed and implemented, allow firms to achieve higher profits by coordinating each other’s incentives.
- Use Excel and Calculus (EOQ Formal) to solve for the Best Order Quantity.
- Use Marginal Analysis and Simulation to solve for Best Order Quantity.
- Use Buy Back Contracts, Revenue Sharing Contracts and Vendor-Managed Inventory to alleviate double marginalization.
In Unit Three students will learn what project management is, the role and requirements of project managers, and specific tools for graphically representing, analyzing, prioritizing and adjusting the duration of projects.
When students successfully complete this Unit, they will have the ability to:
- Evaluate the need for and requirements of a Project Manager in relationship to a specific project.
- Break a project into manageable portions, determine the critical path and graphically represent projects through Gnatt charts, Activity-on-Node diagram and/or Activity-on-Arrow diagram.
- Analyze the duration of projects and predict the likelihood of completion within a specific time frame while also balancing time and cost.
Who should enroll: This Certificate is ideal for individuals who want to increase their skills and value to their future organizations, including those planning a career in:
- Business Ownership
- Business Leadership
- Operations Management
- Supply Chain Management
- Project Management
HIROSHI OCHIUMI, PHD, MBA, BENG
Dr. Hiroshi Ochiumi is an operations scholar. His research interests include supply chain
management, design and analysis of contracts, and behavioral aspects of decision
making, including sales forecasting and compensation. He teaches classes on operations
management and designing spreadsheet-based business models. Prior to receiving his PhD,
Professor Ochiumi worked for Hilti Japan and Goldman Sachs.
University of Southern CaliforniaMarshall School of Business
*2nd Private University in US | 10th Worldwide*
Based in the bustling center of glamorous Los Angeles, the University of Southern California (USC) has been ranked among the Top 10 Dream Colleges in America and is the oldest private research institution in the state, serving 43,000 students—a quarter from around the globe. The university is also Los Angeles’ largest private-sector employer and a $5 billion annual contributor to the region’s economy.
Ranked among the top 50 universities in the world by the Shanghai Jiao Tong University’s Academic Ranking of World Universities and 23rd in America by the 2016 U.S. News & World Report, USC is one of the globe’s most impactful institutions, shaping the future of multiple industries. A hub for innovation, pioneering research and extraordinary talent, USC counts among its faculty and alumni Nobel Laureates, Rhodes Scholars, MacArthur Fellows, Fulbright Fellows, and winners of the Turing Award, Academy Awards and Emmy Awards as well as recipients of National Medals of Arts, Humanities, Science and Technology and Innovation. Over the years, USC’s student athletes have also won 287 Olympic medals, more than any other university in America, and uniquely, its marching band has earned two platinum records.Through its world-class education, groundbreaking research, and 375,000 global alumni from film moguls such as Clint Eastwood and George Lucas to the first man on the moon, Neil Armstrong, USC is contributing to international excellence and investing in the most powerful human bedrock – its students and scholars – to continue shaping the world of tomorrow.
|How is the Short Course Certificate designed?||Each Certificate Course is specialized content from a top university and contains three Units. Each Unit has an end of Unit quiz which must be passed prior to moving forward. At the end of all three Units, you must pass a Certificate final exam in order to earn the Short Course Certificate.|
|How is the Short Course Certificate Unit graded?||The Units are pass/fail in nature and the student must achieve at least 80% to pass. Students will need to pass the end of Certificate exam to complete and receive the Certificate.|
|How many times can I take an end of Unit quiz in the Short Course Certificate?||The Unit quiz may be taken an unlimited number of times.|
|How many times can I take the Short Course end of Certificate exam?||Students have two attempts to pass the end of Certificate final exam. Students who do not achieve the required minimum score of 80% by the second attempt will not pass the Course and will not receive a Certificate.|
|How long do I have to complete the Short Course Certificate Unit?||You will have 90 days to finish the Short Course Certificate.|
|What if I signed up for the wrong Certificate? (What is the refund policy?)||Your satisfaction is our goal. If for any reason you are not satisfied, you will have 3 days from purchase by which to request a refund for the Short Course Certificate. However, please note that if you have accessed more than one lesson/module/topic's worth of content, no refund will be given. For assistance, please email firstname.lastname@example.org.
|What if I have a technical or policy question?||Please email email@example.com.|