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.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 7E: Professional foes earned budget for a service company LundquistFret well. CPAs, offer three types of...

See similar textbooks

Similar questions

Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
TIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.
Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Foy Company has a welding activity and wants to develop a flexible budget formula for the activity. The following resources are used by the activity: Four welding units, with a lease cost of 12,000 per year per unit Six welding employees each paid a salary of 50,000 per year (A total of 9,000 welding hours are supplied by the six workers.) Welding supplies: 300 per job Welding hours: Three hours used per job During the year, the activity operated at 90 percent of capacity and incurred the actual activity and resource costs, shown on page 676. Lease cost: 48,000 Salaries: 315,000 Parts and supplies: 805,000 Required: 1. Prepare a flexible budget formula for the welding activity using welding hours as the driver. 2. Prepare a performance report for the welding activity. 3. What if welders were hired through outsourcing and paid 30 per hour (the welding equipment is provided by Foy)? Repeat Requirement 1 for the outsourcing case.
Adam Corporation manufactures computer tables and has the following budgeted indirect manufacturing cost information for the next year: If Adam uses the step-down (sequential) method, beginning with the Maintenance Department, to allocate support department costs to production departments, the total overhead (rounded to the nearest dollar) for the Machining Department to allocate to its products would be: a. 407,500. b. 422,750. c. 442,053. d. 445,000.
Douglas Davis, controller for Marston, Inc., prepared the following budget for manufacturing costs at two different levels of activity for 20X1: During 20X1, Marston worked a total of 80,000 direct labor hours, used 250,000 machine hours, made 32,000 moves, and performed 120 batch inspections. The following actual costs were incurred: Marston applies overhead using rates based on direct labor hours, machine hours, number of moves, and number of batches. The second level of activity (the right column in the preceding table) is the practical level of activity (the available activity for resources acquired in advance of usage) and is used to compute predetermined overhead pool rates. Required: 1. Prepare a performance report for Marstons manufacturing costs in the current year. 2. Assume that one of the products produced by Marston is budgeted to use 10,000 direct labor hours, 15,000 machine hours, and 500 moves and will be produced in five batches. A total of 10,000 units will be produced during the year. Calculate the budgeted unit manufacturing cost. 3. One of Marstons managers said the following: Budgeting at the activity level makes a lot of sense. It really helps us manage costs better. But the previous budget really needs to provide more detailed information. For example, I know that the moving materials activity involves the use of forklifts and operators, and this information is lost when only the total cost of the activity for various levels of output is reported. We have four forklifts, each capable of providing 10,000 moves per year. We lease these forklifts for five years, at 10,000 per year. Furthermore, for our two shifts, we need up to eight operators if we run all four forklifts. Each operator is paid a salary of 30,000 per year. Also, I know that fuel costs about 0.25 per move. Assuming that these are the only three items, expand the detail of the flexible budget for moving materials to reveal the cost of these three resource items for 20,000 moves and 40,000 moves, respectively. Based on these comments, explain how this additional information can help Marston better manage its costs. (Especially consider how activity-based budgeting may provide useful information for non-value-added activities.)
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?
Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?
Patterson Corporation expects to incur 70,000 of factory overhead and 60,000 of general and administrative costs next year. Direct labor costs at 5 per hour are expected to total 50,000. If factory overhead is to be applied per direct labor hour, how much overhead will be applied to a job incurring 20 hours of direct labor? a. 120 b. 260 c. 28 d. 140
Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.