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 $6270 Inventories $352700
Accounts receivable 474400 Accounts payable 151700

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,300 is for depreciation, are equal to 15% of the current months sales.
7. Actual and projected sales are as follows:

Month Sales Units
November $405000 13500
December 414000 13800
January 408000 13600
February 390000 13000
March 411000 13700
April 417000 13900

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

Accounting What The Numbers Mean

Authors: David Marshall, Wayne William McManus, Daniel Viele

7th Edition

0073011215, 9780073011219

More Books

Students also viewed these Accounting questions

Question

What is the pecking order hypothesis?

Answered: 1 week ago

Question

Please solve and show all work!

Answered: 1 week ago

Question

What perspective or approach to talent would be appropriate?

Answered: 1 week ago

Question

What policies and practices for talent development are needed now?

Answered: 1 week ago