Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The management of Pillay Limited decided to compile monthly cash budgets from January 2019 onwards. They provide the following information: Sales before any discounts

  All purchases are on credit. 75% of the purchases will be paid during the month ofpurchase and 25% will be paid during the e 

The management of Pillay Limited decided to compile monthly cash budgets from January 2019 onwards. They provide the following information: Sales before any discounts were taken into account: 1. Total Cash Credit R R October 2020 (Actual) 560 000 200 000 360 000 November 2020 (Actual) 710 000 290 000 420 000 December 2020 (Actual) 860 000 350 000 510 000 January 2021 (forecasted) 880 000 360 000 520 000 February 2021 (forecasted) March 2021 (forecasted) April 2021 (forecasted 920 000 380 000 540 000 980 000 410 000 570 000 1 060 000 450 000 610 000 The selling price and cost price per unit are R80 and R40 respectively. 2. The following discounts must be allowed on sales: 10% on cash sales 5% on credit sales if accounts are paid within 1 month after the month of sale 3. Accounts receivable normally settle their accounts as follows: 60% within 1 month after the month of sale 25% within 2 months after the month of sale 10% within 3 months after the month of sale 5% is irrecoverable 4. Budgeted indirect expenses: January 2021 R180 000 February 2021 R230 000 March 2021 R320 000 Indirect expenses include depreciation of R11 000 per month 5. Balances on 1 January 2021: Accounts payable R121 810 Inventory R254 000 Bank R87 500 All purchases are on credit. 75% of the purchases will be paid during the month of purchase and 25% will be paid during the ensuing month. A trade discount of 4% is allowed by suppliers on all payments during the month of purchase. The expected closing inventory for each month is 4 000 units plus 10% of the ensuing month's sales. 7. 8. Provisional tax of R200 000 must be paid on the 28th February 2019. Required: Prepare the cash budget of Pillay Limited, in columnar form for January and February 2019. Show all calculations.

Step by Step Solution

3.47 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Solution Currency is R Pillay Limited Cash Budget February 270150 January Opening Balance of Cash Re... 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

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions