2 excel assignments
alnassar
AdditionalAssignmentExcel1QuarterlyBudgetDescription.pdf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29 30
31
32 33
34 35
36 37
38 39
40 41
42 43
44 45
46 47
48 49
50 51
52 53
54 55
56 57
58
A B C D E
Item January February March Quarter Total
REVENUE
Sales Revenue $232,897.95 $432,989.76 $765,998.61 (1)
Other Revenue $1,232.93 $3,265.81 $2,145.99 (1)
Total Revenue (2) (2) (2) (2)
EXPENSES
Manufacturing (3) (3) (3) (6)
Research (3) (3) (3) (6)
Marketing (3) (3) (3) (6)
Administrative (3) (3) (3) (6)
Fulfillment (3) (3) (3) (6)
Total Expenses (4) (4) (4) (4)
Net Income (5) (5) (5) (5)
Budget % Values:
Manufacturing 38%
Research 11%
Marketing 16%
Administrative 17%
Fulfillment 8%
Enter all formulas first then format.
Print the worksheet, formulas and two charts.
(1) Quarter total is the sum of January through March.
(2) Write formula for B11 so it can be copied: Total Revenue is the sum of Sales and Other Revenue.
(3) Write formula for B14 so it can be copied: Expenses are a percentage of total revenue. The budget percent values
are located in rows 25‐29. Be sure your formula uses these cell addresses.
(4)Write formula for B20 so it can be copied: Total expenses are the sum of the department expenses.
Create a column chart as a new sheet to show first quarter expenses by month. Name the chart "First Quarter
Expenses by Month" On the next line of the chart title in smaller font put "Prepared by YourFirstName
YourLastName".
(6) Quaterly Total is a sum of January, February , and March for that row.
Create a column chart as a new sheet to show first quarter expenses by the type of expenses. Name the chart "First
Quarter Expenses by the Expense Type" On the next line of the chart title in smaller font put "Prepared by
YourFirstName YourLastName".
(5) Write formula for B22 so it can be copied: Net Income is total revenue minus total expenses.
Format all currency amounts with 2 decimals.
Insert right section footer with your name, date and file name, each on a separate line. Use font size 8. See sample at
the right bottom corner of this page.
Make sure that entire content of cells is visible and spreadsheet fits on a single page. Modify margins and/or layout if
needed.
Quarterly Budget ‐ January through March
Prepared by (your name here )
(today's date here )
Build the spreadsheet above and save file as Quarterly_Budget_ YourFirstName_YourLastName.xlsx.
Create an embedded pie chart ( as an object in this spreadsheet) which shows contribution of each type of an
expense into total expenses.
John Doe
8/15/2011
Additional Excel Assignment Quarterly_ Budget_John_Doe.xlsx
