Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

making a speadsheet exactly like the one presented
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Environmental Responsibility Accounting And Corporate Finance In The EU

Authors: Panagiotis Dimitropoulos, Konstantinos Koronios

1st Edition

3030727726, 9783030727727

More Books

Students also viewed these Accounting questions

Question

Define cost estimation

Answered: 1 week ago

Question

1. What physical and mental tasks does the worker accomplish?

Answered: 1 week ago

Question

5. Why is the job done?

Answered: 1 week ago

Question

4. How does the worker do the job?

Answered: 1 week ago