Assignment: (worth 15 exercise points)Create a document (Microsoft Word is fine) with your answers to each of the following questions. You are expected to use a spreadsheet to help you answer the questions. For each question, you should give an answer AND a prose description of what you typed into the spreadsheet to get help. You will hand in a printout of this document at the beginning of class on Friday.
1) A population of animals is increasing at the rate of 3% per year. That is, each year 3% more animals are present than the year before.
2) Joanne Katupsin is an up and coming harp player. The Joanne Katupsin Fan Club gets 25 new members each month. Additionally, each time they put a table in the lobby at one of her concerts, they get 6 more members. For each church bazaar they visit, they will get 2 more members.
The club currently has 350 members, how many months will it take for them to reach 1000 members in each of the following scenarios:
3) Download the spreadsheet on State Smoking Data. Each row indicates a state/district/province and the number of packs of cigarettes smoked per capita in that location. (Not all jurisdictions are included.)
4) Download the Shipping Info spreadsheet. Each row indicates one order. Write your steps as to how to achieve each item listed below. Note that I should be able to change the information on any given order and have columns G-J automatically update appropriately. Thus, the spreadsheet needs to do the calculations.
a) Customers in VA are to be charged a 5.3% sales tax, while customers elsewhere are not charged sales tax. Thus, we want column G to indicate how much tax is to be charged on this order.
b) Gold Customers get free shipping. Orders over $50 also qualify for free shipping. All other shipping is $10 (no matter the price or the weight). We want column H to indicate the amount of shipping on the order.
c) Column I should indicate the TOTAL cost of the order, including tax and shipping. For instance, if a customer from Maryland purchases something for $19.99, the total cost would be $29.99 (including $10 shipping and no sales tax). If a customer from Virginia purchases $60, the total cost would be $63.18 (including $3.18 sales tax and free shipping).
d) We want column J to indicate how each order is being shipped. Orders over 5 pounds are sent via UPS. Orders between 1 and 5 pounds are sent via FedEx. Orders under 1 pound are sent by USmail.
HandinYour answers to the above, on paper, at the beginning of class.