Exercise on Budgeting To be turned in on May 24, 2022 Following information relates to the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Exercise on Budgeting To be turned in on May 24, 2022 Following information relates to the last operating year of HISAR Hotel who is still working on its budget for the year 2022. DEPARTMENTS Rooms Food & Beverage Other Operated Departments Total UNDISTRIBUTED OPERATING EXPENSES Administrative and General Advertising and Promotion Heat, Light and Power Repairs and Maintenance INCOME BEFORE FIXED CHARGES FIXED CHARGES Insurance Interest Expense Depreciation INCOME BEFORE TAX Hisar Hotel Departmental Income Statement For the Year ending Dec.31, 2021 TAX (30%) NET INCOME SALES REVENUE 759.200 728.200 76.500 1.563.900 COST OF SALES 0 240.300 34.400 274.700 DEPT'AL PAYROLL 160.900 291.280 27.540 479.720 DEPT'AL EXPENSES 84.310 65.530 5.350 155.190 125.690 47.130 62.840 94.270 23.000 95.000 110.000 DEPT'AL INCOME 513.990 131.090 9.210 654.290 329.930 324.360 228.000 96.360 28.908 67.452 HİSAR Hotel has 40 rooms and it has operated at 80% occupancy in the year 2021 and its aver- age room rate has been 65 TL. The predictions of the management team for the year 2022 were as follows: • Occupancy is expected to fall to 70% and management plans to increase the average room rate by 15% in response to falling occupancy. The revenues of F&B and other oper- ated departments are expected to increase by 10%. While payroll costs will be kept con- stant for the next year, departmental expenses and costs of sales are expected to increase by 15% over the coming year. • In undistributed operating expenses, administrative and general expenses are expected to increase by 5%, while advertising and promotion increase is budgeted as 10%. Further- more, heat, light, energy and maintenance costs are expected to increase by 20%. • Forecasts on fixed charges are as follows for 2021: Insurance 28,000 TL.; Interest expense 105,000 TL and Depreciation 110,000 TL. Required: 1. Evaluate the past profitability of HISAR Hotel and its departments in the year 2021. Con- sider the additional information in your evaluations: Total Assets were 2,250,000 TL and total equity was 1,500,000 TL in 2021. In making your evaluations of profitability, use various appropriate analysis ratios and comment on the existing level of profitabil- ity in the year 2021. 2. Given the forecasts and predictions of the management team, prepare the budgeted in- come statement of the management for the year 2022. Evaluate the expected profita- bility of HISAR Hotel according to the plans of management. In evaluating profitability for the budgeted 2022 results, use a 10% increase in total assets in 2022 and the same relation between the size of total assets and equity. 3. Suggest changes in plans and policies, so that the future of HISAR Hotel improves over the budget foreseen by the management team. Including your own forecasts, plans and estimations, construct your own budgeted income statement for HISAR Hotel for the year 2022. 4. Depending on your own budget, explain to the management team your forecasts and plans and how to improve the profitability of HISAR over what they have planned for. Exercise on Budgeting To be turned in on May 24, 2022 Following information relates to the last operating year of HISAR Hotel who is still working on its budget for the year 2022. DEPARTMENTS Rooms Food & Beverage Other Operated Departments Total UNDISTRIBUTED OPERATING EXPENSES Administrative and General Advertising and Promotion Heat, Light and Power Repairs and Maintenance INCOME BEFORE FIXED CHARGES FIXED CHARGES Insurance Interest Expense Depreciation INCOME BEFORE TAX Hisar Hotel Departmental Income Statement For the Year ending Dec.31, 2021 TAX (30%) NET INCOME SALES REVENUE 759.200 728.200 76.500 1.563.900 COST OF SALES 0 240.300 34.400 274.700 DEPT'AL PAYROLL 160.900 291.280 27.540 479.720 DEPT'AL EXPENSES 84.310 65.530 5.350 155.190 125.690 47.130 62.840 94.270 23.000 95.000 110.000 DEPT'AL INCOME 513.990 131.090 9.210 654.290 329.930 324.360 228.000 96.360 28.908 67.452 HİSAR Hotel has 40 rooms and it has operated at 80% occupancy in the year 2021 and its aver- age room rate has been 65 TL. The predictions of the management team for the year 2022 were as follows: • Occupancy is expected to fall to 70% and management plans to increase the average room rate by 15% in response to falling occupancy. The revenues of F&B and other oper- ated departments are expected to increase by 10%. While payroll costs will be kept con- stant for the next year, departmental expenses and costs of sales are expected to increase by 15% over the coming year. • In undistributed operating expenses, administrative and general expenses are expected to increase by 5%, while advertising and promotion increase is budgeted as 10%. Further- more, heat, light, energy and maintenance costs are expected to increase by 20%. • Forecasts on fixed charges are as follows for 2021: Insurance 28,000 TL.; Interest expense 105,000 TL and Depreciation 110,000 TL. Required: 1. Evaluate the past profitability of HISAR Hotel and its departments in the year 2021. Con- sider the additional information in your evaluations: Total Assets were 2,250,000 TL and total equity was 1,500,000 TL in 2021. In making your evaluations of profitability, use various appropriate analysis ratios and comment on the existing level of profitabil- ity in the year 2021. 2. Given the forecasts and predictions of the management team, prepare the budgeted in- come statement of the management for the year 2022. Evaluate the expected profita- bility of HISAR Hotel according to the plans of management. In evaluating profitability for the budgeted 2022 results, use a 10% increase in total assets in 2022 and the same relation between the size of total assets and equity. 3. Suggest changes in plans and policies, so that the future of HISAR Hotel improves over the budget foreseen by the management team. Including your own forecasts, plans and estimations, construct your own budgeted income statement for HISAR Hotel for the year 2022. 4. Depending on your own budget, explain to the management team your forecasts and plans and how to improve the profitability of HISAR over what they have planned for.
Expert Answer:
Answer rating: 100% (QA)
Stepbystep Explanation A budget plans for and tracks income and expenses over a specific time period ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Information on occupancy and costs at the New Light Hotel for April, May, and June are indicated below: Required a. Calculate the fixed costs per month and the variable cost per occupied room using...
-
Income statement 2020 Net sales 60,000 Operating expenses excl. depreciation - 55,000 Depreciation - 1,500 Operating profit 3,500 Financial expenses - 1,000 Profit before tax 2,500 Tax -500 Reported...
-
In comparing total payroll tax expense with that of the preceding year, Merlin Brendin, CPA, observed a significant increase, even though the total number of employees increased only from 175 to 185....
-
Consider the approximation of the welfare loss due to inter-area deviations from the correct rate of care. All else equal, which procedures would yield the largest welfare losses those with low price...
-
What are the arguments for and against social responsibility on the part of businesses? Research the topic and discuss. In addition, which set of arguments is more compelling?
-
Define human comfort.
-
What are some problems that may crop up in groups and teams?
-
CLOSING INCOME SUMMARY AND DIVIDENDS TO RETAINED EARNINGS Davidson Company had a net income of $120,000 and paid cash dividends of $24,000 for 20--. Wilson and Picket Company had a net loss of...
-
Oakmont Company has an opportunity to manufacture and sell a new product for a four-year period. The company's discount rate is 18%. After careful study, Oakmont estimated the following costs and...
-
Figure 12.15 represents the network for delivering coolant to five different machine tools in an automated machining system. The grid is a rectangle 7.5 m by 15 m. All pipes are drawn steel tubing...
-
When calculating the Living Expenses Covered Ratio, which financial statement(s) would be needed to complete the ratio? Balance Sheet Cash Flow Statement & Balance Sheet Cash Flow Statement Cash Flow...
-
Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices one in Chicago and one in Minneapolis. The firm classifies...
-
Dr . Erica Chan, MD owns EC Health Clinic. She prepares annual financial statements and has a December 3 1 , 2 0 2 3 year - end. On October 1 , 2 0 2 3 , Dr . Chan prepaid $ 9 , 9 0 0 for four months...
-
Golden Wedding Dress Company designs custom wedding dresses for brides to be . The person preparing the adjusting entries at year - end was unable to complete the adjustments due to illness. You have...
-
Gitano Products operates a job - order costing system and applies overhead cost to jobs on the basis of direct materials used in production ( not on the basis of raw materials purchased ) . Its...
-
On April 1 , Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company s first month. April 2 Nozomi invested $ 4 6 , 0 0 0 cash and computer...
-
All of the following are steps used to analyze ethical dilemmas EXCEPT Select one: A. identifying potential stakeholders. B. discussing the ethical dilemma with co-workers in the lunchroom. C. using...
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
Carol Harris, Ph.D, CPA, is a single taxpayer and she lives at 674 Yankee Street, Durham, NC 27409. Her Social Security number is 793-52-4335. Carol is an Associate Professor of Accounting at a local...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
Janie graduates from high school in 2012 and enrolls in college in the fall. Her parents pay $4,000 for her tuition and fees. a. Assuming Janie's parents have AGI of $170,000, what is the American...
-
Show that \[ \gamma_{i}=\frac{\bar{\phi}_{i}}{\phi_{i}} \]
-
Carbon dioxide occupies a tank at \(100^{\circ} \mathrm{C}\). If the volume of the tank is \(0.5 \mathrm{~m}^{3}\) and the pressure is \(500 \mathrm{kPa}\), determine the mass of the gas in the tank.
-
Give an informatory note on saturation temperature and saturation pressure.
Study smarter with the SolutionInn App