Waterway and Crede, CPAS, are preparing their service revenue (sales) budget for the coming year (2022). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below. Department Quarter 1 Auditing Tax Consulting 3,040 3,840 1,920 Quarter 2 2,000 2,720 1,920 Quarter 3 2,560 2,560 1,920 Quarter 4 3,120 3,200 1,920 Average hourly billing rates are auditing $70, tax $80, and consulting $100. Prepare the service revenue (sales) budget for 2022 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.

Waterway and Crede, CPAS, are preparing their service revenue (sales) budget for the coming year (2022). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below. Department Quarter 1 Auditing Tax Consulting 3,040 3,840 1,920 Quarter 2 2,000 2,720 1,920 Quarter 3 2,560 2,560 1,920 Quarter 4 3,120 3,200 1,920 Average hourly billing rates are auditing $70, tax $80, and consulting $100. Prepare the service revenue (sales) budget for 2022 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 6E: Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement...

See similar textbooks

Similar questions

Roman Inc. has the following totals from its operating budgets: Prepare a budgeted income statement for the year ended December 31, 2016, assuming that income from operations is taxed at a rate of 30%.
Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2020). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided below. Department Quarter 1 Quarter 2 Quarter 3 Quarter 4 Auditing 2,330 1,870 2,120 2,730 Tax 3,150 2,660 2,330 2,790 Consulting 1,830 1,830 1,830 1,830 Average hourly billing rates are auditing $81, tax $91, and consulting $104. Prepare the service revenue (sales) budget for 2020 by listing the departments and showing for each quarter and the year in total, billable hours, billable rate, and total revenue. THOME AND CREDE, CPAsService Revenue Budgetchoose the accounting period For the Year Ending December 31, 2020December 31, 2020For the Quarter Ending December 31, 2020 Quarter 1 Quarter 2 Dept. Billable Hours…
Service Thome and Crede, CPAs, are preparing their service revenue (sales) budget for the coming year (2022). The practice is divided into three departments: auditing, tax, and consulting. Billable hours for each department, by quarter, are provided here. DepartmentQuarter 1Quarter 2Quarter 3Quarter 4 Auditing2,3001,6002,0002,400 Tax3,0002,2002,0002,500 Consulting1,5001,5001,5001,500 Average hourly billing rates are auditing $80, tax $90, and consulting $110.InstructionsPrepare the service revenue (sales) budget for 2022 by listing the departments and showing billable hours, billable rate, and total revenue for each quarter and the year in total. Prepare quarterly production budgets.
Tyler Sheen is the owner of Stopby Inn. He provided the selected opening balances as at June 1, 2020 and the budgeted information for June and July 2020. Selected Opening Balances as of June 1, 2020 Cash $108,700 Accounts Receivable 45,000 Inventory 235,000 Long-term Assets 648,000 Accounts Payable 48,400 Shareholder's Equity 928,000 Budgeted Amounts For the month of June: Total Revenue $349,000 Total General and Administration Costs 185,000 Total Capital Expenditures 193,000 For the month of July: Total Revenue 359,200 Total General and Administration Costs 203,000 Total Capital Expenditures 222,000 Do not enter dollar signs or commas in the input boxes. Round your answer to the nearest dollar The company’s monthly depreciation represents 20% of general and administration costs. 70% percent of the general and administration costs (excluding depreciation) are paid in the month in which they are incurred, and the rest is recorded in accounts payable to be paid in the next month. Of the…
You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending March 31, 2021. (i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales on Account Purchases November $151,100 $480,000 $390,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $505,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $518,000 (ii) An analysis of the records shows that accounts receivable are settled according to the following credit pattern, in accordance with the credit terms 2/30, n90: 45% in the month of sale 30%…
You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending March 31, 2021. (i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales on Account Purchases November $151,100 $480,000 $390,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $505,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $518,000 (ii) An analysis of the records shows that accounts receivable are settled according to the following credit pattern, in accordance with the credit terms 2/30, n90: 45% in the month of sale 30%…
Bravo Company is a bookstore that prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the first quarter: As of December 31, 2023 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash 44,000 Accounts Receivable 184,000 Inventory 60,000 Building & Equipment 404,000 Accumulated Depreciation 144,000 Accounts Payable 93,000 Capital shares 200,000 Retained Earnings 255,000 Totals $ 692,000 $ 692,000 Actual sales for December and budgeted…
On January 1,2022, the Vaughn Company budget committee has reached agreement on the following data for the 6 months ending June 30,2022. Sales units: First quarter 7,200: second quarter 8,640: third quarter 10,080.Ending raw materials inventory: 40% of the next quarter's production requirements.Ending finished goods inventory: 25% of the next quarter's expected sales units.Third-quarter production: 10,430 units. The ending raw materials and finished goods inventories at December 31,2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Total Required DIrect Labor HoursTotal Pounds Needed for productionDirect Material PurchasesCost Per PoundDirect Labor Cost Per HourTotal Cost of Direct Material PurchasesDirect Materials Per unitUnits to be…
Springfield Corporation operates on a calendar-year basis. It begins the annualbudgeting process in late August, when the president establishes targets for total salesdollars and net operating income before taxes for the next year.The sales target is given to the Marketing Department, where the marketing managerformulates a sales budget by product line in both units and dollars. From this budget,sales quotas by product line in units and dollars are established for each of thecorporation’s sales districts. The marketing manager also estimates the cost of themarketing activities required to support the target sales volume and prepares a tentativemarketing expense budget.The executive vice president uses the sales and profit targets, the sales budget byproduct line, and the tentative marketing expense budget to determine the dollaramounts that can be devoted to manufacturing and corporate office expense. Theexecutive vice president prepares the budget for corporate expenses, and then…
The background information is attached in the photos provided. (b) Another team member who is preparing the Budgeted Balance Sheet for the business for the same quarter ending March 31, 2022 and has asked you to furnish him with the figures for the expected trade receivables and payables to be included in the statement. Is that a reasonable request? If yes, what should these amounts be? (c) Upon receipt of the budget, the team manager, June Jackson, has now informed you that, in keeping with industry players, the management of Pelican Merchandising have indicated an industry requirement to maintain a minimum cash balance of $185,000 each month. She has also noted that management is very keen on keeping the gearing ratio of the business as low as possible and would therefore prefer to cushion any gaps internally using equity financing. Based on the budget prepared, will the business be achieving this desired target? Suggest three (3) internal strategies that may be employed by…
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,900; third quarter 7,300. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,360 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. 3 pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $6 per pound. (A) Prepare a production budget by quarters for the 6-month period ended June 30, 2020. HARDIN COMPANYProduction Budget For the Six Months Ending June 30, 2020June 30, 2020For…
Render Co. CPA is preparing activity-based budgets for 2019. The partners expect the firm to generate billable hours for the year as follows. Data entry . . . . . . . . . . . 2,200 hours Auditing 4,800 hours Tax 4,300 hours Consulting 750 hours The company pays $15 per hour to data-entry clerks, $30 per hour to audit personnel, $40 per hour to tax personnel, and $50 per hour to consulting personnel. Prepare a schedule of budgeted labor costs for 2019 using activity-based budgeting.