Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Allan Corporation has a sales budget for March of $ 440,000. About 10% are cash sales and the remainder is sold on account. The company

Allan Corporation has a sales budget for March of $ 440,000. About 10% are cash sales and the remainder is sold on account.

The company expects that 60% of credit sales will be collected in the month of the sale, 25% in the next month and 10% in the following month.

Materials purchased on account are expected to be $ 250,000. Allan pays 35% in the month of the purchase, 50% in the month following the purchase and the remaining 15% in the second month after the purchase.

Salaries and wages of the workers are approximately $ 45,000 per month. The employees are paid weekly so on average 95% of their wages are paid in the month to which they relate and the remaining 5% is paid in the following month.

Utilities average $ 4,300 per month.

Rent on the building is $ 9,000 per month.

Insurance is $ 3,000 per month and advertising costs are $ 1,000 per month.

February sales were $ 320,000 and purchases of materials in February were $ 170,000; January sales were $ 200,000 and purchases of materials in January were $ 130,000.

The cash balance on March 1st is $ 5,400.

Required:

A. Prepare a schedule of cash receipts for the month of March.

B. Prepare a schedule of cash payments (Accounts payable payments) for March.

C. Prepare a cash budget for the month of March for this company.

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_2

Step: 3

blur-text-image_3

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

No Nonsense Employee Retention Audit

Authors: Jeff Kortes

1st Edition

0988307014, 978-0988307018

More Books

Students also viewed these Accounting questions