ACCT 222 Problems Excel Template 9, Fall 2014

Name: Section: When totals are correct the cell will change to green. Exercise 9-3 Lyons & Rappaport, CPAs Revenue Budget For the Year Ending December 31, 2013 Classification Partners Managers Staff Total Professional Hours Billing Rate Total Revenues Name: Section: When totals are correct the cell will change to green. Exercise 9-4 Fiorella and Sanchez, Physicians Budgeted Income Statement For the Month Ending September 30, 2013 Patient revenue Operating costs: Physicians' salaries Nursing wages Fringe benefits Lease expense Secretarial support Depreciation - equipment Utilities Operating income Name: Section: When double ruled amounts are correct the cell will change to green. Problem 9-2 1. Cost Performance Report Budget Variance Partners' salary and overhead Associates' salary and overhead Travel Telephone/fax/copying Total 2. Bid price Budgeted costs Budgeted profit Bid price Actual costs Actual profit Actual Result Name: Section: When double ruled amounts are correct the cell will change to green. Problem 9-3 1. Hornick and Sena Revenue Budget For the Year Ended December 31, 2013 Item Partners Associates Staff Total 2. Hornick and Sena Professional Labor Budget For the Year Ended December 31, 2013 Item Partners Associates Staff Total Professional Hours Billing Rate Total Revenues Professional Hours Wage Rate Total Labor Name: Section: When totals are correct the cell will change to green. Problem 9-4 1. Hornick and Sena Overhead Budget For the Year Ended December 31, 2013 Secretarial support Fringe benefits Utilities Depreciation - building Telephone/fax Photocopying Depreciation - equipment Total 2. Hornick and Sena Other Direct Expenses Budget For the Year Ended December 31, 2013 Travel Meals Total Name: Section: When subtotal and final amount are correct the cell will change to green. Problem 9-5 Hornick and Sena Budgeted Income Statement For the Year Ended December 31, 2013 Revenues Operating costs: Professional labor Overhead support Other expenses Operating income Name: Section: When totals are correct the cell will change to green. Problem 9-8 1. Job Cost Sheet Professional labor cost: Ford hrs. x $ Mickey's hrs. x $ Professional support: Ford hrs. x $ Mickey's hrs. x $ Total 2. Job Cost Sheet Partner labor cost: Ford hrs. x $ Mickey's hrs. x $ Associate labor cost: Ford hrs. x $ Mickey's hrs. x $ Design support: Ford hrs. x $ Mickey's hrs. x $ Staff support: Ford hrs. x $ Mickey's hrs. x $ Total Ford Products Mickey's Markets Ford Products Mickey's Markets