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)
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...
Related questions
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)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff7c48744-47f3-4a90-a935-207c6a088f97%2F7d069f7b-bccb-4998-a480-eade18529558%2Fnfmout_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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)](https://www.bartleby.com/isbn_cover_images/9780133923605/9780133923605_smallCoverImage.gif)
Introductory Circuit Analysis (13th Edition)
Electrical Engineering
ISBN:
9780133923605
Author:
Robert L. Boylestad
Publisher:
PEARSON
![Delmar's Standard Textbook Of Electricity](https://www.bartleby.com/isbn_cover_images/9781337900348/9781337900348_smallCoverImage.jpg)
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:
9781337900348
Author:
Stephen L. Herman
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Electrical Engineering
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
![Introductory Circuit Analysis (13th Edition)](https://www.bartleby.com/isbn_cover_images/9780133923605/9780133923605_smallCoverImage.gif)
Introductory Circuit Analysis (13th Edition)
Electrical Engineering
ISBN:
9780133923605
Author:
Robert L. Boylestad
Publisher:
PEARSON
![Delmar's Standard Textbook Of Electricity](https://www.bartleby.com/isbn_cover_images/9781337900348/9781337900348_smallCoverImage.jpg)
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:
9781337900348
Author:
Stephen L. Herman
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Electrical Engineering
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
![Fundamentals of Electric Circuits](https://www.bartleby.com/isbn_cover_images/9780078028229/9780078028229_smallCoverImage.gif)
Fundamentals of Electric Circuits
Electrical Engineering
ISBN:
9780078028229
Author:
Charles K Alexander, Matthew Sadiku
Publisher:
McGraw-Hill Education
![Electric Circuits. (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780134746968/9780134746968_smallCoverImage.gif)
Electric Circuits. (11th Edition)
Electrical Engineering
ISBN:
9780134746968
Author:
James W. Nilsson, Susan Riedel
Publisher:
PEARSON
![Engineering Electromagnetics](https://www.bartleby.com/isbn_cover_images/9780078028151/9780078028151_smallCoverImage.gif)
Engineering Electromagnetics
Electrical Engineering
ISBN:
9780078028151
Author:
Hayt, William H. (william Hart), Jr, BUCK, John A.
Publisher:
Mcgraw-hill Education,