Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DecorRetail buys and sells seasonal decoration items. The President has collected the following information about her operations as of December 31 : 1. Balances of

image text in transcribed
image text in transcribed
DecorRetail buys and sells seasonal decoration items. The President has collected the following information about her operations as of December 31 : 1. Balances of selected general ledger accounts: 2. Sales history and forecast (unit selling price. $10 ): 3. All sales are on credit. Fifty percent of a month's sales are collected one month after the sale; 45% are collected two months after the sale; and 5% are uncollectible. 4. DecorRetail wants to have 20% of next month's expected sales units as merchandise inventory. Cash payments for purchases are as follows: three-quarters in the month of purchase; onequarter in the month after the purchase. 5. Accounts payable as shown above relate solely to merchandise inventory purchases. Merchandise inventory costs are $5 per unit. 6. Other expenses average about 50% of the sales dollar amount. Depreciation is part of these expenses and costs $3,000 per month. All other cash-effective items are paid in the month incurred. 7. The company can borrow and repay in multiples of $500 from its line of credit at a rate of 8% per annum. It makes all borrowings from the line of credit at the beginning of a month and all repayments at the end of a month. It pays interest only on the portion of the short-term loan (line of credit) that is repaid. DecorRetail wants to maintain a minimum cash balance of $20,000. In April, DecorRetail plans to sell one of its short-term investments for $30,000. Tasks: Prepare a merchandise inventory budget and cash budget for January, Februar and the total of the two months in order to answer the following questions: Note: Only enter the numerical value, do not add a "plus" or "minus" sign. a) What are the accounts receivables at the end of February? 2 marks b) What are the total merchandise purchasing costs in January? 2 marks c) What are the merchandise accounts payables at the end of February? 2 marks d) What are the total cash receipts in January and February? 2 marks e) What are the total cash disbursements in January and February? 2 marks f) What is the amount borrowed in January? 2 marks g) What is the amount of interest paid in February? 2 marks h) What is the ending cash balance in April? 2 marks i) What is the ending balance of merchandise inventory in April? 2 marks

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_2

Step: 3

blur-text-image_3

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 Custom Edition For National American University

Authors: Charles T. Horngren, Walter T. Harrison Jr, M. Suzanne Oliver

9th Edition

1256297585, 978-1256297581

More Books

Students also viewed these Accounting questions