Use the information provided below to prepare the Cash Budget for October, November, and December 2021. Provide separate monetary columns for each month. INFORMATION 1. The following data and estimates are available for a project of Fego Limited for September to December 2021: September October November December R R R R Sales 130 000 110 000 120 000 140 000 Wages 40 000 34 000 38 000 39 000 Fixed overheads 16 000 16 000 16 000 16 000 Variable overheads 16 000 13 000 15 000 17 000 Materials purchases 17 000 14 000 16 000 18 000 2. Sixty percent (60%) of the sales are expected to be for cash and the balance on credit. Credit customers usually pay in the month after the sale. 3. Labour costs are paid for in the month in which they are incurred. 4. Fixed overheads include R5 000 each month for depreciation and payment is made monthly. 5. Variable overheads are paid for in the month after they are incurred. 6. Direct materials are purchased by electronic funds transfers each month. 7. The cash balance on 01 October 2021 is expected to be R30 000. 8. Ten percent (10%) of the sales for December 2021 will be invested in an interest-bearing account for a period of six months. Interest will be received upon maturity.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter4: Financial Planning And Forecasting
Section: Chapter Questions
Problem 4P
icon
Related questions
icon
Concept explainers
Question

Use the information provided below to prepare the Cash Budget for October, November, and December
2021. Provide separate monetary columns for each month.
INFORMATION
1. The following data and estimates are available for a project of Fego Limited for September to
December 2021:
September October November December
R R R R
Sales 130 000 110 000 120 000 140 000
Wages 40 000 34 000 38 000 39 000
Fixed overheads 16 000 16 000 16 000 16 000
Variable overheads 16 000 13 000 15 000 17 000
Materials purchases 17 000 14 000 16 000 18 000
2. Sixty percent (60%) of the sales are expected to be for cash and the balance on credit. Credit
customers usually pay in the month after the sale.
3. Labour costs are paid for in the month in which they are incurred.
4. Fixed overheads include R5 000 each month for depreciation and payment is made monthly.
5. Variable overheads are paid for in the month after they are incurred.
6. Direct materials are purchased by electronic funds transfers each month.
7. The cash balance on 01 October 2021 is expected to be R30 000.
8. Ten percent (10%) of the sales for December 2021 will be invested in an interest-bearing account for a
period of six months. Interest will be received upon maturity.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College