HASF PVT.LTD BUDGETED INCOME STATEMENT FOR 1st QUARTER 1999 Description JANUARY FEBRUARY MARCH Sales 285,000 323,000 221,000 Purchases 129,000 168,000 95,000 Wages 35,000 37,000 30,000 Supplies 26,000 23,000 21,500 Utilities 6,500 8,700 7,200 Rent 15,000 12,800 13,600 Insurance 12,000 12,000 12,000 Advertising 24,500 28,500 18,000 Depreciation 20,000 20,000 20,000 Net Profit 17,000 13,000 3,700 Required: Please make a cash budget for the months of January, February and March 1999 based on the data for: View Receivable Trend: 30% of Sales are collected in the month of sale 30% of Sales are collected after the month of sale 40% of Sales are collected two months after the sale is made View Payable Trend: 10% of Purchases are paid for in the month of purchase 35% of Purchases are paid after the month of purchase 55% of Purchases are paid two months after the purchase is made Additional Information: Rent and Insurance expense were prepaid at the end of 1998 All other expenses are paid for in the month they were incurred November Sales = 195,000 November Purchases = 100,000 December Sales = 250,000 December Purchases = 165,000 Please see attached Budgeted Income Statement for 1st Quarter 1999 Being a CFO of the company, interpret the importance budget in strategic and operational planning of the company
HASF PVT.LTD BUDGETED INCOME STATEMENT FOR 1st QUARTER 1999 Description JANUARY FEBRUARY MARCH Sales 285,000 323,000 221,000 Purchases 129,000 168,000 95,000 Wages 35,000 37,000 30,000 Supplies 26,000 23,000 21,500 Utilities 6,500 8,700 7,200 Rent 15,000 12,800 13,600 Insurance 12,000 12,000 12,000 Advertising 24,500 28,500 18,000 Depreciation 20,000 20,000 20,000 Net Profit 17,000 13,000 3,700 Required: Please make a cash budget for the months of January, February and March 1999 based on the data for: View Receivable Trend: 30% of Sales are collected in the month of sale 30% of Sales are collected after the month of sale 40% of Sales are collected two months after the sale is made View Payable Trend: 10% of Purchases are paid for in the month of purchase 35% of Purchases are paid after the month of purchase 55% of Purchases are paid two months after the purchase is made Additional Information: Rent and Insurance expense were prepaid at the end of 1998 All other expenses are paid for in the month they were incurred November Sales = 195,000 November Purchases = 100,000 December Sales = 250,000 December Purchases = 165,000 Please see attached Budgeted Income Statement for 1st Quarter 1999 Being a CFO of the company, interpret the importance budget in strategic and operational planning of the company
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
HASF PVT.LTD |
|||
|
|||
FOR 1st QUARTER 1999 |
|||
|
|
|
|
Description |
JANUARY |
FEBRUARY |
MARCH |
Sales |
285,000 |
323,000 |
221,000 |
Purchases |
129,000 |
168,000 |
95,000 |
Wages |
35,000 |
37,000 |
30,000 |
Supplies |
26,000 |
23,000 |
21,500 |
Utilities |
6,500 |
8,700 |
7,200 |
Rent |
15,000 |
12,800 |
13,600 |
Insurance |
12,000 |
12,000 |
12,000 |
Advertising |
24,500 |
28,500 |
18,000 |
|
20,000 |
20,000 |
20,000 |
Net Profit |
17,000 |
13,000 |
3,700 |
Required:
- Please make a
cash budget for the months of January, February and March 1999 based on the data for:
View Receivable Trend:
- 30% of Sales are collected in the month of sale
- 30% of Sales are collected after the month of sale
- 40% of Sales are collected two months after the sale is made
View Payable Trend:
- 10% of Purchases are paid for in the month of purchase
- 35% of Purchases are paid after the month of purchase
- 55% of Purchases are paid two months after the purchase is made
Additional Information:
- Rent and Insurance expense were prepaid at the end of 1998
- All other expenses are paid for in the month they were incurred
- November Sales = 195,000
- November Purchases = 100,000
- December Sales = 250,000
- December Purchases = 165,000
- Please see attached Budgeted Income Statement for 1st Quarter 1999
Being a CFO of the company, interpret the importance budget in strategic and operational planning of the company
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 2 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