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 growth of a fish is often modeled by the von Bertalanffy growth model: dw/dt = aw2/3 - bw where w is the weight and a and b are constants. Solve the equation for w for the case a = 5/b1/3, b = 2...
-
What are some similarities and differences between the NYSE and the NASDAQ Stock Market?
-
How does an auditor test the valuation of investment securities?
-
Richard Schewe and others placed personal property in a building occupied by Winnebago County Fair Association, Inc. Prior to placing their property in the building, they signed a Storage Rental...
-
Gladstone Company tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period, as if it uses a periodic...
-
Table 1 shows Apple's online orders for the last week. When shoppers place an online order, several "recommended products" (upsells) are shown as at checkout an attempt to upsell See table 2 in cell...
-
Assume that interest rate in the US is 7%, while that in the UK is 3%. Assume also that the spot and one-month forward exchange rates between the USD and the pound sterling are $1.20 and $1.25. Does...
-
Based on key consumer rates such as the Prime and Federal Funds rates, would you describe these rates as: neutral, low or high at this time. (answer in at least a paragraph)
-
what are the steps to process mapping and analysis, and based on Step 1..., what are some desired outcomes that exist at your company? What are some general guidelines to documenting an existing...
-
You are the sales manager of the Northwest region for a mediumsized software manufacturer, and youre kneedeep in the process of analyzing quarterly sales volume, marketing costs, and profitability by...
-
How do cutting-edge metabolomics technologies facilitate the comprehensive profiling of metabolic signatures, thereby unveiling the intricate metabolic dysregulation underlying multifactorial...
-
What are the implications of metabolic flexibility and adaptation in cellular responses to environmental challenges, and how do epigenetic modifications modulate metabolic programming in health and...
-
Assume that a matrix A has the following set of eigenvalue/eigenvector pairs: T = 1, (1) 72=-2, (2) = ;73 = 3, (3) = satisfying the initial condition X(0) = = problem. Find the solution to this...
-
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....
-
The rotor of a dial indicator is connected to a torsional spring and a torsional viscous damper to form a single-degree-of-freedom torsional system. The scale is graduated in equal divisions, and the...
-
The equation of motion of a spring-mass-damper system, with a softening-type spring, is given by (in SI units) \[100 \ddot{x}+500 \dot{x}+10,000 x-400 x^{3}=0\] a. Determine the static equilibrium...
-
A wooden rectangular prism of cross section \(40 \mathrm{~cm} \times 60 \mathrm{~cm}\), height \(120 \mathrm{~cm}\), and mass \(40 \mathrm{~kg}\) floats in a fluid as shown in Fig. 2.111. When...
Study smarter with the SolutionInn App