Question

In: Accounting

The urgent care manager must resubmit her budget based on 2018 projected visits. The 2018 budget...

The urgent care manager must resubmit her budget based on 2018 projected visits. The 2018 budget should be based on actual expenses and visits incurred during the first seven months of 2017. Cost standards (2017) and budget standards (2018) must be prepared for all variable costs (indicated by a V behind the object code description). All fixed costs (F) should be projected using the incremental budgeting methodology. Projected visits is 2018 is 52,560. Salary and fringe benefit (object codes 4000-4199) increases for all personnel should be estimated at 4.0% except for health insurance (4120) which is expected to increase by 8%. Input price increases for supplies and other costs (4200-4960) should be increased by 3% except for medications, 5% increase and profession insurance, 10%. All increases are effective January 1, 2015. The budget report, BudgetCh06, Problem 6.1 tab, shows the urgent care centers expenses for 2016 and the actual and budgeted expenses for the first seven months of 2017. The CEO has requested all department heads submit their 2015 operating budget by Wednesday, March 21, 2014. The 2018 fiscal year begins January 1, 2018.

Total Visits

51,986

30,331

30,672

52,560

Obj.Code

Description

2016

Actual 2017

Budget 2017

Budget 2018

4010

Physician salaries – V

$960,000

$585,306

$576,800

________

4020

Nursing staff salaries – V

1,380,000

857,157

829,150

________

4030

Management & clerical salaries – F

780,000

466,971

468,650

________

4110

FICA – F

238,680

143,397

143,407

________

4120

Health Insurance – F

390,000

238,760

234,325

________

4130

Retirement – F

124,800

76,763

74,984

________

4140

Unemployment – F

31,200

18,323

18,746

________

4211

Medications – V

148,152

91,687

89,015

________

4212

Medical instruments - V

102,792

64,287

61,761

________

4214

Bandages, gauze… - V

57,468

34,140

34,529

________

4216

Latex gloves, gowns… - V

40,416

24,476

24,283

________

4216

Sterile wipes – V

26,820

15,780

16,114

________

4250

Office supplies – V

115,200

69,388

69,216

________

4280

Cleaning supplies – V

39,048

23,103

23,461

________

4310

Rent – F

144,000

89,251

86,520

________

4350

Maintenance – F

13,764

11,245

8,270

________

4410

Electricity – F

10,788

6,684

6,482

________

4420

Gas – F

18,504

11,215

11,118

________

4430

Water and Sewage – F

6,756

4,225

4,059

________

4440

Telephone – F

3,228

2,004

1,939

________

4930

Housekeeping – F

36,000

21,694

21,630

________

4940

Travel/professional meetings/meals – F

7,908

4,744

4,751

________

4945

Professional Insurance – F

22,380

15,669

13,447

________

4950

CME – F

29,856

17,994

17,938

________

4960

Other expenses - F

57,732

35,955

34,687

________

$4,785,492

$2,930,217

$2,875,283

________

B. Compare and contrast the incremental budget (prepared in homework 4) and the flexible budget.

C. Assume 2015 has been completed and actual output is 53,011, restate (or flex) the budget, what is the final budget the manager will be accountable to?

D. Assume 2015 has been completed and actual output is 51,543, restate the budget what is the final budget the manager will be accountable to?

Solutions

Expert Solution

Ans (b) = Budget 2018 - Budget 2017


Related Solutions

The nurse manager of an ambulatory care clinic has noted an increased number of visits by...
The nurse manager of an ambulatory care clinic has noted an increased number of visits by patients from different countries and cultures, including patients from Mexico and other Latin American countries. Concerned about meeting the needs of this culturally diverse population, the nurse manager convenes a staff meeting to discuss this change in patient demographics, and to query the staff about any learning needs they have related to the care of these patients. (Learning Objective 3) What strategy to avoid...
The nurse manager of an ambulatory care clinic has noted an increased number of visits by...
The nurse manager of an ambulatory care clinic has noted an increased number of visits by patients from different countries and cultures, including patients from Mexico and other Latin American countries. Concerned about meeting the needs of this culturally diverse population, the nurse manager convenes a staff meeting to discuss this change in patient demographics, and to query the staff about any learning needs they have related to the care of these patients. ( Learning objective 3). a. What strategy...
A mother has come to urgent care with her 8 year old daughter because of a...
A mother has come to urgent care with her 8 year old daughter because of a rash and swollen joints. When asked about past illness, the mother relates that the daughter recently had a cold sore throat but they went away. She never took her daughter to the doctor just kept her in bed a couple days with a fever and had her gargle with warm salt water. mom states to you, "all the kids are sharing and no need...
You have been the practice manager of Rockford Urgent Care for five years. The practice is...
You have been the practice manager of Rockford Urgent Care for five years. The practice is profitable, but the current physician owner is ready to retire, and sell the practice. He has hired a company to broker the sale. Respond to the following points: What information should you begin preparing to aid in a smooth valuation process? Explain the relationship of a practice's income to valuation. Explain how your ability to collect from patients will impact a favorable valuation.
Jane is a 3-year old female brought into the urgent care clinic by her mother. Child...
Jane is a 3-year old female brought into the urgent care clinic by her mother. Child has been complaining of left ear pain for the past 2 days. She has had fevers with the last at 101 F; mother treated fever with ibuprofen. No cough, vomiting or diarrhea. You are working with a family practice Nurse Practitioner who diagnoses the child with left otitis media (ear infection). The NP selects amoxicillin suspension for treatment. The NP asks that you double...
Case: Ms. D, a mother approaching her 35th week of pregnancy reports to an urgent care...
Case: Ms. D, a mother approaching her 35th week of pregnancy reports to an urgent care facility with her husband. She complains of diffuse abdominal pain, weakness, and dizziness that started approximately 3 days earlier. Her blood pressure is 145/95 mm Hg. The laboratory technician does a quick urinalysis and detects 1 + protein in the patient's urine. A blood sample is drawn, the physician calls the woman 's obstetrician, and the woman and her husband are sent to the...
You recently started working as a nurse manager at a larger local urgent care facility. Because...
You recently started working as a nurse manager at a larger local urgent care facility. Because the center is so new (and a bit fancier than most) many patients come here expecting a bit of a wait before they can be seen. Out of curiosity, on a particularly busy day you write down how many minutes a random sample of patients has to wait before being seen by one of the medical staff. Using a significance level of 20%, test...
Complete a cash budget for The Stars basketball team based on the following information.  Projected...
Complete a cash budget for The Stars basketball team based on the following information.  Projected Total Revenues: Q1=$800, Q2=$900, Q3=$950, Q4=$1000, 1 st quarter next yr. = $1000  Accounts Receivable (beginning) are equal to $450  50% of Revenues are cash sales  The rest of the revenues (50%) are collected in the following quarter  Beginning accounts payable are equal to $250  Purchases from vendors each quarter are 50% of next quarter sales  Payments to...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April 1,100 units May 1,250 units June 1,300 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.15 per unit and component B cost is $.85 per unit. 7. Calculate the Direct Material budgeted cost for May 2018 8. Calculate the Direct Material budgeted cost for the quarter April - June...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units...
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced: April    1,000 units May     1,200 units June     1,250 units Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit. Each unit requires the following labor: 2 hours in the processing department 1 hour in the assembly department Processing department labor rate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT