...Assignment Of OR Maximize profit in Incident Management operations of IT service Company Akhil Gupta 6/16/2012 Batch – PGCBM-21 SMS ID – 110402 Faculty Name - Dr Supriya Kumar De Study Center – Grand Mall, Gurgaon Contents Introduction 3 Problem Statement 3 Solution 4 Solution from Solver 4 Summary of attached excel 5 Sensitivity Report 5 Answer Report 6 Analysis and Answers 7 Introduction I am working in a project where we get 3 types of incidents and for each resolution we get some (dollar) amount. At high level, we have 3 teams Design, Build and Test . Analysis and assignment of incidents is done by client team so we don’t have any role to play there. Team size is also decided by clients based on number of incidents they assign to us. I am formulating that problem based on my project and will provide some analysis based on leanings in class. I have learnt a lot in OR classes and now in a position to suggest my findings to client team. Data shared below is not exactly same as that is confidential and cannot be shared having said that problem and scenario is exactly what I use in my day to day project work. Problem Statement There are three types of incidents say Type X incidents, Type Y incidents, Type Z Incidents. All 3 require Design, build and test efforts. It is mandatory to resolve minimum 10 incidents of each type on each working day. To resolve one incident of one type data is shown below - For type X - requires...
Words: 638 - Pages: 3
...Unit 6 Advanced Spreadsheet Skills Assignment 6.1 This assignment covers the following grading criteria (P1, P2, P5, M1, and D1) The assessed tasks in this unit are based on the scenario below Scenario MNK is a local company who publish 10 different magazines/newspapers in a variety of languages specifically for the Bradford area. They have been approached by other cities interested in their work. MNK are therefore looking to expand their operation to at least one more large city. To achieve this they will need to apply for extra funding from their bank. To support the funding application, the company needs to analyse and review the sales data and costs for the last financial year, which is included in Appendix A. This will require the production of a working spreadsheet model which will enable the production of suitable reports and graphs of current and predicted sales and financial data. You have been approached by MNK to create this spreadsheet model. By using the MNK Sales Data provided, your spreadsheet will hopefully show that MNK is a well run business, capable of expansion. You need to carry out the tasks listed below. Successful completion of these tasks may enable you to achieve the following grading criteria: P1 - create a complex spreadsheet that is fit for purpose and check accuracy P2 - use formulae and functions to solve a complex problem P5 – use conversion facilities to export the contents of a spreadsheet to an alternative format ...
Words: 1012 - Pages: 5
...Lab I – Probability Models When finished fill in the table at the end of this document and email it to your teacher Cards: Use the tab for Cards in the excel file and get the total probability for the various hands All of your inputs are on the yellow cells (a) The first task is to figure how many chances you have for each pick that will result in a successful hand INPUT: columns B/C/D/E/F (b) Then if any of the events (one of the five cards) has 100% chance then you need multiply the one path by five to account for the parallel paths to a successful hand INPUT: column H (c) Finally, if there are more than one way to get the result (example four of a kind can be done with 13 different cards) then you need to add that number too INPUT: column J Note: this step will be more complicated when dealing with royal hands, and multiple runs. (d) Your final probability will be the percentage in the last column in the “prob” row (I’ve formattesd it such that these all fall in rows 7,17,27, etc) Dice: Use the tab for Dice in the excel file and get the probabilities for all the outcomes when tossing three dice Note: this problem has been started with the first result for the outcomes of 3 and 4 The probability also has been simplified to two events (rather that 3) by using the results from lab H for the rolls for dice #2 and #3… see below (also on your excel file) Outcome | theoretical % | total | possible outcomes (die 1 / die 2) | 2 |...
Words: 788 - Pages: 4
...Site Explorer Report for grand-theft-auto-cheats.org/ by © AHREFS Overview: grand-theft-auto-cheats.org/ URL Rank 0 0 Ahrefs Domain Rank n/a 2 Backlinks 13 2 Referring Domains 6 2 Linking Metrics: Referring Pages Total Backlinks Crawled Pages Referring IPs Referring Subnets Referring Domains: Governmental Educational .com .net .org 13 13 0 4 3 6 0 0 2 0 3 Backlink Types: text dofollow nofollow sitewide not sitewide redirect image frame form Governmental Educational 13 11 2 0 13 0 0 0 0 0 0 1/6 Site Explorer Report for grand-theft-auto-cheats.org/ by © AHREFS Referring Pages 18 6 16 5 New & Lost Referring Pages Referring Pages 14 4 12 3 10 2 8 1 6 Jan '13 Apr '13 Jul '13 Oct '13 0 Total Referring Pages New Referring Pages Lost Referring Pages Referring Domains 7 6 5 Referring Domains 4 3 2 1 0 16. Sep 30. Sep 14. Oct 28. Oct 11. Nov 2/6 Site Explorer Report for grand-theft-auto-cheats.org/ by © AHREFS 100% 75% 50% 25% 0% Jan '13 Mar '13 May '13 Jul '13 Sep '13 Nov '13 Text 100% Redirect 75% 50% 25% 0% Jan '13 Mar '13 May '13 Jul '13 Sep '13 Nov '13 NoFollow 100% DoFollow 75% 50% 25% 0% Jan '13 Mar '13 May '13 Jul '13 Sep '13 Nov '13 Sitewide NotSitewide 3/6 Site Explorer Report for grand-theft-auto-cheats...
Words: 385 - Pages: 2
...2015/10/20 A mind map of the 2020 agency A MIND MAP OF THE 2020 AGENCY Propulsion, the official blog of Ignition Consulting Group. Propulsion May 27, 2015 | By Tim Williams It’s appropriate that in the new agency ecosystem that emphasizes best-in-class providers instead of traditional “full-service” firms, today’s clients have a set of world-class expectations of their agencies. Some of these needs are a 21st century version of long-standing agency qualities. But there’s also a new class of emerging competencies, mostly in response to a new environment for marketing organizations in which: 1. Established categories of business are being constantly disrupted by innovative new start ups. 2. Marketing organizations must respond to market forces faster than ever before. 3. Traditional marketing campaigns are clearly losing their effectiveness, requiring much more marketing invention and experimentation. http://www.ignitiongroup.com/propulsionblogpost/mindmapfoundationsofthe2020agency/ 1/6 2015/10/20 A mind map of the 2020 agency 4. The marketing function is under constant scrutiny for proof of performance and is increasing under the thumb of finance and operations. 5. Marketers are saddled with the colossal job of central integration, overseeing and managing the efforts of a large federation of marketing services providers. 6. Client organizations are increasingly dependent on innovation vs. cost cutting to maintain ...
Words: 602 - Pages: 3
...1/25/2015 Magnolia Ice Cream Wikipedia, the free encyclopedia Magnolia Ice Cream From Wikipedia, the free encyclopedia Magnolia is a brand of ice cream and dairy products owned by San Miguel Corporation (SMC). The brand was commercially established by SMC (then known as San Miguel Brewery) in 1925. From its core products of ice cream and milk, the brand expanded into frozen desserts, butter, margarine and processed cheese and operated as the Magnolia Division of San Miguel Corporation until 1996. After a brief spinoff of the ice cream and milk business from 1996 to 1998 (and its hibernation from 1998 to 2003), these products were combined once again under one corporation in 2004 Magnolia, Inc., a wholly owned subsidiary of San Miguel Pure Foods Company, Inc. The Magnolia brand name is also used by other SMC companies for various food and beverage products. Magnolia Industry Dairy industry Founded 1925 Founder San Miguel Corporation Headquarters Philippines Products Ice cream, frozen desserts, UHT milk, butter, margarine, processed cheese, allpurpose cream Parent San Miguel Corporation Website http://www.magnoliaicecream.com.ph http://www.magnolia.com.ph Contents 1 History 1.1 Magnolia, Inc. 2 Products 2.1 Affiliated products 3 Trademark dispute 4 Relation to Magnolia (Singapore) 5 Aurora Boulevard site 6 References 7 External links History The history of the Magnolia brand can be traced bac...
Words: 2068 - Pages: 9
...8/1/2015 NT2580 Unit 7 Policy Definition and Data Classification Standard : NT 2580 : ITT Tech : Homework NT2580 Unit 7 Policy Definition and Data Classification Standard Home ITT Tech NT NT 2580 NT2580 Unit 7 Policy Definition and Data Classification Standard You have successfully unlocked this document. You have 24 more unlocks available. Was this document helpful? Yes Download Document https://www.coursehero.com/file/11610135/NT2580Unit7PolicyDefinitionandDataClassificationStandard/?timestamp=20150801105100 1/6 8/1/2015 NT2580 Unit 7 Policy Definition and Data Classification Standard : NT 2580 : ITT Tech : Homework Share and earn access CorporalStarViper9176 ITT Tech Follow 3 1787 302 https://www.coursehero.com/file/11610135/NT2580Unit7PolicyDefinitionandDataClassificationStandard/?timestamp=20150801105100 2/6 8/1/2015 NT2580 Unit 7 Policy Definition and Data Classification Standard : NT 2580 : ITT Tech : Homework VIEWS UNLOCKS 0 1 HELPFUL UNHELPFUL 0 0 About this Document SCHOOL ITT Tech COURSE NT 2580, Summer 2014 COURSE TITLE Introduction to Information Security PROFESSOR MR J TYPE Homework PAGES 1 WORD COUNT 206 Is this correct? Flag Get Help in NT 2580 https://www.coursehero.com/file/11610135/NT2580Unit7PolicyDefinitionandDataClassificationStandard/?timestamp=20150801105100 ...
Words: 487 - Pages: 2
...7/12/2015 ACC_206_Week_Three_Assignment_WP : ACC ACC206 : Ashford University : Homework ACC_206_Week_Three_Assignment_WP Home Ashford University ACC ACC ACC206 ACC_206_Week_Three_Assignment_WP You have successfully unlocked this document. You have 28 more unlocks available. Was this document helpful? Yes Download Document https://www.coursehero.com/file/11645606/ACC206WeekThreeAssignmentWP/?timestamp=20150712140326 1/6 7/12/2015 ACC_206_Week_Three_Assignment_WP : ACC ACC206 : Ashford University : Homework Share and earn access JudgeComputerCapybara1598 Ashford University Follow ~ 17 https://www.coursehero.com/file/11645606/ACC206WeekThreeAssignmentWP/?timestamp=20150712140326 4 2/6 7/12/2015 ACC_206_Week_Three_Assignment_WP : ACC ACC206 : Ashford University : Homework VIEWS DOWNLOADS 0 2 HELPFUL UNHELPFUL 0 0 About this Document SCHOOL Ashford University COURSE ACC ACC206, Fall 2015 PROFESSOR PACKWOOD TYPE Homework PAGES 4 WORD COUNT 756 Is this correct? Flag Get Help in ACC ACC206 Ask our Tutors a Question... Select a Subject: * https://www.coursehero.com/file/11645606/ACC206WeekThreeAssignmentWP/?timestamp=20150712140326 3/6 7/12/2015 ACC_206_Week_Three_Assignment_WP : ACC ACC206 : Ashford University : Homework Select a Subject Due Date and Time: * Due Date Any ...
Words: 370 - Pages: 2
...9/16/12 Assignment Print View Score: 140 out of 150 points (93.33%) 1. awar d: 10 out of 10.00 points Economic explanations of consumer behavior take into consideration Ego gratification. Lack of selfconfidence. Social status. Prices and income. Prices and income are just as relevant to consumption decisions as are more basic desires and preferences. Multiple Choice 2. Learning Objective: 1901 Why demand curves are downward sloping. awar d: 10 out of 10.00 points Which of the following is not a determinant of demand? Desire for the good. Income of the consumer. The cost of the factor inputs. The price of other goods. An individual's demand for a specific product is determined by tastes, income, expectations (for income, prices, tastes), and the availability and price of other goods. The cost of the factor inputs is a determinant of supply. Multiple Choice 3. Learning Objective: 1901 Why demand curves are downward sloping. awar d: 10 out of 10.00 points Graphically, as a consumer buys more of a good, the marginal utility line will Increase as more goods are consumed. Increase steadily and then decline. Continuously decline if diminishing returns are present. Follow the same shape as the total utility line. Total utility increases as a consumer enjoys more units of a product. Due to the law of diminishing marginal utility, marginal utility declines. Multiple Choice 4. ...
Words: 1558 - Pages: 7
...easier by their inventions? There are quite a few from the Ancient Chinese that I was not aware of and was amazed at how many of these we do use in our lives every day and never stop to think where these items were invented. So what are some of the amazing things the Ancient Chinese have invented? Well to answer this question and to explain all of the different inventions that the Chinese have brought to us would really be a mouthful. So I will explain the top ten in my list. And they are the following: • Row Planting • The Compass • Gunpowder • Paper • Seismograph • The Wheelbarrow • Kites • Silk • Seed Drill • Hang Gliders Thank You Ancient Chinese Now allow me explain these marvels. Row planting was first planted in 6th century BC. This way of planting allows the crops to grow faster and stronger and they also realized that as the wind travels there is less damage in crops planted in rows due to the wind passing through gently. It is also more efficient in watering, weeding and harvesting the crops. The compass was created in 4th century BC and was made of lodestone. The compass was first used by fortune-tellers before it was applied to the cardinal direction. Then the Chinese’s started using the compass to point to the south because they considered south not north their cardinal direction. Gunpowder has been credited to certain Chinese alchemists around 9th century but the legend has it as gunpowder being accidently discovered by alchemists looking...
Words: 381 - Pages: 2
...1/22/2015 Database Systems: Design, Implementationa and Management; 01 Flashcards create, study and share online flash cards MyFlashcards FlashcardDB About Help Donate TellFriends! Home >> Flashcards >> Computer Science >> Database Systems: Design, Implementationa and Management; 01 Shared Flashcard Set Details Title Click here to study/print these flashcards. Database Systems: Design, Implementationa and Management; 01 Ch1 19 Computer Science 02/08/2010 Create your own flash cards! Sign up here. Description Total Cards Subject Created Additional Computer Science Flashcards Related Study Documents from www.coursehero.com (What's Course Hero?) Course Hero is an online platform providing educational resources to help students learn more effectively. Subscription required. ch03 ch03 Course: Course: Cards Term Definition ch1, q1: Define each of the following terms: raw facts i.e., telephone number, a birth date, a customer name, and a yeartodate (YTD) sales value. Data have little meaning unless they have been organized in some logical manner data Term Definition ch1, q1: http://www.flashcardmachine.com/databasesystemsdesignimplementationaandmanagement01.html 1/6 1/22/2015 Database Systems: Design, Implementationa and Management; 01 Flashcards Define each of the following terms: a character or group of characters can be alphabetic or numeric that has a specific...
Words: 1375 - Pages: 6
...7/21/2015 Boeing, Airbus Rivalry – Lessons in Strategic Planning Tuesday, July 21, 2015 Search: GO Home Terry Corbell Bio Management Services Seminars – HR Training Contact Author OpEd Economic Analysis U.S. Economic Forecasts Subscribe BusinessCoaching Topics: Planning Operations Marketing/Sales Finance Tech Public Policy HR Career Tips Wall Street Leadership Newsroom Video Reports: National & World Politics Business Science & Technology Sports Health Entertainment Oddly Enough Browse > Home / Marketing/Sales, Planning / Boeing, Airbus Rivalry – Lessons in Strategic Planning By Terry Corbell The Biz Coach http://www.bizcoachinfo.com/archives/1326 1/6 7/21/2015 Boeing, Airbus Rivalry – Lessons in Strategic Planning Boeing, Airbus Rivalry – Lessons in Strategic Planning Updated Feb. 24, 2015 It would make a great Hollywood movie. As of February 24, Boeing leads Airbus in the sales war in 2015, 69 to 28 jets. Boeing also beat Airbus in 2014. Probably to the chagrin of the American company, Airbus has invaded Boeing’s home turf – it’s assembling 10 percent of its A320s in Alabama. And China is building jets to compete with Boeing and Airbus. Companies can learn valuable lessons from the BoeingAirbus competition. In terms of strategic planning, it has been quite a rollercoaster ride with no end in sight. Have both sides done enough strategic homework? Should major manufacturers rely on government funding...
Words: 1599 - Pages: 7
...de Ermita family. Some members of the ilustrado group, while in Spain, decided to start a Spanish publication with the aim of promoting the autonomy and independence projects. Members of this group included Pedro Alejandro Paterno, who wrote the novel Nínay (first novel written by a Filipino)[citation needed] and the Philippine national hero, José Rizal, who wrote excellent poetry and his two famous novels in Spanish: Noli Me Tángere (Touch Me Not), and El Filibusterismo. Especially potent was La Solidaridad, more fondly called La Sol by the members of the propaganda movement, founded in 15 February 1885.[citation needed] With the help of this paper, Filipino national heroes like José Rizal, Graciano Lopez Jaena, and Marcelo H. del Pilar were able to voice out their...
Words: 271 - Pages: 2
...Marcelo Hilario del Pilar y Gatmaitan: (August 30, 1850—July 4, 1896) was a celebrated figure in the Philippine Revolution and a leading propagandist for reforms in the Philippines. Popularly known as Plaridel, he was the editor and co-publisher of La Solidaridad. He tried to marshal the nationalist sentiment of the Filipino ilustrados, or bourgeoisie, against Spanish imperialism. Marcelo H. del Pilar was born in Cupang (now Barangay San Nicolas), Bulacan, Bulacan, on August 30, 1850, to cultured parents Julián Hilario del Pilar and Blasa Gatmaitan. He studied at the Colegio de San Juan de Letran and later at the University of Santo Tomas, where he obtained his law degree in 1880. Fired by a sense of justice against the abuses of the clergy, del Pilar attacked bigotry and hypocrisy and defended in court the impoverished victims of racial discrimination. He preached the gospel of work, selfrespect, and human dignity. His mastery of Tagalog, his native language, enabled him to arouse the consciousness of the masses to the need for unity and sustained resistance against the Spanish tyrants. In 1882, del Pilar founded the newspaper Diariong Tagalog to propagate democratic liberal ideas among the farmers and peasants. In 1888, he defended José Rizal's polemical writings by issuing a pamphlet against a priest's attack, exhibiting his deadly wit and savage ridicule of clerical follies. In 1888, fleeing from clerical persecution, del Pilar went to Spain, leaving...
Words: 582 - Pages: 3
...George Gordon Byron, who is often referred to as Lord, was a prominent English writer, poet and aristocrat. One of his most renowned characters was Child Harold - his alter ego, who became the prototype of numerous other heroes in European literature. That’s why even after Byron’s death his books were highly-demanded. The well-known writer was born on January 22nd in 1788 in London. However, his mother soon got divorced and moved with little George to Scotland where her relatives lived. From the very childhood Byron suffered from physical disability, which influenced greatly his life. His right foot was deformed which caused him a limp that resulted in lifelong misery. That’s why he had quite a difficult personality and hysterical character. In fact, even having such physical disabilities, he voluntarily took part in the Greek War of Independence and therefore was considered a national hero of Greece. Already when the poet was eighteen his first book was published but under a different name. It was a vast collection of poems which he soon refilled with over a hundred of new rhymes and published this time under his own name. His next book, released in 1809, received a wide response. The same year he left England, as the sum of his debts dramatically increased, and started exploring Europe. Byron visited Spain, Greece, Albania and some other countries. His exciting journey lasted for two years and that was the time when he started working on his successful poem “Child Harold’s...
Words: 523 - Pages: 3