Q.2 A Rodriques Mountain Climbing, Inc. (RMC) has the following information: Previous Sales: November 2007 130,000 December 2007 125,000 Forecast sales for: January 2008 120,000 February 2008 260,000 March 2008 140,000

Intermediate Financial Management (MindTap Course List)
13th Edition
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Eugene F. Brigham, Phillip R. Daves
Chapter21: Supply Chains And Working Capital Management
Section: Chapter Questions
Problem 9P: Grunewald Industries sells on terms of 2/10, net 40. Gross sales last year were 4,562,500 and...
icon
Related questions
Question
Q.2
A Rodriques Mountain Climbing, Inc. (RMC) has the following information:
Previous Sales:
November 2007 130,000
December 2007 125,000
Forecast sales for: January 2008
120,000
February 2008
260,000
March 2008
140,000
April 2008
140,000
Collections : 30% of customers pay cash
50% pay in month after sale
20%
раy
2 months after sale
Other information for RMC Cash Budget:
Purchases of inventory are 75% of sales
and are made 2 months before sale
and are paid for 1 month after delivery
Other expenses
$14,000 per month
Taxes
$10,000 due in March
Cash Balance (Dec. 31, 2007) = $28,000
Minimum balance required by bank = $25,000
(ST borrowing rate = 6% annually)
Prepare a cash budget for the month of January, Feb and March.
Transcribed Image Text:Q.2 A Rodriques Mountain Climbing, Inc. (RMC) has the following information: Previous Sales: November 2007 130,000 December 2007 125,000 Forecast sales for: January 2008 120,000 February 2008 260,000 March 2008 140,000 April 2008 140,000 Collections : 30% of customers pay cash 50% pay in month after sale 20% раy 2 months after sale Other information for RMC Cash Budget: Purchases of inventory are 75% of sales and are made 2 months before sale and are paid for 1 month after delivery Other expenses $14,000 per month Taxes $10,000 due in March Cash Balance (Dec. 31, 2007) = $28,000 Minimum balance required by bank = $25,000 (ST borrowing rate = 6% annually) Prepare a cash budget for the month of January, Feb and March.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Income Statement Analysis
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
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning