Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
1 Page
9LotSizing
Course: IE 383, Spring 2012School: Purdue
Rating:
Word Count: 154
Document Preview
Sizing: Lot Application Developed by: Alejandro Tern Lot Sizing Objective: To develop an Application (Excel + VBA) that determines schedules under a L4L Lot Sizing policy. APPLICATION CHARACTERISTICS Consider the Lot for Lot Policy for Lot Sizing. Develop an application (EXCEL + VBA) that determines the orders and cost schedules for a L4L Policy. The application should: Allow the user to enter the problem...
Unformatted Document Excerpt
Coursehero >> Indiana >> Purdue >> IE 383Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Sizing: Lot Application
Developed by: Alejandro Tern
Lot Sizing
Objective: To develop an Application (Excel + VBA) that determines schedules
under a L4L Lot Sizing policy.
APPLICATION CHARACTERISTICS
Consider the Lot for Lot Policy for Lot Sizing.
Develop an application (EXCEL + VBA) that determines the orders and cost
schedules for a L4L Policy.
The application should:
Allow the user to enter the problem parameters into a user form.
Read requirements (demand) for set a of periods from a spreadsheet (the
user does not introduces the number of time periods within the planning
horizon).
Develop on a spreadsheet the orders and cost schedules.
Generate a report (on a User Form) that shows the overall characteristics of
the policy.
The application runs at the click of a button by the user.
Due date: Friday, after HW 9 quiz, to be tested by appointment at Alejandro
Terans office (GRIS 258) with different sets of test data.
1
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more.
Course Hero has millions of course specific materials providing students with the best way to expand
their education.
Below is a small sample set of documents:
Below is a small sample set of documents:
Purdue - IE - 383
Purdue - IE - 383
13-24D K i 1,700 120 0.25j 1 2 3 4LBPj 1 300 500 800UBPj 299 499 799Cj 38 37.24 36.48 36.1hj 8 8 8 8EOQj 225.83 225.83 225.83 225.83Realizable? Candidate Yes 225.83 No 300 No 500 No 800Optimal?OptimalTAC(Q) $66,406.65 $65,188.00 $64,424.00 $64,
Purdue - IE - 383
13-23D K i 1,700 120 0.25j 1 2 3 4LBPj 1 300 500 800UBPj 299 499 799Cj 38 37.24 36.48 36.1hj 9.5 9.31 9.12 9.025EOQj 207.24 209.34 211.51 212.62Realizable? Candidate Yes 207.24 No 300 No 500 No 800Optimal?OptimalTAC(Q) $66,568.76 $65,384.50 $64
Purdue - IE - 383
13-20D K h QEOQ 40,000 800 1.9 5,803.81j 1 2 3 4 5 6LBPj 1 10,000 20,000 30,000 40,000 50,000UBPj 9,999 19,999 29,999 39,999 49,999Cj 3.4 3.2 3 2.8 2.6 2.4EOQj Realizable? Candidate Optimal? TAC(Q) DC KD/Q hQ/2 5,803.81 Yes 5,803.81 $147,027.24 $136
Purdue - IE - 383
IE 383 Integrated Production Systems Spring 2012HW 8: Discounts, Random Demand Due: TBAProblem 13-20 As in the textbook. Problem 13-23 As in the textbook. Problem 13-24 As in the textbook. Problem 13-31 a) As in the textbook. b) Based on your answers to
Purdue - IE - 383
Inventory Discount Models: ApplicationDeveloped by: Alejandro TernDiscount ModelsObjective: To develop an Application (Excel + VBA) that determines the optimal inventory policy under an All-Units Discount scheme.APPLICATION CHARACTERISTICS Consider th
Purdue - IE - 383
13-40Calculations (items ranked):ItemDemandCostUsage Value % Usage Value Cum Usage Value % Cum Usage Value1372,30016,10013.65%16,10013.65%491,23011,0709.38%27,17023.03%10273509,4508.01%36,62031.04%20109359,3507.93%45,97038
Purdue - IE - 383
Purdue - IE - 383
Purdue - IE - 383
Purdue - IE - 383
Purdue - IE - 383
IE 383 Integrated Production Systems Spring 2012HW 7: ABC Classification, EOQ, EPQ Due: TBAProblem 13-40 For the data provided, based on the variable: (Cumulative) Usage Value: a) Plot the items on a Pareto Chart. Does the plot seem to suggest there are
Purdue - IE - 383
Aggregate Production Planning: ApplicationDeveloped by: Alejandro TernEOQ, EPQ50% Bonus: Alternative 1: Develop an application (EXCEL + VBA) to implement the EOQ Model. The application should: Read relevant information entered by the user. Display rele
Concordia Canada - COMM - 222
Q 1: The main problem of Howe store is its employees' productivity. To increase it, Howe decided to give a merit performance bonus for only one kind of employees, which has demotivated others employees. After the establishment of this system, employees, w
Concordia Canada - COMM - 222
Organizational BehaviorChapter 1 Organizational behavior is the attitudes and behaviors of individuals and groups in organizations. Classical Approach: Controlling and coordinating people. Human relations Approach: Being flexible and acceptable. Letting
Concordia Canada - COMM - 222
Work Locus of Control ScaleCopyright Paul E. Spector, All rights reserved, 1988The following questions concern your beliefs about jobs in general. They do not refer only to your present job. Use the following scale to answer each item: Disagree very muc
Concordia Canada - COMM - 222
Conclusion: From the results of the interviews it seems that employees at Total Auto Service seem to be willing to achieve the goal set by their managers as well as goals that they set for themselves that are tied to the company's goals even of they don't
Concordia Canada - COMM - 222
ORGANIZATIONAL BEHAVIOR AND HUMAN PERFORMANCE15,335-354(1976)Test of Equity Theory by Controlling for Comparison Co-workers' EffortsR. DENNIS MIDDLEMISTOklahoma State University AND RICHARD B. PETERSON University of WashingtonThis study tested the
Concordia Canada - COMM - 222
Using Leader-Member Exchange Theory to Examine Principal-School Counselor Relationships, School Counselors' Roles, Job Satisfaction, and Turnover Intentions By: E. V. Clemens, A. Milsom, and Craig S. Cashwell Clemens, E. V., Milsom, A., & Cashwell, C. S.
Concordia Canada - COMM - 222
JOHN MOLSON SCHOOL OF BUSINESS CONCORDIA UNIVERSITY-COMM 222 (ORGANIZATIONAL BEHAVIOR) / SECTION L WINTER 2012-PREPARED FOR PROFESSOR MELANIE BRIANDBY David DE SOMMA Slimane LAAMOURI Maziar M-SHAHI Stephane PARIS Iman SARR-DIARRA1Table of Contents
Concordia Canada - COMM - 222
CH7 Groups & Teamwork Group: Consists of two or more people interacting interdependently to achieve a common goal. 2 types: Formal & Informal. Tuckman's Stages of Group Development:Punctuated Equilibrium Model: Advice for managers: -Prepare carefully for
Concordia Canada - COMM - 222
CH8 Social Influence and CultureSocial Influence: In many social settings, and especially in groups, people are highly dependenton others. This dependence sets the stage for influence to occur.- 2 kinds of dependence are: information dependence and eff
Concordia Canada - COMM - 222
CH9 LEADERSHIP What is leadership: The influence that particular individuals exert on the goal achievement of others in an organizational context. Effective leadership exerts influence in a way that achieves organizational goals. 2 types: Strategic leader
Concordia Canada - COMM - 222
CH11 Decision Making Decision making is the process of developing a commitment to some course of action. Three things are noteworthy about decision making: It involves making a choice among several action alternatives. It is a process and involves a commi
Concordia Canada - COMM - 222
CH12 Power & Ethics Power: the capacity to influence others who are in a state of dependence. It is not always perceived or exercised It does not imply a poor relationship between the power holder and the target of power Power can flow in any direction in
Concordia Canada - COMM - 222
CH12 Conflict and Stress Conflict: A process that occurs when one person, group, or organizational subunit frustrates the goal attainment of another. Often involves antagonistic attitudes and behaviors. Causes of Conflict in organizations: Group identific
Concordia Canada - COMM - 222
Comm 222 Organizational Behavior: Chapter 1 What Are Organizations? Organizations: Social inventions for accomplishing common goals through group effort. Social Inventions: The essential characteristic of organizations is the presence of people. The field
Concordia Canada - COMM - 222
Comm 222 Organizational Behavior: Chapter 2Personality: The relatively stable set of psychological characteristics that influencethe way individuals interact with their environment. Personality isdetermined by genetics and long term learning history.P
Concordia Canada - COMM - 222
Comm 222 Organizational Behavior: Chapter 3 Perception: The process of interpreting the messages of our senses to provide order and meaning to the environment. Perception has 3 components that influence the perceiver's interpretation of the target: Percei
Concordia Canada - COMM - 222
Comm 222 Organizational Behavior: Chapter 4 Values: A broad tendency to prefer certain states of affairs over others; general beliefs about what is good or bad, right or wrong. Values can be classified into: intellectual, economic, aesthetic, social, poli
Concordia Canada - COMM - 222
Comm 222 Organizational Behavior: Chapter 5 What is Motivation? Motivation: The extent to which persistent effort is directed toward a goal. Effort: strength of a person's work-related behavior Persistence: how often they apply effort Direction: quality o
Concordia Canada - COMM - 222
Comm 222 Organizational Behavior: Chapter 6 Money as a Motivator -Money can satisfy needs (need theories) -Money is a valued reward (expectancy theory) -Money is an important outcome in social comparisons (equity theory) -Money can increase goal commitmen
Concordia Canada - FINA - 385
Question 1: ABL shares are currently trading at a price of $9, while HHT shares are trading at a price of $30.82. The risk-free rate is 1.77% per year. Using the information above, perform each of the following tasks:a) Identify which of the following op
Concordia Canada - FINA - 385
ABL returns 5.2 5.1 -2.2 6.2 1.1 0.2 -2.8 3.1 19.2 -4.8 0.1 1.2 Mean: Standard dev: Skew: Kurtosis:2.63333 6.21543 1.77324 4.42661HHT returns 4.1 -4.1 4.1 3.1 -1.1 -4.1 -0.9 3.1 -6.9 -1.9 0.1 17.2 GM: Mean: Standard dev:ABL(Ra) 1.041 0.959 1.041 1.031
Concordia Canada - FINA - 385
Print Last Name:Print First Name:ID Number:COURSE FINANCENUMBER FINA 385/2SECTION: B & C Version 1EXAMINATION Final Exam DATE Dec 15, 2010TIME 3 hours# OF PAGES 16 including cover INSTRUCTOR: D. NewtonDIVISION John Molson School of Business Con
Concordia Canada - FINA - 385
Print Last Name:Print First Name:ID Number:COURSE FINANCENUMBER FINA 385/2SECTION: B & C Version 1EXAMINATION Final Exam DATE Dec 15, 2010TIME 3 hours# OF PAGES 14 including cover INSTRUCTOR: D. NewtonDIVISION John Molson School of Business Con
Concordia Canada - FINA - 385
Print Last Name:Print First Name:ID Number:COURSE FINANCENUMBER FINA 385/2SECTION: B & C Version 1EXAMINATION Final Exam DATE Dec 15, 2010TIME 3 hours# OF PAGES 16 including cover INSTRUCTOR: D. NewtonDIVISION John Molson School of Business Con
Concordia Canada - FINA - 385
Print Last Name:Print First Name:ID Number:COURSE FINANCENUMBER FINA 385/2SECTION: B & C Version 2EXAMINATION Final Exam DATE Dec 15, 2010TIME 3 hours# OF PAGES 14 including cover INSTRUCTOR: D. NewtonDIVISION John Molson School of Business Con
Concordia Canada - FINA - 385
COURSE Finance Theory I EXAMINATION Midterm - B INSTRUCTOR David Newton INSTRUCTIONS:-NUMBER FINA 385/2 DATE October 14th, 2010 TIME 11:45-2:30 DIVISIONSECTION B # OF PAGES 13JOHN MOLSON SCHOOL OF BUSINESS--This exam consists of 20 multiple-choice
Concordia Canada - FINA - 385
COURSE Finance Theory I EXAMINATION Midterm - C INSTRUCTOR David Newton INSTRUCTIONS:-NUMBER FINA 385/2 DATE October 14th, 2010 TIME 2:45-5:30 DIVISIONSECTION C # OF PAGES 13JOHN MOLSON SCHOOL OF BUSINESS--This exam consists of 20 multiple-choice q
Concordia Canada - FINA - 385
COURSE Finance Theory I EXAMINATION Midterm V1 INSTRUCTOR David Newton INSTRUCTIONS:-NUMBER FINA 385/2 DATE October 18th, 2010 TIME 8:45-11:30 DIVISIONSECTION A # OF PAGES 13JOHN MOLSON SCHOOL OF BUSINESS--This exam consists of 20 multiple-choice q
Concordia Canada - FINA - 385
COURSE Finance Theory I EXAMINATION Midterm V2 INSTRUCTOR David Newton INSTRUCTIONS:-NUMBER FINA 385/2 DATE October 18th, 2010 TIME 8:45-11:30 DIVISIONSECTION A # OF PAGES 13JOHN MOLSON SCHOOL OF BUSINESS--This exam consists of 20 multiple-choice q
Concordia Canada - FINA - 385
FINA 385 Section BC Final Practice ProblemsBootstrapping Problem It's Gabrielle's first day on the job and she's been asked by her boss to bootstrap the implied yield curve from two different sets of bonds. The first set of bonds are issued by the German
Concordia Canada - FINA - 385
FINA 385 Section Midterm Practice ProblemsAPT Problem Oproh believes that stock market returns for pharmaceutical companies are governed by the equation: E(ri ) = rf + a (Av.Age) + d (Diabetes) + h (Hypertension) (1)Where the Av.Age variable measures th
Concordia Canada - FINA - 385
Effective rate = (1+Qrate/m)^m) 1 - Mutual funds accept funds from small investors and invest, on behalf of these investors, in the national and international securities markets. - Securitization requires access to a large number of potential investors. T
Concordia Canada - FINA - 385
Chapter 5 p142-143 Estimating Risk Aversion -Yes, these are valid calculations. However I will not focus on these. You should be able to manipulate a utility function to isolate a parameter of interest (such as A on page 143). p148-151 CAL Development/R
Concordia Canada - FINA - 385
Quoted rates and Effective rates This note clarifies why the textbook formula is different than the formula I gave in class and shows you how to use each one (whichever you prefer) in whichever instance you may encounter. The major difference (besides ch
Concordia Canada - FINA - 385
CHAPTER 1 THE INVESTMENT ENVIRONMENT 1. a. Cash is a financial asset because it is the liability of the government. b. No. The cash does not directly add to the productive capacity of the economy. c. Yes. You can buy more goods and services than previousl
Concordia Canada - FINA - 385
CHAPTER 1 THE INVESTMENT ENVIRONMENT 1. a. Cash is a financial asset because it is the liability of the government. b. No. The cash does not directly add to the productive capacity of the economy. c. Yes. You can buy more goods and services than previousl
Concordia Canada - ESL - 201
Answers: Unit 1, exercise 16 (p. 12-13) 3. A lot of people in my class work during he day an attend class in the evening. 4. Many of the satellites orbiting the earth are used for communication. 5. Correct 6. Studying a foreign language often leads studen
Concordia Canada - ESL - 201
Slimane LaamouriElement paragraphESL 202Although known for its use in large quantities in the objects of our electronic batteries, lithium is also an element used extensively in the medical field. With electro-chemical qualities much better than zinc,
Concordia Canada - ESL - 201
Slimane LAAMOURI Id : 6090885ESL 202: Assignment 2.Warren Buffett, widely revered in China for his investment savvy, will sing and play guitar tocelebrate Chinas upcoming Lunar New Year in a specially recorded performance to be airedonline by state te
Concordia Canada - ESL - 201
Slimane laamouri Id : 6090885ESL 202: Assignment 2. Without "s" Warren Buffett, widely revered in China for his investment savvy, will sing and play guitar to celebrate China upcoming Lunar New Year in a specially recorded performance to be aired online
Concordia Canada - ESL - 201
Ice-breaker for First Class "Getting Acquainted" Some questions for Class Discussion Some ways to agree or disagree: Formal Less Formal Informal 1. Oh yes! I completely agree. Yes I think that's true Yeah. Absolutely. Un huh! 2. I agree somewhat with this
Concordia Canada - ESL - 201
Slimane id:6090885ESL 202 03/06/2012Re-Writing Class Paragraph Although sharing your apartment with roommates has the advantage to give you more social interactions, living alone gives you more freedom of living, increases your responsibility, and provi
Concordia Canada - ESL - 201
Slimane Laamouri 6090885 Language Learning ParagraphESL 202There are different strategies for learning a new language. Personally, I have focused on three learning areas: the mnemonic power, the use of the whole brain, and the most effective one accordi
Concordia Canada - ESL - 201
Slimane Laamouri 6090885Mr. STEPHAN MCELCHERAN ESL 202Language Learning I disagree somewhat with the fact that adults learn languages faster than children for two reasons. Not only do children have a better capacity of learning due to their brain facult
Concordia Canada - ESL - 201
Concordia 202 2012 with Stephen McElcheran An ice-breaker and introduction to classmates and opinions about language learning: Directions: In small groups you will interview classmates, informally about their backgrounds and learning experiences, attitude
Concordia Canada - ESL - 201
Slimane Laamouri id: 6090885Punctuation test.ESL 202.Facebook launched the process for its highly anticipated stock market debut, filing papers for a $5bn initial public offering that will turn key shareholders into billionaires, most notably Mark Zuck
Concordia Canada - ESL - 201
Slimane Laamouri Id 6090885Biographical ParagraphMr. Stephan MCElcheranRe-written paragraph:Born in the neighborhood of Lazaret, Morocco, in 1951, my uncle Ahmad had to showcourage, generosity, and motivation to become world champion in boxing. He wa
Concordia Canada - ESL - 201
Slimane Laamouri id 6090885 Short AnswerStephan McElcheran. ESL 2021. What prevented Frank McCourt from writing stories of his childhood and his experiences until later in life? 2. What did McCourt mean when he said "Dig deep. Find your own voice and