s company sales in December 2018 were $80,000 and they are expected to rise by $5,000 per month for the next 5 months. Of sales, 80 per cent are collected during the month of sale and the rest two months after sales. The cost of sales is 60 per cent of sales and, the company plans to keep an inventory at the end of each month equal to 40 per cent of the anticipated sales for the next month’s sales. Suppliers are paid one month after purchases are made. Monthly wages amount to $4,500, rent and heating $750 and depreciation $600. A machine is to be bought in March for $6,000 paid in cash. The purchase of the machine means that the monthly change for depreci
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.
Austin Computers company sales in December 2018 were $80,000 and they are expected to rise by $5,000 per month for the next 5 months. Of sales, 80 per cent are collected during the month of sale and the rest two months after sales. The cost of sales is 60 per cent of sales and, the company plans to keep an inventory at the end of each month equal to 40 per cent of the anticipated sales for the next month’s sales. Suppliers are paid one month after purchases are made. Monthly wages amount to $4,500, rent and heating $750 and
Required:
- Calculate the estimated cash collection from sales for February and March.
- Calculate the purchases for February and March.
- Assuming that the cash balance at 31/01/2019 is $10,000; prepare a
cash budget for the two months ending March 31, 2019. - Discuss whether the company will be able to repay a loan of $55,000 at the end of March.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 7 images
