Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following budgeted statement of profit or loss has been prepared for Quest Ltd for the four months January to March Year5 January R February

The following budgeted statement of profit or loss has been prepared for Quest Ltd for the four months January to March Year5

January R February R March R
Sales 60 000 50 000 70 000
Cost of production 50 000 55 000 32 000
Increase/ decrease in inventory (5 000) (17 500) 20 000
Cost of sales 45 000 37 500 52 500
Gross profit 15 000 12 500 17 500
Administration and selling overhead (8 000) (7 500) (8 500)
Net Profit before interest 7 000 5 000 9 000

Additional Information

  1. Forty percent of the production cost relates to direct materials. Materials are bought in the month prior to the month in which they are used. Purchases are paid for one month it is uncured.
  2. The remainder of the production cost is production overhead. R5 000 per month is a fixed cost which includes R3 000 depreciation. Fixed production overhead costs are paid for when incurred. The remaining overhead is variable. Forty percent of the variable production overhead is paid for in the month of usage and the balance one month later. Unpaid variable production overhead at the beginning of January is R9 000.
  3. The administration and selling costs are paid quarterly in advance on 1 January, 1 April, 1 July and1 October. The amount payable is R15 000 per quarter.
  4. All sales are on credit. Twenty percent of the receivables are expected to be paid in the month of sale and 80% in the following month. Unpaid trade receivables at the beginning of January were R44 000.
  5. The bank balance on 1 January Year 5 is expected to be R5 000 overdrawn.

REQUIRED

Complete the cash budget for each of the months: January and February Year 5 for Quest Ltd.

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

Research Methods And Audit In General Practice

Authors: David Armstrong, John Grace

1st Edition

0192624547, 978-0192624543

More Books

Students also viewed these Accounting questions

Question

What is the weighted average cost of capital?

Answered: 1 week ago