Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are the Medical Director of Tinu-od General Hospital. At present, OPD consultants affiliated in your hospital are charging PhP 250.00 per OPD consultation. TRF

You are the Medical Director of Tinu-od General Hospital. At present, OPD consultants affiliated in your hospital are charging PhP 250.00 per OPD consultation. TRF Manufacturing Inc, a motor part production plant located in your province, has approached the hospital to be their retainer hospital. Your hospital will receive a monthly retainer fee of P 100,000. Based on their estimates, they project that the average number of monthly OPD consultations will increase 750 patients on the average. These additional OPD consultations are expected to be the plant's employees and their dependents. In line with this, they also propose that their employees and their dependents enjoy a 20% discount on the current OPD consultation fees of the hospital. Use the total cost computation from 2017 to 2018 (XLSX file is in the FILES section) to generate the forecasted monthly total cost based on the projected monthly OPD consultations.

Year Month Total Consultations Monthly Total Cost
2017 Jan 5,302 580,622
2017 Feb 3,904 454,876
2017 Mar 2,200 301,238
2017 Apr 4,909 545,310
2017 May 6,099 652,732
2017 Jun 3,044 376,815
2017 Jul 4,400 499,217
2017 Aug 6,500 688,655
2017 Sep 7,135 745,411
2017 Oct 4,090 471,243
2017 Nov 3,400 409,678
2017 Dec 4,800 535,555
2018 Jan 4,787 533,766
2018 Feb 2,939 368,248
2018 Mar 1,187 209,840
2018 Apr 2,726 348,175
2018 May 4,314 491,943
2018 Jun 2,295 309,914
2018 Jul 2,250 305,941
2018 Aug 4,465 505,506
2018 Sep 4,795 534,924
2018 Oct 3,277 398,315
2018 Nov 2,492 327,770
2018 Dec 4,494 507,617

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Management

Authors: Richard L Daft, Dorothy Marcic

6th Edition

9780324581782, 324581785, 978-0324568387

More Books

Students also viewed these General Management questions