Financial And Managerial Accounting
15th Edition
ISBN: 9781337902663
Author: WARREN, Carl S.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 4MAD
Housekeeping staff budget
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 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 on duty to staff the restaurant for breakfast and lunch (eight hours), regardless of occupancy. However, for every 60 occupied rooms, an additional person is brought in to work in the restaurant for breakfast and lunch (eight hours). The restaurant staff is paid $12 per hour. Prepare two columns, labeled as weekday and weekend day.
- A. Determine the number of rooms occupied for an average weekday and weekend day.
- B. Determine the housekeeping staff budget for an average weekday and weekend day.
- C. Determine the restaurant staff budget for an average weekday and weekend day.
- D. Determine the total staff budget for an average 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…
Bruer Jeep Tours operates Jeep tours in the heart of the Colorado Rockies. The company bases its budgets on two measures of
activity (I.e., cost drivers), namely guests and Jeeps. One vehicle used in one tour on one day counts as a jeep. Each Jeep has one tour
guide. The company uses the following data in its budgeting:
Guests
Jeeps
Revenue
Expenses:
Fixed element
per month
Revenue
$0
Tour guide wages
Vehicle expenses
$ 6,000
Administrative expenses
$ 3,100
In November, the company budgeted for 370 guests and 165 Jeeps. The actual activity for the month was 384 guests and 150 Jeeps.
Tour guide wages
Vehicle expenses
Administrative expenses
Total expense
Net operating income
Variable
element per
guest
$183
Required:
Prepare a report showing the company's activity variances for November. Label each varlance as favorable (F) or unfavorable (U).
(Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (l.e., zero
varlance). Input…
Flexible Budget for Assembly Department
Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department:
Direct labor per filing cabinet
30 minutes
Supervisor salaries
$135,000 per month
Depreciation
$20,000 per month
Direct labor rate
$21 per hour
Prepare a flexible budget for 8,000, 10,000, and 12,000 filing cabinets for the month of August in the Assembly Department, similar to Exhibit 5.
Cabinaire Inc-Assembly DepartmentFlexible Production BudgetFor the Month Ending August 31 (assumed data)
Units of production
8,000
10,000
12,000
Variable cost:
Direct labor
Fixed cost:
Supervisor salaries
Depreciation
Total fixed cost
Total department cost
Chapter 22 Solutions
Financial And Managerial Accounting
Ch. 22 - Prob. 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 would a static budget be...Ch. 22 - Prob. 6DQCh. 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 - Give an example of how the capital expenditures...
Ch. 22 - At the beginning of the period, the Fabricating...Ch. 22 - Pasadena Candle Inc. projected sales of 800,000...Ch. 22 - Pasadena Candle Inc. budgeted production of...Ch. 22 - Pasadena Candle Inc. budgeted production of...Ch. 22 - Prepare a cost of goods sold budget for Pasadena...Ch. 22 - Prob. 6BECh. 22 - At the beginning of the school year, Craig Kovar...Ch. 22 - Digital Solutions Inc. uses flexible budgets that...Ch. 22 - Static budget versus flexible budget The...Ch. 22 - Flexible budget for Assembly Department Steelcase...Ch. 22 - Production budget Healthy Measures Inc. produces a...Ch. 22 - Sales and production budgets Sonic Inc....Ch. 22 - Professional foes earned budget for a service...Ch. 22 - Professional labor cost budget for a service...Ch. 22 - Direct materials purchases budget Tobins Frozen...Ch. 22 - Direct materials purchases budget Coca-Cola...Ch. 22 - Direct materials purchases budget Anticipated...Ch. 22 - Direct labor cost budget Ace Racket Company...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 Delaware 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 service company...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Capital expenditures budget On January 1, 20Y6,...Ch. 22 - Forecast sales volume and sales budget For 20Y8,...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Bridgeport...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 - Prob. 4PBCh. 22 - Cash budget The controller of Mercury Shoes Inc....Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Analyze Johnson Stores staffing budget for...Ch. 22 - Nursing staff budget Mercy Hospital staffs its...Ch. 22 - Parking lot staff budget Adventure Park is a large...Ch. 22 - Housekeeping staff budget Ambassador Suites Inc....Ch. 22 - Ethics in Action The director of marketing for...Ch. 22 - Communication The city of Milton has an annual...Ch. 22 - Prob. 4TIFCh. 22 - Static budget for a service company A hank manager...Ch. 22 - Objectives of the master budget Dominos Pizza LLC...Ch. 22 - When compared to static budgets, flexible budgets:...Ch. 22 - Hannon Retailing Company prices its products by...Ch. 22 - Ming Company has budgeted sales at 6,300 units for...Ch. 22 - Krouse Company produces two products, forged...
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_forwardFoy 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_forwardCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?arrow_forward
- Sunrise Poles manufactures hiking poles and is planning on producing 4,000 units in March and 3,700 in April. Each pole requires a half pound of material, which costs $1.20 per pound. The companys policy is to have enough material on hand to equal 10% of the next months production needs and to maintain a finished goods inventory equal to 25% of the next months production needs. What is the budgeted cost of purchases for March?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_forwardLens 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.arrow_forward
- Cloud Shoes manufactures recovery sandals and is planning on producing 12.000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The companys policy is to have enough material on hand to equal 15% of next months production needs and to maintain a finished goods inventory equal to 20% of the next months production needs. What is the budgeted cost of purchases for March?arrow_forwardService 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.…arrow_forwardFlexible Budget for Assembly Department Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 15 minutes Supervisor salaries $200,000 per month Depreciation $30,000 per month Direct labor rate $25 per hour Prepare a flexible budget for 25,000, 40,000, and 55,000 filing cabinets for the month of March in the Assembly Department, similar to Exhibit 5. Steelcase Inc.Assembly Department BudgetFor the Month Ending March 31 (assumed data) Units of production 25,000 40,000 55,000 Variable cost: $Direct labor $Direct labor $Direct labor Total variable cost $fill in the blank 5 $fill in the blank 6 $fill in the blank 7 Fixed cost: $Supervisor salaries $Supervisor salaries $Supervisor salaries Depreciation Depreciation…arrow_forward
- Flexible Budget for Assembly Department Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 30 minutes Supervisor salaries $117,000 per month Depreciation $32,000 per month Direct labor rate $12 per hourarrow_forwardFlexible Budget for Assembly Department Cabinaire Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it assembles filing cabinets in an Assembly Department. Assume the following information for the Assembly Department: Direct labor per filing cabinet 20 minutes Supervisor salaries $144,000 per month Depreciation $27,000 per month Direct labor rate $21 per hour Prepare a flexible budget for 8,000, 10,000, and 12,000 filing cabinets for the month ending February 28 in the Assembly Department similar to Exhibit 5. Round your final answers to the whole dollar, if required. Cabinaire Inc. Assembly Department Budget For the Month Ending February 28 (assumed data) Units of production 8,000 10,000 12,000 Variable cost: $fill in the blank 2 $fill in the blank 3 $fill in the blank 4 Total variable cost $fill in the blank 5 $fill in the blank 6 $fill in the blank 7 Fixed cost: $fill in the…arrow_forwardPreparing a Selling and Administrative Expenses Budget Fazel Company makes and sells paper products. In the coming year, Fazel expects total sales of $19,800,000. There is a 4% commission on sales. In addition, fixed expenses of the sales and administrative offices include the following: Salaries $ 960,000 Utilities 365,000 Office space 230,000 Advertising 1,200,000 Required: Prepare a selling and administrative expenses budget for Fazel Company for the coming year. Fazel Company Selling and Administrative Expenses Budget For the Coming Year Variable selling expenses Fixed expenses: Salaries Utilities Office spacе Advertising Total fixed expenses Total selling and administrative expensesarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher: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
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher: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,
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
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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