Results 1 to 3 of 3

Math Help - Business Math Help MS Excel

  1. #1
    Newbie
    Joined
    May 2007
    Posts
    24

    Business Math Help MS Excel

    Plase try it to solve on Excel sheet. thanks

    Q#1: A photo machine operator purchased 20 packets of papers. The market price of a packet is Rs.144. He gets a discount of 17.5% and an additional 5% for cash. How much did he pay for the whole quantity?
    Q#2: Three partners invested Rs.18000, Rest. 16500 and Rs.12500 respectively. When profit was distributed, the third one gets Re.4625. Find the total profit.
    Q#3: Airport Security Force purchased 10,000 pairs of socks for the staff members. The cost of manufacturer was Rs. 4 per pair of socks and he supplied the socks on 24% profit.
    What was the total selling price?
    Q#4: The price of a laptop is RS.62, 000.The series discounts are
    15%, 18% & 5%. Find the net price.
    Q#5: After a mark -up of 30% on sales, a book sells for RS.200.
    • What is its cost price?
    What is the percentage mark-up on sales if the cost price of the book would have been RS.153?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Super Member
    earboth's Avatar
    Joined
    Jan 2006
    From
    Germany
    Posts
    5,829
    Thanks
    123
    Quote Originally Posted by nisoo-1 View Post
    Plase try it to solve on Excel sheet. thanks

    Q#1: A photo machine operator purchased 20 packets of papers. The market price of a packet is Rs.144. He gets a discount of 17.5% and an additional 5% for cash. How much did he pay for the whole quantity?
    Q#2: Three partners invested Rs.18000, Rest. 16500 and Rs.12500 respectively. When profit was distributed, the third one gets Re.4625. Find the total profit.
    Q#3: Airport Security Force purchased 10,000 pairs of socks for the staff members. The cost of manufacturer was Rs. 4 per pair of socks and he supplied the socks on 24% profit.
    What was the total selling price?
    Q#4: The price of a laptop is RS.62, 000.The series discounts are
    15%, 18% & 5%. Find the net price.
    Q#5: After a mark -up of 30% on sales, a book sells for RS.200.
    • What is its cost price?
    What is the percentage mark-up on sales if the cost price of the book would have been RS.153?
    Hello,

    1. I don't use Excel but with your problems you only need a simple calculator:

    to #1: ((20 \cdot 144) \cdot (1-0.175) ) \cdot (1-0.05)=2257.2

    to #2: I assume that the partners participate in the profit according to their investment.
    Total investment: 18000 + 16500+ 12500 = 47000
    Let p be the total profit then you know:

    \frac{12500}{47000} \cdot p = 4625 Solve for p. I've got 17390.

    to #3: (10000 \cdot 4) \cdot (1+0.24)=49600

    Unfortunately I can't help you with #4 and #5.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Super Member angel.white's Avatar
    Joined
    Oct 2007
    Posts
    723
    Awards
    1
    A photo machine operator purchased 20 packets of papers. The market price of a packet is Rs.144. He gets a discount of 17.5% and an additional 5% for cash. How much did he pay for the whole quantity?
    Quote Originally Posted by earboth View Post
    to #1: ((20 \cdot 144) \cdot (1-0.175) ) \cdot (1-0.05)=2257.2
    (1-0.175)(1-.05)=.78375

    I read the question as he gets 17.5% off, and 22.5% off if he pays cash. Meaning (1-.225) = .775

    It just seems odd to me to take the discount out of the already discounted price.

    The question is kind of ambiguous anyway, they say he has the option to get an additional 5% off for cash, but they never say that he pays cash, so it is questionable whether he even qualifies for the additional 5%
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 2
    Last Post: February 15th 2010, 03:09 PM
  2. Business Math
    Posted in the Business Math Forum
    Replies: 0
    Last Post: April 18th 2008, 05:07 PM
  3. Business Math
    Posted in the Business Math Forum
    Replies: 1
    Last Post: April 13th 2008, 04:10 PM
  4. business math
    Posted in the Business Math Forum
    Replies: 5
    Last Post: March 13th 2008, 07:39 PM
  5. Business math
    Posted in the Business Math Forum
    Replies: 4
    Last Post: August 12th 2007, 10:37 AM

Search Tags


/mathhelpforum @mathhelpforum