Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following information for Questions 1-7, which will appear on pages 2 and 3 of this exam. You will use the information to prepare

Use the following information for Questions 1-7, which will appear on pages 2 and 3 of this exam.

You will use the information to prepare elements of the ABC Company Budget for the 4th quarter (October, November, and December) of 2018.

The following balances were taken from the ABC Companys balance sheet on September 30, 2018:

Cash 25,000

Accounts Receivable 90,000

Inventory 30,000

Accounts Payable 54,000

The following information is also available and pertaining to ABC Company:

ABC sells one product that is priced at $10/unit. Sales for the months of October and November are expected to be 10,000 units, sales for December are expected to be 12,000 units, and sales for January are expected to be 9,000 units.

The company possessed 5,000 units of inventory as of September 30, 2018. They are required to have 50% of the following months projected sales available as an ending inventory. They purchase their inventory for $6/unit.

ABC pays their sales representatives a commission of 7.5% of sales. They pay their sales supervisors $3,000 per month. All salaries are paid in cash in the same month.

ABCs cash-based general and administrative expenses are $4,000 per month, and are all paid in cash in the same month. ABC has a depreciation expense of $250/month.

All sales are on credit, and all accounts receivable are collected in full during the month following the sale.

All purchases of inventory are on credit, and all accounts payable are paid in full during the month following the purchase.

The minimum cash balance that ABCs corporate policy requires is $10,000. If the monthly ending balance is below that amount, ABC must initiate a borrowing that requires a 1% monthly interest payment. As of September 30, there is no active borrowing. Excess cash balances above the minimum are to be used to repay active borrowings, if applicable.

Prepare the Cash Budget for the ABC Company for the 4th Quarter of 2018.

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

Business Accounting

Authors: Frank Wood, Alan Sangster

7th Edition

0273619829, 9780273619826

More Books

Students also viewed these Accounting questions

Question

How did Socrates challenge the relativism of Protagoras?

Answered: 1 week ago