Prepare cash budget for the month of April, May, and June 2019. Balance at the end of March 2019 shows an overdraft balance of RM48,000.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
100%

Prepare cash budget for the month of April, May, and June 2019. Balance at the end of March 2019 shows an overdraft balance of RM48,000.

Q1.
(a)
Tasty Food Industries produces and sells cookies for local market. Data for the
production of one packet of cookies are as follows:
Material per packet
Special flour
Icing sugar
1kg at RM1.20 per kg
½ kg at RM4.80 per kg
Labor per packet
Mixing operation
Wrapping operation
12 minutes at RM10.50 per hour
24 minutes at RM10.00 per hour
During the second quarter of 2019, the expected productions are as follows:
April
Мay
June
48,000 packets
45,000 packets
46,000 packets
Projected data supporting the production are summarized as below:
1.
Sales
February
March
April
May
June
RM500,000
RM540,000
RM720,000
RM630,000
RM600,000
A cash sale is 40% and the remaining balance will be paid two months
after sales. It is also expected that 5% of the remaining sales balance
will be uncollectable.
2.
Payments to suppliers are made in the month of purchase.
3.
Administrative expenses (including depreciation) are RM24,350;
RM24,950 and RM21,150 for April, May and June respectively.
Labor and administrative expenses are paid in the month in which they
are incurred.
4.
5.
Other monthly costs are:
April
RM
May
RM
June
RM
Water and electricity
Stationery
Depreciation
General expenses
Rent
2,110
3,240
5,750
1,850
2,850
2,320
1,980
1,850
5,750
2,340
2,850
2,300
5,750
2,760
2,850
Transcribed Image Text:Q1. (a) Tasty Food Industries produces and sells cookies for local market. Data for the production of one packet of cookies are as follows: Material per packet Special flour Icing sugar 1kg at RM1.20 per kg ½ kg at RM4.80 per kg Labor per packet Mixing operation Wrapping operation 12 minutes at RM10.50 per hour 24 minutes at RM10.00 per hour During the second quarter of 2019, the expected productions are as follows: April Мay June 48,000 packets 45,000 packets 46,000 packets Projected data supporting the production are summarized as below: 1. Sales February March April May June RM500,000 RM540,000 RM720,000 RM630,000 RM600,000 A cash sale is 40% and the remaining balance will be paid two months after sales. It is also expected that 5% of the remaining sales balance will be uncollectable. 2. Payments to suppliers are made in the month of purchase. 3. Administrative expenses (including depreciation) are RM24,350; RM24,950 and RM21,150 for April, May and June respectively. Labor and administrative expenses are paid in the month in which they are incurred. 4. 5. Other monthly costs are: April RM May RM June RM Water and electricity Stationery Depreciation General expenses Rent 2,110 3,240 5,750 1,850 2,850 2,320 1,980 1,850 5,750 2,340 2,850 2,300 5,750 2,760 2,850
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Performance measurements
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