Homework 1
xlsx
keyboard_arrow_up
School
The University of Tennessee, Knoxville *
*We aren’t endorsed by this school
Course
INMT-242
Subject
Industrial Engineering
Date
Dec 6, 2023
Type
xlsx
Pages
7
Uploaded by lcason2
Car Loan
Date
Monthly Payment Statistics
Minimum
Median
Inputs
Maximum
Down Payment
5%
Average
APR
3.25%
Years 5 Payments Per Year
12 Car Product #
Car Name
Cost
Down Payment
Monthly Payment
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
Car Product #
Car Name
Mazda 3
Honda Civic
1012 Volkswagen GTI
$ 33,900.00 $ 28,300.00 1011 Volkswagen Golf
1010 Nissan Sentra
1009 Subaru WRX
1008 Subaru Impreza
1007 Volkswagen Jetta
1006 Toyota Corolla
1005 Hyundai Elantra
1004 Hundai Veloster
1003 Kia Forte
1002 Honda Civic
1001 Mazda 3
Price Comparison
Car Information
Kia Forte
Hundai Veloster
Hyundai Elantra
Toyota Corolla
Volkswagen Jetta
Subaru Impreza
$ 23,390.00 $ 28,450.00 $ 25,450.00 $ 28,360.00 $ 31,545.00 $ 26,395.00 Use this worksheet to calculate the down payment and monthly payment on car optio
Please include today's date in the date box (one that will update each time the worksh
- Lecture video(s): 2.4 - Car Loan
- Help video(s): 2.4.2 - TODAY Help Video
Obtain the car name and cost of the car by using lookups from the data starting in row
- Lecture video(s): 2.2 - Lookups
- Help video(s): 2.2.1 - VLOOKUP Help Video & 2.2.2 - HLOOKUP Help Video
Calculate the down payment and monthly payment of each of the car loans using the calculate the monthly payment statistics. Be sure the fields are using the proper data t
- Lecture video(s): 2.4 - Car Loan
- Help video(s): 2.4.1 - PMT Help Video
In the Price Comparison column, use an if statement to determine if the monhly paym
vehicles (Note that the user wants the worksheet to be dynamic - meaning that the sp
display "Above Average" if the monthly payment is greater than the average of all mon
ments, and if not then display "Below Average" in the column.
- Lecture video(s): 2.3 - Simple IF - Help video(s): 2.3.1 - IF Statement Help Video
Subaru WRX
Nissan Sentra
Volkswagen Golf
Volkswagen GTI
$ 41,945.00 $ 21,800.00 $ 23,995.00 $ 37,745.00 ons you are considering purchasing. heet opens).
w 27 of this worksheet. appropriate absolute, mixed, and relative references and then types.
ment is higher than the average monthly payment of all of the preadsheet will update appropriately as data changes). Please nthly pay
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
World-wide Sales - Millions of Dollars
Domestic
Europe
Asia
Total
Jan
88
66
114
268
Feb
145
86
122
353
Mar
132
81
114
327
Apr
136
103
129
368
May
142
94
142
378
Jun
179
108
135
422
Jul
194
125
150
469
Aug
215
136
166
517
Sep
162
144
189
495
Oct
213
134
187
534
Nov
256
128
193
577
Dec
308
138
208
654
Total
2,170
1,343
1,849
5,362
% of Total
40.5%
25.0%
34.5%
Use World-wide Sales data to creat
update the chart title to "Sales Data
so that the top left corner is located
- Lecture video(s): 2.5 - Creating Ch
- Help video(s): 2.5.1 - Creating and
Add axis titles to the chart and labe
Millions" and label the X-axis (horiz
format the chart area to have a gra
- Lecture video(s): 2.5 - Creating Ch
- Help video(s): 2.5.1 - Creating and
te a Stacked Area Chart. Please ta by Country" and place the chart d in cell A21.
harts
d Modifying Charts Help Video
el the Y-axis (Vertical axis) "Sales - zontal axis) "Month" and then adient fill.
harts
d Modifying Charts Help Video
Home Division Executive Travel
Month
Miles
Cost per mile
Total Cost per month
Jan
2,926 0.35 1,024.14 Feb
2,159 0.55 1,187.26 Mar
2,803 0.67 1,877.74 Apr
1,619 0.46 744.73 May
2,979 0.86 2,561.75 Jun
2,253 0.85 1,914.89 Jul
2,908 0.33 959.61 Aug
2,535 0.90 2,281.77 Sep
1,688 0.57 962.07 Oct
1,930 0.45 868.42 Nov
1,764 0.67 1,181.73 Dec
2,006 0.84 1,684.84
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your boss has given you data regarding travel expenses for the executives of this division. On a new worksheet, titled “Executive Expenses” create a combo chart showing the Miles traveled by the executives and the total cost of travel. Your combo chart must have dual axes. Your chart should be in the worksheet by itself (not with the data it is made from).
- Lecture video(s): 2.6 Combo Charts
- Help video(s): 2.6.1 - Combo Charts Help Video