a) Construct a Cash Budget for Sweet Royale Inc. for the third quarter of 2023. b) Comment on the company's cash budget for the third quarter of year 2023. c) Based on your answer in (ii), give recommendations to Sweet Royale Inc.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![SWEET ROYALE INC.
Given the following information, construct a Cash Budget for Sweet Royale Inc. for the third
quarter of 2023.
i)
Sales forecasts for the company from April through November 2023:
April
RM600,000
August
RM310,000
May
RM650,000
September
RM250,000
June
RM450,000
October
RM860,000
July
RM350,000
November
RM900,000
The sales are 25% on cash basis and 75% on credit.
Collections on credit sales are as follows:
60% are collected within the first month after-sales.
35 % are collected within the second month after-sales
5% are uncollectible
iv)
Raw materials are purchased two months before sales based on a credit term of 5/35
net 65 and are paid one month after purchase. Purchases are 60% of sales.
v)
Operating expenses are estimated at:
Salaries and wages of RM45,000 every month.
Rental of RM5000 every month.
Utility amount to 2% of the current month's total sales.
vi)
The corporate tax is RM35,000 and will be paid in September.
vii)
The company allocates RM5000 as depreciation for fixed assets in August.
viii)
The firm bought a new machine for RM115,000 and paid an installation cost of about
RM5,000 in January. The payment for the expenditure on the machine is to be made
into 12 equal monthly payments starting February onwards.
ix)
The interest of RM10,000 on marketable securities will be paid in the beginning of each
quarter.
x)
A quarterly dividend of RM9,000 will be received at the end of each quarter.
xi)
Ending cash balance for June is RM20,000. The company also intends to maintain a
minimum cash balance of RM50,000 every month.
ii)
E](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5d070bcd-9271-4246-9751-e52c4da7bf1a%2F665bc5ad-4c23-45a1-9105-acfe93e4b12b%2Fxf2mj7r_processed.png&w=3840&q=75)
![a) Construct a Cash Budget for Sweet Royale Inc. for the third quarter of 2023.
b) Comment on the company's cash budget for the third quarter of year 2023.
c) Based on your answer in (ii), give recommendations to Sweet Royale Inc.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F5d070bcd-9271-4246-9751-e52c4da7bf1a%2F665bc5ad-4c23-45a1-9105-acfe93e4b12b%2Ffo6odq_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)