Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the budgeted cash disbursements during the month of February. Calculate the budgeted cash collection during the month of January Calculated budgeted number of units

  1. Calculate the budgeted cash disbursements during the month of February.
  2. Calculate the budgeted cash collection during the month of January
  3. Calculated budgeted number of units of inventory to be purchased during the month of March

Metlock State sells electronic products. The controller is responsible for preparing the master budget and has accumulated the information below for the months of January, February, and March. Balances at January 1 are expected to be as follows:

Cash

$5,720

Inventories

$321,800

Accounts receivable

432,700

Accounts payable

138,400

The budget is to be based on the following assumptions:

1. Each months sales are billed on the last day of the month.
2. Customers are allowed a 3% discount if their payment is made within 10 days after the billing date. Receivables are booked at gross.
3. The company collects 60% of the billings within the discount period, 25% by the end of the month after the date of sale, and 9% by the end of the second month after the date of sale; 6% prove uncollectible.
4. It pays 54% of all materials purchases and the selling, general, and administrative expenses in the month purchased and the remainder in the following month. Each months units of ending inventory are equal to 130% of the next months units of sales.
5. The cost of each unit of inventory is $20.
6. Selling, general, and administrative expenses, of which $2,100 is for depreciation, are equal to 15% of the current months sales.
7. Actual and projected sales are as follows:

Month

Sales

Units

November

$369,000 12,300

December

378,000 12,600

January

372,000 12,400

February

357,000 11,900

March

375,000 12,500

April

381,000

12,700

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

The ASQ Auditing Handbook

Authors: J. P. Russell

3rd Edition

0873896661, 978-0873896665

More Books

Students also viewed these Accounting questions

Question

Can workers be trained in ethics? How? Defend your answer.

Answered: 1 week ago