### Crable and Tesch Revenue Budget#### For the Year Ended December 31, 2016**Table 1: Revenue Budget**- **Columns:** - Item - Professional Hours - Billing Rate - Total Revenues- **Rows:** - Partners - Associates - Staff - TotalThis table is formatted to calculate total revenues based on the professional hours and billing rates of partners, associates, and staff. Each category has designated input cells for quantifying the professional hours worked and the corresponding billing rate. The Total Revenues column is intended to be calculated based on these inputs.**Table 2: Professional Labor Budget**#### For the Year Ended December 31, 2016- **Columns:** - Item - Professional Hours - Wage Rate - Total Labor- **Rows:** - Partners - Associates - Staff - TotalThis table focuses on budgeting for labor costs. It includes columns for recording professional hours and the wage rate for each category of employees, namely partners, associates, and staff. The Total Labor column is intended to display the calculated labor costs for each category.Both tables are structured to provide a detailed view of financial planning for the firm, helping in assessing revenue and labor cost projections. **Crable and Tesch**, partners in a systems consulting firm, budgeted the following professional labor hours for the year ended December 31, 2016:- **Partners**: 4,000 hours- **Associates**: 14,000 hours- **Staff**: 22,000 hoursPartners have a billing rate of $225 per hour and actually earn $110 per hour. Associates bill out at $140 per hour and earn $85 per hour. Staff bill out at a rate of $75 per hour and earn $35 per hour.**REQUIRED:**1. Prepare a revenue budget.2. Prepare a professional labor budget.

Crable and Tesch, partners in a systems consulting firm, budgeted the following professional labor hours for the year ended December 31, 2016: Partners 4,000 Associates 14,000 Staff....... 22,000 Partners have a billing rate of $225 per hour and actually earn $110 per hour. Associates bill out at $140 per hour and earn $85 per hour. Staff bill out at a rate of $75 per hour and earn $35 per hour. REQUIRED: 1. Prepare a revenue budget. 2. Prepare a professional labor budget.

