The book retails for $28.00. The publisher sells the book to the bookseller for $20.00. The book seller will dispose of all unsold copies of the book at 75% off
the retail price, at the end of the season. Demand for the book during the selling season is a
Cu, Underage Cost
Co, Overage Cost
$70
$20
Critical Ratio
Demand Forecast
3193
1182
Retail
Wholesale
Refund
S&H Charge
$180
$110
$90
$-
0.778
Trial Order Quantity, Q
Z for Critical Ratio
Z for Trial Order Quantity, Q
L(Z) for Trial Q
L(Z) for Profit Maxim
LL Bean
Case Analysis Questions
SCM 366
Case Preparation Questions:
LL Bean has adopted a two stage ordering process for products with one-shot
commitments (i.e., products that they get to order only once because of long
supplier lead times). First they d
SCM 380
Assignment # 4
Due 10/14/2015
The Dean Door Corporation
The Dean Door Corporation (DDC) manufactures steel and aluminum exterior doors for
commercial and residential applications. DDC landed a major contract as a supplier to Walker
Homes, a builde
Patrick Wiseman
SCM 366-001
Homework 15.5, 15.6
15.5 Given Information
Capacity 200
Mean
Normal Price $475
Standard Deviation
Cost to Bump Passenger $800
30
15
Derived Information
Critical Ratio 0.3725
Z- value #NAME?
Part A.
Amount of Reservations to Acc
Patrick Wiseman
SCM 366-001
Inter-Arrival Times
Minimum 0
Maximum 5
Customer
0
1
2
3
4
5
6
7
8
9
10
11
12
994
995
996
997
998
999
1000
Service Times
Mean, 2
Std. Deviation, 0.5
Interarrival
Service Start
Completion
Arrival Time
Waiting Time Service Time
T
Revenue Management
Problem Set
Patrick Wiseman
SCM 366-001
Felgas
Production Capacity 1000
Price @ Capacity
Customer Willing to Pay
$5.00
Production Capacity to
Hold in Reserve
$10.00
Demand Mean,
250
Demand Std. Deviation,
100
#NAME?
NORM.INV(1-B2/B3,B4,
Revenue Management
Problem Set
Patrick Wiseman
SCM 366-001
Felgas
Production Capacity 1000
Price @ Capacity
Customer Willing to Pay
$5.00
Production Capacity to
Hold in Reserve
$10.00
Demand Mean,
250
Demand Std. Deviation,
100
#NAME?
NORM.INV(1-B2/B3,B4,
Chapter 02 - Linear Programming: Basic Concepts
CHAPTER 2
LINEAR PROGRAMMING: BASIC CONCEPTS
Review Questions
2.1-1
1) Should the company launch the two new products?
2) What should be the product mix for the two new products?
2.1-2 The group was asked to
CHAPTER 2
LINEAR PROGRAMMING: BASIC CONCEPTS
SOLUTION TO SOLVED PROBLEMS
2.S1 Conducting a Marketing Survey
The marketing group for a cell phone manufacturer plans to conduct a telephone survey to
determine consumer attitudes toward a new cell phone that
Chapter 18 - Inventory Management With Known Demand
CD CHAPTER 18
INVENTORY MANAGEMENT WITH KNOWN DEMAND
Review Questions
18.1-1 Administrative costs, such as labor charges to place an order, can cause the cost to
exceed the purchase price.
18.1-2 Capital
Automobile Alliance, a large automobile manufacturing company, organizes the vehicles it manufactures into three families: a family of trucks, a family of small cars, and a
family of midsized and luxury cars. One plant outside Detroit, Michigan, assembles
Chapter 11 - Queueing Models
CHAPTER 11
QUEUEING MODELS
ReviewQuestions
11.1-1
Customers might be vehicles, machines, or other items.
11.1-2
It might be a crew of people working together, a machine, a vehicle, or an electronic
device.
11.1-3
Mean arrival
Name: _Leila Fathalian_
Individual Assignment #6 - 50 pts
For the following queries, write them in SQL and save as you have done previously.
Query 20 (8 pts)
Points received
Using DDL, add the table CAMPUS (see below) to the SCHOOL database.
Be sure to in
ITEM
3-in-1 Ski-Vertible Jacket
Adventure Duffle Bag
Bayside Belt
Bayside Walking Shorts
Boat and Tote Bag
Boat Mocs, Slide
Camp Mocs
Canvas Drawstring Skirt
Canvas Purse
Cashmere-Lined Leather Gloves
Casual Friday Polo
Charles Street Tassel Loafers
Class
Green Grass Company
Patrick Wiseman
SCM 366-001
Table 2
Production Costs
Shipping Costs
Plant Opening Cost
Capacity Constraint
Boston
Quantity Required
1430
Price Bid
$75,740
Chicago
Dallas
Denver
Los Angeles
870
770
1140
700
$44,370
$46,320
$87,780
$43,8
A. Formulate and solve a linear programming model to determine the number of Family
Thrillseekers and Classy Cruisers that should be assembled
EXPLICIT CONSTRAINTS:
Objective: Maximize Profits
Constraint # 1 = LH
Constraint # 2 = Resources
Constraint # 3
A. Formulate and solve a linear programming model to determine the number of Family
Thrillseekers and Classy Cruisers that should be assembled
EXPLICIT CONSTRAINTS:
Objective: Maximize Profits
Constraint # 1 = LH
Constraint # 2 = Resources
Constraint # 3
Problems listed on the syllabus will be DUE IN CLASS on FEBRUARY 9th.
2.9 (Part A only)
2.10 (Parts A, B & C)
3.5 (Parts B & D)
3.19 (Part A only)
3.21 (Part A only)
29ca39a97629e21bdbd9f7557160813e98e1ca55.xlsx
The Apex Television Company has to decide o
Patrick Wiseman
Dr. Fry
SCM 366-001
SCM 366
Supply Chain Modeling
Spring, 2015
Assignment 1
Inventory Management with Steady Demand
Your friend needs to purchase malt for his micro-brewery. His supplier charges $35 per delivery,
for each delivery, regardl
In order to conserve capital, an electronics parts wholesaler leases regional warehouses for its use. It currently has a candidate list of
three warehouses it can lease. The cost per month to lease warehouse i is Fi. Also, warehouse i can load a maximum o
Delivery Charges
Production Cost
Annual Holding Cost per Unit
Weekly Usage (gallons)
Annual Demand
Order Quantity
Q
$35.00
$1.20
35%
Annual Holding Cost per Unit per year
Number of Orders Per Year
Average Inventory
Annual Ordering Cost
Annual Holding Cost
Optimal Protection Level Analysis
Capacity 150
# Protected at Full Price 50
Full Price (High Fare)
Discount Price (Low Fare)
St. Dev of High-Fare Demand, 29
$200.00
$120.00
Cost Understock, CU
Cost Overstock, CO
Expected High-Fare Demand, 70
$80.00
$120.0
Cu, Underage Cost
Co, Overage Cost
8
4
Critical Ratio
Demand Forecast
200
80
0.667
Trial Order Quantity, Q
Z for Critical Ratio
Z for Trial Order Quantity, Q
L(Z) for Trial Q
L(Z) for Profit Maximizing Q
Profit Maximizing Q
Mean
St Dev
100
Demand Trial Q
Integer Modeling Exercise
Patrick Wiseman
SCM 366-001
1. If the New York warehouse is opened, then the Los Angeles warehouse must be open.
2. At most two warehouses can be opened.
1. A company is considering opening warehouses in four cities: New York, Lo
Units Required
Carrying Cost
Storage Penalty
35
$2.00
$35.00
Process 1 One Big Machine
Day
1
Units
Made
39
Inventory Shortage
4
0
Carrying Shortage
Total Cost
Cost
Penalty
$8.00
$8.00
Process 2 (10 Small Machines)
Day
1
Day
1
2
3
4
5
6
7
8
9
10
11
12
13
1
Cost
Plant A
Plant B
Shipping
Quantities
Plant A
Plant B
Shipped
Needed
Distribution Distribution Distribution
Center 1
Center 2
Center 3
$
800 $
700 $
400
$
600 $
800 $
500
Distribution
Center 1
0
20
20
=
20
Distribution
Center 2
20
0
20
=
20
Distributio
Input data
Initial inventory of boots
Holding cost/pair of boots in inventory/month
Profit per pair of boots
Production plan
Shoes produced
Production capacity
Inventory after production
Demand
Excess Inventory
Ending inventory
1000
$8
$20
Q1
3000
<=
6000
Objective Maximize = 400X1 + 100X2
S.T.
50X1+25X2<= 2500
6X1+6X2<= 480
X1,X2 >= 0
X2 >= 2X1
Number to Produce
Table
Chair
25
Decisions
Profits Per Unit
Oak Used Per Unit
Labor Used Per Unit
Total Oak Used
Total Labor Used
Oak Available
Labor Available
$
4