Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Macron Publisher Ltd own 14 shops selling books. At the beginning of January, the business has overdraft of 40,000 and bank had asked for this

Macron Publisher Ltd own 14 shops selling books. At the beginning of January, the business has overdraft of 40,000 and bank had asked for this to be eliminated by end of July. As a result, the directors have recently decided to review their plans for the next 6 months. The following plans are prepared.

image text in transcribed

Notes:

1. Inventory level at 1st Jan was 200,000. Macron prefer to maintain minimum inventory level 70,000 of goods over the period to 31st July.

2. Suppliers allow one month credit. The first three months purchase are subject to a contractual agreement which must be honoured.

3. The gross profit margin is 40%.

4. Cash sales are received in the month of sale. However, 50% of the customers pays with the credit card. The credit card handling company charge 4% to the macron. This charge is an additional charge to the selling expenses mentioned above. The credit card handling company pays the Macron in the month of sales.

5. The Macron has a business loan which its pays by instalment of 10,000. The interest elements represent 25% of each instalment.

6. Administration expenses are paid when they occurred. The item includes depreciation charge of 25,000 each month.

7. Selling expenses are payable in the following month.

Required:

A) Prepare a cash budget for the Macron Limited for the 6 months from February to July.

B) Identify and critically assess FIVE inherent weaknesses of the annual budget model irrespective of the budgeting approach that is applied.

\begin{tabular}{|l|l|l|l|l|l|l|l|} \hline & \begin{tabular}{l} Jan \\ (f000) \end{tabular} & \begin{tabular}{l} Feb \\ (f000) \end{tabular} & \begin{tabular}{l} Mar \\ (f000) \end{tabular} & \begin{tabular}{l} Apr \\ (f000) \end{tabular} & \begin{tabular}{l} May \\ (000) \end{tabular} & \begin{tabular}{l} June \\ (f000) \end{tabular} & \begin{tabular}{l} July \\ (f000) \end{tabular} \\ \hline Sales Revenue & 215 & 270 & 340 & 280 & 200 & 320 & 210 \\ \hline Purchase & 170 & 280 & 175 & 104 & 89 & 73 & 68 \\ \hline \begin{tabular}{l} Administration \\ Expenses \end{tabular} & 55 & 60 & 68 & 48 & 57 & 54 & 49 \\ \hline Selling Expenses & 33 & 38 & 28 & 26 & 21 & 19 & 18 \\ \hline Taxation Payment & 12 & 52 & & 22 & & & \\ \hline Finance Payment & 10 & 10 & 10 & 10 & 10 & 10 & 10 \\ \hline \begin{tabular}{l} Shop \\ Refurbishment \end{tabular} & & & 15 & 10 & 16 & & \\ \hline \end{tabular}

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

Make It Complete A Guide Of Knowledge Advice And Tips For Internal Audit And Compliance

Authors: Mónica Ramírez Chimal

1st Edition

6202304456, 978-6202304450

More Books

Students also viewed these Accounting questions

Question

What role does statistical significance play in the Jensen measure?

Answered: 1 week ago