Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I am trying to keep my sales volume at a predictable level…

Customer Question
I am trying to keep...
I am trying to keep my sales volume at a predictable level each month at $50,000

It employs a trial offer to subscription strategy.

My business has the following retention model statistics:

Day 1 - Customer signs up for trial at $6.95
Day 15 - 60% of customers convert to paid membership for $99.98
Day 44 - 50% of customers from Day 15 stay in club and get billed $99.98
Day 74 - 50% attrition from Day 44 (repeats every month until cancels out)


I am trying to come up w/ a formula that takes into account this model and predicts how many new customers i need to make sure
i have $50,000 being billed every month in total sales taking into account attrition for previous months recurring sales.

i am trying to have an excel spreadsheet calculation, price not an issue
Submitted: 8 years ago.Category: Programming
Show More
Show Less
Ask Your Own Programming Question
Answered in 4 minutes by:
6/14/2010
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9,666
Experience: Vast experience in Excel programming and business solutions
Verified

Hi,

 

I think I will need to see the data with some examples of what you want to achieve. Would it be ok to send the file

 

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
yes, how do i send my excel file. also i would like to ensure privacy of this conversation.
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok, as you know this is more or less a public forum and the files as well as the messages are accessible to members and others

 

Are you concerned about the data in the file or the messages posted here?

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
yea, i cannot post this in public forum. i thought if you payed it was private
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

I can give you an email address to send the file to which will remain private and cannot be accessed by any unauthorized person. And you can add your sensitive messages in the email instead of posting them here.

 

Would that be ok?

 

Ask Your Own Programming Question
Customer reply replied 8 years ago
great that would be best
Programmer: John D, Bachelor of Science - Engineering Consultant replied 8 years ago

Ok since it is not allowed to exchange personal email addresses on this site you can send the message with file by email to the site moderator at [email protected] with the phrase "For John D" and your username in the subject line. Let me know as soon as you have sent it so I can follow up with them as It may take a few hours until it is forwarded to me.

 

 

 

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask ATLPROG Your Own Question
ATLPROG
ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7,677
7,677 Satisfied Customers
Experience: MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

ATLPROG is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
Having a lot of trouble with the week 4 assignment. Modify
Having a lot of trouble with the week 4 assignment. Modify the Week Three Java application using NetBeans IDE to meet these additional and changed business requirements: •The application will now comp… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
I have daily stock results, one row per day. I would like to
I have daily stock results, one row per day. I would like to create a formula that indicates the cell value (a stock price) of the row before a row that I have named "Today". How can I do this? The re… read more
R. Michael
R. Michael
MIS Analyst
Master\u0027s Degree
22 satisfied customers
Pertaining to my payroll hours I want to add start and end
Pertaining to my payroll hours I want to add start and end times and have it total up the total hours and minutes, yet convert to the nearest quarter, IE: 8:10 am to 4:10 PM = 8:20 minutes or 8 1/2 hr… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
In excel 2010 spreadsheetneed to calculate a rent amount
In excel 2010 spreadsheet need to calculate a rent amount based on no of weeks (or part thereof). Day 1 of each week = Sat / Day 7 = Friday. If arrival date is Wed, rent is calculated from previous Sa… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Question is what formula can I plug into cell F3 that will
Question is what formula can I plug into cell F3 that will populate the answer ( total number of “bill” in “july” ) The long hand the answer is f13+f15+f16 = 10+20+30 = 60 But since all the “bills” ar… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Hi from Sydney, Australia - My Problem is using IF in Excel
Hi from Sydney, Australia - My Problem is using IF in Excel I need to obtain a value for Sales vs Income costs (1) each sale is worth $300 so if on each day of the week various sales ocur 1 or 2 or 3 … read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,133 satisfied customers
This is my request for formulas in Excel. Below is what is
This is my request for formulas in Excel. Below is what is needed - can it be done in Excel through your efforts. C2 - Employee Hire Date MM/DD/YYYY A8 -Beginning pay period date ex: 12/25/11 B8 -Endi… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
In Excel, is there a way to code if day of date A (which is
In Excel, is there a way to code if day of date A (which is employee start date) is in range of pay period date 1 (start pay day) and pay period 2 (end pay day) Example: Employee started on March 31, … read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Write the following program in C++ **I need this answer
Write the following program in C++ **I need this answer by Sunday, April 3rd at 10pm. It is 3:14pm Saturday April 2nd Pacific time. That leaves around 30 hours for the question to be answered. Each pr… read more
unvadim
unvadim
Computer Software Engineer
Diplom
1,168 satisfied customers
In the aviation world, we are required to receive a check ride
In the aviation world, we are required to receive a check ride every six months. But, we have a grace month on either month of the actual due date, so the actual check ride may be given in the month b… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Minihan Sales employs seven salespeople. Each salesperson has
Minihan Sales employs seven salespeople. Each salesperson has an ID number, as shown in the following table: ID Number Name 103 Edwards 104 Rogers 201 Krybek 319 Delaney 367 LaFleur 375 Smith 400 Blac… read more
LogicPro
LogicPro
Computer Software Engineer
Bachelor of Technology
7,175 satisfied customers
need to create a nested formula using IF and AND function to
need to create a nested formula using IF and AND function to determine number of vacation days each employee is eligible for. My formula thus far is: =IF(AND([Status]="FT", [Years Employed]>=2=1<… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Hi I am a pro baseball handicapper and I have each and
Hi I am a pro baseball handicapper and I have each and every game back to 1999 on excel with the starting pitchers stats on each game. What I am trying to do is figure out what the pitchers season to … read more
Bill Sprouse
Bill Sprouse
Bachelor\u0027s Degree
37 satisfied customers
I have a spreadsheet with column lables of 1,2,3 etc up to
I have a spreadsheet with column lables of 1,2,3 etc up to 23 I have row labels of person name I have about 50 names or rows. I want to refer to a number between 1 and 23 and look up the data in the r… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Monthly Compensation % progressively increases depending on
Monthly Compensation % progressively increases depending on YTD cumulative earned commissions. $0-$17,000 15% $17,001-$34,000 35% $34,000-$59,000 35% $59,001-$95,000 45% $95,001-$206,000 50% $206,001-… read more
Jason Jones
Jason Jones
AAS Information Technology
6,329 satisfied customers
If John D. is available, I would like his help with my question.
If John D. is available, I would like his help with my question. I have attached the spreadsheet we had previously worked on. I have found something that isn't adding up correctly. On the players tota… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Hi, I finally found your 201205 macro to add a new value to
Hi, I finally found your 201205 macro to add a new value to an existing value is a cell. Very clever ! But I need to add a number from an ADJACENT cell. So, for example cell A1 are the monthly sales T… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
I need to create a formula that will calculate a % of sales
I need to create a formula that will calculate a % of sales by employee only if another employee worked on that day. I am desperate.… read more
John D
John D
Bachelor of Science - Engineering Consultant
9,666 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x