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.
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.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Concept explainers
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.
Question
100%
Transcribed Image Text: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
Transcribed Image Text: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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education