Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

all of it if you can pls Coolidge Company is preparing a cash budget for the first three months of 2021. The following budgeted information

all of it if you can pls image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Coolidge Company is preparing a cash budget for the first three months of 2021. The following budgeted information is available: 2020 2021 Budgeted November December January February March Item: Sales $676,500 $717,500 $758,500 $738,000 $779,000 Direct Material Purchases $47,300 $49,900 $51,400 $52,100 $53,500 $287,300 $305,400 $316,700 $313,000 $320,400 Direct Labor Costs Overhead Costs $226,500 $232,100 $236,300 $235,700 $238,200 Selling and Admin $129,600 $132,000 $134,400 $133,200 $135,600 Costs All sales are on account. All direct material purchases are on account. All costs besides direct material purchases are paid as incurred. The overhead costs include $3,000 of monthly depreciation and the selling and administrative costs include $1,000 of monthly depreciation. In February, Coolidge must make a $2,200 cash dividend payment to preferred shareholders and in March, Coolidge must make a $15,000 installment payment on a note payable. The projected beginning balance of cash on January 1 is $5,000. Coolidge would like to maintain a minimum $5,000 cash balance. Required: Part A In the attached workpaper #2: 1. Using the collection pattern indicated on the workpaper, prepare a schedule of cash collection from sales for January, February, and March. (9 pts) 2. Using the payment pattern indicated on the workpaper, prepare a schedule of cash payments for direct materials for January, February, and March. (6 pts) 3. Prepare a cash budget for January, February, and March. (23 pts) Part B 1. What is the expected Accounts Receivable balance at the end of March? (3 pts) 2. What is the expected Accounts Payable balance at the end of March? (1 pt) 1. Prepare a schedule of cash collections from sales, SCHEDULE OF CASH COLLECTIONS FROM SALES November December CREDIT Sales January February March Cash Collections of CREDIT sales: 30%-Month of Sale 55% Month after Sale 15%-2 Months after Sale Total Collections of Credit Sales 2. Prepare a schedule of cash payments for materials SCHEDULE OF CASH PAYMENTS FOR DIRECT MATERIAL PURCHASES November December January DM Purchase Coats February March Cash Payment: 70%-Month of Purchase 30% 1 Month After Purchase Total Payments for Purchases 3. Propare a cash budget CASH BUDGET January February March Cash Rece: Cash Payment

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

Construction Auditing Planning Implementation Use

Authors: Peter Wotschke, Gregor Kindermann

1st Edition

3658388404, 978-3658388409

More Books

Students also viewed these Accounting questions