Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Dudley Merchandising Company has planned the following sales for the next three months: January February Budgeted Sales $40,000 $50,000 March $70,000 Sales are made

image text in transcribedThe Dudley Merchandising Company has planned the following sales for the next three months: January February Budgeted Sales $40,000 $50,000 March $70,000 Sales are made 20% in cash and 80% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Month of sale: 60% First month following sale: 30% Second month following sale: 8% Uncollectible: 2% Additional information is presented below: February purchases of merchandise inventory March purchases of merchandise inventory Monthly operating expenses, including $5,000 depreciation; cash affecting expenses are fully paid in the month incurred. Equipment purchases in March $15,000 $28,000 $45,000 $21,000 Dudley pays 70% of its inventory purchases in the month of purchase, the rest in the following month of purchase. Half of the equipment purchases are paid in the month of purchase and the balance in the first month following the purchase. Required: The company requires a minimum cash balance of $5,000 to start a month. Dudley has a line of credit with its bank that allows Dudley to borrow any amount up to $200,000. Its bank charges a simple interest rate of 1.8% per month on borrowed fund. Interest must be paid at the end of each month. All borrowing is assumed to occur at the beginning of a month. Dudley would repay amount borrowed as soon as it can at the end of each month. The cash balance on March 1 is budgeted to be $6,000. Using the budgeted cash receipts you computed for part a) and given data, prepare a cash budget in good form for the month of March. Calculate all amounts to the nearest full dollar.

Sales are made 20% in cash and 80% on account. From experience, the company has learned that a month's sales on account are collected according to the following pattern: Dudley pays 70% of its inventory purchases in the month of purchase, the rest in the following month of purchase. Half of the equipment purchases are paid in the month of purchase and the balance in the first month following the purchase. Required: The company requires a minimum cash balance of $5,000 to start a month. Dudley has a line of credit with its bank that allows Dudley to borrow any amount up to $200,000. Its bank charges a simple interest rate of 1.8% per month on borrowed fund. Interest must be paid at the end of each month. All borrowing is assumed to occur at the beginning of a month. Dudley would repay amount borrowed as soon as it can at the end of each month. The cash balance on March 1 is budgeted to be $6,000. Using the budgeted cash receipts you computed for part a) and given data, prepare a cash budget in good form for the month of March. Calculate all amounts to the nearest full dollar

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions