Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mischa Furniture Stores (MFS) is a company that specializes in office furniture based in Windhoek. Due to the effects of Covid-19, it has become very

Mischa Furniture Stores ("MFS") is a company that specializes in office furniture based in Windhoek. Due to the effects of Covid-19, it has become very imperative for the company to manage its cash flows effectively. The owner of MFS knows of your skills in management accounting and has requested your service in the preparation of the forthcoming quarter's cash budget. Upon interviews with different departments at MFS, you have ascertained the following information: 1. Budget information for January, February, and March 2023 is as follows: January February March N$ N$ N$ Sales 590 000 650 000 750 000 Production costs 300 000 350 000 420 000 Sales and Administration costs 150 000 170 000 200 000 Purchase of non-current assets - - 120 000 2. Due to reduced income as a result of Covid-19, the company expects 10% of sales to be on cash, and bad debts of 5% are anticipated. 3. 60% of the customers will pay in the month after the sale and the balance will pay two months after the sale. 4. As for the period under review, included in the monthly production costs are depreciation and insurance amounting to N$60 000 combined. 5. Insurance premium costs N$384 000 annually and is paid in January every year. 6. The remaining production costs are paid as 80% in the month in which they are incurred and the balance in the following month. 7. The following balances are anticipated on 1 January 2023: N$ Bank balance 55 000 Accounts receivable (net of allowance for bad debts) (see note 8) 611 135 8. The balance of accounts receivable on 1 January 2023 is comprised of N$459 135 from December 2022 sales and N$152 000 from November 2022 sales. 9. Current liabilities on 1 January 2023 comprise of N$100 000 short-term loans payable in February 2023 at a premium of 2% and N$60 000 accounts payable incurred in December 2022 for production costs. 10. All selling and administration costs are paid in cash in the month in which they are incurred. 11. Shareholder dividends will be paid in January 2023 amounting to N$35 000. MFS anticipates receiving a dividend of N$8 000 on their investments in February 2023. Required: Marks SubTotal Total 3.1 Showing all relevant workings, prepare a cash budget for January, February, and March 2023 in table format. Use the format illustrated below for the cash budget: 26 26 Cash budget for the three months ending 31 March 2023 January February March N$ N$ N$ 3.2 Calculate the accounts receivable and accounts payable figure for inclusion in the statement of financial position as of 31 March 2023. 5 31 3.3 Using the cash budget, you have prepared, what advice would you give to the company

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

Managerial Accounting Tools For Business Decision Making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Jill E. Mitchell

9th Edition

111970958X, 9781119709589

More Books

Students also viewed these Accounting questions

Question

=+1. Who is responsible for CSRfirms or their stakeholders? Why?

Answered: 1 week ago