Crable and Tesch, partners in a systems consulting firm, budgeted the following professional labor hours for the year ended December 31, 2016: Partners 4,000 Associates 14,000 Staff....... 22,000 Partners have a billing rate of $225 per hour and actually earn $110 per hour. Associates bill out at $140 per hour and earn $85 per hour. Staff bill out at a rate of $75 per hour and earn $35 per hour. REQUIRED: 1. Prepare a revenue budget. 2. Prepare a professional labor budget.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Pooler Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.74 direct labor-hours. The direct labor rate is $11.70 per direct labor-hour. The production budget calls for producing 6,600 units in April and 6,400 units in May. The company guarantees its direct labor workers a 40-hour paid work week. With the number of workers currently employed, that means that the company is committed to paying its direct labor work force for at least 5,480 hours in total each month even if there is not enough work to keep them busy. What would be the total combined direct labor cost for the two months? Multiple Choice $119,52720 $112.554.00 $130.291.201 $128.232.00
Metropolitan Dental Associates is a large dental practice in Chicago. The firm's controller is preparing the budget for the next year. The controller projects a total of 48,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be half-hour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $60 for half-hour appointments and $115 for one-hour office visits. Ninety percent of each month's professional service revenue is collected during the month when services are rendered, and the remainder is collected the month following service. Uncollectible billings are negligible. Metropolitan's dental associates earn $95 per hour. Metropolitan uses activity-based budgeting to budget office overhead and administrative expenses. Two cost drivers are used: office visits and direct professional labor. The cost-driver rates are as follows: Patient registration and records All other overhead and…
Professional Labor Cost Budget Day & Spieth, CPAs, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending March 31, 20Y6: Billable Hours Audit Department: Staff 50,000 Partners 10,000 Tax Department: Staff 75,000 Partners 16,000 Small Business Accounting Department: Staff 20,000 Partners 4,000 Assume that the average compensation per hour for staff is $36 and for partners is $300. Prepare a professional labor cost budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. Enter all amounts as positive numbers. DAY & SPIETH, CPAs Professional Labor Cost Budget For the Year Ending March 31, 20Y6 Staff Partners Audit Department hours fill in the blank 1 fill in the blank 2 Tax Department hours fill in the blank 3 fill in the blank 4 Small Business…
Wetherbee Tech Services (WTS) is a chain of computer maintenance technicians for households and small businesses. The following data are available for last year's services: • WTS recorded 120,300 tech calls last year. It had budgeted 125,600 calls, averaging 90 minutes each. • Standard variable labor and support costs per tech call were as follows: Direct IT specialist services: 90 minutes at $54 per hour Variable support staff, supplies, and overhead: 30 minutes at $24 per hour . Fixed overhead costs: Annual budget $4,140,600 Fixed overhead is applied at the rate of $36.00 per call. • Actual tech service call costs: Direct IT specialist services: 120,300 calls averaging 84 minutes at $56.00 per hour Variable support staff, supplies, and overhead: averaging 48 minutes per call at $22.50 per hour x 120, 300 calls Fixed overhead Required: a. Prepare a cost variance analysis for each variable cost for last year. b. Prepare a fixed overhead cost variance analysis. Complete this question by…
Victor Inc. has just received its sales and expense report for December, which follows. Item Amount Sales commissions $250,000 Sales staff salaries 100,000 Telephone and mailing 30,000 Building lease payment 60,000 Heat, light, and water 15,000 Packaging and delivery 30,000 Depreciation 25,000 Marketing consultants 10,000 Sales 600,000 You have been asked to develop budgeted costs for the coming year. Since this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: • Sales volume is expected to increase by 20 percent. • Sales prices are expected to decrease by 10 percent. • Commissions are based on a percentage of selling price. • Sales staff salaries will increase 8 percent next year regardless of sales volume. • Building rent is based on a five-year lease that expires in three years. • Telephone and mailing costs are scheduled to decrease by 5 percent even with no change in sales volume.…
I could use some help on this app me problem
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes. Factory administration The Production Department planned to work 4,200 labor-hours in March; however, it actually worked 4,000 labor-hours during the month. Its actual costs incurred in March are listed below: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.20g $4,200+ $1.50g $5,700+ $0.60g $1,500+ $0.10g $18,300+ $2.60g $8,600 $2,500 $13,300+ $0.90g Actual Cost Incurred in March $ 66,360 $ 9,680 $ 8,610 $ 2,130 $ 28,700 $ 9,000 $ 2,500 $ 16,310 Required: 1. Prepare the Production…
oriole company provides financial consulting and has collected the following data for the nexts years budgeted activity for a lead consultant, the company employs time and materials pricing. consultants wages $95000 fringe benefits $12500 related overhead $17500 materials clerk wages$17000 fringe benefits $4500 related overhead $20000 profit margin per hour $20 profit margin on materials 33% total estimated consulting hours 5000 total estimated material costs $166000.... the material loading charge is?a)33% b)58% c)25% d)91%
Wetherbee Tech Services (WTS) is a chain of computer maintenance technicians for households and small businesses. The following data are available for last year's services: • WTS recorded 120,600 tech calls last year. It had budgeted 126,200 calls, averaging 90 minutes each. • Standard variable labor and support costs per tech call were as follows: . Direct IT specialist services: 90 minutes at $54 per hour Variable support staff, supplies, and overhead: 30 minutes at $24 per hour Fixed overhead costs: Annual budget $4,141,200 Fixed overhead is applied at the rate of $36.00 per call. Actual tech service call costs: Direct IT specialist services: 120,600 calls averaging 84 minutes at $56.00 per hour Variable support staff, supplies, and overhead: averaging 40 minutes per call at $22.50 per hour x 120,600 calls Fixed overhead Required: a. Prepare a cost variance analysis for each variable cost for last year. b. Prepare a fixed overhead cost variance analysis. Complete this question by…
Wetherbee Tech Services (WTS) is a chain of computer maintenance technicians for households and small businesses. The following data are available for last year's services: • WTS recorded 121,100 tech calls last year. It had budgeted 127,200 calls, averaging 90 minutes each. • Standard variable labor and support costs per tech call were as follows: Direct IT specialist services: 90 minutes at $54 per hour Variable support staff, supplies, and overhead: 30 minutes at $24 per hour • Fixed overhead costs: Annual budget $4,142,200 Fixed overhead is applied at the rate of $36.00 per call. • Actual tech service call costs: Direct IT specialist services: 121,100 calls averaging 84 minutes at $56.00 per hour Variable support staff, supplies, and overhead: averaging 40 minutes per call at $22.50 per hour x 121,100 calls Fixed overhead Required: a. Prepare a cost variance analysis for each variable cost for last year. b. Prepare a fixed overhead cost variance analysis. Complete this question by…
HSS Company provides security services to senior executives of prominent corporations when they travel outside the United States. HSS applies both fixed and variable overhead using direct labor hours. The annual budget for one if its customers is as follows: Budgeted hours Direct labor Variable overhead Fixed overhead 800 hours $50.00 per hr. $30.00per hr. $15.00 per hr. During the year, HSS had the following activity related to this customer: Actual hours were 850 at a total cost of $44,200. Actual fixed overhead was $12,750. Actual variable overhead was $22,950. What is the Variable Overhead Flexible Budget Variance? Select one: O a. $1,050 favorable O O O b. $1,050 unfavorable c. $2,550 favorable d. $2,550 unfavorable
Dee and Co. is a small manufacturing business which has prepared the following monthly budgeted figures for an average month: Production Volume 15,000 units Selling Price per Unit GH¢5.50 Sales GH¢82,500 Variable Costs GH¢37,500 Fixed Costs GH¢20,000 Profit GH¢25,000 Required: a) What is the contribution per unit? b) Determine the contribution to sales ratio. c) What is the number of units Dee and Co. needs to produce and sell each month in order to break even? d) Find the sales revenue in value required to make a target profit of GH¢50,000.