HASF Inc a distributor of cosmetics throughout Karachi, is in the process of assembling a cash budget for the first quarter 2015 the following information has been extracted from the company s’ accounting records All sales divided in equal part between cash and credit sales. 40 % of credit sales are collected in the month of sales 50% are collected in the following month and remaining is uncollectible. Management believes that only 40% of the a/c receivable outstanding on December 2014 will be recovered that the recovery will be in January 2015 50% of Purchase are paid for in the month of purchase the remaining 50% are paid for in the month after acquisition The December 31 2014 balance sheet disclosed the following selected figures cash 10,000 a/c receivable 75,000 and a/c payable 22,000 Company Maintains a 20,000 minimum cash balance at all time. Financing is available in 1,000 multiples at an 4% interest rate interest is paid ate the time of repaying principle. Additional date Jan Feb March Sales 150,000 180,000 185,000 Purchases 90,000 100,000 140,000 Cash operating cost 31,000 24,000 45,000 Proceeds from the sales of equipment - 5,000 Prepare a schedule of cash collection and cash disbursement for Jan through March. Prepare a cash budget for Jan through March and also prepare income statement
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.
HASF Inc a distributor of cosmetics throughout Karachi, is in the process of assembling a
- All sales divided in equal part between cash and credit sales. 40 % of credit sales are collected in the month of sales 50% are collected in the following month and remaining is uncollectible. Management believes that only 40% of the a/c receivable outstanding on December 2014 will be recovered that the recovery will be in January 2015
- 50% of Purchase are paid for in the month of purchase the remaining 50% are paid for in the month after acquisition
- The December 31 2014 balance sheet disclosed the following selected figures cash 10,000 a/c receivable 75,000 and a/c payable 22,000
- Company Maintains a 20,000 minimum cash balance at all time. Financing is available in 1,000 multiples at an 4% interest rate interest is paid ate the time of repaying principle.
- Additional date
Jan Feb March
Sales 150,000 180,000 185,000
Purchases 90,000 100,000 140,000
Cash operating cost 31,000 24,000 45,000
Proceeds from the sales of equipment - 5,000
Prepare a schedule of cash collection and cash disbursement for Jan through March. Prepare a cash budget for Jan through March and also prepare income statement
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
