Answered step by step
Verified Expert Solution
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
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,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started