| ACME WIDGET EMPLOYEE SURVEY |
| Employee | Soda machine | | Sodas per week | | Snack machine | | Snacks per week | Comments |
| Barry Bonds | no | | | | no |
| Celia Cruz | yes | | 5 | | yes | | 1 |
| Felix Frankfurter | no | | | | no |
| Izzy Isaacs | yes | | 10 | | no |
| Lisa Ling | no | | | | yes | | 3 | bring my lunch |
| Mary Martin | yes | | 1 | | no | | | refrigerator |
| Nick Nolte | no | | | | no |
| Robin Roberts | no | | | | no | | | coffeemaker |
| Tom Thompson | yes | | 5 | | no |
| Ursula Upton | yes | | 4 | | no | | | | | | 0 | | | 0 |
| Winnie Widget | no | | | | no | | | | | | 0 | | | 0 |
| Zinnia Zinn | no | | | | no | | | refrigerator |
| Amy Adams | yes | | 10 | | yes | | 4 |
| Doris Day | no | | | | yes | | 5 | refrigerator | | | 0 | | | 0 |
| Emilio Estavez | yes | | 5 | | yes | | 2 | | | | 0 | | | 0 |
| George Garcia | no | | | | yes | | 3 |
| Henry Higgins | yes | | 2 | | yes | | 4 |
| Janet Jackson | no | | | | no | | | | | | 0 | | | 0 |
| Kevin Kline | no | | | | yes | | 3 | | | | 0 | | | 0 |
| Ophelia O'Brian | yes | | 3 | | yes | | 2 |
| Paula Poundstone | yes | | 3 | | yes | | 5 |
| Quenella Quincy | yes | | 10 | | yes | | 6 |
| Sylvester Strange | yes | | 2 | | yes | | 7 |
| Vince Vaughan | yes | | 6 | | yes | | 5 | coffeemaker |
| Xavier Xerxes | yes | | 1 | | yes | | 5 |
| Yolanda Young | yes | | 8 | | yes | | 5 |
| Total number of employees who want soda machine: | | Average sodas per week for "yes" answers: | | Total number of employees who want snack machine: | | Average snacks per week for "yes" answers: |
| | | Total number of sodas per week | | | | Total number of snacks per week |
| Constants |
| Number of work weeks per month | 4 |
| Average number of sodas per "yes" employee per month |
| Average number of snacks per "yes" employee per month |
| Total number of snacks per month |
| Total number of sodas per month |
| Vendor Queen |
| Sodas | | | | | Snacks |
| | Costs for Acme | | | | | Costs for Acme |
| Installment | | | | | Installment |
| Cost per drink (for Acme) | | | | | Cost per snack (for Acme) |
| Total cost per month | | | | | Total cost per month |
| | Costs for "yes" employees | | | | | Costs for "yes" employees |
| Cost per drink | | | | | Cost per snack |
| Average cost per employee per month | | | | | Average cost per employee per month |
| Total cost to employees per month | | | | | Total cost to employees per month |
| Superior Sodas and More (less than 50) |
| Sodas | | | | | Snacks |
| | Cost for Acme | | | | | Cost for Acme |
| Installment | | | | | Installment |
| Cost per drink (for Acme) | | | | | Cost per snacks (for Acme) |
| | | | | | Costs of snack per month |
| Total cost per month | | | | | Income per snack |
| | | | | | Total monthly income from snack sales |
| | | | | | Total cost per month (installment + costs of snacks per month - total monthly income from snack sales) |
| | Costs for "yes" employees | | | | | Costs for "yes" employees |
| Cost per drink | | | | | Cost per snack |
| Average cost per employee per month | | | | | Average cost per employee per month |
| Total cost to employees per month | | | | | Total cost to employees per month |
| Superior Sodas and More (more than 50) |
| Sodas | | | | | Snacks |
| | Cost for Acme | | | | | Cost for Acme |
| Installment | | | | | Installment |
| Cost per drink (for Acme) | | | | | Cost per snack (for Acme) |
| Total cost per month | | | | | Total cost per month |
| | Costs for "yes" employees | | | | | Costs per "yes" employees |
| Cost per drink | | | | | Cost per snack |
| Average cost per employee per month | | | | | Average cost per employee per month |
| Total cost per month | | | | | Total cost per month |
| 1. Why is it useful to use formulas in this situation? |
| 2. Which formula did you find hardest to use and why? Which was most useful and why? |
| © Copyright 2016 College for America at Southern New Hampshire University. All rights reserved. |
bori787
mind_your_business_-_spreadsheet.xlsx
