GBA 220, Business Information Systems and Analytics

Your answers to all five questions must be in the Answers worksheet of the Ad Bids workbook that you downloaded from Blackboard. In addition, your Excel model coming up with the answers for each of the five questions should be on the appropriate worksheet in the Ad Bids workbook

Answers
Please show two digits to the right of the decimel point for your profit answers.
Your answers should be reflected on the worksheets for the individual questions.
Question 1
Profit 140.24
Which jobs? 1 – 5 and 19% of 6.
Question 2
Profit
Which jobs?
Question 3
Profit
Which jobs?
Question 4
Profit
Which jobs?
Did you need to resort?
Why or why not?
Question 5
Profit
Which jobs?
Did you need to resort?
Why or why not?
Question 1
Ad Size Height (pixels)
S 90
M 150
L 220
VLOOKUP Example in cell F6 M 150
looks up height of ad size in cell E6
Ad # Size Border Bid
1 M 1 $21.00
2 S 0 $1.00
3 M 0 $30.00
4 L 1 $32.00
5 S 0 $54.00
6 M 0 $12.00
7 L 1 $36.00
8 L 1 $51.00
9 M 1 $12.00
10 L 1 $46.00
11 S 1 $32.00
12 M 0 $15.00
13 M 0 $21.00
14 M 0 $39.00
15 S 1 $18.00
16 L 0 $9.00
17 M 0 $14.00
18 L 0 $60.00
19 S 1 $40.00
20 M 0 $27.00
21 L 1 $15.00
22 L 0 $5.00
23 M 0 $35.00
24 M 0 $45.00
25 M 0 $17.00
26 M 1 $55.00
27 M 1 $78.00
28 L 0 $49.00
29 M 1 $9.00
30 L 0 $93.00
Question 2
Question 3
Q
Question 4
Question 5

The post GBA 220, Business Information Systems and Analytics appeared first on Versed Writers.