Data Tables and Goal Seek Assessment

1. Question

This is the file needed to answer this assessment question: Data Tables Question 1

Use the file above to answer this question: LL Bean is going to mail out 10,000 catalogs. It costs $2 to mail out each catalog. When a customer places an order from a catalog assume a profit of $50 is earned. Use a data table to determine how the total profit earned from the mailing varies between 1% and 10%.

2. Question

This is the file needed to answer this assessment question: Data Tables Question 2

Use the file above to answer this question: Today you bought 5 shares of Stock 1 for $30 per share and 3 shares of stock 2 for $25 per share.In a month you will sell your stock.Use a two way data table to show how your profit varies as the change in each stockprice varies from -$5 to $5.

3. Question

This is the file needed to answer this assessment question: Data Tables Question 3

Use the file above to answer this assessment question: Currently Garden and Gun Magazine has 5,000 Subscribers in Houston. Based on assumptions on new subscribers per year and percentage of subscribers who renew each year what follows gives the number of subscribers each year to Garden and Gun in Houston.

Use a data table to show how the number of subscribers at the end of year 6 varies for retention rate of 60%, 70%, 80% and 90% and new subscribers rates varying from 1,000 to 5,000.

4. Question

This is the file that has the formulas/solutions for this assessment question: Goal Seek Question 4

The current annual interest rate is 5% and you are taking out a 20 year loan with end of month payments. If you can afford monthly payments of $3,000 per month, what is the most you can borrow?

5. Question

This is the file needed to answer this assessment question: Goal Seek Question 5

Miley Cyrus has gone bankrupt and started a lemonade stand. She had to invest $400 in lemonade equipment. She sells lemonade for $4 and her unit cost of producing a glass of lemonade is $2.50. How many glasses of lemonade must Miley sell so her total profit (including her investment as a cost) is $300?