Lecture 1 Practice 3 大学课件
- 格式:pdf
- 大小:109.04 KB
- 文档页数:1
5. An appliance warehouse stocks the following items: microwaves, ranges, washers, dryers, and dishwashers. Operational data in the ch4_P5appliances file, which can be downloaded from the companion website, indicates the demand for each appliance during the last 12 months. The following table stores additional operational data for each appliance:You are the logistics manager and would like to calculate the monthly order quantity for each item category to minimize overall inventory cost. The Economic Order Quantity model can be used to optimally calculate the amount of inventory for each item group with the goal of minimizing the storage (holding) cost and ordering cost. However, there are some constraints such as storage capacity (5,000 cubic feet) and purchasing budget ($2.0 million) that may make the optimal solution of the EOQ model not feasible.a. Formulate and solve the above problem as a linear programming model.• What is the optimal order inventory level for each appliance? Are these quantities different from the values calculated via the EOQ formula? Why?• What is the value of the objective function (holding plus ordering cost) for the above solution?b. The company will implement a quantity discount policy when pricing each appliance. Thefollowing table represents the price for each appliance when the warehouse orders a specifiedquantity range. For example, if the warehouse orders up to 40 microwaves, the price is $160, butwhen the warehouse orders from 41 to 60 microwaves, the price drops to $150, and so on.Adjust the Excel template to reflect the price discount using VLOOKUP functions.c. Formulate and solve the problem with an NLP model to determine the optimal order quantity thatmaximizes the total profit. Note that the profit for each appliance can be calculated as:((selling price – discounted purchasing price) × (monthly demand)) – total cost per monthd. Analyze the Answer Report to identify the final values for the decision variables, binding and not binding constraints, and the impact of changing the righthand side values of the constraints in the final value of the objective function.。
University LifeTime spent at a university is a most worthwhile period in a young person's life. This is a time when a student begins to form his or her ideas about life in general. Attending classes and studying in the library keep a student busy and provide him or her with access to valuable information, adding to his or her knowledge base.Campus life can also be rich and colorful. Most universities offer a variety of extracurricular activities such as sports events, contests, and other social gatherings, enabling the students to experience relief from study and homework. Students often form lifelong friendships through the varied experiences of university life.During the time a student spends at university, he not only develops his intellectual ahilites, he also develops social skills as well as knowledge and wisdom necessary for choosing a future career. By learning how to balance intense study and recreation, a student will be well prepared for the challenges of future responsibilities.College is much different than high school. Many students have to leave far away from home and prepare beginning the new life by themselves. What can we expect as we head off into the wonderful world of higher education? The first thing I concerned is the workload. Obviously. It is lighter and more freedom than my high school. But if you are a foresight man, you may feel intense because of the major challenges of college work are large volume of reading, short deadlines, and many competition. A related effect that can be brought on by the workload is doubt, frustration, and loneliness if possible.I have made a lot of new friends. I am sure college friendships will be among the most satisfying and long-term in my life. It's always exciting to discover how wonderfully diverse college relationships can be.I am enjoying my newfound freedom. Stay up until dawn talking about my ideals and ambitions with my dormitory’s regular bull sessio n buddies. Sleep in until the afternoon on a light class day. In the free time hiking and visiting the local town or well-known spots with some of my new friendsI even start to think about my future. Going to college is as much about finding out who am I as it is about getting the degree.ON being a studentGoing up to university to study for a degree means you have decided to study professionally, rather than as an amateur, so being a student is now your profession for at least the next four years.This involves a change of attitude in many ways. Although he process has been going on since you went to middle school, the biggest change is going to take place. Now, instead of taking several subjects, you have chosen one major subject because you find it interesting and worth exploring further. The choice was yours. You also have before you the goal of getting a degree. The degree, and the stages you have to pass through to achieve it, give you motivation, even though it may become weak from time to time, and not all parts of the course will be exciting, a sure way to lose interest is to do too little work. It is a law of diminishing returns-the less work you do, the less interest you will have and the more bored you will become. So regular work is needed to keep up your interest as well as to keep pace with new work.Anther change is in the relationship with those who teach you. This may well have changed during middle school and high school, but now the whole context is different. You are no longer forced to stay in school all day, and apart from your class time, you organize your own time and place for studying. You are there to study (an active process ) rather than to be taught ( passive ).You teachers may or may not urge you, but they do want you to share their interest in the subject and they want you to succeed.The teacher works as your coach or trainer. If you were becoming a professional tennis player or musician, you would expect your coach to look out for ways of improving your performance, and to criticize your work all the time, you would be silly to feel fed up about this -in fact you would sack your coach if she just said everything was fine. So if you get work back with a poorer mark than y ou expected and with various criticisms. don’t feel discouraged by this, if you don’t understand what is wrong and how to improve, then ask your teacher to explain and don’t be satisfied until you do understand.Professionalism involves discipline. Nobody becomes or remains a professional pianist or football player without putting in hours of regular practice. They have to learn to use time well, and they practice to improve their skills.Some activities, like reading, writing, note-taking, speaking and discussing are basic to studying. Make sure that you are doing these efficiently.Efficient reading is part of your training. Many of us keep on reading the same way we did in primary school. Since it is a learned skill we can change it and relearn it. By taking this course, you will learn how to read fast—how to read with your eyes rather than your throat, how to avoid lingering lovingly over words like “of” and “the”, and how to keep what you read.Poor handwriting is a disadvantage. It makes your own notes slower to read, and it is hard for those like teachers who have to read your work. Unless you have a physical disability, you can reform it: try practicing on the notes you make in a slow and boring lecture—it will strengthen you interest and is of more use than talking in class!Note-taking is done for yourself, not for anyone else, so make your notes easy to read, economical and pleasing to the eye. Vary, or change, the arrangement on the page to suit the material (diagrams, columns, underlining), use colored pens to give you a color code (system) for different topics, or just to catch the eye and make things stand out. Work out your own shorthand speedwriting.Group discussions give you a chance to train yourself to speak and discuss more effectively. They will fail in their purpose if you keep silent—and if you start off this way, the harder it will become to get out of the situation of being the non-speaking member of the group. In the future you are almost certainly going to have to be good at speaking, so get into the way of talking about your subject now. This is actually more fun than sitting being silently miserable because you are not saying anything. Nobody will think what you say is foolish. Everyone will be thankful not to face awkward silence.Finally I hope all my friends will enjoy a beneficial college life wholeheartedly!academic year 学年正常授课期,通常为每年九月至第二年六月。
6. A paint manufacturer produces two paint primer products: Glidden Professional Aquacrylic (GPA) and BEHR Premium Plus (BPP). The manufacturer currently sells more units and receives better customer reviews from GPA than the BPP. Over the last few months, GPA has received an average rating of 4.1 out of 5 and BPP has received an average rating of 3.1. However, BPP offers a larger profit margin. The following table shows the sales price and manufacturing cost for each primer product.
The production facility wants to stay under a $30,000 monthly budget for making these two products. Due to contractual agreements, the facility must produce at least 1,500 gallons of GPA and 1,000 gallons of BPP for each month. The goal of the manufacturer is to maximize the net profit.
a. Formulate a linear programming model that represents the preceding business description. Solve the
problems graphically. (Hint: Consider changing the measuring unit from gallons to hundreds of
gallons or thousands of gallons so the graphical solution can better fit in the xy axis.)
• What is the optimal number of GPA and BPP to be produced each month?
• What is the value of the objective function (total profit) for the solution?
• Identify binding and not binding constraints for the optimal solution and explain why some constraints are not fully met.
b. The manufacturer is also interested in the product reviews and wants to provide a production mix
that maximizes the total customer satisfaction. Assuming that the average ratings are offered for
each purchased gallon, reformulate the LP model and answer the same questions as in step a. Does the solution change? Why or why not?
c. The manufacturer now changes the goal: It wants to minimize the production cost. However, a
$20,000 profit per month must be achieved. Solve the problem and investigate the Solver’s Answer Report to identify:
• The optimal monthly production mix
• Binding and not binding constraints
• Does the solution change compared with step b? Why or why not?。