Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello this is management accounting homework im struggling with my homework and i was wondering if anyone could help me correct it if i have

hello this is management accounting homework im struggling with my homework and i was wondering if anyone could help me correct it if i have any mistakes all the information is provided below thank you so much i appreciate it

image text in transcribedimage text in transcribed
Kat Lid.'s September balance sheet contains the following Information: Cash $ 37,500 ( dr) Accounts receivable. 126,000 (dr) Allowance for doubtful accounts 2,800 (er ) Merchandise inventory 26,250 (dr ) 04:16:22 Management has designated $37,500 as the firm's minimum monthly cash balance. Other information about the firm and its operations s as follows: a. Sales revenues of $350,000, $420,000, and $312,500 are expected for October, November, and December, respectively. All goods are sold on account. b. The collection pattern for accounts receivable is 60% in the month of sale, 39% in the month following the month of sale, and 1% uncollectible, which is set up as an allowance. c. Cost of goods sold is 60% of sales revenues. d. Management's target ending balance of merchandise inventory is 10% of the current month's budgeted cost of goods sold. e. All accounts payable for inventory are paid in the month of purchase. f. Other monthly expenses are $49,250, which Includes $3,500 of depreciation and $2,000 of bad debt expense. g. In the event of a shortfall, the company borrows money. In contrast, In the event of excess cash, the company invests in short-term Investments. Borrowings and investments are assumed to be made at the end of a month in Increments of $6,250. h. Interest on borrowings is 10% per year, payable every quarter, on the accumulated amount of the loan; similarly, Interest earned on Investments is 8% per year on the accumulated investments and is received every quarter. Investments can be matured and the principal amount redeemed in June or December of a year. Required: 1. Prepare a merchandise purchases budget for October and November. Kat Ltd. Merchandise Purchases Budget October November December Budgeted cost of goods sold $ 210,000 $ 252,000 $ 187,500 Add: Desired ending inventory 21,000 25,200 18,750 Total needs 231,000 277.200 206,250 Deduct: Beginning inventory 26.250 21,000 25,200 Required inventory purchases $ 204.750 $ 256,200 $ 181,0502. Prepare the cash budgets for October and November, including the effects of financing (borrowing or investing). Interest is earned or paid quarterly. (Any "Repayments" and "Interest" should be Indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required.) Kat Ltd. Cash Budget October November Cash balance, beginning $ 37,500 5 40,950 Add: Collections from sales 333,200 385,500 Total cash available 370,700 429,450 Deduct: Disbursements: Purchases for inventory 204,750 256,200 Monthly expenses 43,750 43,750 Total disbursements 248,500 299,950 Excess (deficiency) of cash 122,200 129,500 Financing: Investments 31,250 87,500 Borrowings Repayments 0 Interest 0 Total financing (81,250) (87,500) Cash balance, ending S 40,950 5 42,000

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

Accounting Best Practices

Authors: Steven M Bragg

7th Edition

1118404149, 9781118404140

More Books

Students also viewed these Accounting questions

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago

Question

Do not come to the conclusion too quickly

Answered: 1 week ago

Question

Engage everyone in the dialogue

Answered: 1 week ago