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
Clark1026
AdBids.xlsxAnswers
| 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 |
