Product and Operations Management

Production & Operations Management — Recitation 1

Jianing Yao

Rutgers University, the State University of New Jersey yaojn 1@hotmail.com

September 5, 2014

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

1 / 14

Overview

1

Review Basic Excels

2

Introduction To Linear Programming

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

2 / 14

Excel Basics

Things you should know at this point: Basic Workbook and Worksheet Data Entry in Excel cells Defining Range of Cells Using Formulas: SUM() and SUMPRODUCT() Relative and Absolute Reference

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

3 / 14

Workbook Creation/Data Entry/Simple Format

The use of Font, Theme, etc. is the same as Microsoft word

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

4 / 14

Formula - SUM()

Click the cell, enter: = sum(range)

Locate the mouse at the right down corner, hold left button and drag down

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

5 / 14

Formula - SUM()/SUMPRODUCT()

We want to have : 0.2 × 100 + 0.2 × 94 + 0.4 × 73 = 68. There are two alternatives: Pair them naturally.

Pay attention to the order of sum and product !!!

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

6 / 14

Relative Reference & Absolute Reference

As usual, we drag down to replicate the implementation, but ...

Click the cell we find it is a relative reference

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

7 / 14

Relative Reference & Absolute Reference

The worlds is saved by relative reference !! The difference is just simple $ sign : Absolute Reference: $B$4 : $D$4 Relative Reference: B4 : D4

Jianing Yao (Rutgers Business School)

POM

September 5, 2014

8 / 14

Intro. to LP & LP History

Linear Programming is an optimization method to achieve the best outcome under linear...