The management of Pillay Limited decided to compile monthly cash budgets from January 2019 onwards. They...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
Solution Currency is R Pillay Limited Cash Budget February 270150 January Opening Balance of Cash Re... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Discuss what considerations were taken into account by the computer operator in deciding in what sequences programs would be run on early computer systems that were manually operated.
-
Describe some of the economic impacts of collaborative consumption. Would companies like Airbnb and Uber help economies or hurt them? Why?
-
A spherical volume of radius 0.2m has a positive charge of 300 C is uniformly distributed throughout it. Find E and V everywhere. Draw a graph of E and V as a function of radius from the center of...
-
Considerations that affect the selection of an inventory costing method do not include: (a) tax effects. (b) balance sheet effects. (c) income statement effects. (d) perpetual vs. periodic inventory...
-
Setting standards for a product may involve many employees of the company. Identify some of the employees who may be involved in setting the standard costs, and describe what their role might be in...
-
Below are some typical transactions incurred by Kwun Company? 1. Payment of creditors on account. 2. Return of merchandise sold for credit. 3. Collection on account from customers. 4. Sale of land...
-
Riverwood International Corporation, a leading provider of paperboard, announced the following: Discuss why, and under what conditions, FIFO might enable Riverwood International to more closely match...
-
An investment analyst has data for the past 8 years on each of two mutual funds, with the annual rates of return for each listed in file XR11074. On average, each fund has had an excellent annual...
-
Q12.14 Finney Inc. is a construction company specializing in commercial real estate projects. Finney has contracted with the Perry Companies to build an office building for $20 million. Finney esti-...
-
Alex Yeoman Painting Co. of Yellowknife uses a purchases journal (page 21) and a general journal (page 32) to record the following transactions. The GST rate is 5%. The paint store has decided to...
-
CASE 7.2 Advantage Research, Inc. Joe Spivey is president of Advantage Research, Inc. The firm specializes in customized research for clients in a vari- ety of industries via computer-assisted mall...
-
## Ex18: Plotly-TimeSeries ## Objective: Use Python to create a time series chart that displays the stock prices of IBM, Google and Airbnb for an 18-month period from 1-Jan-2022 to 1-Jun-2023....
-
The cash balance per books for Wellmeyer Company on November 30, 2010, is $10,740.93. The following checks and receipts were recorded for the month of December 2010: Checks Receipts No. Amount No....
-
How does the vendor benefit in a vendor-managed inventory system? The vendor is able to grow its sales and its business. The vendor gets to do more work. The vendor gains a business for the long term...
-
Nieman Company purchased merchandise on account from Springhill Company for $10,200, terms 2/10, n/30. Nieman returned merchandise with an invoice amount of $1,600 and received full credit. a. If...
-
The Milikan experiment can be performed with latex microspheres, each with a mass of 2 . 2 x 1 0 ^ - 1 5 kg . What voltage is needed to balance a sphere with an excess charge of 9 electrons between...
-
0.36k -0.48k -0.48k 0.64k -0.36k1 0.48k 0.48k 0 0 -0.64k 0 0 -0.36k 0.48k 0.36 (kk) 0.48 (-k+k) -0.36k2 -0.48k2 [KM] = 0.48k -0.64k 0.48 (-k + k) 0.64 (k + k) -0.48k2 -0.64k 0 0 -0.36k -0.48k 0.36k...
-
Global.asax is used for: a. declare application variables O b. all other answers are wrong O c. declare global variables O d. handle application events
-
This project demonstrates how Excel can be used to create a variety of useful documents for small businesses. a. Read the article A Do-It-Yourself Automated Invoicing System, by Jacob M. Rose, which...
-
Modify Table 11-1 by indicating if each specific control procedure listed there is preventive (P), detective (D), or corrective (C) in nature. Table 11-1 Threats and Controls in the Expenditure Cycle...
-
The receiving department at Culp Electronics Company processes inventory deliveries upon arrival by means of online data terminals located on the receiving dock. Each inventory receipt entered into...
Study smarter with the SolutionInn App