Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Budget OJ Small Ltd. needs a cash budget for the month of April, 2021. The company's controller has provided you with the following

image text in transcribed

Cash Budget OJ Small Ltd. needs a cash budget for the month of April, 2021. The company's controller has provided you with the following information and assumptions: a. The April 1, 2021 cash balance is expected to be $11,000. b. All sales are on account. Credit sales are collected over a three-month period-50 percent in the month of sale, 35 percent in the month following sale, and 15 percent in the second month following sale. Actual sales for February and March were $100,000 and $90,000, respectively. April's sales are budgeted at $110,000. c. Marketable securities are expected to be sold for $25,000 during the month of April. d. The controller estimates that direct materials totalling $44,000 will be purchased during April. Sixty percent of a month's raw materials purchases are paid in the month of purchase with the remaining 40 percent paid in the following month. Accounts payable for March purchases total $9,000, which will be paid in April. e. During April, direct labour costs are estimated to be $19,000. f. Manufacturing overhead is estimated to be 40 percent of direct labour costs, Further, the controller estimates that approximately 10 percent of the manufacturing overhead is amortization on the factory building and equipment. g. Selling and administrative expenses are budgeted at $22,000 for April. Of this amount, $7,000 is for amortization. h. During April, OJ Small Company plans to buy a new delivery van costing $25,000. The company will pay cash for the van. . OJ Small Company owes $35,000 in income tax which must be paid in April. j. OJ Small Company must maintain a minimum cash balance of $10,000. To bolster the cash position when needed, an open line of credit is available from the bank. Required Prepare the following: 1. A schedule of cash collections for April (25 marks) 2. A schedule of cash payments for raw materials for April (25 marks) 3. A cash budget for the month of April. Indicate in the financing section any borrowing that will be necessary during the month. (Z marks)

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

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

Advanced Accounting

Authors: Joe Ben Hoyle, Thomas Schaefer, Timothy Doupnik

12th edition

77862228, 978-1259283567, 1259283569, 978-0077862220

More Books

Students also viewed these Accounting questions

Question

Find Io in the network shown using source transformation 3 4mA 12 3

Answered: 1 week ago

Question

Avoid evasiveness. Be direct with your answers when possible.

Answered: 1 week ago

Question

To establish a nondiscriminatory work environment. AppendixLO1

Answered: 1 week ago