Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

watson Watson Merchandiser sells baby lotion in Bangkok. The store is about to prepare its budgets for the first quarter of 2022. The following information

watson
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Watson Merchandiser sells baby lotion in Bangkok. The store is about to prepare its budgets for the first quarter of 2022. The following information has been assembled to assist in preparing the store's budgets of the quarter. a. Selected account balances from the post-closing trial balance on December 31, 2021 are as follows: Debit Credit Cash... Inventory........ Property, Plant, Equipment (net)...... Accounts Payable (from inventory purchased) Notes Payable.... $ 40,000 $ 145,800 $330,000 $ ? $5,000 The notes payable was issued on December 31, 2021. It is a 12% interest rate notes to be paid on March 31, 2022. b. Actual sales and budgeted sales are as follows (sales price per bottle $30): b. Actual sales and budgeted sales are as follows (sales price per bottle $30): Actual Sales Budgeted Sales 2021: November December $360,000 $ 420,000 2022: January February March April $540,000 $ 600,000 $ 750,000 $ 840,000 Sales are 25% for cash and 75% on credit. Sales on credit are collected as follows: - 80% collected in the first month following sales. - 15% collected in the second month following sales. - 5% is uncollectible C. The store maintains its ending inventory at 45% of the following month's cost of goods sold. d. The purchase cost per bottle of lotion purchased in the quarter is the same as the inventory purchased in 2021 ($ 18 per bottle). Inventory purchases are paid 60% in the month of purchase, and the remaining balance are paid in the following month. e. The store plans to purchase for cash the noncurrent assets as follows: Date of acquisition Assets Cost Date of acquisition Assets Cost January 1, 2022 Land $ 100,000 February 1, 2022 Equipment $ 40,000 Depreciation expense is computed at 12% per annum f. Monthly operating expenses are budgeted and paid when incurred as follows: Sales commission 5% of sales Delivery expense 2% of sales Salaries expense $ 15,000 Advertising expense $ 4,000 ** Depreciation expense $ 2,000 Bad debts expense ?% of credit sales Other expense 3% of sales ** Excluding depreciation of assets purchases of data (e), g. The company must maintain a minimum cash balance of $ 40,000. All borrowings are done at the beginning of a month, and all repayments are made at the end of a month. Borrowings and repayments of principal must be in multiples of $1,000. Interest is paid only when principal is repaid. The interest rate is 12% per annum. Required: Fill in the blanks of the following balances for the first quarter of 2022. Fill in only the amount. Dollar sign ($), and comma () are not required. Answer 1. Total gross profit of the quarter. 2. Total operating expenses in the income statement of the first quarter. 3. Total cash disbursements for operating expenses of the quarter. 4. Total inventory purchases of the quarter. 5. Total cash disbursements for inventory purchases in the first quarter. 6. Total cash collected from sales of the quarter. 7. Total cash disbursements of the quarter. 8. The amount of cash the store will borrow in January. 8. The amount of cash the store will borrow in January 9. Total cash repayments will be made in March. . 10. Interest expense in the income statement of the first quarter

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

Financial Accounting with IFRS Fold Out Primer

Authors: John Wild

5th edition

978-0077408770, 77408772, 978-0077413804

More Books

Students also viewed these Accounting questions