Wk 5
Topic: Economic Order Quantity Determine the Economic Order Quantity in Excel for: Price of Product: $150 Savings Rate: 12% Annual Usage: 16240 Cost of transportation: $200/order Cost of PO preparation: $60/order Warehouse Rental: $8/piece Topic: Linear Programming Develop problem 1 of chapter 8 using excel or by hand. You need to present the objective and constraints equations. No need to solve it.
Problem 1
The Waikiki Enterprise Corporation produces two types of computers at its manufacturing plant in Torrance, California. Profit on computer A is $900 per unit and for computer B it is $600. The manufacturing plant can produce not more than 50 of computer A and 100 of computer B a day. The following table displays the capacity for the manufacturing plant.
PLANT | CAPACITY TO PRODUCE COMPUTER A | CAPACITY TO PRODUCE COMPUTER B | MAXIMUM AVAILABLE CAPACITY |
A River view Plant | 51 | 101 | 18000 |
Unit profit | $900 | $600 |
a. What are the decision variables?
b. What is the objective function?
c. What are the constraints?
d. What are the non-negativity assumptions?
Wk 5
Topic:
Economic
Order
Quantity
Determine the Economic Order Quantity in Excel for:
Price of Product:
$150
Savings Rate: 12%
Annual Usage: 16240
Cost of transportation: $200/order
Cost of PO preparation: $60/order
Warehouse Rental: $8/piece
Topic:
Linear
Programming
Develop problem 1 of chapter 8 using excel or by hand. You need to present the objective
a
nd
constraints equations. No need to solve it.
Problem 1
The
Waikiki
Enterprise
Corporation
produces
two
types
of
computers
at
its
manufacturing
plant in Torrance, California. Profit on computer A is $900 per unit and for computer B it is
$600. The
manufacturing plant can produce not more than 50 of computer A and 100 of
computer B a day. The following table displays the capacity for the manufacturing plant.
PLANT
CAPACITY TO
PRODUCE
COMPUTER A
CAPACITY TO
PRODUCE
COMPUTER B
MAXIMUM
AVAILABLE
CAPACITY
A Riverview Plant
51
101
18000
Unit profit
$900
$600
a. What are the decision variables?
b. What is the objective function?
c. What are the constraints?
d. What
are
the
non
–
negativity
assumptions?
Wk 5
Topic: Economic Order Quantity
Determine the Economic Order Quantity in Excel for:
Price of Product: $150
Savings Rate: 12%
Annual Usage: 16240
Cost of transportation: $200/order
Cost of PO preparation: $60/order
Warehouse Rental: $8/piece
Topic: Linear Programming
Develop problem 1 of chapter 8 using excel or by hand. You need to present the objective and
constraints equations. No need to solve it.
Problem 1
The Waikiki Enterprise Corporation produces two types of computers at its manufacturing
plant in Torrance, California. Profit on computer A is $900 per unit and for computer B it is
$600. The manufacturing plant can produce not more than 50 of computer A and 100 of
computer B a day. The following table displays the capacity for the manufacturing plant.
PLANT
CAPACITY TO
PRODUCE
COMPUTER A
CAPACITY TO
PRODUCE
COMPUTER B
MAXIMUM
AVAILABLE
CAPACITY
A Riverview Plant 51 101 18000
Unit profit $900 $600
a. What are the decision variables?
b. What is the objective function?
c. What are the constraints?
d. What are the non-negativity assumptions?
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
[meteor_slideshow slideshow="slide2"]Use the order calculator below and get ordering with idealtermpapers.com now! Contact our live support team for any assistance or inquiry.
[order_calculator]