Do My Homework / Homework Help Answers / Microsoft Excel Homework Help / Linear Programming Quiz this Monday 7pm Malaysia time

Linear Programming Quiz this Monday 7pm Malaysia time

Need help with this question or any other Microsoft Excel assignment help task?

The quiz will be on this Monday 28th of Feb at 7pm Malaysia timezone, time limit is 1hour but need 5-10mins to submit. It's only 1 excel question. I've provided some samples. Please do let me know if you can do it.
Additional Instructions:
Question Name: TOTAL MARK TP Number: 0 / 30 Intake: Duration: 30 minutes Instruction: 1. Read ALL of the information carefully before you start answering. 2. Use of the Excel help facility is permitted and encouraged where necessary. Use of any software (e.g. email, internet) other than Excel is NOT permitted. 3. You MUST save your work in the same file at least every five minutes. 4. Save your file as (NAME and TP number). Question: A farmer has recently acquired an 110 hectares piece of land. He has decided to grow Wheat and Barley on that land. Due to the quality of the sun and the region’s excellent climate, the entire production of Wheat and Barley can be sold. He wants to know how to plant each variety in the 110 hectares, given the costs, net profits and labor requirements according to the data shown below: Variety Cost (Price/Hec)  Net Profit (Price/Hec)  Man-days/Hec Wheat 100  50  10 Barley 200  120  30 The farmer has a budget of $10000 and an availability of 1200 man-days during the planning horizon. Since the production from the entire land can be sold in the market. The farmer would want to maximize the profit for his total produce for both Wheat and Barley. The farmer earns a net profit of $50 for each hectare of Wheat and $120 for each hectare of Barley. The optimal solution by using Excel solver had print out from the Answer report (in different sheet-Answer Report). Please leave this side blank for marking Answer your question here: Let x -> represent the total area for growing Wheat (in hectares) Let y -> represent the total area for growing Barley (in hectares) 1st marker 2nd marker (a) Construct the Objective function: (2 marks) x y Profit (2 marks) (b) Construct the Constraints function: (i) Cost/total budget (ii) Number of man-days (iii) Total area (in hectares) (6 marks) x y Used Maximum/ minimum capacity Cost/total budget Number of man-days Total area (in hectares) (12 marks) For part (c) till part (f), refer Answer report sheet to answer the questions: (c) Write the quantity to produce for x and y in obtaining optimal solution: x y (2 marks) (d) State the total area for growing Wheat and Barley (in hectares) to achieve maximum profit. Answer: (2 marks) (e) State the total maximum profit ($) achieved for growing both Wheat and Barley. Answer: (2 marks) (f) State the total area used (in hectares) out of maximum 110 hectares land available. Answer: (2 marks) TOTAL: 0 0 AQ022-3-1-QSS Sample Lab Quiz 1 Page &P of &N Level 1 Asia Pacific University of Technology and Innovation yyyy Answer Report Microsoft Excel 16.0 Answer Report Worksheet: [Sample Lab Quiz 1.xlsx]Question Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $G$41 z Profit 0 5400 Variable Cells Cell Name Original Value Final Value Integer $E$57 x 0 60 Contin $F$57 y 0 20 Contin Constraints Cell Name Cell Value Formula Status Slack $F$49 Cost/total budget Used 10000 $F$49
Question Name: TOTAL MARK TP Number: 30 / 30 Intake: Duration: 30 minutes Instruction: 1. Read ALL of the information carefully before you start answering. 2. Use of the Excel help facility is permitted and encouraged where necessary. Use of any software (e.g. email, internet) other than Excel is NOT permitted. 3. You MUST save your work in the same file at least every five minutes. 4. Save your file as (NAME and TP number). Question: A farmer has recently acquired an 110 hectares piece of land. He has decided to grow Wheat and Barley on that land. Due to the quality of the sun and the region’s excellent climate, the entire production of Wheat and Barley can be sold. He wants to know how to plant each variety in the 110 hectares, given the costs, net profits and labor requirements according to the data shown below: Variety Cost (Price/Hec)  Net Profit (Price/Hec)  Man-days/Hec Wheat 100  50  10 Barley 200  120  30 The farmer has a budget of $10000 and an availability of 1200 man-days during the planning horizon. Since the production from the entire land can be sold in the market. The farmer would want to maximize the profit for his total produce for both Wheat and Barley. The farmer earns a net profit of $50 for each hectare of Wheat and $120 for each hectare of Barley. Find the optimal solution by using Excel solver and call out the Answer report from the Solver. Please leave this side blank for marking Answer your question here: Let x -> represent the total area for growing Wheat (in hectares) Let y -> represent the total area for growing Barley (in hectares) 1st marker 2nd marker (a) Construct the Objective function: Maximise, z = 50x + 120y 2 (a2) x y Profit z 50 120 5400 2 (a2 for Excel formula) (b) Construct the Constraints function: (i) Cost/total budget 100x + 200y
Answer Report 1 Microsoft Excel 16.0 Answer Report Worksheet: [Sample 2-Lab Quiz 1(Q).xlsx]Question Report Created: 17/2/2022 11:39:47 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.094 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $G$41 z Profit 0 3700 Variable Cells Cell Name Original Value Final Value Integer $E$57 x 0 500 Contin $F$57 y 0 150 Contin Constraints Cell Name Cell Value Formula Status Slack $F$49 Cutting and Sewing Used 725 $F$49
Answer Report 1 Microsoft Excel 16.55 Answer Report Worksheet: [T2-LP-Question 5.xlsx]Sheet1 Report Created: 2/26/22 8:31:23 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 2227.993 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $F$11 z Profit 0 100 Variable Cells Cell Name Original Value Final Value Integer $D$29 x 0 20 Contin $E$29 y 0 10 Contin Constraints Cell Name Cell Value Formula Status Slack $E$21 (i) Used 100 $E$21
Answer Report 1 Microsoft Excel 16.55 Answer Report Worksheet: [T2-LP-Question 7.xlsx]Sheet1 Report Created: 2/26/22 9:05:32 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 2058.898 Seconds. Iterations: 0 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $F$11 z 0 0 Variable Cells Cell Name Original Value Final Value Integer $D$12 x 0 0 Contin $E$12 y 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack $E$19 (i)Assembly Used 0 $E$19
Answer Report 1 Microsoft Excel 16.0 Answer Report Worksheet: [T2-LP-Question 8.xlsx]Sheet1 Report Created: 3/11/2020 10:45:13 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.047 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $F$11 z 0 60 Variable Cells Cell Name Original Value Final Value Integer $D$25 x 0 24 Contin $E$25 y 0 12 Contin Constraints Cell Name Cell Value Formula Status Slack $E$19 (i)Nitrate Used 300 $E$19>=$F$19 Binding 0 $E$20 (ii)Potash Used 240 $E$20>=$F$20 Binding 0 $E$21 (iii)Phosphorus Used 156 $E$21>=$F$21 Not Binding 66 Sheet1 T2-Question 8 Let x -> Let y -> Construct your objective function: x y z Construct the Constraints function: (i)Nitrate (ii)Potash (iii)Phosphorus x y Used Maximum/ minimum capacity (i)Nitrate (ii)Potash (iii)Phosphorus Quantity to produce in obtaining optimal solution x y Conclusion: Answer questions below (Refer Answer Report 1): (a) State number of units of fertiliser A and fertiliser B to produce to minimise cost. Answer: (b) State the total minimum cost ($) for both fertiliser A and B. Answer: (c) State the total number of units used for phosphorus when minimum cost was achieved. Answer:
Answer Report 1 Microsoft Excel 16.0 Answer Report Worksheet: [T2-LP-Question 9.xlsx]Sheet1 Report Created: 3/11/2020 11:55:25 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.062 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $F$11 z 0 654.5454545455 Variable Cells Cell Name Original Value Final Value Integer $D$25 x 0 163.6363636364 Contin $E$25 y 0 245.4545454545 Contin Constraints Cell Name Cell Value Formula Status Slack $E$19 (i) Blending Used 736 $E$19
Quantitative Skills Linear Programming TOPIC 2: LINEAR PROGRAMMING 1. A factory can produce two products, A and B. The contribution that can be obtained from these products are, A contributes RM 20 per unit B contributes RM 30 per unit. It is required to maximise contribution. Write down the objective function for this factory. 20x+30y=Z, Maximize profit 2. A farmer mixes three products to feed his cows. Feedstuff X costs 40 cents per kg, feedstuff Y costs 80 cents and feedstuff Z costs 110 cents per kg. Each feedstuff contributes some essential part of the cows’ diet and the farmer wishes to feed the cows as cheaply as possible. State the objective function. 40x+80y+110z=A, minimize cost 3. A factory can produce four products A, B, C, and D. The factory employs 200 skilled workers and 150 unskilled workers and works a 40 hour week. The times to produce 1 unit of each product by the two types of labour are given below: Products A B C D Skilled hours 5 3 1 8 Unskilled hours 5 7 4 11 If x1 is the number of units of A produced, x2 is the number of B produced, x3 is the number of C produced, and x4 is the number of D produced, write down the constraint functions. No of skilled workers available: 200*40=8000 No. of unskilled workers: 150*40=6000 5x1+3x2+x3+8x4
There are no answers to this question.
Login to buy an answer or post yours. You can also vote on other others

Get Help With a similar task to - Linear Programming Quiz this Monday 7pm Malaysia time

Popular Services
Tutlance Experts offer help in a wide range of topics. Here are some of our top services: