Solving Linear Programming Applications With Desmos and Excel
For each application, choose meaningful variables, define them, and write the objective function and constraints.
Use the Desmos tool to find the feasible region and the corner points. Use Exce
Buying A Home
Step 1
Monthly Net Income=
Can afford a house worth=
$20,000
$600,000
Step 2
The house I can afford taken from ww.har.com
Step 3
Down payment=
$ 120,000.00 * I do not have the amount to pay the downpayment since I only
have $20,000 income pe
Solving Linear Programming Applications With Excel's Solver Tool
Instructions: Use Excel's Solver Tool to solve each application. Each problem should consist of the following
components (outlined in the comment boxes below) and look similar to the followi
Applying Break-Even Problems by Using the Goal Seek Feature in Excel
For each application, use the Goal Seek feature in Excel in your solution. Identify the variables
and equations in a text box. Conclude with a summary statement. Your work for each probl
Question 1
1 out of 1 points
If $5000 is borrowed at 7.5% for 4 years, what is the simple interest
amount on this loan?
Selected
Answer:
Answers:
d.
$15
00
a.
$19
50
b.
$18
60
c.
$16
25
d.
$15
00
Question 2
0 out of 1 points
Determine the present value, g
Debt=
Interest Rate=
Minimum monthly payment=
Outstanding balance < $100
$10,000
17% <-APR of your outstanding balance
2% <-of outstanding debt
<-decide to pay off the remainder
Remaining
End of
(Oustanding)
Month # Balance
You charged this amount on a cr
Question 1
1 out of 1 points
Tiffany just purchased a new house costing $113,000. Houses in the area
are appreciating at the rate of 4.50% per year .If this rate holds steady for
4 years, what will the house be worth assuming that this 4.50% rate is
compo
Question 1
1 out of 1 points
What are the required class prerequisites? (If you do not have these prerequisites, contact your
advisor immediately before you are administratively withdrawn from the class.)
Question 2
1 out of 1 points
What are the require
Date: May 19, 2016
Home Mortgage Spreadsheet Assignment
The purpose of this project is to investigate the cost of a home mortgage.
A couple has decided to purchase a home. The
negotiated price is $175,000 The couple can pay the
standard 20% down payment,
Writing the Objective Function and Constraints for Linear
Programming Applications.
For each application, choose meaningful variables, define them, and write the objective
function and constraints. Do not solve.
1. Manufacturing- Production scheduling A c
Question 1
1 out of 1 points
Two numbers are stored in cells A1and A2. Write an Excel formula that will find the
product of this set of numbers.
Selected
Answer:
Answers:
=A1*A
2
=
A1+A2
=A1
A2
=A1*A
2
=A1/A2
Question 2
1 out of 1 points
When calculating
Elvis Products International
Balance Sheet
As of Dec. 31, 2014
Assets
Cash and Equivalents
Accounts Receivable
Inventory
Total Current Assets
Plant & Equipment
Accumulated Depreciation
Net Fixed Assets
Total Assets
Liabilities and Owner's Equity
Accounts
Using the Solver Tool to Solve Systems of Linear Equations
For each application, use the Solver Tool in Excel to find your solution. Identify the variables
and equations in a text box. Conclude with a summary statement. Your work for each problem
in the t
1
Personal Finance Goal Statement
Assignment: Personal Finance Goal Statement
June 1, 2016
Life Value Quiz
2
Financial Priorities Worksheet
3
Reflection
4
During these exercises, I learned that setting priorities when it comes to financial aspect
of life
Elvis Products International
Income Statement
For the Year Ended Dec. 31, 2014
2014
2013
Sales
3,850,000 3,432,000
Cost of Goods Sold
3,250,000 2,864,000
Gross Profit
600,000 568,000
Selling and G&A Expenses 330,300 240,000
Fixed Expenses
100,000 100,000
Present value of an annuity
payment
interest rate
number of payments
presernt value
($399.27)
100
8%
5
Future value of an annuity
payment
interest rate
number of payments
future value
$568,696.71
5500
7.50%
30
solving for an annuity payment
present value
————"
/
ELET 3403 Test 2 Fall 2012 Student Name: H Odell Palms in
Time: 2:303m —4:00pm
. )1. (20 points) Short questions:
-,—-
a». J-
J,
/
.9, z (a) (5 points) What is the ratio of the input power to the output power level at the
critical frequency of a l
Dont Shoot the Messenger
On July 5, 2000, the unit general manager of Billings Equipment, Inc. instructed
the supply management team to renegotiate existing agreements for a 10 percent
reduction with major suppliers due to target costs exceeding expectati
1.
A company has the following history of sales for an item.
Month
Jan.
Feb.
Mar.
Apr.
May
Jun.
Jul.
Aug.
Sep.
Oct.
Sales Volume
120
90
100
75
110
50
75
130
110
90
a. Compute the monthly demand forecast for April through November using a 3month moving ave