Need help creating a formula for calculating percentage for product from a mysterybox

I need help creating a formula that can calculate the winning percentage of the product inside a mysterybox for sale

Example:

The mysterybox has 5products inside that the customer can win.

The price for opening the box is a \$100

Product that the costumer can win inside the mysterybox

product 1= value \$10

product 2= value \$30

product 3= value \$50

product 4= value \$150

product 5= value \$300

The website needs 20% of the earnings, so when we have sold 100 boxes and shipped all the items that the customer won, we should be left with (\$100*100boxes)*0.2=2.000

The question is how to calculate the correct winning percentage so we don't lose money in the end?

I need a formula for this :)

Tietoa työnantajasta:
( 22 arvostelua ) Tallaght, Ireland

Projektin tunnus: #28007260

15 freelanceria on tarjonnut keskimäärin \$116 tähän työhön

liveexperts123

Hi there,I'm biddin on your project "Need help creating a formula for calculating percentage for product from a mysterybox" I have read your project description and i'm an expert in C programming and machine learning t Lisää

\$250 USD 3 päivässä
(131 arvostelua)
7.8
(1542 arvostelua)
7.8
umg536

Hi there, I'm bidding on your project "Need help creating a formula for calculating percentage for product from a mysterybox" Being an expert in C, and C++ programming I can do this project for you. please leave a mes Lisää

\$250 USD 6 päivässä
(30 arvostelua)
6.6
daniyal3214

I can perfectly help you with that. I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data A Lisää

\$40 USD 1 päivässä
(40 arvostelua)
5.2
iquicksolution

Hey there I'm professional developer and experienced programmer I can help you in doing your task perfectly I'll be waiting to hear back from you

\$70 USD 2 päivässä
(13 arvostelua)
4.7
hayteekeys

hello i can help you in creating a formula that can calculate the winning percentage of the product inside a mysterybox for sale perfectly well.. Hello, I am an MSC majored in mathematics. I have rich exp in ACM/ICPC a Lisää

\$50 USD 1 päivässä
(23 arvostelua)
4.8
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit my Lisää

\$40 USD 7 päivässä
(23 arvostelua)
4.5
Dutchstudent7750

Hi there, Experienced programmer and algorithm expert here. Can create your formula and program it into a simple console application within an hour. Niels

\$30 USD 1 päivässä
(15 arvostelua)
4.2
engrhassanwali

Hello! I have read your project details completely and thoroughly. I am statistical analyst and have 10 years experience. Further details will be discuss in the inbox. I have few Important suggestions for y Lisää

\$250 USD 7 päivässä
(4 arvostelua)
3.8
GeorgeLaz

Hi. I think you don't really need a formula when a computer can do it for you. I can program something to calculate the right dosage for you, in a way that there will be mostly middle packets (with 20 profit). Some re Lisää

\$120 USD 7 päivässä
(5 arvostelua)
2.4
todor1996

Hello, do you have exact amount of every item in mysterybox, or it is randomized aswell? Nice tricky problem, i'd love to try to solve it.

\$140 USD 1 päivässä
(2 arvostelua)
1.1

Hi, sir. Thank you for sharing your project Need help creating a formula for calculating percentage for product from a mysterybox, and I would be very happy to help you with your business. Let me share you with my expe Lisää

\$155 USD 2 päivässä
(0 arvostelua)
0.0
ChamGam

[login to view URL] are you? I am a math expert. I can make method to calculate correct winning perfectly. I'd love to discuss more details with you. Thank you.

\$140 USD 1 päivässä
(0 arvostelua)
0.0
Nachobascar

Is a simple formula with mutiple solutions. I will tell u the formula at the moment you contact me.

\$30 USD 1 päivässä
(0 arvostelua)
0.0
johnny737

I am a disabled veteran that has over 40 years experience in computers and programming in QBasic and C++. I have written scientific calculations and equations in my programs and also I have written equations for elect Lisää

\$100 USD 7 päivässä
(0 arvostelua)
0.0