Question

In: Accounting

Review the information presented below in the Sample Operating Budget and adjust this budget according to...

Review the information presented below in the Sample Operating Budget and adjust this budget according to the following:

You have just learned that inpatient charges will probably be 3% higher than projected and that outpatient charges are expected to increase by 8%, and that your research grant support will be reduced by half.

The continuing education conference projected to net $3,200 has been canceled.

Salary expenses will likely be 2% higher than originally anticipated.

You are required to show a projected net profit of at least 50% of total revenue. If your revised budget generates less than this level of net profit or surplus, indicate where you can probably cut expenses to meet the target and explain why the expenses you have chosen to cut are your best choices.

Sample Operating Budget—Department of Physical Therapy

(July 1, 20n1, through June 30, 20n2)

I. Revenue and Income

A. Inpatient Charges           $550,000

B. Outpatient Charges                             310,000

C. Research Grant Support                      29,000

D. Continuing Education Conference         3,200

E. Supplies and Equipment Sales          11,500

       Total Revenue                                     $903,700

II. Expenses

     Direct Expenses

A. Salaries                                      $260,000

B. Consultant                                  2,500

C. Honorarium                                1,500

D. Minor Equipment                       6,000

E. Equipment Rental                       2,000

F. Travel                                           2,500

G. Telephone                                   5,000

H. Supplies                                      6,000

I. Postage                                        350

J. Copy Machine Rental                 11,000

K. Advertisement                             1,500

L. Dues                                               800

M. Books                                            350

N. Equipment Maintenance and Service Contracts       2,000

       Total Direct Expenses                                            $301,500

III. Indirect Expenses

A. Employee Benefits (23%)                                        $59,800

B. Administration                                                          23,000

C. Equipment Depreciation                                          7,200

D. Physical Plant Operation                                          39,000

E. Maintenance and Repairs                                          2,000

F. Building Depreciation                                                6,000

G. Laundry/Linen                                                        2,500

H. Housekeeping                                                           4,900

        Total Indirect Expenses                 $144,400

       Total Expenses                               $445,900

       Net Profit or Loss                          $457,800

Solutions

Expert Solution

I. Revenue and Income

A. Inpatient Charges           $5,66,500

B. Outpatient Charges                             3,34,800

C. Research Grant Support 14,500

D. Continuing Education Conference Nil

E. Supplies and Equipment Sales          11,500

       Total Revenue                                     $9,27,300

II. Expenses

     Direct Expenses

A. Salaries                                      $265,200

B. Consultant                                  2,500

C. Honorarium                                1,500

D. Minor Equipment                       6,000

E. Equipment Rental                       2,000

F. Travel                                           2,500

G. Telephone                                   5,000

H. Supplies                                      6,000

I. Postage                                        350

J. Copy Machine Rental                 11,000

K. Advertisement                             1,500

L. Dues                                               800

M. Books                                            350

N. Equipment Maintenance and Service Contracts       2,000

       Total Direct Expenses                                            $306,700

III. Indirect Expenses

A. Employee Benefits (23%)                                        $59,800

B. Administration                                                          23,000

C. Equipment Depreciation                                          7,200

D. Physical Plant Operation                                          39,000

E. Maintenance and Repairs                                          2,000

F. Building Depreciation                                                6,000

G. Laundry/Linen                                                        2,500

H. Housekeeping                                                           4,900

        Total Indirect Expenses                 $144,400

       Total Expenses                               $451,100

       Net Profit or Loss                          $476,200

Net pofit is 51.35% of total revenue. hence, no expenses has to be cut.


Related Solutions

