Working Papers, Chapters 18-26 for Warren/Reeve/Duchacâs Accounting, 27E
27th Edition
ISBN: 9781337272162
Author: Reeve, James M., Duchac, Jonathan, WARREN, Carl S.
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 22.13EX
Direct labor budget for a service business
Ambassador Suites Inc. operates a downtown hotel property that has 300 rooms. On average, 80% of Ambassador Suites' rooms are occupied on weekdays and 40% are occupied during the weekend. The manager has asked you to develop a direct labor budget for the housekeeping and restaurant staff for weekdays and weekends. You have determined that the housekeeping staff requires 30 minutes to clean each occupied room. The housekeeping staff is paid $14 per hour. The housekeeping labor cost is fully variable to the number of occupied rooms. The restaurant has six full-time staff (eight-hour day) on duty, regardless of occupancy. However, for every 60 occupied rooms, an additional person is brought in to work in the restaurant for the eight-hour day. The restaurant staff is paid $12 per hour.
Determine the estimated housekeeping, restaurant, and total direct labor cost for an average weekday and average weekend day. Format the budget in two columns, labeled as weekday and weekend day.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Direct Labor Budget-Service Business
Ambassador Suites Inc., operates a downtown hotel property that has 600 rooms. On average, 90% of Ambassador Suites's rooms are occupied on weekdays, and 60% are occupied during the weekend. The manager has asked you to develop a direct labor budget for the housekeeping and restaurant staff for
weekdays and weekends. You have determined that the housekeeping staff requires 40 minutes to clean each occupied room. The housekeeping staff is paid $12 per hour. The restaurant has 12 full-time staff (eight-hour day) on duty, regardless of occupancy. However, for every 20 occupied rooms, an additional
person is brought in to work in the restaurant for the eight-hour day. The restaurant staff is paid $10 per hour.
Determine the estimated housekeeping, restaurant, and total direct labor cost for an average weekday and average weekend day. Enter percentages as whole numbers.
Ambassador Suites Inc.
Direct Labor Cost Budget
For a Weekday or a Weekend Day…
Service Department Charges
Sharp Motor Company has two operating divisions—an Auto Division and a Truck Division. The company has a cafeteria that serves the employees of both divisions. The costs of operating the cafeteria are budgeted at $40,000 per month plus $3 per meal served. The company pays all the cost of the meals.
The fixed costs of the cafeteria are determined by peak-period requirements. The Auto Division is responsible for 65% of the peak-period requirements, and the Truck Division is responsible for the other 35%.
For June, the Auto Division estimated it would need 35,000 meals served, and the Truck Division estimated it would need 20,000 meals served. However, due to unexpected layoffs of employees during the month, only 20,000 meals were served to the Auto Division. Another 20,000 meals were served to the Truck Division as planned.
Cost records in the cafeteria show that actual fixed costs for June totaled $42,000 and actual meal costs totaled $128,000.
Required:
1.…
Cabinare Inc. Is one of the largest manufacturers of office furniture in the United States. In Grand Rapids Michigan and assembles filing cabinets in a assembly Department. Assume following nformation for the assembly departments:
Direct labor per filing cabinets 30 min
Supervisor salaries $132,000 per month
Depreciation $24,000 per month
Direct labor rate $21 per hr.
Prepare a flexible budget for 13,000,16,000,and 20,000 filing cabinets for the month ending February 28 in assembly departments similar to exhibit 5 Round your final answer to the whole dollar, if required.
Chapter 22 Solutions
Working Papers, Chapters 18-26 for Warren/Reeve/Duchacâs Accounting, 27E
Ch. 22 - Prob. 22.1DQCh. 22 - Briefly describe the type of human behavior...Ch. 22 - What behavioral problems are associated with...Ch. 22 - What behavioral problems are associated with...Ch. 22 - Under what circumstances is a static budget...Ch. 22 - How do computerized budgeting systems aid firms in...Ch. 22 - Why should the production requirements set forth...Ch. 22 - Why should the timing of direct materials...Ch. 22 - a. Discuss the purpose of the cash budget. b. If...Ch. 22 - Prob. 22.10DQ
Ch. 22 - Flexible budgeting At the beginning of the period,...Ch. 22 - Flexible budgeting At the beginning of the period,...Ch. 22 - Production budget Daybook Inc. projected sales of...Ch. 22 - Prob. 22.2BPECh. 22 - Direct materials purchases budget Daybook Inc....Ch. 22 - Direct materials purchases budget Magnolia Candle...Ch. 22 - Direct labor cost budget Daybook Inc. budgeted...Ch. 22 - Direct labor cost budget Magnolia Candle Inc....Ch. 22 - Cost of goods sold budget Prepare a cost of goods...Ch. 22 - Cost of goods sold budget Prepare a cost of goods...Ch. 22 - Cash budget Daybook Inc. collects 30% of its sales...Ch. 22 - Cash budget Magnolia Candle Inc. pays 10% of its...Ch. 22 - Personal budget At the beginning of the school...Ch. 22 - Flexible budget for selling and administrative...Ch. 22 - Static budget versus flexible budget The...Ch. 22 - Flexible budget for Assembly Department Steelcase...Ch. 22 - Production budget Weightless Inc. produces a small...Ch. 22 - Sales and production budgets Sonic Inc....Ch. 22 - Professional fees earned budget for a service...Ch. 22 - Professional labor cost budget for a service...Ch. 22 - Direct materials purchases budget Lorenzo's Frozen...Ch. 22 - Prob. 22.10EXCh. 22 - Direct materials purchases budget Anticipated...Ch. 22 - Direct labor cost budget MatchPoint Racket Company...Ch. 22 - Direct labor budget for a service business...Ch. 22 - Production and direct labor cost budgets Levi...Ch. 22 - Factory overhead cost budget Sweet Tooth Candy...Ch. 22 - Cost of goods sold budget Wilmington Chemical...Ch. 22 - Cost of goods sold budget The controller of...Ch. 22 - Schedule of cash collections of accounts...Ch. 22 - Schedule of cash collections of accounts...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Capital expenditures budget On January 1, 20Y2,...Ch. 22 - Forecast sales volume and sales budget For 20Y6,...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Sonoma Housewares...Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Forecast sales volume and sales budget Sentinel...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Mercury Shoes Inc....Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Prob. 22.1CPCh. 22 - Communication The city of Milton has an annual...Ch. 22 - Prob. 22.4CPCh. 22 - Static budget for a service company A bank manager...Ch. 22 - Objectives of the master budget Dominos Pizza...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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.arrow_forwardMultiple production department factory overhead rates The total factory overhead for Bardot Marine Company is budgeted for the year at 600,000 divided into two departments: Fabrication, 420,000, and Assembly, 180,000. Bardot Marine manufactures two types of boats: speedboats and bass boats. The speedboats require 8 direct labor hours in Fabrication and 4 direct labor hours in Assembly. The bass boats require 4 direct labor hours in Fabrication and 8 direct labor hours in Assembly. Each product is budgeted for 250 units of production for the year. Determine (A) the total number of budgeted direct labor hours for the year in each department, (B) the departmental factory overhead rates for both departments, and (C) the factory overhead allocated per unit for each product using the department factory overhead allocation rates.arrow_forwardProfessional foes earned budget for a service company LundquistFret well. CPAs, offer three types of services to clents: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending May 31. 20Y8: The average billing rate for staff is 140 per hour, and the average billing rate for partners is 450 per hour. Prepare a professional fees earned budget for Lundquist Fretwell, CPAs, for theyear ending May 31, 20Y8, using the following column headings and showing the estimated professional fees by type of service rendered:arrow_forward
- 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.arrow_forwardKrouse Company produces two products, forged putter heads and laminated putter heads, which are sold through specialty golf shops. The company is in the process of developing itsoperating budget for the coming year. Selected data regarding the companys two products areas follows: Manufacturing overhead is applied to units using direct labor hours. Variable manufacturing overhead Ls projected to be 25,000, and fixed manufacturing overhead is expected to be15,000. The estimated cost to produce one unit of the laminated putter head is: a. 42. b. 46. c. 52. d. 62.arrow_forwardUse the following information for Exercises 9-63 and 9-64: Palladium Inc. produces a variety of household cleaning products. Palladiums controller has developed standard costs for the following four overhead items: Next year, Palladium expects production to require 90,000 direct labor hours. Exercise 9-63 Flexible Budget for Various Levels of Activity Refer to the information for Palladium Inc. above. Required: 1. Prepare an overhead budget for the expected level of direct labor hours for the coming year. 2. Prepare an overhead budget that reflects production that is 15% higher than expected and for production that is 15% lower than expected.arrow_forward
- Firenza Company manufactures specialty tools to customer order. Budgeted overhead for the coming year is: Previously, Sanjay Bhatt, Firenza Companys controller, had applied overhead on the basis of machine hours. Expected machine hours for the coming year are 50,000. Sanjay has been reading about activity-based costing, and he wonders whether or not it might offer some advantages to his company. He decided that appropriate drivers for overhead activities are purchase orders for purchasing, number of setups for setup cost, engineering hours for engineering cost, and machine hours for other. Budgeted amounts for these drivers are 5,000 purchase orders, 500 setups, and 2,500 engineering hours. Sanjay has been asked to prepare bids for two jobs with the following information: The typical bid price includes a 40 percent markup over full manufacturing cost. Required: 1. Calculate a plantwide rate for Firenza Company based on machine hours. What is the bid price of each job using this rate? 2. Calculate activity rates for the four overhead activities. What is the bid price of each job using these rates? 3. Which bids are more accurate? Why?arrow_forwardCorazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?arrow_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forward
- Salisbury Bottle Company manufactures plastic two-liter bottles for the beverage industry. The cost standards per 100 two-liter bottles are as follows: At the beginning of March, Salisburys management planned to produce 500,000 bottles. The actual number of bottles produced for March was 525,000 bottles. The actual costs for March of the current year were as follows: a. Prepare the March manufacturing standard cost budget (direct labor, direct materials, and factory overhead) for Salisbury, assuming planned production. b. Prepare a budget performance report for manufacturing costs, showing the total cost variances for direct materials, direct labor, and factory overhead for March. c. Interpret the budget performance report.arrow_forwardLens & 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.arrow_forwardManjiarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY