Questions
Use the following information to answer questions 23 to 30. In order to ascertain clarity on...

Use the following information to answer questions 23 to 30. In order to ascertain clarity on how much cash Musa (Pty) Ltd needs each month, complete the cash budget using the information below. Sales (in rand) are as follows:

:June

July

August

September

October

November

950 000

1 100 000

1 300 000

1 450 000

1 600 000

1 850 000

Of the company’s sales, 40% are done in cash. Credit sales are collected as follows: 

40% during the month of sale 

20% during the first month following the month of sale 

20% during the second month following the month of sale 

20% during the third month following the month of sale

Purchases are as follows:

June

July

August

September

October

November

530 000

600 000

300 000

715 000

880 000

1 000 000

All purchases are on credit and are paid as follows: 

40% during the month of purchase 

30% during the first month following the month of purchase 

15% during the second month following the month of purchase 

15% during the third month following the month of purchase

Other information 

Salaries and wages of R100 000 are paid monthly 

Rent of R50 000 on a monthly basis 

Interest on debt of R4 000 each month

Major maintenance on machines and plant amounting to R1 500 000 in October was undertaken. 

Depreciation costs of R20 000 is charged on a monthly basis 

At the beginning of September, the business will have R50 000 in cash 

The management of the company has a policy of maintaining R50 00 minimum cash balance.

Requirements:

Compile the cash budget for Musa (Pty) Ltd for the months of September, October and November. Also indicate the financing needed to maintain the minimum cash balance and meet the operational requirements.

Question 23

Calculate the total credit sales collected for October.

1. R846 000

2. R896 000

3. R950 000

4. R986 000

Question 24

Calculate the opening balance for October.

1. R430 000

2. R585 800

3. R680 500

4. R720 200

Question 25

Calculate the total credit purchases collected for September.

1. R360 000

2. R460 000

3. R520 500

4. R545 500

Question 26

Calculate the total credit sales collected for November.

1. R566 000

2. R700 000

3. R966 000

4. R975 000

Question 27

Calculate the financing required for October.

1. R239 000

2. R397 500

3. R405 000

4. R515 000

Question 28

Calculate the financing required for November.

1. R154 000

2. R297 500

3. R496 750

4. R515 000

Question 29 Calculate the cash sales for September. 1. R340 000 2. R580 000 3. R650 000 4. R700 000 .

Question 30 Calculate the credit purchases for June that were collected in September. 1. R114 000 2. R140 000 3. R160 000 4. R170 000

In: Finance

Natalie has prepared the balance sheet and income statement of Cookie & Coffee Creations Inc. and...

Natalie has prepared the balance sheet and income statement of Cookie & Coffee Creations Inc. and would like you to prepare the cash flow statement. The comparative balance sheet of Cookie & Coffee Creations Inc. at October 31, 2023 for the years 2023 and 2022 and the income statement for the year ended October 31, 2023, are presented below.

COOKIE & COFFEE CREATIONS INC.
Balance Sheet
October 31,
Assets 2023 2022

Cash

$29,074 $11,550

Accounts receivable

3,250 2,710

Inventory

7,897 7,450

Prepaid expenses

5,800 6,050

Equipment

102,000 75,500

Accumulated depreciation— equipment

(25,200) (9,100)

Total assets

$122,821 $94,160
Liabilities and Stockholders’ Equity 2018 2017

Accounts payable

$1,150 $2,450

Income taxes payable

9,251 7,200

Dividends payable

27,000 27,000

Salaries and wages payable

7,250 1,280

Interest payable

188 0

Note payable

10,000 0

Preferred stock, no par, $6 cumulative, 3,000 and 2,800 shares issued, respectively

15,000 14,000

Common stock, $1 par—25,930 shares issued and outstanding

25,930 25,930

Additional paid-in capital—treasury stock

250 0

Retained earnings

26,802 16,800

Less: Treasury stock

0 (500)

Total liabilities and stockholders’ equity

