Dr freedom قام بنشر أكتوبر 14, 2010 قام بنشر أكتوبر 14, 2010 السلام عليكم ممكن المساعده في حل هذا السؤال ممكن مساعده عاجلة في كيفية عمل تنبيه في الخلية وايضا كيفية تحديد قيمة قصوى بحيث لاتتجاوزها عند ادخال رقم في الخلية Our hypothetical company, The Sweater Company (TSC), manufactures and sells two products: leisure sweaters and letter (athletic) sweaters. The company makes a profit of $6 for each letter sweater sold and a profit of $3 for each leisure sweater sold. The labor-hour requirements for the products in each of the three production departments is shown in the table below: Department Leisure Sweater Letter Sweater Cutting 1 3 Sewing 2 2 Finishing 1 3 Each product must be processed by each one of the three departments before it's complete and ready for sale. Reading the table above, for example, each letter sweater must spend three hours in the Cutting Department, two hours in the Sewing Department, and three hours in the Finishing Department before it’s complete. The supervisors of the three departments have estimated that the following numbers of labor hours will be available during the next month department hours cutting 900 sewing 1,600 finishing 2,000 Use Microsoft Excel to solve this problem. Remember the concepts of useful information (accurate and formatted). The spreadsheet must correctly solve the problem _and_ be easy to read and understandable. Create a spreadsheet which will allow someone to play a “what if” game to maximize the profit. The user will input the number of leisure sweaters and the number of letter sweaters to produce. The spreadsheet will determine the profit generated by that “mix” of leisure and letter sweaters. For example, if 50 leisure sweaters and 20 letters sweaters are produced, the profit would be (50 * $3) + (20 * $6). The user can then change the number of each sweater type produced and see if a better profit figure is produced. However, there are constraints on the number of sweaters that can be produced, as given in the labor-hours table. The company can’t produce 2,000 letter sweaters as each takes 3 hours of finishing work and there are only 2,000 hours of finishing work available. Your spreadsheet needs to enforce these constraints. If the user enters numbers that result in too many hours of labor, the spreadsheet will alert the user to that fact. Your spreadsheet will be used by the plant manager to determine the “best” number of leisure sweaters and letter sweaters to manufacture in the next month, given the constraints, that will maximize profits. The model will allow the manager to experiment with a variety of product mix scenarios. In order to complete this assignment, you must first understand the problem. Then you must plan the solution (outputs, inputs, algorithms). Finally, you need to convert your plan into a spreadsheet. Remember that a spreadsheet is a mathematical model. Spreadsheets are useful tools when the user will play “what if” game on the input data. 1
ياسر خليل أبو البراء قام بنشر أكتوبر 14, 2010 قام بنشر أكتوبر 14, 2010 أخي الحبيب ارفق ملف لو سمحت حتى تتضح الأمور ويستطيع الأخوة الأعضاء مساعدتك فيما تطلب
as_helaly قام بنشر أكتوبر 15, 2010 قام بنشر أكتوبر 15, 2010 السلام عليكم مش عارف إذا كان دا هو المقصود أو محتاج حاجة زيادة على العموم أنا لم استخدم أي أكواد ولكن ببساطة هو conditional formating مع إدخال المعطيات اللازمة حسب الموضح وما عليك إلا إدخال الكمية المراد إنتاجها في الخانة الملونة باللون الأصفر B16 ==> Leisure Sweater C16 ==> Letter Sweater لو محتاج أي تعديل أو إنك محتاج إنك تجبر المستخدم على عدم إدخال كميات زائدة يا ريت تقول ولو فيه إمكانية إني استخدم الكود في الحل حيسهل حاجات كتير. تحياتي.. What if.rar
الردود الموصى بها
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.