Below is selected information for ABC Company Inc. The table summarizes the various operating budgets for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Below is selected information for ABC Company Inc. The table summarizes the various operating budgets for the quarter ending March 31, 2023. Assume that all sales are on account. 75% of the accounts receivable are collected in the month of sale and 25% are collected in the month after sale. On 12/31/2022, the balance in Accounts Receivable was $306,300. Assume that all purchases of direct materials are on account. 55% of the credit purchases are paid in the month of purchase and 45% are paid in the month after purchase. On 12/31/2022, the balance in Accounts Payable was $120,595. Included in the monthly fixed factory overhead costs is $16,800 in depreciation. Included in the monthly fixed selling and administrative costs is $2,500 in depreciation. The cash balance on December 31, 2022, is $100,500. Beginning on January 31, 2023, management wants to maintain a cash balance of at least $800,000. Each month, ABC will pay a $12,500 dividend. ABC plans on purchasing a $500,000 machine in February. ABC has an open line of credit with Bank of America. The rate is 8%. Per the agreement, borrowing and repayments must be in $1,000 increments. ABC will borrow on the first day of the month in which it expects a deficiency, and it will repay as much as it can on the last day of the month in which it has funds that exceed the required minimum cash balance. Interest is paid only when the principal or a fraction thereof is repaid. Except for the $1,000 borrowing and repayment increments, round all computations to the nearest dollar. ABC Company Inc. Selected Data For the Quarter Ending March 31, 2023 Total budgeted sales Total budgeted cost of direct materials purchases Total budgeted cost of direct labor Total budgeted factory overhead Total budgeted selling and admnistrative expense January February March $1,356,000 $1,350,000 $1,392,000 $ 169,418 $ 169,579 $ 176,051 $ 515,048 $ 180,720 $ 180,560 $ 187,040 $548,320 $ 97,860 $ 97,830 $ 99,045 $ 294,735 279,500 $ 828,100 $ 274,700 $ 273,900 $ Quarter $4,098,000 Required 1. Prepare a schedule of expected cash collections from customers. 2. Prepare a schedule of expected cash payments for materials purchases. 3. Prepare a cash budget (use the format below). Below is selected information for ABC Company Inc. The table summarizes the various operating budgets for the quarter ending March 31, 2023. Assume that all sales are on account. 75% of the accounts receivable are collected in the month of sale and 25% are collected in the month after sale. On 12/31/2022, the balance in Accounts Receivable was $306,300. Assume that all purchases of direct materials are on account. 55% of the credit purchases are paid in the month of purchase and 45% are paid in the month after purchase. On 12/31/2022, the balance in Accounts Payable was $120,595. Included in the monthly fixed factory overhead costs is $16,800 in depreciation. Included in the monthly fixed selling and administrative costs is $2,500 in depreciation. The cash balance on December 31, 2022, is $100,500. Beginning on January 31, 2023, management wants to maintain a cash balance of at least $800,000. Each month, ABC will pay a $12,500 dividend. ABC plans on purchasing a $500,000 machine in February. ABC has an open line of credit with Bank of America. The rate is 8%. Per the agreement, borrowing and repayments must be in $1,000 increments. ABC will borrow on the first day of the month in which it expects a deficiency, and it will repay as much as it can on the last day of the month in which it has funds that exceed the required minimum cash balance. Interest is paid only when the principal or a fraction thereof is repaid. Except for the $1,000 borrowing and repayment increments, round all computations to the nearest dollar. ABC Company Inc. Selected Data For the Quarter Ending March 31, 2023 Total budgeted sales Total budgeted cost of direct materials purchases Total budgeted cost of direct labor Total budgeted factory overhead Total budgeted selling and admnistrative expense January February March $1,356,000 $1,350,000 $1,392,000 $ 169,418 $ 169,579 $ 176,051 $ 515,048 $ 180,720 $ 180,560 $ 187,040 $548,320 $ 97,860 $ 97,830 $ 99,045 $ 294,735 279,500 $ 828,100 $ 274,700 $ 273,900 $ Quarter $4,098,000 Required 1. Prepare a schedule of expected cash collections from customers. 2. Prepare a schedule of expected cash payments for materials purchases. 3. Prepare a cash budget (use the format below).
Expert Answer:
Answer rating: 100% (QA)
a Schedule of expected cash collections it indicates the time frame within which cash receipts are expected from customers b Schedule of cash payments it indicates the expected cash payments from purc... View the full answer
Related Book For
Managerial Accounting
ISBN: 9781260247787
17th Edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these general management questions
-
In his preliminary cash budget, Barnes has assumed that all sales are collected and, thus, that SKI has no bad debts. Is this realistic? If not, how would bad debts be dealt with in a cash budgeting...
-
At Morris Mart Inc., all sales are on account. Mary Morris-Manning is responsible for mailing invoices to customers, recording the amount billed, opening mail, and recording the payment. Mary is very...
-
Below is selected information from Tripe Corp: Return on Common Equity for Year 1 is: A) 19.0% B) 19.60% C) 21.08% D)26.03% ear ear Net operating assets /common equity Net operating profit margin...
-
Burke Fabricators completed two jobs in June. Burke Fabricators recorded the following costs assigned to the jobs by the companys activity-based costing system: Job 622 required 2,400 parts, 77,500...
-
From the following data, compute the working capital for Monson Equipment Co. at December 31, 2008. Cash in general checking account . . . . . . . . . . . . . . . . . . . $ 25,000 Cash in fund to be...
-
What is a balanced transportation model? Describe the approach you would use to solve an unbalanced model.
-
For the following problems, propose a verification and validation tests of the CFD solution. a) Flow in confluence of two rivers. b) Wind flow around a smokestack of a coal power station and the...
-
Samantha A. Cranston, age 37, is single and lives with her dependent mother at 426 Grouse Avenue, Allentown, PA 18105. Her Social Security number is 111-21-1113. 1. Samantha is a licensed...
-
Which one of the following is NOT a core feature for a general AIS system? a. Data/File management b. Communication management c. Module / Package / Application management d. User management In a...
-
The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of...
-
An audience centered approach to communication involves Select one: a. embedding a layer of technology between you and your audience members. b. saying whatever it takes to win over the members of...
-
A rigid container of 0.2 kg R-134a at a quality of 0.4 is heated such that the temperature increases by 111.65 F. The container is originally at a pressure of 500 kPa. Note: you can use interpolation...
-
If D 0 = $2.25, g (which is constant) = 3.5%, and P 0 = $60, what is the stock's expected dividend yield for the coming year?
-
What are closed-end funds? Why do some closed-end funds use leverage to raise more funds rather than issue new shares like mutual funds? Why might the price of a share of a closed-end fund diverge...
-
A piston-cylinder system in an automobile engine contains 0.15 liters of air at 80 kPa and 18C. The air in the cylinder is compressed through a quasi-static polytropic process (n = 1.4) with a volume...
-
a rolling company bond has a coupon rate of 4%, 14 years to maturity and a current price of $1086. what is the YTM? what is the current yield?
-
Garlington Technologies Inc.'s 2019 financial statements are shown below: Income Statement for December 31, 2019 Sales $4,000,000 Operating costs 3,200,000 EBIT $800,000 Interest 120,000 Pre-tax...
-
Cassandra Casey operates the Futuristic Antique Store. She maintains subsidiary ledgers for accounts payable and accounts receivable. She presents you with the following information for October 2019:...
-
The following cost data pertain to the operations of Montgomery Department Stores, Inc., for the month of July. Corporate legal office salaries . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
What is a relevant cost?
-
Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided...
-
You are presented with the following forecast information relating to Baker Limited for the nine months to 30 September 2007. Forecast profit and loss accounts (abridged) for the three quarters to 30...
-
The accountant of a private company has been able to get the use of a computer to produce the spreadsheets shown below but as yet the computer lacks a program to print out final accounts. The...
-
The following information has been extracted from the draft financial information of V Ltd: Dividend paid = 52,000 (a) You are required to prepare a cash flow statement for V Ltd for the year ended...
Study smarter with the SolutionInn App