$122,821 $94,160
COOKIE & COFFEE CREATIONS INC.
Income Statement
Year Ended October 31, 2023

Sales

$485,625

Cost of goods sold

222,694

Gross profit

262,931

Operating expenses

Salaries and wages expense

$147,979

Depreciation expense

17,600

Other operating expenses

48,186 213,765

Income from operations

49,166

Other expenses

Interest expense

$413

Loss on disposal of plant assets

2,500 2,913

Income before income tax

46,253

Income tax expense

9,251

Net income

$37,002


Additional information:

1. Equipment (cost $4,500 and book value $3,000) was disposed of at the beginning of the year for $500 cash and replaced with new equipment purchased for $4,000 cash.
2. Additional equipment was bought for $14,000 on November 1, 2022. A $12,000 note payable was signed. The terms provide for equal semi-annual installment payments of $2,000 on May 1 and November 1 of each year, plus interest of 5% on the outstanding principal balance.
3. Other equipment was bought for $13,000 cash.
4. Dividends were declared on the preferred and common stock on October 15, 2023, to be paid on November 15, 2023.
5. Accounts payable relate only to merchandise creditors.
6. Prepaid expenses relate only to other operating expenses.

Prepare a statement of cash flows for Cookie & Coffee Creations Inc. for the year ended October 31, 2023, using the indirect method. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)Partially correct answer iconYour answer is partially correct.

Prepare a statement of cash flows for Cookie & Coffee Creations Inc. for the year ended October 31, 2023, using the direct method. (Show amounts in the investing and financing sections that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)

$Enter a dollar amount

In: Accounting

Bank Reconciliation and Entries The Coins, currency (paper money), checks, money orders, and money on deposit...

  1. Bank Reconciliation and Entries

    The Coins, currency (paper money), checks, money orders, and money on deposit that is available for unrestricted withdrawal from banks and other financial institutions.cash account for Collegiate Sports Co. on November 1 indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The A summary of all transactions mailed to the depositor or made available online by the bank each month.bank statement indicated a balance of $112,675 on November 30. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:

    1. Checks outstanding totaled $41,840.
    2. A deposit of $12,200, representing receipts of November 30, had been made too late to appear on the bank statement.
    3. A check for $7,250 had been incorrectly charged by the bank as $2,750.
    4. A check for $760 returned with the statement had been recorded by Collegiate Sports Co. as $7,600. The check was for the payment of an obligation to Ramirez Co. on account.
    5. The bank had collected for Collegiate Sports Co. $7,385 on a note left for collection. The face of the note was $7,000.
    6. Bank service charges for November amounted to $125.
    7. A check for $2,500 from Hallen Academy was returned by the bank because of insufficient funds.

    Required:

    1. Prepare a bank reconciliation as of November 30.

    Collegiate Sports Co.
    Bank Reconciliation
    November 30
    Cash balance according to bank statement $
    • Add bank error in charging check as $2,750 instead of $7,250
    • Add bank service charges
    • Add deposit of November 30, not recorded by bank
    • Add outstanding checks
    • Add note and interest collected by bank
    $
    • Deduct bank service charges
    • Deduct check returned because of insufficient funds
    • Deduct deposit of November 30, not recorded by bank
    • Deduct outstanding checks
    • Deduct note and interest collected by bank
    $
    • Deduct bank error in charging check as $2,750 instead of $7,250
    • Deduct bank service charges
    • Deduct deposit of November 30, not recorded by bank
    • Deduct error in recording check by Collegiate Sports Co.
    • Deduct proceeds of note collected by bank, including $100 interest
    Adjusted balance $
    Cash balance according to company's records $
    • Add bank error in charging check as $2,750 instead of $7,250
    • Add bank service charges
    • Add check returned because of insufficient funds
    • Add deposit of November 30, not recorded by bank
    • Add note and interest collected by bank
    $
    • Add bank service charges
    • Add cash balance according to company's records
    • Add deposit of November 30, not recorded by bank
    • Add error in recording check as $7,600 instead of $760
    • Add outstanding checks
    $
    • Deduct check returned because of insufficient funds
    • Deduct deposit of November 30, not recorded by bank
    • Deduct error in recording check by Collegiate Sports Co.
    • Deduct outstanding checks
    • Deduct note and interest collected by bank
    $
    • Deduct bank service charges
    • Deduct deposit of November 30, not recorded by bank
    • Deduct error in recording check by Collegiate Sports Co.
    • Deduct outstanding checks
    • Deduct note and interest collected by bank
    Adjusted balance $

    Feedback

    2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. For a compound transaction, if a box does not require an entry, leave it blank.

    a. Nov. 30
    • Accounts Payable-Ramirez Co.
    • Accounts Receivable-Ramirez Co.
    • Cash
    • Interest Revenue
    • Notes Receivable
    • Cash
    • Cash Short and Over
    • Interest Receivable
    • Miscellaneous Administrative Expense
    • Notes Receivable
    • Accounts Receivable-Hallen Academy
    • Interest Revenue
    • Petty Cash
    • Sales
    • Unearned Interest
    • Accounts Payable-Ramirez Co.
    • Accounts Receivable-Ramirez Co.
    • Cash
    • Cash Short and Over
    • Sales
    b. Nov. 30
    • Accounts Payable-Hallen Academy
    • Accounts Receivable-Hallen Academy
    • Cash Short and Over
    • Interest Expense
    • Interest Revenue
    • Cash Short and Over
    • Miscellaneous Expense
    • Miscellaneous Revenue
    • Notes Receivable
    • Petty Cash
    • Accounts Payable-Hallen Academy
    • Accounts Receivable-Hallen Academy
    • Cash
    • Miscellaneous Revenue
    • Petty Cash

    3. If a balance sheet is prepared for Collegiate Sports Co. on November 30, what amount should be reported as cash?
    $