Operating data for Navarro Corporation are presented below.
Operating data for Navarro Corporation are presented below.   Instructions Prepare a schedule showing a vertical analysis for 2017 and 2016.
Operating Budget • Review 1: Purchase Budget and Cash Collections • Capes Corporation is a wholesaler...
Operating Budget • Review 1: Purchase Budget and Cash Collections • Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations • follow: • · Sales are budgeted at $390,000 for November, $360,000 for December, and $340,000 for January. • · Collections are expected to be 85% in the month of sale, 10% in the month following the sale, and 5% uncollectible. • · The cost of goods sold is 80% of sales. • · The company...
Do It! Review 1-05 a-c Presented below is selected information related to Cullumber Company at December...
Do It! Review 1-05 a-c Presented below is selected information related to Cullumber Company at December 31, 2020. Cullumber reports financial information monthly. Accounts Payable $ 4,054 Salaries and Wages Expense $22,298 Cash 8,784 Notes Payable 33,785 Advertising Expense 8,108 Rent Expense 14,190 Service Revenue 72,300 Accounts Receivable 18,244 Equipment 39,191 Owner’s Drawings 10,135 Determine the total assets of Cullumber Company at December 31, 2020. Total assets $ SHOW SOLUTION Determine the net income that Cullumber Company reported for December...
Selected information about American Industries is presented below. American has three operating divisions and requires a...
Selected information about American Industries is presented below. American has three operating divisions and requires a 12% return on all investments: Eastern Division Central Division Western Division Revenues $ 1,000,000 ? ? Operating income $ 120,000 ? $ 100,000 Operating assets $ 500,000 $ 300,000 ? Margin ? 12 % ? Turnover ? 1 turn 2 turns ROI ? ? ? Residual income ? ? $ 25,000 Calculate the missing amounts for each division.
Financial information is presented below: Operating expenses $ 47000 Sales returns and allowances 6000 Sales discounts...
Financial information is presented below: Operating expenses $ 47000 Sales returns and allowances 6000 Sales discounts 9000 Sales revenue 190000 Cost of goods sold 99000 The profit margin would be 0.43. 0.17. 0.34. 0.16.
1. Financial information is presented below: Operating expenses $ 40000 Sales returns and allowances 2000 Sales...
1. Financial information is presented below: Operating expenses $ 40000 Sales returns and allowances 2000 Sales discounts 6000 Sales revenue 166000 Cost of goods sold 86000 The amount of net sales on the income statement would be $160000. $166000. $158000. $164000. 2. Financial information is presented below: Operating expenses $ 60000 Sales returns and allowances 2000 Sales discounts 6000 Sales revenue 140000 Cost of goods sold 106000 Gross Profit would be $36000. $32000. $34000. $26000. 3. Novak has the following...
Presented below is selected information for Brimmer Company: Changes in Various Ratios Presented below is selected...
Presented below is selected information for Brimmer Company: Changes in Various Ratios Presented below is selected information for Brimmer Company: 2013 2012 Sales revenue $912,000 $840,000 Cost of goods sold 577,000 542,000 Interest expense 22,000 20,000 Income tax expense 29,000 24,000 Net income 63,000 52,000 Cash flow from operating activities 67,000 55,000 Capital expenditures 44,000 45,000 Accounts receivable (net), December 31 128,000 120,000 Inventory, December 31 198,000 160,000 Stockholders' equity, December 31 452,000 400,000 Total assets, December 31 732,000 660,000...
Information related to Harwick Co. is presented below.
Information related to Harwick Co. is presented below. 1. On April 5, purchased merchandise from Botham Company for $23,000, terms 2/10, net/30, FOB shipping point. 2. On April 6, paid freight costs of $900 on merchandise purchased from Botham.  3. On April 7, purchased equipment on account for $26,000. 4. On April 8, returned damaged merchandise to Botham Company and was granted a $3,000 credit for returned merchandise. 5. On April 15, paid the amount due to Botham Company in full. Instructions (a) Prepare the journal entries...
Financial information for Kurzen Inc. is presented below.
Question Description   Financial information for Kurzen Inc. is presented below.   Instructions Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year.
Please review the following below and provide , one-page reaction to this budget proposal. 1. Budget...
Please review the following below and provide , one-page reaction to this budget proposal. 1. Budget The President’s Budget and Health Care While the president’s budget is not likely to be acted upon by Congress, it does signal what the administration’s priorities are—as well as what policy initiatives they might push. Repeal the Affordable Care Act: The administration’s budget includes a plan that is based upon the plan put forward by Sens. Lindsey Graham (R-SC) and Bill Cassidy (R-LA) last...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT