Sales Revenue Variable Costs Fixed costs Profit Number of rooms occupied Sales Room Rate Variable Costs Actual £ 579,500 213,500 100,000 266,000 6,100 Head Office Budget Assumptions 80% occupancy per month (30 days) £105 per night £25 per room per night Fixed/Overhead Costs £1,000 per night There is also a profit target for each hotel of £120,000 per month. Requirement: Section B of your report to the Exeter hotel manager Evaluate performance for the quarter to budget and provide recommendations for budgeting and cost management.

Sales Revenue Variable Costs Fixed costs Profit Number of rooms occupied Sales Room Rate Variable Costs Actual £ 579,500 213,500 100,000 266,000 6,100 Head Office Budget Assumptions 80% occupancy per month (30 days) £105 per night £25 per room per night Fixed/Overhead Costs £1,000 per night There is also a profit target for each hotel of £120,000 per month. Requirement: Section B of your report to the Exeter hotel manager Evaluate performance for the quarter to budget and provide recommendations for budgeting and cost management.

Name: A performance report for the Exeter hotel for the three months ending
Uploaded: 2024-03-20T06:32:49.000Z
Channel: Bartleby
Description: A performance report for the Exeter hotel for the three months ending 30 June 2022 showed:Actual£579,500213,500100,000Sales RevenueVariable CostsFixed costsProfitNumber of rooms occupiedSalesRoom RateVariable Costs266,0006,100Head Office Budget Assu

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 1CE: The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include:...

See similar textbooks

Similar questions

A company estimates its manufacturing overhead will be $840,000 for the next year. What is the predetermined overhead rate given each of the following Independent allocation bases? Budgeted direct labor hours: 90,615 Budgeted direct labor expense: $750000 Estimated machine hours: 150,000
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?
Assume that the inspection activity has an expected cost of 120,000. Expected direct labor hours are 3,000, and expected number of inspections is 600. The best activity rate for inspection is as follows: a. 40 per inspection b. 40 per hour c. 200 per inspection d. 200 per hour
The following information is budgeted for Hana Sdn Bhd (HSB) for second quarter next year: April May June Sales RM10,000 RM30,000 RM40,000 Purchase of materials RM50,000 RM30,000 RM20,000 Rental expenses RM5,000 RM5,000 RM5,000 Fixed overhead RM40,000 RM40,000 RM40,000 Variable overhead RM2,000 RM5,000 RM5,000 Receipt- sales of used equipment - RM55,000 - Additional information: All sales at HSB are on credit. Past experience indicates that 80% of sales will be collected in the month of sale and the remaining 20% will be collected in the following month. HSB…
The following data have been extracted from the budgets and standard costs of FAA Limited a company which manufactures and sells a single product, for the 1st quarter of 2021.GH¢ per unitSelling price 60Direct material 15Direct labour 10Variable production overhead 5Fixed production overhead costs are budgeted at GH¢ 700,000 per annum. Normal productionlevels are thought to be 350,000 units per annum.Selling and distribution expenses are:Fixed GH¢ 20,000 per monthVariable 5% of the sales valueAdministration costs are GH¢ 200,000 per annum.The following trends of sales and production are expected during the first quarter of 2021UnitsProduction 80,000Sales 70,000There were no opening inventories.REQUIRED:a) Prepare the absorption costing and marginal costing income statements for 1st quarter, 2021b) Reconcile the profits in (a) above3c) State two (2) differences between absorption costing and marginal costing approachesd) What is the meaning of slack under limiting factor analysis?
The Management Accountant of Kafululu Plc has prepared the following budget information for theyear ending 31st December 2022 for product A. Annual Fixed Costs K270,000.00 Variable costs per unit K90.00 Contribution to sales ratio(C/S) 75% Annual budget units 1,500 Required:a) Calculate the contribution per unit for Product A. b) Calculate the Unit Selling Price for Product A. c) Calculate the Break Even Point for Product A. d) Calculate the margin of safety in Units and in percentage terms. e) If the Selling Price per Unit is reduced by 10%, variable cost per Unit is increased to K100.00and Fixed costs remain unchanged, calculate:i. The new Breakeven Point. ii. The total units that should be sold in order to make a profit of K450,000 in 2020.(
The budget of Bisby plc shows total production overheads of £78m. They plan to work 6m hours and total labour costs for the year are £26m. Which of the following can be a suitable absorption rate for the production overhead?   i. £4 per hour ii.  £13 per hour iii.  £3 per labour cost iv.  £13 per labour cost Select one: a. i and iii b. i and iv c. ii and iii d. ii and iv
In planning its operations for 2021 based on a sales forecast of P6,000,000 and breakeven point in pesos of P4,000,000, Thone, Inc., prepared the following estimated data: Cost and Expenses (Variable) Direct materials P1,600,000 Direct labor 1,400,000 Factory overhead 600,000 Selling expenses 240,000 Administrative expenses 60,000 What would be the amount of fixed cost and expenses? 1350,000 1,400,000 c. 1,450,000 d. 1,500,000
Accounting A company’s planned activity level for next year is expected to be 50,000 machine hours. At this level of activity, the company budgeted the following manufacturing overhead costs: Variable Fixed Indirect materials $90,000 Depreciation $37,500 Indirect labor 120,000 Taxes 7,500 Factory supplies 15,000 Supervision 30,000 A flexible budget prepared at the 90,000 machine hours level of activity would show total manufacturing overhead costs of $405,000 $480,000 $477,500 $425,000
XYZ Company, INC. assumes to make 2,000,000 units of Product A in 2027. Monthly production is estimated from 100,000-145,000 units. Budgeted variable manufacturing costs per unit are direct materials $8, direct labor $5, and overhead, $10. Budgeted fixed manufacturing costs per unit for depreciation are $4 and supervision is $3. Prepare a flexible manufacturing budget for the relevant rand value using 35,000 unit increments.
Haigh Ltd produces garden chairs. The budgeted output and sales for the month of April 2020 was 5,000 chairs. The standard cost is: £ wood 30 sq metres at £4 per sq metre 120.00 labour 7 hours at £9 per hour 63.00 Variable overheads 7 hours at £5 per hour 35.00 Fixed overheads 7 hours at £10 per hour 70.00 Total production cost 288.00 Standard profit 32.00 Standard selling price 320.00 The actual results were: Wood 170,000 sq metres at £3.50 per sq metre Labour 40,000 hours at £10 per hour Variable overheads £174,000 Fixed overheads £370,000 Sales revenue £1,606,500 Actual production was 5,500 chairs and sales were 5,100 chairs. Prepare a budgeted reconciliation statement for April 2020, which will show the actual profit for the month. Identify the four different types of standards which…
The fixed costs of operating the Srepta Corp. are $4,800,000 annually. Variable costs are incurred at the rate of $25 per maintenance-hour. On average, the company incurs 38,000 maintenance-hours per year. Budgeted and actual hours per user for 2019 are as follows: Budgeted hours Actual hours Building and grounds 10,000 9,800 Administration 2,500 1,600 Customer Service 18,000 22,500 IT support 7,500 7,800 Total 38,000 41,700 Assume that budgeted maintenance-hours are used to calculate the allocation rates. 1. Using a single-rate allocation and budgeted usage, how much will each department be allocated? 2. Using a dual-rate allocation with fixed costs allocated according to budgeted hours and variable costs allocated to actual hours, how much overhead will each department be allocated?