In: Accounting

A study indicates that 90% of American teenagers have tattoos. You randomly sample 25 teenagers. Find...

A study indicates that 90% of American teenagers have tattoos. You randomly sample 25 teenagers. Find the probability that less than 19 will have tattoos. Round your answer to 4 decimal places.

In: Statistics and Probability

According to AMA (American Medical Association) give me the information about the Evaluation and Management (E/M)...

According to AMA (American Medical Association) give me the information about the Evaluation and Management (E/M) changes coming for 2021? How many new codes coming, deleted codes, and revision codes?

In: Nursing

Which of the following would be studied in Microeconomics?


Which of the following would be studied in Microeconomics? 

a. The level of prices in the American economy 

b. The fixed costs of the Mxyzptlk Corporation 

c. Aggregate demand in the second quarter of 2020 

d. The balance of trade differential with China

In: Economics

Describe the attitudes of employers and other workers toward immigrant, African American, and female workers. Why...

Describe the attitudes of employers and other workers toward immigrant, African American, and female workers. Why were these workers seen as “taking” the jobs of others, and how did this view affect their opportunities and working experiences?

In: Psychology

Many of the causes were linked to irresponsible behaviors throughout the 1920s by companies, banks, governments,...

Many of the causes were linked to irresponsible behaviors throughout the 1920s by companies, banks, governments, and American consumers. Please discuss 1 of these irresponsible behaviors and describe in detail how this behavior contributed to the Great Depression.

In: Economics

1. Why did the United States go to war with Britain in 1812? Which groups of...

1. Why did the United States go to war with Britain in 1812? Which groups of people supported and opposed the war? Why?

2. Examine the impact the War of 1812 had on American industrial development.

In: Economics

John Ford's The Searchers is a classic American Western. Discuss how the cinematographer's choice of film...

John Ford's The Searchers is a classic American Western. Discuss how the cinematographer's choice of film stock affected the film’s overall look and feel. How did this differ from the traditional Western genre film?

In: Economics