Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started