Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A Company expects to have a cash balance of $100,000 on February 28, 2021. A Company wants to maintain a minimum monthly cash balance

image text in transcribed

A Company expects to have a cash balance of $100,000 on February 28, 2021. A Company wants to maintain a minimum monthly cash balance of $80,000. All costs are paid as incurred. Relevant monthly budget data for March 2021 are as follows: A Company's sales are 40% cash and 60% credit. Credit sales are collected 20% in the month of sale, 50% in the month following sale, and 26% in the second month following sale; 4% are uncollectible. The sales in January, February, March are respectively $305,000, $350,000, and $360,000. A Company's purchases are 30% cash and 70% credit. Purchases on account are paid 60% in the month following purchase, and 40% in the second month following purchase. The purchases in January, February, March are respectively $230,000, $220,000, and $210,000. Direct labor incurred in March 2021 : $95,000 Manufacturing overhead excluding the monthly depreciation of $5,000: $69,500 Selling and administrative expenses including the monthly depreciation $ 2,000: $53,600 Marketable securities of $50,000 can be sold if needed for addition cash. The cash budget for March 2021 will be: A Company Cash Budget For the month ended 31 March 2021 Beginning cash balance add Collection from customers Sales of securities Total Receipts Total Available Cash less Direct Material Direct Labor Manufacturing Overhead Selling & Administrative Expenses Total Disbursements Excess (Deficiency) of available cash over cash disbursement Financing A B C D 95,000 E F G

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

Managerial Accounting

Authors: Stacey Whitecotton, Robert Libby, Fred Phillips

2nd edition

9780077493677, 78025516, 77493672, 9780077826482, 978-0078025518

More Books

Students also viewed these Accounting questions