Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use excel : plot the change in overall net profit with a rise in commissions from 3% to 7% in half % increments. plot the
use excel : plot the change in overall net profit with a rise in commissions from 3% to 7% in half % increments. plot the change in net profit based upon increases in cost of goods sold rising at 5%, 10%, 15%, and 20% 5- UV6325 Exercise 4: Breakeven Calculations II Aaron Nathan and Alexis Roberts are thinking about launching a new e-commerce business. They firmly believe that 30% of the people who try their product at the full price will buy two additional units at their planned 25% discount for follow-up purchases. It is unlikely anyone will buy one additional unit (as they'd have to pay full price) or three additional units (as most people need at most three total units). Suppose their fixed costs are $390,000, selling price is $40 per unit, and variable costs are $20 per unit. How many customers do they need to break even? What profit do they make if 20,000 people try their product? a. b. How sensitive is your profit projection in (b) to the assumption that 30% will buy two additional units? d. Suppose a 50% discount for follow-on purchases causes a dramatic increase in the percentage of people who buy two additional units. How dramatic would it have to be for this to be a good idea
use excel :
plot the change in overall net profit with a rise in commissions from 3% to 7% in half % increments.
plot the change in net profit based upon increases in cost of goods sold rising at 5%, 10%, 15%, and 20%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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