Unit RM First Unit Slab Next Unit 200 0.218 Fixed Charge 200 RM 100 Surcharge Slab Next Unit Slab 0.334 0.00 RM/Unit 300 0.516 Тах.Charge 6 Next Unit Slab 300 0.546 Meter Charge 200 RM Last Unit Slab 100 0.571 NUMBER no. hours/day unit consumed in kwh ITEM RATINGS LED 8W 8 16 CFL 20W 16 REF 200W 1 24 FAN 80W 24 total meter reading for a month 190 Monthly Bill 540 final bill 1 Calculate the electricity bill as per the table given 2 nested if formula has to be used to apply various conditions for all tariff blocks 3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block IF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)

Introductory Circuit Analysis (13th Edition)
13th Edition
ISBN:9780133923605
Author:Robert L. Boylestad
Publisher:Robert L. Boylestad
Chapter1: Introduction
Section: Chapter Questions
Problem 1P: Visit your local library (at school or home) and describe the extent to which it provides literature...
icon
Concept explainers
Question
Answer good ok and explain
Electrical Unit Tariff blocks.
Unit
RM
First Unit Slab
Next Unit
200
0.218
Fixed Charge
200
RM
Slab
Next Unit
Slab
100
0.334
Surcharge
0.00
RM/Unit
300
Tax.Charge
0.516
6
Next Unit
Slab
300
0.546
Meter Charge
200
RM
Last Unit Slab
100
0.571
ITEM
RATINGS
NUMBER
no. hours/day
unit consumed in kwh
LED
8W
8
16
CFL
20w
16
REF
200W
24
FAN
80W
6.
24
total meter reading for a month
190
Monthly Bill
540
final bill
1 Calculate the electricity bill as per the table given
2 nested if formula has to be used to apply various conditions for all tariff blocks
3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block
IF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)
Transcribed Image Text:Electrical Unit Tariff blocks. Unit RM First Unit Slab Next Unit 200 0.218 Fixed Charge 200 RM Slab Next Unit Slab 100 0.334 Surcharge 0.00 RM/Unit 300 Tax.Charge 0.516 6 Next Unit Slab 300 0.546 Meter Charge 200 RM Last Unit Slab 100 0.571 ITEM RATINGS NUMBER no. hours/day unit consumed in kwh LED 8W 8 16 CFL 20w 16 REF 200W 24 FAN 80W 6. 24 total meter reading for a month 190 Monthly Bill 540 final bill 1 Calculate the electricity bill as per the table given 2 nested if formula has to be used to apply various conditions for all tariff blocks 3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block IF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Types of Distribution in Power System
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, electrical-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Introductory Circuit Analysis (13th Edition)
Introductory Circuit Analysis (13th Edition)
Electrical Engineering
ISBN:
9780133923605
Author:
Robert L. Boylestad
Publisher:
PEARSON
Delmar's Standard Textbook Of Electricity
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:
9781337900348
Author:
Stephen L. Herman
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Electrical Engineering
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
Fundamentals of Electric Circuits
Fundamentals of Electric Circuits
Electrical Engineering
ISBN:
9780078028229
Author:
Charles K Alexander, Matthew Sadiku
Publisher:
McGraw-Hill Education
Electric Circuits. (11th Edition)
Electric Circuits. (11th Edition)
Electrical Engineering
ISBN:
9780134746968
Author:
James W. Nilsson, Susan Riedel
Publisher:
PEARSON
Engineering Electromagnetics
Engineering Electromagnetics
Electrical Engineering
ISBN:
9780078028151
Author:
Hayt, William H. (william Hart), Jr, BUCK, John A.
Publisher:
Mcgraw-hill Education,