Question
1) Data Tables Review the worksheet labeled 6-Data Tables (This is the same worksheet we worked on in class to illustrate formula auditing tools in
1) Data Tables Review the worksheet labeled 6-Data Tables (This is the same worksheet we worked on in class to illustrate formula auditing tools in Excel). The business would like to know the following: What would be the impact on Gross Revenue and Earnings before Taxes if first year sales ranged from $75,000 to $125,000 (in increments of $5,000). Create a table, appropriately labeled, to show this information. The business would also like to know what Earnings before Taxes would be on the same range of first year sales (as above) as well as if the percentage increase in first year sales ranged from 8% to 12% (in increments of 1%). Create a table, appropriately labeled, to show this information. Hint: Be sure to use the Data Table function to answer both questions.
Get Rich Quick Enterprises 2011 2012 2013 2014 2015 Income Revenues Units Sold Unit Price Gross Revenue $100,000 $3.50 $350,000 $110,000 $3.68 $404,250 $121,000 $3.86 $466,909 $133,100 $4.05 $539,280 $146,410 $4.25 $622,868 Expenses $50,000 $25,000 $54,000 $26,250 $58,320 $27,563 $62,986 $28,941 $68,024 $30,388 Fixed costs Production facility Administration Variable costs Unit mfg cost Variable mfg cost $1.50 $150,000 $1.65 $181,500 $1.82 $219,615 $2.00 $265,734 $2.20 $321,538 Earnings before taxes $125,000 $142,500 $161,411 $181,619 $202,918 Assumptions Initial Values First year sales Selling price Unit mfg cost Production facility Administration First year of forecast 100,000 $3.50 $1.50 $50,000 $25,000 2011 Increase 10.0% 5.0% 10.0% 8.0% 5.0%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started