Question 1
1 out of 1 points
Which point minimizes the objective function, z = 4x + 2y?
Selected
Answer:
a.
(0, 8)
Answers:
a.
(0, 8)
b.
(6.5,
2)
c.
(3, 4)
d.
(12,
0)
Question 2
1 out of 1 points
Desc
Question 1
1 out of 1 points
A number is stored in cell C24. In cell D24, you wish to calculate 5% of the
number stored in cell C24. To accomplish this, what formula should be entered
in cell D24?
Sel
Question 1
1 out of 1 points
Compute the Future value for Principal value of $11,000 with
annual interest rate 7.25% compounded monthly at the end of 5
years.
Selected
Answer:
a.
$15,788.
85
Answers:
Question 1
1 out of 1 points
In an Excel calculation, what symbol must begin the statement?
Selected
Answer:
=
Answers:
a.
c.
!
b.
$
c.
=
d.
&
Question 2
1 out of 1 points
A companys budget expenses a
Question 1
1 out of 1 points
Graphical Linear programming can only be used to solve:
Selected
Answer:
Two-variable
problems
Question 2
1 out of 1 points
Which choice is a simultaneous solution of thes
Question 1
1 out of 1 points
What is the number, n, of periods? At the beginning of each
quarter, a 50-year-old woman whose birthday is March 1st,
deposits $1200 in a retirement account that pays 6% i
Question 1
1 out of 1 points
A restaurant purchased a kitchen appliance for $3,700. It has a
salvage value of $120 at the end of eight years. Use the straight
line method to find the scrap value at th
Jibran Samad
TECH 3365
Internet Exercise 1
A)
Amazon.com, INC(AMZN)
Choose your own company and repeat the analysis from Problem 3.
You can get the data from MSN Money at http:/money.msn.com/investing
Jibran Samad
TECH 3365
Depreciation and Depletion
Problem 1:
Note:
Some solutions below show values only; others show full formulas. When you submit your
assignment, be sure that all of your work and
Jibran Samad
TELS 3365
Applied Practice With Matrix Operations
ForProblem
each applied
problem,
use Excel
formulas
functions
to calculate
the solutions.
1: Two
salepersons
sell two
modelsand
of new
ca
Jibran Samad
Amortization and Sinking Funds
TECH 3365
Problem 1
Loan Amortization A sum of $100,000 is to be repaid over a 10-year period through
equal installments made at the end of each year. If an
Jibran Samad
TECH 3365
Elvis Products International
Income Statement
For The Year Ended Dec.31,2014
Assets
2014
Sales
3,850,000
Cost of good sold
3,250,000
Gross Profit
600,000
Selling and G&A Expense
Applying Break-Even Problems by Using the Goal Seek Feature in Excel
Jibran Samad
TECH 3365
For each application, use the Goal Seek feature in Excel in your solution. Identify the variables
and equati
Jibran Samad
TELS 3365
Elvis Products International
Income Statement
For The Year Ended Dec.31,2014
Assets
2014
2013
Sales
3,850,000
3,432,000
Cost of good sold
3,250,000
2,864,000
Gross Profit
600,00
Jibran Samad
TECH 3365
Problem 1:
IRAs If a merchant deposits $1000 annually at the end of each tax year in an IRA
account paying interest at the rate of 6% per year compounded annually, how much will
JIBRAN SAMAD
PRESENT VALUE OF AN ANNUITY
Payment
$100.00
Interest Rate
8%
Number Of Payments
Present Value
5
($399.27)
PRESENT VALUE OF AN ANNUITY
Payment
$50.00
Interest Rate
8.00%
Number Of Payment
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 f
IF/THEN Statements Applied Practice
Instructions: This spreadsheet contains 10 problems that are to be completed using Excel formulas. In
order to receive credit, use Excel formulas and IF/THEN statem
Ri Xu
1
How Technology Invades Privacy
Name: Ri Xu
HOW TECHNOLOGY INVADES PRIVACY
How Technology Invades Privacy
2
Confidentiality is an important aspect in various areas of human life. However, the m
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,0
The couple can p
Interest Practice Problems
Use Excel to solve each problem. Do not use excel as a calculator.
Write the probl
If you use the mathmatics formula, then you are using cell reference which is fine.
Proble
2016
Microsoft Corporation Sales
(Millions of Dollars)
2011 to 2016
2015
2014
2013
2012
2011
85,320.00 93,580.00 86,833.00 77,849.00 73,723.00 69,943.00
2016
Microsoft Corporation Sales
(Millions of D
Elvis Products International
Income Statement
For the Year Ended Dec. 31, 2016
2016
3,850,000
Cost of Goods Sold
3,250,000
Gross Profit
600,000
SEllingt and G&A Expenses
330,300
Fixed Expenses
100,000
Present Value of an Annuity
Payment
100
Interest Rate
8%
Number of Payments
5
Present Value
($399.27)
Payment
Interest Rate
Number of Payments
Present Value
100
8%
5
$399.27
Payment
Interest Rate
Numb
Annuities Applied Practice: Use excel functions and cell references to s
Include your name on your spreadsheet.
Problem 1: IRAs If a merchant deposits $1000 annually at the end of each tax year in an
Amortization and Sinking Funds Applied Practice
Do not share your assignment. Do not use excel as a calculator.
Problem 1:
Loan Amortization A sum of $100,000 is to be repaid over a 10-year perio
equa
Present Value of an Annuity
Payment
100
Interest Rate
8.00%
Number of Payments
4
Present Value
($331.21)
Future Value of an Annuity
Payment
5,500
Interest Rate
7.50%
Number of Payments
30
Future Value
Intertek, Next Generation Oil and Gas
Life Cycle Integrity Management
During the lifecycle of an oil and gas asset, activities are carried out that ensure
the integrity of the asset to be maintained f