Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please check my work . BUT I'm having trouble doing Budgeted cash disbursements for merchandise purchases , Scheduled of expected cash collections and #3. Just

Please check my work . BUT I'm having trouble doing Budgeted cash disbursements for merchandise purchases , "Scheduled of expected cash collections" and #3. Just want to understand it. Thank you December of the previous year 50,000, January70,000, February 100,000, March60,000, April100,000. Past experience shows that 45% of sales are collected in the month of the sale, and 55% in the month following the sale.

2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $35.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time delivery of the product. Also assume that currently it is company policy that ending inventory should equal 45% of next months projected sales. All costs are paid in the current month except inventory purchases, which are paid in the month following the purchase (i.e. January purchases are paid in February).

3. Prepare a cash budget for January through March and for the first quarter in total. The company maintains a minimum cash balance of $70,000, and this was the balance in the cash account on January 1st. Other expenses include $35,000 per month for rent, $24,000 per month for advertising, and $66,000 per month for depreciation. In addition, variable Selling & Administrative cost is $12 per unit sold, and the company paid a $20,000 dividend in February.

The company has an open line of credit with a bank and can borrow at an annual rate of 12%. For simplification assume that all loans are made at the beginning of the month when borrowing is needed, and repayments are made at the end of a month if there is enough cash to make the payment. Also, interest associated with a loan is only paid at the time when that loan or a portion thereof is paid. Additionally, all loans and repayments (not the interest portion) can only be made in increments of $1000 and the company would like to pay its debts, or a portion thereof, as soon as it has enough cash to do so.

Budgeted unit sales 50,000 70,000 100,000 60,000 230,000 100,000
Selling price per unit $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Total sales $2,500,000 $3,500,000 $5,000,000 $3,000,000 $11,500,000 $5,000,000
Scheduled of Expected Cash Collections
January February March Total
Beginning accounts receivable (December) $750,000
January
February
March
Total cash collection

December January February March Total
Budgeted unit Sales 50,000 70,000 100,000 60,000 230,000
Add desired ending merchandise inventory 35,000 45,000 27,000 45,000 117,000
Total needs 120,000 130,000 110,000 360,000
Less beginning merchandise inventory 31,500 45,000 27,000 103,500
Required purchases - 88,500 85,000 83,000 256,500
Unit product cost $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00
Cost of inventory purchases $ - $ 3,097,500 $ 2,975,000 $ 2,905,000 $ 8,977,500
Budgeted cash disbursements for merchandise purchases:
For the first quarter ended March 2020
Quarter 1
January February March Total
Beginning accounts payable (December)
January purchases
February purchases
March purchases
Total cash disbursements for merchandise purchases $ - $ - $ - $ -
Beginning cash balance
add cash receipts
Cash collections from customers
Total cash available
Less cash disbursements
Total cash disbursements for merchandise purchases
Cash from Selling and administrative
Dividend
Total cash disbursements
Excess (deficiency) of cash available over disbursements
Financing
Borrowing (at the beginnings of the month)
Repayments (at end of the month)
Interest
Total financing
Ending cash balance

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

Auditing The Ultimate Guide To Performing Internal And External Audits

Authors: Greg Shields

1st Edition

1647483344, 978-1647483340

More Books

Students also viewed these Accounting questions

Question

What would you do if the bullies and victim were girls?

Answered: 1 week ago