(Answered) Topic economic order quantitydetermine the economic order

Management Studies

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

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?

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M93135984
Price:- $40

Verified Expert

Priced at $80 Now at $40, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Operation Management

1what you understand from big 5 amp personality traits

1. What you understand from Big 5 & Personality Traits ? with proper reference, 2. How do work norms affect leadership effectiveness? 3. What can individual women do to reduce the influence of sex and gender discriminati ...

1 as a supplier what characteristics of a buyer your

1. As a supplier, what characteristics of a buyer (your potential customer) would be considered extremely important in building a long-term relationship? Please list at least two and provide your reasons. 2. What would y ...

1 what is organizational sustainability why is it vital to

1. What is organizational sustainability? Why is it vital to business success? 2. Are human rights and sustainable development issues relevant to the behaviour of MNCs? Discuss and defend your answer by giving examples. ...

This assignment gives you practice with the skills you have

This assignment gives you practice with the skills you have learned in Chapter 13: Project Management. Using the notes from me and from your teacher, complete the following assignment: Group 2 Activity Predecessor Time ...

Is the zappos supply chain push or pull and is it

Is the Zappos supply chain push or pull, and is it responsive or efficient? Explain. Question from Case Study Zappos.com: Developing a supply chain to Deliver WoW. Standford Graduate School of Business

Hbs quantum corporation- esupply chain group case1 what are

HBS Quantum Corporation- eSupply Chain Group Case 1. What are the key objectives/role of the eSupplyChain group to help Quantum better address their competitive needs? What improvement efforts should the eSupplyChain gro ...

1 how can you project a more positive image over the

1. How can you project a more positive image over the telephone? 2. What information should you always get when taking telephone messages? 3. When transferring calls, what should you avoid and why? 4. When you leave a me ...

1 how many observations should a time study analyst plan

1. How many observations should a time study analyst plan for in an operation that has a standard deviation of 1.7 minutes per piece if the goal is to estimate the mean time per piece to within .4 minute with a confidenc ...

Select a real hypothetical company of your choice and write

Select a real /hypothetical company of your choice and write an article titled as ‘Strategic Management in XYZ company’( Word Limit: Not more than 1000 words) You should try to include the following components in the wri ...

1 a colleague says that if the confidence level is 95 then

1. A colleague says that if the confidence level is 95%, then the probability that the true mean/average is within the calculated confidence interval is 95%. Explain why this is true or false. 2. Explain customer perspec ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert