BBQ Berhad projected sales for the first six months of 2023 are given below: Jan. Feb....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
BBQ Berhad projected sales for the first six months of 2023 are given below: Jan. Feb. Mar. April RM490,000 May RM740,000 June RM610,000 RM500,000 RM740,000 RM380,000 40% of sales are collected in cash at time of sale, 50% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. • Cost of goods sold is 60% of sales. Purchases are made in the month prior to the sales, and payments for purchases are made in the month of the sale. • Total other cash expenses are RM40,000/month. • The company's cash balance as of February 28, 2023, will be RM25,000. Excess cash will be used to retire short-term borrowing (if any). BBQ Berhad has no short-term borrowing as of February 28, 2023. Assume that the interest rate on short-term borrowing is 1% per month. • The company must have a minimum cash balance of RM15,000 at the beginning of each month. Required: Prepare a cash budget for the months of March to May 2023. BBQ Berhad projected sales for the first six months of 2023 are given below: Jan. Feb. Mar. April RM490,000 May RM740,000 June RM610,000 RM500,000 RM740,000 RM380,000 40% of sales are collected in cash at time of sale, 50% are collected in the month following the sale, and the remaining 10% are collected in the second month following the sale. • Cost of goods sold is 60% of sales. Purchases are made in the month prior to the sales, and payments for purchases are made in the month of the sale. • Total other cash expenses are RM40,000/month. • The company's cash balance as of February 28, 2023, will be RM25,000. Excess cash will be used to retire short-term borrowing (if any). BBQ Berhad has no short-term borrowing as of February 28, 2023. Assume that the interest rate on short-term borrowing is 1% per month. • The company must have a minimum cash balance of RM15,000 at the beginning of each month. Required: Prepare a cash budget for the months of March to May 2023.
Expert Answer:
Answer rating: 100% (QA)
Total Sales receipts Current month first month second month 40 50 10 1 Cash Budget Particulars Sales ... View the full answer
Related Book For
Managerial Accounting An Introduction to Concepts Methods and Uses
ISBN: 978-0324639766
10th Edition
Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil
Posted Date:
Students also viewed these finance questions
-
Sam was injured in an accident, and the insurance company has offered him the choice of $49,000 per year for 15 years, with the first payment being today, or a lump sum. If a fair return is 7.5%, how...
-
The Kelleher family has health insurance coverage that pays 80 percent of out-of-hospital expenses after a $500 deductible per person. If one family member has doctor and prescription medication...
-
The Kelleher family has health insurance coverage that pays 80 percent of out-of-hospital expenses after a $500 deductible per person. If one family member has doctor and prescription medication...
-
a. Given the following information, calculate the expected value for Firm Cs EPS. Data for Firms A and B are as follows: E(EPS A ) = $5.10, and A = $3.61; E(EPS B ) = $4.20, and B = $2.96. b. You...
-
The annual report for Sears Holding Corporation contained the following information: Assume that accounts receivable write-offs amounted to $ 5 during 2013 and $ 8 during 2012 and that Sears did not...
-
Explain how government intervention in markets might not improve market outcomes.
-
Do a search for a sample pleading format and see if you can find one for California.
-
a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Identify the internal control weaknesses in the system. Use the six categories of physical...
-
Identify the assets that could be sold to meet the callable liabilities: i. Policy loans ii. Value of businesses acquired iii. Short-term investments iv. Deferred policy acquisition costs
-
On November 1, 2005, Janet Morton and Kim Wong formed Pet Kingdom, Inc., to sell pets and pet supplies. Pertinent information regarding Pet Kingdom is summarized as follows: Pet Kingdom's business...
-
In what way do political systems have an impact on global business? Explain
-
Discuss the emergence of the species Homo erectus. Where are these fossils found? How old are they?
-
Where were the earliest hominids found? Describe the hominid Lucy.
-
Discuss the applicability of the pseudo-American model for pricing American call options.
-
Do you think it is possible to adopt a humanitarian standard that would be accepted by everyone in the world? What might this view entail?
-
What is natural selection, and how does it work? Give an example of natural selection in action.
-
X.S. Giovanni Corp. (XSG) is expected to generate free cash flow from operations of $4 million in the coming year (year 1), and $4.4 million in the following year (year 2) and $4.84 million (year 3)....
-
Use the method of Example 4.29 to compute the indicated power of the matrix. 1 0 1
-
Data from the shipping department of Wanda's Gourmet Foods for the past four months follow: Are these costs fixed, semifixed, variable, orsemivariable? Shipping Department Costs $1,500 3,500 4,500...
-
Define the profit equation.
-
Schering Pharmaceuticals incurs the following costs: a. Cost of redesigning blister packs to make drug containers more tamper-proof b. Cost of videos sent to doctors to promote sales of a new drug c....
-
For the spring-mass system shown in the given Fig.27, the frequency of oscillations of the block along the axis of the spring is (a) \(\frac{1}{2 \pi} \sqrt{\frac{k_{1}-k_{2}}{m}}\) (b) \(\frac{1}{2...
-
Match List I with List II and select the answer using the codes given below the Lists. List I A. Helical gears B. Herringbone gears C. Worm gears D. Hypoid Gears List II 1. Non-interchangeable 2....
-
A fixed gear having 200 teeth is in mesh with another gear having 50 teeth. The two gears are connected by an arm. The number of turns made by the smaller gear for one revolution of arm about the...
Study smarter with the SolutionInn App