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

## Related Questions

Similar orders to
Linear Programming Quiz this Monday 7pm Malaysia time

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

- Online writing help
- Online homework help
- Personal statement help
- Essay writing help
- Research paper help
- Term paper help
- Do my homework
- Online assignment help
- Online class help
- Dissertation help
- Thesis help
- Proofreading and editing help
- Lab report writing help
- Case study writing help
- White paper writing help
- Letter writing help
- Resume writing help

Post your project now for free and watch professional experts outbid each other in just a few minutes.