Q.No.1: Prepare the
following bill and calculate the bill amount for the customers. Also create a
suitable chart.
Cust. No.
|
Name
|
Current Meter
Reading
|
Previous Meter
Reading
|
Consumed
Unit
|
Bill
Amount
|
A1001
|
RajKumar Sharma
|
1250
|
1130
|
||
A1002
|
Hari Shankar
|
1320
|
1305
|
||
A1003
|
Anita K.C.
|
768
|
599
|
||
A1003
|
Sarita Thapa
|
1380
|
1125
|
Condition: Minimum Charge upto 20 units is
Rs.80, the charge for 21 to 250 units is Rs.7.30 per unit and the charge for
more than 250 units is Rs.11.50 per unit.
Q.No. 2:
Calculate the wages for the following workers.
S.N.
|
Name
|
Working Days
|
Absent Days
|
Wages
|
1.
|
Sanjaya Neupane
|
20
|
10
|
|
2.
|
Sarita Ghimire
|
24
|
6
|
|
3.
|
Hari Sharma
|
28
|
2
|
|
4.
|
Raju Acharya
|
29
|
1
|
Conditions:
Rs. 450 is
given for working days and 4 days holiday is announced per month. 50% amount is
deducted for absent days except holidays and 50% extra wages is given for
working on holidays.
Q.No.3:
Prepare the following salary sheet and calculate the income tax, social tax and
net salary.
EmpCode
|
Name
|
Address
|
Monthly Salary
|
IncomeTax
|
SocialTax
|
Net Salary
|
A001
|
Hari Sharma
|
Banepa
|
22500
|
|||
A002
|
Ramita Gurung
|
Kathmandu
|
27000
|
|||
A003
|
Anjana Giri
|
Bhaktapur
|
30000
|
|||
A004
|
Sarita Ghimire
|
Sanga
|
20000
|
-Social Tax is 1%
of salary. Income tax is not charged upto annual income of Rs.250000, 15% tax
is charged for annual salary above 250000. 20% income tax is charged for annual
salary above 350000.
Q.No.4. Enter following data in Sheet 1 and perform as
asked. (10)
S.N.
|
Name
|
Quantity
(kg)
|
Rate
|
Amount
|
Discount
(10%)
|
Net
amount
|
1
|
Apple
|
20
|
150
|
|||
2
|
Lemon
|
30
|
120
|
|||
3
|
Grapes
|
50
|
230
|
Calculate Amount discount and net
amount with suitable formula.
Create a pie chart of Rate
Q.No. 5. Enter following data
in Sheet 1 and perform as asked. (10)
SN
|
Item Name
|
Item price
|
Quantity no.
|
Total
|
1
|
Tube light
|
10
|
100
|
|
2
|
Tourch Light
|
20
|
50
|
|
3
|
LCD Monitor
|
1400
|
100
|
|
4
|
CD
|
20
|
20000
|
Do following
calculation.
Total
=?, Insert "Depawali offer as 20% Discount" calculate value and
insert bar chart of total & item name.
No comments:
Post a Comment