The problem is based on a spreadsheet representing channeling charges of Suwa Medura Medical Center. We need to: (i) (a) Write the formula to find the income received by Dr. Prasanna Jayakody from channel service, which is in cell G4. (i) (b) Write the formula as it appears in cell E8. (ii) Write the formula to find the center charges in cell F4, given that 20% is charged as center charges out of the total charges. (iii) State the formula used to find the doctor's fees (charges of Dr. Prasanna) in cell G4. (iv) Write the formula to find the total center charges in F11 using a function with a cell range. (v) Suggest a suitable chart type to show the income received from each doctor.

1. Problem Description

The problem is based on a spreadsheet representing channeling charges of Suwa Medura Medical Center. We need to:

(i) (a) Write the formula to find the income received by Dr. Prasanna Jayakody from channel service, which is in cell G

4. (i) (b) Write the formula as it appears in cell E

8. (ii) Write the formula to find the center charges in cell F4, given that 20% is charged as center charges out of the total charges.

(iii) State the formula used to find the doctor's fees (charges of Dr. Prasanna) in cell G

4. (iv) Write the formula to find the total center charges in F11 using a function with a cell range.

(v) Suggest a suitable chart type to show the income received from each doctor.

2. Solution Steps

(i) (a) The income received by Dr. Prasanna Jayakody is in cell G

4. From the spreadsheet, we can see that doctor's fees = Total Charges - Centre Charges. Therefore the formula in cell G4 is Total Charges in E4 - Centre Charges in F

4. Formula in G4:

$=E4-F4$

(i) (b) The formula as it appears in cell E8 represents the total charges for Dr. Satharasinghe. From the given data, total charges = number of patients * charges per patient. E8 refers to the total charges for Dr. Satharasinghe which is equal to the Number of Patients in C8 multiplied by the Charges in D

8. Formula in E8:

$=C8*D8$

(ii) 20% is charged as center charges out of the total charges. The total charges for Dr. Prasanna Jayakody is in cell E

4. Therefore, the formula to find the center charges in cell F4 is 20% of E

4. Formula in F4:

$=E4*20/100$ or $=E4*0.2$

(iii) The formula used to find the charges of Dr. Prasanna in cell G4 is the total charges (E4) minus the center charges (F4). As shown in (i) (a).

Formula in G4:

$=E4-F4$

(iv) To find the total center charges in F11, we need to sum the center charges from F4 to F

1

0. Formula in F11:

$=SUM(F4:F10)$

(v) A suitable chart type to show the income received from each doctor would be a bar chart or a column chart. This type of chart effectively compares values across different categories (in this case, doctors).

3. Final Answer

(i) (a) $=E4-F4$

(i) (b) $=C8*D8$

(ii) $=E4*0.2$

(iii) $=E4-F4$

(iv) $=SUM(F4:F10)$

(v) Bar chart or Column chart