QI. Below are the budgeted revenue and expenses for a restaurant for the year 2022. RM (*000) 71,250 Revenue | Sales RM (*000) 28,500 4,200 17,100 Expenses Cost of supplies Salaries Wages Depreciation Repair and Maintenance Advertisement Laundry |Interest on Loan Miscellaneous expenses Utilities 900 3,000 1,500 200 2,200 2,300 650 Below are the additional information given to you for further analysis: The expected pattern of sales for the year 2022 are as follows and it is the company policy to analyse based on quarters. Percentage of sales 24 20 24 32 Quarter 2 3 4 75% of the sales are on a cash basis and the balance will be received in the next quarter. The costs of supplies vary directly with sales and a constant stock value of supplies are kept. 20% of purchases of the food and drinks are for cash and the balance are paid during next quarter. 80% of the repairs and maintenance item is for a major redecoration to be paid in the third quarter. Wages, which are variable with sales, are paid in the same quarter which they are incurred. Utilities and interest on loan are paid half yearly in the first and third quarters.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Q1.
Below are the budgeted revenue and expenses for a restaurant for the year 2022.
RM (*000)
71,250
Revenue
Sales
RM ('000)
28,500
4,200
17,100
Expenses
Cost of supplies
Salaries
Wages
Depreciation
Repair and Maintenance
Advertisement
Laundry
Interest on Loan
Miscellaneous expenses
Utilities
900
3,000
1,500
200
2,200
2,300
650
Below are the additional information given to you for further analysis:
The expected pattern of sales for the year 2022 are as follows and it is the
company policy to analyse based on quarters.
Percentage of sales
24
Quarter
1
2
20
3
24
4
32
75% of the sales are on a cash basis and the balance will be received in the
next quarter.
The costs of supplies vary directly with sales and a constant stock value of
supplies are kept. 20% of purchases of the food and drinks are for cash and the
balance are paid during next quarter.
80% of the repairs and maintenance item is for a major redecoration to be paid
in the third quarter.
Wages, which are variable with sales, are paid in the same quarter which they
are incurred.
Utilities and interest on loan are paid half yearly in the first and third quarters.
Transcribed Image Text:Q1. Below are the budgeted revenue and expenses for a restaurant for the year 2022. RM (*000) 71,250 Revenue Sales RM ('000) 28,500 4,200 17,100 Expenses Cost of supplies Salaries Wages Depreciation Repair and Maintenance Advertisement Laundry Interest on Loan Miscellaneous expenses Utilities 900 3,000 1,500 200 2,200 2,300 650 Below are the additional information given to you for further analysis: The expected pattern of sales for the year 2022 are as follows and it is the company policy to analyse based on quarters. Percentage of sales 24 Quarter 1 2 20 3 24 4 32 75% of the sales are on a cash basis and the balance will be received in the next quarter. The costs of supplies vary directly with sales and a constant stock value of supplies are kept. 20% of purchases of the food and drinks are for cash and the balance are paid during next quarter. 80% of the repairs and maintenance item is for a major redecoration to be paid in the third quarter. Wages, which are variable with sales, are paid in the same quarter which they are incurred. Utilities and interest on loan are paid half yearly in the first and third quarters.
All other expense payments are made evenly over the year.
Below are the opening balances:
Items
RM (*000)
Trade receivables
Trade payables
Bank overdraft
4,750
7,050
800
Required:
Prepare a tabular form of the cash budget for the four quarters of the year 2022.
Transcribed Image Text:All other expense payments are made evenly over the year. Below are the opening balances: Items RM (*000) Trade receivables Trade payables Bank overdraft 4,750 7,050 800 Required: Prepare a tabular form of the cash budget for the four quarters of the year 2022.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education