1. ## 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?

2. Originally Posted by nisoo-1
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$

3. 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?
Originally Posted by earboth
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%