طلب مساعدة : في حل هذا السؤال وكيفية عمل تحذير او Alert

[Dr freedom]

السلام عليكم

ممكن المساعده في حل هذا السؤال

ممكن مساعده عاجلة في كيفية عمل تنبيه في الخلية وايضا كيفية تحديد قيمة قصوى بحيث لاتتجاوزها عند ادخال رقم في الخلية

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.

[ياسر خليل أبو البراء]

أخي الحبيب

ارفق ملف لو سمحت حتى تتضح الأمور ويستطيع الأخوة الأعضاء مساعدتك فيما تطلب

[as_helaly]

السلام عليكم

مش عارف إذا كان دا هو المقصود أو محتاج حاجة زيادة

على العموم أنا لم استخدم أي أكواد ولكن ببساطة هو

conditional formating

مع إدخال المعطيات اللازمة حسب الموضح

وما عليك إلا إدخال الكمية المراد إنتاجها في الخانة الملونة

باللون الأصفر

B16 ==> Leisure Sweater

C16 ==> Letter Sweater

لو محتاج أي تعديل أو إنك محتاج إنك تجبر المستخدم على عدم إدخال كميات زائدة

يا ريت تقول ولو فيه إمكانية إني استخدم الكود في الحل حيسهل حاجات كتير.

تحياتي..

What if.rar

[omega887]

 هلا

الحل جيد لكن كيف وضعت الشرط

[omega887]

("IF(W3<=F4,"OK","PASSED=