Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Al Noor Company is a trading company that sells one product. The company has planned inventory, production, and unit sales for the next three months

Al Noor Company is a trading company that sells one product. The company has planned inventory, production, and unit sales for the next three months as follows:

October

November

December

Inventory at the beginning of the period

500

500

500

Purchases of goods

5000

7000

6000

sales

4000

4000

4000

Closing stock

1500

3500

2500

The unit is sold at a price of 15 riyals. Half of the value is paid in the same month of sale and the rest is paid in the following month. Accounts receivable on September 30 are 1000 riyals.

The goods are purchased at 4 per unit. Half of the value is paid in the same month of purchase and the remainder is paid in the following month of purchase. The planned selling and administrative expenses, which will be paid monthly, 5000 riyals per month. Transfer expenses per month 6000 riyals, including 500 riyals depreciation on equipment. The balance of accounts payable on September 30 is 13000 riyals.

The cash balance on September 30 is estimated at 10,000 riyals. The value of purchasing equipment will be paid during the month of November at a value of 6,000 riyals, and a dividend of 9,000 riyals will be paid during December. The company wants to keep a minimum of 10,000 riyals of cash at the end of each month

Required:

a. Prepare a table of expected cash collections for each of the three months, October, November, and December. B. Create a schedule of expected cash payments for purchases for each of the three months, October, November, and December. c. Prepare the projected cash budget for each of the three months, October, November, and December.

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 Statement Analysis And Earnings Forecasting In Accounting

Authors: Steven J Monahan

1st Edition

1680834509, 978-1680834505

More Books

Students also viewed these Accounting questions