Produce a college expense sheet that summarizes the expenses provided below. To complete the exercise, the following should be performed. a. A total summary of expenses. Expenses - Scholarships = Total Cost b. Create two pie charts that include the total amount of: 1) Charges and 2) Payments. c. Create two summary tables that include the total amount of: 1) Charges and 2) Payments. d. The pie charts and summary tables should be categorized based on the form of expense or payment.

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question
100%

Please Use excel to solve this problem

 

Produce a college expense sheet that summarizes the expenses provided below. To complete
the exercise, the following should be performed.
a. A total summary of expenses.
Expenses – Scholarships = Total Cost
b. Create two pie charts that include the total amount of: 1) Charges and 2) Payments.
c. Create two summary tables that include the total amount of: 1) Charges and 2) Payments.
d.
The pie charts and summary tables should be categorized based on the form of expense or
payment.
e. Review your Excel spreadsheet and ensure that it is clear, organized, and easy to follow.
Transcribed Image Text:Produce a college expense sheet that summarizes the expenses provided below. To complete the exercise, the following should be performed. a. A total summary of expenses. Expenses – Scholarships = Total Cost b. Create two pie charts that include the total amount of: 1) Charges and 2) Payments. c. Create two summary tables that include the total amount of: 1) Charges and 2) Payments. d. The pie charts and summary tables should be categorized based on the form of expense or payment. e. Review your Excel spreadsheet and ensure that it is clear, organized, and easy to follow.
Term
Fall 2017
Date
Description
04/28/2017 Enrollment Confirmation Deposit
04/28/2017
Housing Deposit
05/16/2017
05/16/2017
08/04/2017
09/19/2017
09/20/2017
09/20/2017
09/23/2017
09/26/2017
09/27/2017
09/27/2017
09/27/2017
09/27/2017
10/03/2017
10/08/2017
10/17/2017
10/18/2017
10/19/2017
10/25/2017
10/28/2017
MDPT
Orientation Registration
CPP Gear
Housing Deposit
Tuition
Housing
iClicker
Arts Package
Gilgamesh
Transactions
Category
Tuition
EGR Paper
Studying Engineering
The Distance Between Us
CE 122 Manual
Pearson's MyLab
Joggers Club Scholarship
Expo Markers
Scantrons
Bowling Scholarship
CPP Folder
Payment
Parents
Parents
Parents
Parents
Personal
Personal
Parents
Housing
Personal
Books/Supplies/Fees
Personal
Books/Supplies/Fees Personal
Books/Supplies/Fees
Personal
Books/Supplies/Fees Personal
Books/Supplies/Fees
Personal
Books/Supplies/Fees
Personal
Books/Supplies/Fees
Personal
Books/Supplies/Fees Personal
Scholarships
Books/Supplies/Fees Personal
Books/Supplies/Fees Personal
Housing
Books/Supplies/Fees
Books/Supplies/Fees
Books/Supplies/Fees
Housing
Tuition
Scholarships
Books/Supplies/Fees Personal
Method
$
$
Amount
150.00
450.00
8.00
189.00
61.02
150.00
2,297.67
3,905.00
25.13
49.00
7.51
11.99
9.99
9.00
7.43
103.95
500.00
5.58
3.87
27.54
1.08
Transcribed Image Text:Term Fall 2017 Date Description 04/28/2017 Enrollment Confirmation Deposit 04/28/2017 Housing Deposit 05/16/2017 05/16/2017 08/04/2017 09/19/2017 09/20/2017 09/20/2017 09/23/2017 09/26/2017 09/27/2017 09/27/2017 09/27/2017 09/27/2017 10/03/2017 10/08/2017 10/17/2017 10/18/2017 10/19/2017 10/25/2017 10/28/2017 MDPT Orientation Registration CPP Gear Housing Deposit Tuition Housing iClicker Arts Package Gilgamesh Transactions Category Tuition EGR Paper Studying Engineering The Distance Between Us CE 122 Manual Pearson's MyLab Joggers Club Scholarship Expo Markers Scantrons Bowling Scholarship CPP Folder Payment Parents Parents Parents Parents Personal Personal Parents Housing Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Books/Supplies/Fees Personal Scholarships Books/Supplies/Fees Personal Books/Supplies/Fees Personal Housing Books/Supplies/Fees Books/Supplies/Fees Books/Supplies/Fees Housing Tuition Scholarships Books/Supplies/Fees Personal Method $ $ Amount 150.00 450.00 8.00 189.00 61.02 150.00 2,297.67 3,905.00 25.13 49.00 7.51 11.99 9.99 9.00 7.43 103.95 500.00 5.58 3.87 27.54 1.08
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Exhaustible Resources
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education