Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

XX Bhd is about to prepare a monthly cash budget for the upcoming 3 months (from January to March 2020). The following transactions are recorded:

XX Bhd is about to prepare a monthly cash budget for the upcoming 3 months (from January to March 2020). The following transactions are recorded:

  • About 60% of sales are collected 1 month after the sale and the remainder is collected in the second month following the sale.
  • The company purchases are 80% of future sales forecasted. These are made 2 months in advance of expected sales.
  • Payments for these purchases are made in the next month after purchase.
  • Other expenses such as monthly wages and salaries are estimated at 5% of monthly forecast sales.
  • You are required to complete the 3-month (January, February, and March) cash budget below for HYD company. Note: Provide answers ONLY for coloured boxes A to X

November

December

January

February

March

April

May

Sales

50,000

60,000

70,000

85,000

98,000

100,000

110,000

Purchases

56,000

68,000

A

I

Q

Cash receipts / collections

Sales collected after one month

B

J

R

Sales collected after two months

C

K

S

Total cash receipts

D

L

T

Cash disbursements

Payments for purchases

E

M

U

Wages and Salaries

F

N

V

Total cash disbursements

G

O

W

Net change in cash

H

P

X

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Top Accounting And Auditing Issues For 2023

Authors: CCH Tax Law Editors

1st Edition

0808059335, 978-0808059332

More Books

Students also viewed these Accounting questions