Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Stratus Ltd. is in the process of preparing its budgets for the period October 2022 to December 2022. The following information is provided to assist

image text in transcribed

Stratus Ltd. is in the process of preparing its budgets for the period October 2022 to December 2022. The following information is provided to assist in the budgeting process: 1. Budgeted monthly sales revenue is as follows: August 90,000 September 100,000 October 120,000 November 160,000 December 140,000 Sales are 20% cash and 80% credit. Credit sales are collected over a two-month period. 40% in the month following sale and 60% in the month after that. Sales in January 2023 are expected to be 190,000 2. Cost of sales is expected to amount to 65% of sales revenue each month 3. Closing inventory levels are held at 50% of the following month's sales revenue. Inventory at the beginning of October is expected to amount to 60,000 4.85% of inventory purchased is paid for in the month of purchase. The remaining 15% is paid for in the month following purchase. Trade payables are 25.000 at 1st October 5. Stratus Ltd. plans to apply for a government grant of 32.000 and it is expected this grant will be received in two equal amounts in November and December. The application for this grant will cost 1,500 which will be paid in October. 6. A van is expected to be sold in December for 15.000. Immediately prior to the sale. Stratus Ltd. expects to spend 1,750 on repairs and maintenance in order to ensure the van will be in a workable condition 7. Equipment costing 17,250 will be purchased and paid for in November. It will be depreciated on a straight line basis over five years. 8. Operating expenses for October are estimated at 12,000 and will increase by 10% per month, thereafter. These expenses will be paid as incurred 9. The cash balance on 1st October is expected to amount to 104.000. You are required to: a. Calculate the purchases figure for each month from October 2022 to December 2022. b. Prepare a cash budget on a monthly basis and in total for the period October 2022 to December 2022. C. Outline any three potential benefits from the preparation of a cash budget as prepared in part (6)

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

Authors: Alan Millichamp, John Taylor

12th Edition

1473778999, 9781473778993

More Books

Students also viewed these Accounting questions

Question

Would you change the ending of the book? If so, how?

Answered: 1 week ago