Exercise 12-30 Performance Report; Hotel (LO 12-3) The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget March (in thousands)* $ 670 1,840 Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead (83) Fixed overhead (98) *Numbers without parentheses denote profit; numbers with parentheses denote expenses. Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Required: Based on Exhibit 12-4, prepare a March performance report and use the same data for year-to-date columns in your report. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (i.e., zero variance). Enter your answers in thousands.) Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense (93) (710) (137) Flexible Budget March Actual Results March (in thousands)* 682 1,830 Year to Date (94) (714) (134) (86) (105) WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) March Actual Results Year to Date March Variance Year to Date

Exercise 12-30 Performance Report; Hotel (LO 12-3) The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget March (in thousands)* $ 670 1,840 Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead (83) Fixed overhead (98) Numbers without parentheses denote profit; numbers with parentheses denote expenses. Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Required: Based on Exhibit 12-4, prepare a March performance report and use the same data for year-to-date columns in your report. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (i.e., zero variance). Enter your answers in thousands.) Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense (93) (710) (137) Flexible Budget March Actual Results March (in thousands) 682 1,830 Year to Date (94) (714) (134) (86) (105) WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) March Actual Results Year to Date March Variance Year to Date

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter23: Flexible Budgeting (flexbud)

Section: Chapter Questions

Problem 4R

See similar textbooks

Similar questions

