Formulate the LP model for the problems below in EXCEL using problem solver:

1. The Big Bang explosives company produces customized blasting compounds for use in the mining industry. The four ingredients for these explosives are agents A, B, C and D. Big Bang just received an order for 2000 pounds of explosive. Agents A and C each costs $5 per pound, agent B costs $6 per pound, and agent D costs $3 per pound. The customer's mixture must contain at least 20% agent A, at least 30% agent B, and at least 15% each for agents C and D. Additionally, the customer insists that there must be at least twice as much agent B as agent C in the mix and that the poundage of agent A must be at least 40% of what's used for agent D. Finally, at least 200 pounds of each agent should be present in the finished product. The company wants to provide the least expensive mixture which will satisfy the customer's requirements.

2. A group of investors has $500,000 to invest and wants to maximize the money they will receive at the end of one year. They can invest in condos, apartments and houses. Furthermore, they wish to invest the entire amount. The profit after one year, the cost and the number of units available are shown below:

Investment Profit per unit Cost per unit Number Available
($1,000) ($1,000)
Condos 6 50 10
Apartments 12 90 5
Houses 9 100 7
Formulate the model for this problem.

Solution Summary

A Complete, Neat and Step-by-step Solution is provided in the attached file.

Assume that x2, x7 and x8 are the dollars invested in three different common stocks from New York stock exchange. In order to diversify the investments, the investing company requires that no more than 60% of the dollars invested can be in "stock two". The constraint for this requirement SHOULD be written as:
a) x2 > 0.60

Given the following linear programming problem:
Min Z = 2x + 8y
Subject to (1) 8x + 4y 64
(2) 2x + 4y 32
(3) y 2
At the optimal solution the minimum cost is:
a. $30
b. $40
c. $50
d. $52
d. $53.33

In each of parts (a) and (b), an operation * is defined over the set of natural numbers. For each operation, determine these four things.
See Attachment.
Please provide detailed explanation showing all steps and reasoning as well as formal notation for the Proof.
Please post response as a MS Word or PDF file.
Thank

Use Gauss-Jordon method to solve the following system of equations:
2s + y - z =1
x -2y + 2z = 7
3x + y + z =4
I have completed...
2 1 -1 1 1 -2 2 1
1 -2 2 7 R1 <->R2 2 -1 2 7 R1 x 2
3 1 1 4 3 1 1 4 R2 - R1

Claims company processes insurance claims, their perm operators can process 16 claims/day and temp process 12/day and the average for the company is at least 450/day. They want to limit claims error to 25 per day total, and the perm generate .5 errors/day and temp generate 1.4 error per day. The perm operators are paid $465/da

1. solve the following equations and show work.
2. You are given the following system of linear equations:
x - y + 2z = 13
2x + xy - z = -6
-x + 3y + z = -7
a. Provide a coefficient matrix corresponding to the system of linear equations.
b. What is the inverse of this matrix?
c. What is the transpose of this mat

We are studying an inner product spaces. See attached file for full problem description.
Let V be a C-space of all complex valued polynomials with an inner product....
(i) Let p be a polynomial and let Mp: V-> V be a linear operator that is given by
Mp (q) :=p⋅q. Show that operator Mp has an adjoint and find it.
(i

Please make sure all work is shown to include the tables so that I can do a comparison to make sure the way I think it should be done is being done. While QM for windows can be used to solve this, I would appreciate the other way shown as well so that I can understand what is going on verse having a program do the work for me.

During summer weekdays, boats arrive at the inlet drawbridge according to the Poisson distribution at a rate of 3 per hour, in a 2-hour period,
What is the probability that 2 boats arrive?
Answer in the form 0.xxxx or.xxxx

Hi, I need some assistance with all the attached questions. I am not too sure how to answer them and a step-by-step working guide for each question would really help me in understanding these problems. These are all linear algebra problems.