Concept explainers
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.
Trending nowThis is a popular solution!
Chapter 22 Solutions
Financial And Managerial Accounting
- Analyze Johnson Stores staffing budget for holidays Johnson Stores is planning its staffing for the upcoming holiday season. From past history, the store determines that it needs one additional sales clerk for each 12,000 in daily sales. The average daily sales is anticipated to increase by 96,000 from Black Friday until Christmas Eve, or 27 shopping days. Each additional sales clerk will work an eight-hour shift and will be paid 14 per hour. A. Determine the amount to budget for additional sales clerks for the holiday season. B. If Johnson Stores has an average 40% gross profit on sales, should it add the staff suggested by your answer in (A)? That is, is it profitable to staff for the increased sales in (A)?arrow_forwardNozama.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_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_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_forwardSunrise 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_forward
- Multiple 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_forwardCloud 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_forward
- Flexible 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_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 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_forward
- 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 CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning