You should make up your own data for this excel project. There are two examples in a file right under the assignment onÂ
Create a workbook to contain your worksheets related to this project. Your workbook and worksheets should look professional in terms of formatting and titles, etc. Date the workbook. Name the workbook Excel Project and your first name. Name each worksheet according to the task you are performing (such as subtotals). Put your name on each worksheet.Â
Include the following in your worksheets:
Use a separate worksheet to show results of each task. Directly on the worksheet explain each numbered item and worksheet specifically so that I can follow your logic.For example, the worksheet showing functions – what five functions did you use and what is the purpose for each? Explain the data you are using.
Use a minimum of five functions in your first worksheet (such as SUM, MIN, etc.)
Create a Chart to help visualize your data.
Use the sort command on more than one column.Create conditional formatting along with this sort.
Use AutoFilter to display a group of records with particular meaning.
Use subtotals to highlight subtotals for particular categories.Â
Develop a Pivot Table and Pivot Chart to visualize data in a more meaningful way.
Use the If function to return a particular value.
Use the Goal Seek command.
Profit Per Service as of:
Board
Lessons
Training
Income
600
75
75
Expense
575
15
40
Total Profit:
Minimum Profit:
Maximum Profit:
Average:
3/18/2024 18:29
Profit
25
60
35
120
25
60
40
Congratulations! You are making a profit!
Quarter
First
Second
Third
Fourth
First
Second
Third
Fourth
First
Fourth
First
Second
Third
Fourth
First
Second
Third
Fourth
First
Second
Third
Fourth
First
Fourth
First
Second
Third
Fourth
First
Second
Third
Fourth
First
Fourth
Client
Lisa
Lisa
Lisa
Lisa
Mary
Mary
Mary
Mary
Pam
Pam
Brenda
Brenda
Brenda
Brenda
Lisa
Lisa
Lisa
Lisa
Mary
Mary
Mary
Mary
Pam
Pam
Brenda
Brenda
Brenda
Brenda
Lisa
Lisa
Lisa
Lisa
Pam
Pam
Service
Board
Board
Board
Board
Board
Board
Board
Board
Board
Board
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Training
Training
Training
Training
Training
Training
Training
Training
Training
Training
Quantity
5
5
4
4
1
2
2
2
1
1
4
4
4
4
8
7
6
8
12
10
24
12
8
8
4
4
4
4
12
12
12
12
4
4
Profit
125
125
100
100
25
50
50
50
25
25
240
240
240
240
480
420
360
480
720
600
1440
720
480
480
140
140
140
140
420
420
420
420
140
140
Quarter
Client
First
Lisa
First
Mary
First
Pam
First
Brenda
First
Lisa
First
Mary
First
Pam
First
Brenda
First
Lisa
First
Pam
First Total
Second
Lisa
Second
Mary
Second
Brenda
Second
Lisa
Second
Mary
Second
Brenda
Second
Lisa
Second Total
Third
Lisa
Third
Mary
Third
Brenda
Third
Lisa
Third
Mary
Third
Brenda
Third
Lisa
Third Total
Fourth
Lisa
Fourth
Mary
Fourth
Pam
Fourth
Brenda
Fourth
Lisa
Fourth
Mary
Fourth
Pam
Fourth
Brenda
Fourth
Lisa
Fourth
Pam
Fourth Total
Grand Total
Service
Board
Board
Board
Lessons
Lessons
Lessons
Lessons
Training
Training
Training
Quantity
5
1
1
4
8
12
8
4
12
4
Board
Board
Lessons
Lessons
Lessons
Training
Training
5
2
4
7
10
4
12
Board
Board
Lessons
Lessons
Lessons
Training
Training
4
2
4
6
24
4
12
Board
Board
Board
Lessons
Lessons
Lessons
Lessons
Training
Training
Training
4
2
1
4
8
12
8
4
12
4
Profit
125
25
25
240
480
720
480
140
420
140
2795
125
50
240
420
600
140
420
1995
100
50
240
360
1440
140
420
2750
100
50
25
240
480
720
480
140
420
140
2795
10335
Quarter
Third
Fourth
Third
Fourth
Third
Fourth
Fourth
Third
Fourth
Third
Fourth
Fourth
Client
Brenda
Brenda
Lisa
Lisa
Mary
Mary
Pam
Brenda
Brenda
Lisa
Lisa
Pam
Service
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Lessons
Training
Training
Training
Training
Training
Quantity
4
4
6
8
24
12
8
4
4
12
12
4
Profit
240
240
360
480
1440
720
480
140
140
420
420
140
Total Profit Per Client
Board
$ 450.00
$ 50.00
$ 175.00
$
–
Lisa
Pam
Mary
Brenda
Lessons
$ 1,740.00
$ 960.00
$ 3,480.00
$ 960.00
Training
$ 1,680.00
$ 280.00
$
$ 560.00
Total
$ 3,870.00
$ 1,290.00
$ 3,655.00
$ 1,520.00
$4,500.00
$4,000.00
$3,500.00
$3,000.00
$2,500.00
Training
$2,000.00
Lessons
$1,500.00
Board
$1,000.00
$500.00
$-
Lisa
Pam
Mary
Brenda
Client
(All)
Sum of Profit
Row Labels
First
Second
Third
Fourth
Grand Total
Column Labels
Board
175
175
150
175
675
Lessons Training Grand Total
1920
700
2795
1260
560
1995
2040
560
2750
1920
700
2795
7140
2520
10335
Client
Sum of Profit
2500
2000
Service
Board
1500
1000
Lessons
500
Training
0
First
Quarter
Second
Third
Fourth
I want my horse business to make as much as it can every month. Below is how much profit I make from each service. My bar
hours per month because the barn takes 140 hours. In Solver A, I have hired someone to do the barn so I can have more time
Income Per Month with 1 Employee (Solver A)
Profit Per Service
Lessons
Training
Board
$
$
$
60.00
35.00
25.00
Time Per Service
Lessons
1 hours
Training
0.75 hours
Constraints
Board = 10 horses
Lessons + Training Time
