Johnson & Wales University 6 Steps for Framework Selection Discussion

Description

Using the same workbook you created for Part 1 of your semester capstone project, create the sparklines and charts according to the instructions below. Be sure to include all necessary chart elements to make the chart useful, conveying information to the audience. Follow these next steps for adding sparklines and other charts to your workbook.

Sparklines & Charts to Create In the Workbook

Step 1: Sparklines

On the Sales worksheet, add column sparklines to show the trend for monthly sales of each item.

Step 2: Chart 1

Create a chart on the Sales Revenue worksheet that will compare sales for each item/product/service for each month of the first quarter only. What columns should you choose to create the most effective chart? Think about this before you create your chart.

Step 3: Chart 2

Using data from the Sales Revenue worksheet create a chart on a separate chart sheet that will show the percentage of each item as compared to the whole (grand total).

Step 4: Chart 3

Using data from the Sales worksheet, create a combination chart on a separate chart sheet showing sales for any one month with the secondary axis illustrating the trend of the 6-month total

2 attachments

Slide 1 of 2

attachment_1

attachment_1
attachment_2

attachment_2

Unformatted Attachment Preview

Inventory
Lechon Beverage
Inventory
Product ID
Product Name
20001 Pomegranate Martini
20002
Mojito
20003
Old Fashioned
20004
JackàSweet Tea
20005
Paloma
20006
Sam Simeon
20007
Avalon
20008
Napa Cellars
20009
Prisoner
20010
Mac Rostie
Quantity on Hand
2450
3500
3250
5000
4000
5300
4600
4650
3050
3000
$
$
$
$
$
$
$
$
$
$
Cost
3.50
4.00
7.00
12.00
15.00
21.00
16.00
8.00
25.00
26.00
Price
$ 15.00
$ 12.00
$ 14.00
$ 42.00
$ 45.00
$ 60.00
$ 50.00
$ 16.00
$ 65.00
$ 56.00
$
$
$
$
$
$
$
$
$
$
Inventory Values at Cost
8,575
14,000
22,750
60,000
60,000
111,300
73,600
37,200
76,250
78,000
$
$
$
$
$
$
$
$
$
$
Inventory Value at Retail
36,750
42,000
45,500
210,000
180,000
318,000
230,000
74,400
198,250
168,000
$
$
$
$
$
$
$
$
$
$
Potential Profit
28,175
28,000
22,750
150,000
120,000
206,700
156,400
37,200
122,000
90,000
11/22/2022
Quantity Sold
Lechon Beverage
Quantity Sold
Product ID
Product Name
20001 Pomegranate Martini
20002
Mojito
20003
Old Fashioned
20004
JackàSweet Tea
20005
Paloma
20006
Sam Simeon
20007
Avalon
20008
Napa Cellars
20009
Prisoner
20010
Mac Rostie
Monthly Total Sales
January
$
300
$
500
$
400
$
600
$
300
$
400
$
325
$
300
$
270
$
345
$
3,740
February
$
400
$
540
$
360
$
650
$
450
$
678
$
400
$
432
$
300
$
400
$
4,610
March
$
250
$
520
$
600
$
500
$
325
$
654
$
340
$
611
$
350
$
500
$
4,650
April
$
320
$
300
$
400
$
900
$
459
$
624
$
450
$
580
$
290
$
430
$ 4,753
May
$
276
$
600
$
367
$
800
$
453
$
580
$
432
$
600
$
400
$
290
$ 4,798
June
$
350
$
490
$
300
$
700
$
332
$
600
$
510
$
621
$
380
$
400
$ 4,683
Total Sold Per
Item
$
1,896
$
2,950
$
2,427
$
4,150
$
2,319
$
3,536
$
2,457
$
3,144
$
1,990
$
2,365
$
27,234
11/22/2022
Sales
Lechon Beverage
Sales Revenue
Product ID
Product Name
20001 Pomegranate Martini
20001
Mojito
20001
Old Fashioned
20001
JackàSweet Tea
20001
Paloma
20001
Sam Simeon
20001
Avalon
20001
Napa Cellars
20001
Prisoner
20001
Mac Rostie
Total Monthly Sales
January
$
4,500
$
6,000
$
5,600
$
25,200
$
13,500
$
24,000
$
16,250
$
4,800
$
17,550
$
19,320
$ 136,720
February
$
6,000
$
6,480
$
5,040
$
27,300
$
20,250
$
40,680
$
20,000
$
6,912
$
19,500
$
22,400
$
174,562
$
$
$
$
$
$
$
$
$
$
$
March
3,750
6,240
8,400
21,000
14,625
39,240
17,000
9,776
22,750
28,000
170,781
$
$
$
$
$
$
$
$
$
$
$
April
4,800
3,600
5,600
37,800
20,655
37,440
22,500
9,280
18,850
24,080
184,605
$
$
$
$
$
$
$
$
$
$
$
May
4,140
7,200
5,138
33,600
20,385
34,800
21,600
9,600
26,000
16,240
178,703
$
$
$
$
$
$
$
$
$
$
$
June
5,250
5,880
4,200
29,400
14,940
36,000
25,500
9,936
24,700
22,400
178,206
Total Sold
Per Item
$
28,440
$
35,400
$
33,978
$ 174,300
$ 104,355
$ 212,160
$ 122,850
$
50,304
$ 129,350
$ 132,440
$ 1,023,577
Percentage
Sales
2.78%
3.46%
3.32%
17.03%
10.20%
20.73%
12.00%
4.91%
12.64%
12.94%
100.00%
Quarterly Summary
Product ID
Product Name
20001 Pomegranate Martini
20002
Mojito
20003
Old Fashioned
20004
JackàSweet Tea
20005
Paloma
20006
Sam Simeon
20007
Avalon
20008
Napa Cellars
20009
Prisoner
20010
Mac Rostie
Quarterly Grand Total
Quarter 1
$
14,250
$
18,720
$
19,040
$
73,500
$
48,375
$ 103,920
$
53,250
$
21,488
$
59,800
$
69,720
$ 482,063
Quarter 2
$
14,190
$
16,680
$
14,938
$
100,800
$
55,980
$
108,240
$
69,600
$
28,816
$
69,550
$
62,720
$
541,514
Quarterly Total
For Product
$
28,440
$
35,400
$
33,978
$
174,300
$
104,355
$
212,160
$
122,850
$
50,304
$
129,350
$
132,440
$
1,023,577
11/22/2022
Inventory
Lechon Beverage
Inventory
Product ID
Product Name
20001 Pomegranate Martini
20002
Mojito
20003
Old Fashioned
20004
JackàSweet Tea
20005
Paloma
20006
Sam Simeon
20007
Avalon
20008
Napa Cellars
20009
Prisoner
20010
Mac Rostie
Quantity on Hand
2450
3500
3250
5000
4000
5300
4600
4650
3050
3000
$
$
$
$
$
$
$
$
$
$
Cost
3.50
4.00
7.00
12.00
15.00
21.00
16.00
8.00
25.00
26.00
Price
$ 15.00
$ 12.00
$ 14.00
$ 42.00
$ 45.00
$ 60.00
$ 50.00
$ 16.00
$ 65.00
$ 56.00
$
$
$
$
$
$
$
$
$
$
Inventory Values at Cost
8,575
14,000
22,750
60,000
60,000
111,300
73,600
37,200
76,250
78,000
$
$
$
$
$
$
$
$
$
$
Inventory Value at Retail
36,750
42,000
45,500
210,000
180,000
318,000
230,000
74,400
198,250
168,000
$
$
$
$
$
$
$
$
$
$
Potential Profit
28,175
28,000
22,750
150,000
120,000
206,700
156,400
37,200
122,000
90,000
11/22/2022
Quantity Sold
Lechon Beverage
Quantity Sold
Product ID
Product Name
20001 Pomegranate Martini
20002
Mojito
20003
Old Fashioned
20004
JackàSweet Tea
20005
Paloma
20006
Sam Simeon
20007
Avalon
20008
Napa Cellars
20009
Prisoner
20010
Mac Rostie
Monthly Total Sales
January
$
300
$
500
$
400
$
600
$
300
$
400
$
325
$
300
$
270
$
345
$
3,740
February
$
400
$
540
$
360
$
650
$
450
$
678
$
400
$
432
$
300
$
400
$
4,610
March
$
250
$
520
$
600
$
500
$
325
$
654
$
340
$
611
$
350
$
500
$
4,650
April
$
320
$
300
$
400
$
900
$
459
$
624
$
450
$
580
$
290
$
430
$ 4,753
May
$
276
$
600
$
367
$
800
$
453
$
580
$
432
$
600
$
400
$
290
$ 4,798
June
$
350
$
490
$
300
$
700
$
332
$
600
$
510
$
621
$
380
$
400
$ 4,683
Total Sold Per
Item
$
1,896
$
2,950
$
2,427
$
4,150
$
2,319
$
3,536
$
2,457
$
3,144
$
1,990
$
2,365
$
27,234
11/22/2022
Sales
Lechon Beverage
Sales Revenue
Product ID
Product Name
20001 Pomegranate Martini
20001
Mojito
20001
Old Fashioned
20001
JackàSweet Tea
20001
Paloma
20001
Sam Simeon
20001
Avalon
20001
Napa Cellars
20001
Prisoner
20001
Mac Rostie
Total Monthly Sales
January
$
4,500
$
6,000
$
5,600
$
25,200
$
13,500
$
24,000
$
16,250
$
4,800
$
17,550
$
19,320
$ 136,720
February
$
6,000
$
6,480
$
5,040
$
27,300
$
20,250
$
40,680
$
20,000
$
6,912
$
19,500
$
22,400
$
174,562
$
$
$
$
$
$
$
$
$
$
$
March
3,750
6,240
8,400
21,000
14,625
39,240
17,000
9,776
22,750
28,000
170,781
$
$
$
$
$
$
$
$
$
$
$
April
4,800
3,600
5,600
37,800
20,655
37,440
22,500
9,280
18,850
24,080
184,605
$
$
$
$
$
$
$
$
$
$
$
May
4,140
7,200
5,138
33,600
20,385
34,800
21,600
9,600
26,000
16,240
178,703
$
$
$
$
$
$
$
$
$
$
$
June
5,250
5,880
4,200
29,400
14,940
36,000
25,500
9,936
24,700
22,400
178,206
Total Sold
Per Item
$
28,440
$
35,400
$
33,978
$ 174,300
$ 104,355
$ 212,160
$ 122,850
$
50,304
$ 129,350
$ 132,440
$ 1,023,577
Percentage
Sales
2.78%
3.46%
3.32%
17.03%
10.20%
20.73%
12.00%
4.91%
12.64%
12.94%
100.00%
Quarterly Summary
Product ID
Product Name
20001 Pomegranate Martini
20002
Mojito
20003
Old Fashioned
20004
JackàSweet Tea
20005
Paloma
20006
Sam Simeon
20007
Avalon
20008
Napa Cellars
20009
Prisoner
20010
Mac Rostie
Quarterly Grand Total
Quarter 1
$
14,250
$
18,720
$
19,040
$
73,500
$
48,375
$ 103,920
$
53,250
$
21,488
$
59,800
$
69,720
$ 482,063
Quarter 2
$
14,190
$
16,680
$
14,938
$
100,800
$
55,980
$
108,240
$
69,600
$
28,816
$
69,550
$
62,720
$
541,514
Quarterly Total
For Product
$
28,440
$
35,400
$
33,978
$
174,300
$
104,355
$
212,160
$
122,850
$
50,304
$
129,350
$
132,440
$
1,023,577
11/22/2022

Purchase answer to see full
attachment

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}