Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Especially need a detailed answer to the third question, thank you very much. UVW Ltd has 5 chain stores, all of which sell CDs. At

Especially need a detailed answer to the third question, thank you very much. image text in transcribed
UVW Ltd has 5 chain stores, all of which sell CDs. At the beginning of June (20X1), the company's overdraft was $4,200,000 and the bank requested that it be cancelled before the end of November. Therefore, the directors recently decided to review their plans for the next six months. Currently, UWW is repaying $600,000 in monthly instalments. The interest element accounts for 20% of each period. The following plans were prepared for the business some months earlier: May June July August Sept Oct Nov $'000 $'000 $'000 $'000 $'000 $'000 $'000 Sales revenue 18,000 23,000 32,000 25,000 14.000 12.000 11,000 Purchases 13,500 18,000 14,200 9,400 7,500 6,600 5,700 Administration expenses 5,200 5,500 5,600 5,300 4,800 4,600 4,500 Selling expenses 2,200 2,400 2,800 2,600 2,100 1,900 1,800 Taxation payment 2,200 Finance payments 600 600 600 600 600 600 600 Shop refurbishment 1,400 1,800 600 Notes: 1) The inventories level at 1 June was $11,200,000. 2) Suppliers allow one month's credit. 3) The gross profit margin is 40 per cent. 4) Receive all cash from sales in the month of sales. However, 50% of customers pay by credit card. The fee charged by the credit card company to UVW Ltd is 3% of the value of the sales revenue. These expenses are in addition to the above sales expenses. The credit card company pays UVW Ltd in the month of sale. 5) Administration expenses are paid when incurred. This item includes a charge of $1,500,000 each month in respect of depreciation. 6) Selling expenses are payable in the following month. Required (working to the nearest $1,000): a) Compute the inventories levels at the end of each month for the six months to 30 November. b) Prepare a cash budget for the six months ending 30 November 20X1 which shows the cash balance at the end of each month. c) Prepare a budgeted income statement for the whole of the six-month period ending 30 November 20X1. (A monthly breakdown of profit is not required.)

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

Auditing Information Security A Complete Guide

Authors: Gerardus Blokdyk

2020 Edition

1867303531, 978-1867303534

More Books

Students also viewed these Accounting questions

Question

19. Compare and contrast the two types of antennas.

Answered: 1 week ago