Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Glob and Dream Company provides the budgeting information for the first two quarters of the coming year 2020; First quarter Second quarter No of sales

Glob and Dream Company provides the budgeting information for the first two quarters of the coming year 2020;

First quarter

Second quarter

No of sales

unit 22,500

unit 20,800

Purchasing costs

RM 290,000

RM 350,000

Capital Additions (new machine)

RM 250,000

__--------___

Selling and Administrative expenses

RM 41,400

RM 46,400

The company expects to sell their units in the first quarter by RM 20 per unit and the price will increase by 25% in the second quarter. Based on the past experiences, the sales department in the company expects to sell about 35% of the total products for cash and only 80% of the sales on account will be collected in full in the first quarter and the remainder in the second quarter.

The company comes to an agreement with the suppliers that one-fourth of the total purchase in each quarter will be paid in the same quarter and the balance will be paid in the following quarter. Amongst the quarterly selling and administration expenses RM6,400 presents property taxes and depreciation. The property tax will be paid by the end of the third quarter however, RM40,000 part of income taxes will be paid on the second quarter. Of the remainder of the selling and administrative expenses; 50% will be paid in the quarter in which they are incurred and the other 50% will be paid in the following quarter. The company has a plan to expand its business and buy a new machine which will cost RM250,000 and it will be paid in the first

The beginning balances in the first quarter are Cash RM45000, Accounts receivable RM51000 and Account payable RM121,500 (RM102,000 for materials purchases and RM19,500 for selling and administrative expenses). Based on the company policy, it is important to maintain a minimum cash balance of RM 25,000 at the end of each quarter.

Required:

Prepare the cash budget of this company for the first and second quarter of the year 2020

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_2

Step: 3

blur-text-image_3

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

Financial Statements Analysis Cases From Corporate India

Authors: Sandeep Goel

1st Edition

1138663921, 9781138663923

More Books

Students also viewed these Accounting questions