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$

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