Determine the economic order quantity

Assignment Help Operation Management
Reference no: EM132148521

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

The Waikiki Enterprise Corporation produces two types of computer satits 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. Whatarethenon-negativityassumptions?

Reference no: EM132148521

Questions Cloud

Discuss theory of efficient markets and behavioral finance : Please discuss the validation or failure of the theory of efficient markets and behavioral finance given the "Credit Crunch" or global financial crisis.
Explain about team leadership : Explain what an operations strategy is and its relationship to competitive priorities. Explain about Team Leadership.
Describe tracking metrics to determine the effectiveness : Describe tracking metrics to determine the effectiveness of your recommendation as a way to solve the problem you identified.
Prepare aggregate plan and determine its cost : They have regular time capacity of 350 units per period and they plan to produce that many each period. Prepare an aggregate plan and determine its cost.
Determine the economic order quantity : The Waikiki Enterprise Corporation produces two types of computer satits manufacturing plant in Torrance, California.
Identifying misleading information in argument : There are many arguments for elimination or modification of current U. S. drug laws, Determine whether or not the argument uses any deceptive statistics.
Did the advertisers use the fallacy effectively : There are several types of fallacies - equivocation, false authority, ad hominem, appeal to ignorance, and bandwagon. Please provide two (2) different examples.
Discuss the effects of your own enculturation : When looking for information about a particular issue, how often do you try to resist biases toward your own point of view? This assignment asks you to engage.
How did ge outweigh others and make an performance : In the fast paced and fierce competitive society, how did GE outweigh others and make an outstanding performance?

Reviews

Write a Review

Operation Management Questions & Answers

  Argument that proposes one change to our electoral system

Present an argument that proposes one change to our electoral system.

  What is advertising wearout-what are some causes of wearout

What is advertising wearout? What are some causes of the wearout? Give examples based on your own experience. Describe briefly what is meant by the “silent” language of cultures by Edward T. Hall. Provide an example. What can managers do to minimize ..

  Do you use any special techniques to deal with change

How comfortable are you with change? Do you embrace it, or do you resist? Do you use any special techniques to deal with change?

  Identify specific strategies for interacting

Write a 1,050- to 1,400-word paper in which you identify specific strategies for interacting with groups that require particular communication methods as discussed in Interpersonal Messages.

  What is the labor content total number of labor hours

How long would it take to complete 1,000 projects with each alternative? What is the labor content (total number of labor hours) for 1,000 projects for each alternative?

  Between which two strategic groups is competition strongest

Between which two strategic groups is competition the strongest? Why do you think no beer producers are positioned in the lower left corner of the map?

  What and how are those assessments characterized

The needs assessment is a valuable tool used to facilitate the management of continuous change taking place in today's organizations.

  Enabled sega to break nintendo near monopoly

What factors do you think enabled Sega to break Nintendo's near monopoly of the U.S. video game console market in the late 1980s?

  Creation and knowledge management

What role does knowledge creation and knowledge management play in organizational learning?

  What is the difference between a leader and a manager

Discuss whether intergroup conflict and intergroup competition are the same or different. Provide examples to support your position. What strategies can a leader use to ensure that there are positive results from the conflict or competition?

  How to prepare for union contract negotiations

You are the manager of a small manufacturing plant. The union contract covering most of your employees is about to expire. working individually or in groups, discuss how to prepare for union contract negotiations.

  Critically discusses the process of operations management

Critically discusses the process of operations management and how it is done within their organization, using the terms just defined.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd