Question: 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:

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.

The Waikiki Enterprise Corporation produces two types of computers at its manufacturing plant in Torrance, California. Profit on computers 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.

a) What are the decision variable?

b) What is the objective function?

c)What are the constraints?

d)What are the non-negativity assumptions?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

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...

Case Analysis read the two cases below words :500 The topic of this paper is Operations Management and Value creation: Lessons from cases. Summarize both cases (Roche and Atlantic Animal Hosptial)...

I need some help with this Managerial Accounting Midterm ACT 5733 - Advanced Managerial Accounting Fall 2013 Mid-Term Exam Directions: Answer all the questions. Please submit your work in Word or PDF...

HI TUTOR THIS ARE THE EXA,PLES IN MY QUESTIONS To calculate the cost of replenishment, include: Annual cost of purchasing department labor 220,000 Annual cost of purchasing department overhead (rent,...

IOE 419 Mark S. Daskin Service Operations Management IOE Department Winter, 2017 University of Michigan Problem set 4 DUE: MONDAY - February 20, 2017 Points: 100 points total Problem 1: Babette has...

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

Hw #5 Answer the following problems * Show ALL WORKI 3(A-D),4,19,20 31 cation for these Unit Cost Uni Cost 20 4. Por, 5100, E130 Find Moden this Story The intable context menu and me from Ny Time...

Determine the economic order quantity in excel: a) Price of product: $150 b) Savings rate : 12% c) Annual Usage: 16240 d) Cost of transportation: $2000/order e) Cost of PO preparation: $60/order f)...

Group: PERON A+ PERSON B +PERSON C 1- Introduction 2- Literature a. Definition of operation management b. Definition of operation strategy and why it is important c. Components of operations strategy...

check on the file and download the...

Selecting Candidates for the position of Marketing Manager in Egypt: Cairo Food Co. is a food- manufacturing company with 200 employees, exporting 40% of its goods to neighboring countries. Most...

Please solve with explanation by using Least Square Method, you have the following data which fit the poly y=x Xi= 0, 1, 2, 3, 4, 5 = Xi

you believe that a corporation's dividends will grow 5 % on average into the foreseeable future

Elizabeth Island Airways scher. Ellermalogenal airine serving the New England area, recently suffered a major cras. As a result passengers are considered to be shy choose As there comer when making...

You have been asked to conduct an equal opportunities survey in an organisation of a thousand employees on one site. How would you carry this out? In your answer, design a questionnaire and indicate...

Role- play interviews from the two complainants in the Meteor case study. Decide on what would be Sarahs best course of action.

Taking Sarahs position in the Meteor case study, draw up the proposal she will need to make to convince the managers of the benefi ts of working towards a learning organisation.