making a speadsheet exactly like the one presented
Home Insert Page Layout Formulas Iphone app sales Data 45 Mon Oct 12 13 Review View Calibri (Body) 11 Paste Wrap B U General + Merge Center E11 x fe $ - % ) Conditional Form . 1 E App for iPhone Scenario 1 Scenarlo 2 Goal Seek U AWN Recommendation (Scenario 1 or Somario 2) Quantity Sold for Goal Seek $30,000.00 $24,000.00 $12,000.00 $30,000.00 $24,000.00 $12,000.00 $30.000 DO $24,000.00 $12,000.00 30% 30% 30% 2 Estimate of Annual profit for year 1 3 Assumptions 4 Sales Price 5 Quantity Sold 6 Fixed Costs 7 Developer costs 8 Advertising 9 Maintainence and Support 10 Total Fixed Costs 11 Variable Costs 12 Apple's commission as percent of Sales price 13 Variable Cost per unit 14 Total Variable Costs 15 Breakeven and Profit 16 Contribution Margin 17 Quantity to be sold for Breakeven 18 Sales Revenue 19 Net Profit 20 21 22 23 Documentation Scenario Sheet + Ready Fixed Costs Page 5 of 6 1533 words English (United States -1-prod-01-ey. Exam 1 Part B (Case Problem) Project Description and Instructions: You have been hired as a financial consultant for an iPhone app developing company. You have been asked to compare two scenarios (Scenario 1 or Scenario 2) with different assumptions of sales price and annual demand for the app based on similar apps in the market. You are required to make a recommendation to the company to choose the scenario that will result in greater Net profit for the firm for the first year. You will use the IF function in cell G2 to compare Net Profit under Scenario 1 and Scenario 2 to make the recommendation of Scenario 1 or Scenario 2. The firm's fixed costs for year 1 include development costs, advertising costs and maintenance costs. The only variable cost is the 30% commission on the Sales Price that is paid to apple for using their platform for each app sold. The fixed and variable costs remain unchanged for all scenarios. Following is the data for costs: Fixed Costs Developer Costs Advertising Costs Maintenance Costs Variable Cost per unit Apple's Commission $30,000 $24,000 $12,000 30% of Sales price Apple's Commission 30% of Sales price As part of this project you will also perform What-IF Analysis using Goal seek and determine the quantity needed to be sold to make a profit for $500,000 at the end of the first year if the sales price is $2.99. The Goal Seek solution for Quantity Sold should be referenced in cell G3. Following is the Sales data including the Sales Price and the Quantity Sold under each scenario. Sales Price Quantity Sold Scenario 1 $1.99 300,000 Scenario 2 $3.99 100,000 Goal Seek $2.99 To be determined using goal seek A W Y A MacBook Air