#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 921
Default Math Question

Hello All,

I know that I am charged 14.99 for every shipment I am sent. I also know
that a shipment can have either one or two units (a 14.99 charge either way).
If I know that 70% of my shipments are of two units, what is my per unit
shipping charge?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 158
Default Math Question

The answer is $8.82 (rounded up). Divide the $14.99 by 170%, which is the
30% PLUS the 70% PLUS another 70% that are free. To make it more concrete,
you can convert your percentages to a sample of 100 shipments, for which you
pay $1499 ($14.99 X 100) and in which 170 units are shipped. $1499/170 units
= $8.82/unit.

"JEFF" wrote:

Hello All,

I know that I am charged 14.99 for every shipment I am sent. I also know
that a shipment can have either one or two units (a 14.99 charge either way).
If I know that 70% of my shipments are of two units, what is my per unit
shipping charge?

Thanks.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 947
Default Math Question

=14.99/(2*0.7+1*0.3)

$8.82 / Unit

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"JEFF" wrote in message
...
Hello All,

I know that I am charged 14.99 for every shipment I am sent. I also know
that a shipment can have either one or two units (a 14.99 charge either
way).
If I know that 70% of my shipments are of two units, what is my per unit
shipping charge?

Thanks.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 921
Default Math Question

thanks!

"andy62" wrote:

The answer is $8.82 (rounded up). Divide the $14.99 by 170%, which is the
30% PLUS the 70% PLUS another 70% that are free. To make it more concrete,
you can convert your percentages to a sample of 100 shipments, for which you
pay $1499 ($14.99 X 100) and in which 170 units are shipped. $1499/170 units
= $8.82/unit.

"JEFF" wrote:

Hello All,

I know that I am charged 14.99 for every shipment I am sent. I also know
that a shipment can have either one or two units (a 14.99 charge either way).
If I know that 70% of my shipments are of two units, what is my per unit
shipping charge?

Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Breakeven/ Math Question.... Jeff Excel Worksheet Functions 7 December 6th 06 10:44 PM
Question on setting up excell to solve a math problem frank c Excel Worksheet Functions 3 October 30th 06 03:30 AM
How do I ? math/excel question Madduck Excel Discussion (Misc queries) 3 July 26th 06 05:41 AM
*Tough Math Question* Spreadsheet Excel Worksheet Functions 7 June 6th 06 05:51 PM
Math Question Mike New Users to Excel 4 December 3rd 04 06:38 AM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"