Budget performance reports for cost centers Partially completed budget performance reports for Runquist Company, a manufacturer of air conditioners, are provided below. a.Complete the budget performance reports by determining the correct amounts for the lettered spaces. b.Compose a memo to Jeff Kitchens, president of Meridian Company, explaining the performance of the Production Division for June.
Professional Labor Cost Budget for a Service Company Lundquist & Fretwell, CPAS, offer three types of services to clients: 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: Audit Department: Staff Partners Tax Department: Staff Partners Small Business Accounting Department: Staff Partners Billable Hours Audit Department hours Tax Department hours Small Business Accounting Department hours Total hours Average compensation per hour Total professional labor cost 25,000 6,000 Based on the data provided above and assuming that the average compensation per hour for staff is $40 and for partners is $175, prepare a professional labor cost budget for each department for Lundquist & Fretwell, CPAS, for the year ending May 31, 20Y8. 40,000 8,500 Lundquist & Fretwell, CPAS Professional Labor Cost Budget For the Year Ending December 31, 20Y8 Staff Partners X $ 5,000 500 x $
Budget performance report for a cost center GHT Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended July 31 is as follows: Line Item Description Customer service salaries Insurance and property taxes Distribution salaries Marketing salaries Engineer salaries 836,850 586,110 185,120 Total $4,167,050 During July, the costs incurred in the Consumer Products Division were as follows: Warehouse wages Equipment depreciation Line Item Description Customer service salaries Insurance and property taxes Distribution salaries Marketing salaries Engineer salaries Warehouse wages Equipment depreciation Total Required: Question Content Area Line Item Description Customer service salaries Insurance and property taxes Distribution salaries Amount $546,840 114,660 872,340 1,025,130 1. Prepare a budget performance report for the director of the Consumer Products Division for the…
Scenario The Francis Corporation operates two service and two producing departments in its production of go carts. The budgeted overhead costs directly associated with the departments and other pertinent data for an upcoming month are as follows: Overhead Costs Machine Hours Number of Employees 19.67 (rounded) 16.67 (rounded) 3.00 14.74 (rounded) Service & Production Departments Data Service Departments Maintenance $144,000 20 O 15.87 Personnel $80,000 16 Personnel costs are allocated based on the number of employees, and maintenance costs are allocated based on machine hours. Assume the Assembly department uses direct labor hours to allocate its cost is overhead costs. For the upcoming month, the estimated direct labor hours is estimated is 19,200 hours. Question What will be the predetermined overhead rate for the Assembly department for the upcoming month? Production Departments Tooling $280,000 30,000 60 Assembly $320,000 20,000 100
The following data pertain to the Waikiki Sands Hotel for the month of March, Flexible Budget March in Actual Results March thousands) (in thousands) $ 650 1,800 $ 658 (85) (698) (125) (75) (90) *Numbers without parentheses denote profit, numbers with parentheses denote expenses. Required: Based on Exhibit 12-4, prepare a March performance report. For the year-to-date columns in your report, use the data given in Exhibit 12-4. You will need to update those figures using the March data given above. Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "0" for no effect (i.e., zero variance). Enter your answers in thousands. Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Food and Beverage Department Banquets & Catering Restaurants Kitchen Total prof Kitchen Kachen staff wages Food Flexible Budget March Year to Date) 1,794 (86) (690) (122) WAIKIKI SANDS HOTEL…
Preparing a flexible budget and performance report This continues the Piedmont Computer Company situation from Chapter 22. Assume Piedmont Computer Company has created a standard cost card for the PCC model tablet computer, with overhead allocated based on direct labor hours: During the month of September, Piedmont Computer Company incurred the following costs while manufacturing 1,100 PCC model tablets; Requirements Prepare a flexible budget for September for 900, 1,000, and 1,100 PCC model tablets. The tablet has a standard sales price of $675. List variable costs separately. Using 1,000 PCC model tablets for the static budget, prepare a flexible budget performance report for September. Total sales revenue for the month was $767,800. The company sold 1,100 tablets. What insights can the management of Piedmont Computer Company draw from the performance report?
Budget Performance Report for a Cost Center Funderburk Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows: Customer service salaries $628,870 Insurance and property taxes 131,860 Distribution salaries 1,003,190 Marketing salaries 1,182,630 Engineer salaries 962,380 Warehouse wages 674,030 Equipment depreciation 211,360 Total $4,794,320 During January, the costs incurred in the Consumer Products Division were as follows: Customer service salaries $692,700 Insurance and property taxes 126,780 Distribution salaries 990,380 Marketing salaries 1,248,010 Engineer salaries 943,010 Warehouse wages 647,030 Equipment depreciation 211,150 Total $4,859,060 Required: 1. Prepare a budget performance report for the director of the Consumer Products Division for the month of January. If an…
ost Centers Partially completed budget performance reports for Delmar Company, a manufacturer of light duty motors, follow: Delmar Company Plant Eastern Region Central Region Western Region Department Cost Chip Fabrication Electronic Assembly Final Assembly Budget Performance Report-Vice President, Production For the Month Ended June 30 a. $ Factory wages Materials Power and light Maintenance b. $ c. $ d. $ e. $ f. $ Actual $390,100 278,100 (g) $(j) Delmar Company Actual $(a) 87,290 137,620 $(d) Budget $390,100 280,900 Actual Budget Performance Report-Manager, Western Region Plant For the Month Ended June 30 $29,190 73,790 5,320 6,920 (h) $(k) $115,220 $ (b) 86,170 138,730 $(e) Over Budget Budget $(c) 1,120 Over Budget Budget (1) $(1) g. $ h. $ j. $ k. $ 1. $ Delmar Company Budget Performance Report-Supervisor, Chip Fabrication For the Month Ended June 30 (Under) Budget $(f) $0 (2,800) $27,280 74,310 4,470 850 6,320 600 $112,380 $3,360 $(520) a. Complete the budget performance reports…
Budget performance report for a cost center GHT Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows: Customer service salaries $546,840 Insurance and property taxes 114,660 Distribution salaries 872,340 Marketing salaries 1,028,370 Engineer salaries 836,850 Warehouse wages 586,110 Equipment depreciation 183,792 Total $4,168,962 During January, the costs incurred in the Consumer Products Division were as follows: Customer service salaries $602,350 Insurance and property taxes 110,240 Distribution salaries 861,200 Marketing salaries 1,085,230 Engineer salaries 820,008 Warehouse wages 562,632 Equipment depreciation 183,610 Total $4,225,270 Required: Prepare a budget performance report for the director of the Consumer Products…
Budget Performance Report for a Cost Center Sneed Industries Company sells vehicle parts to manufacturers of heavy construction equipment. The Crane Division is organized as a cost center. The budget for the Crane Division for the month ended August 31, 20Y6, is as follows (in thousands): Customer service salaries $ 375,000 Insurance and property taxes 75,000 Distribution salaries 712,500 Marketing salaries 450,000 Engineer salaries 1,110,000 Warehouse wages 420,000 Equipment depreciation 232,500 Total $ 3,375,000 During August, the costs incurred in the Crane Division were as follows: Customer service salaries $ 515,200 Insurance and property taxes 68,740 Distribution salaries 657,300 Marketing salaries 519,400 Engineer salaries 1,033,550 Warehouse wages 384,860 Equipment depreciation 217,000 Total $ 3,396,050 Required: 1. Prepare a budget performance report for the director of the Crane Division for the month of August. Enter amounts in…
Budget performance report for a cost center GHT Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows: Customer service salaries $546,840 Insurance and property taxes 114,660 Distribution salaries 872,340 Marketing salaries 1,028,370 Engineer salaries 836,850 Warehouse wages 586,110 Equipment depreciation 183,792 Total $4,168,962 During January, the costs incurred in the Consumer Products Division were as follows: Customer service salaries $602,350 Insurance and property taxes 110,240 Distribution salaries 861,200 Marketing salaries 1,085,230 Engineer salaries 820,008 Warehouse wages 562,632 Equipment depreciation 183,610 Total $4,225,270 Required: 1. Prepare a budget performance report for the director of the Consumer Products Division for the month of January. If an amount box does…
Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner Company makes and sells high-quality glare filters for microcomputer monitors. John Craven, controller, is responsible for preparing Greiner’s master budget and has assembled the following data for the coming year. The direct labor rate includes wages, all employee-related benefits, and the employer’s share of FICA. Labor saving machinery will be fully operational by March. Also, as of March 1, the company’s union contract calls for an increase in direct labor wages that is included in the direct labor rate. Greiner expects to have 5,600 glare filters in inventory on December 31 of the current year, and has a policy of carrying 25 percent of the following month’s projected sales in inventory. Information on the first four months of the coming year is as follows: January February March April Estimated unit sales 35,600 34,600 40,400 39,600 Sales price per unit $80 $80 $76 $76…