Quality foods ltd. wants to arrange an overdraft facility from month August to October 2018. During this
Question:
Quality foods ltd. wants to arrange an overdraft facility from month August to October 2018. During this time period, them will manufacture most of its products for stock.
Required:
a cash budget for the period of August to October based on the data given below:
Month | Sales $ | Purchases $ | Wages $ | Manufacturing expenses $ | Office expenses $ | Selling expenses $ |
June | 90,000 | 62,400 | 6,000 | 1,500 | 1,000 | 1,000 |
July | 96,000 | 72,000 | 7,000 | 2,000 | 500 | 2,000 |
August | 54,000 | 121,500 | 5,500 | 1,500 | 750 | 1,000 |
September | 87,000 | 123,000 | 6,000 | 2,250 | 1000 | 2,500 |
October | 63,000 | 134,000 | 7,500 | 2,500 | 1250 | 2,000 |
November | 70,000 | 140,000 | 8,500 | 2,750 | 1500 | 2,250 |
December | 80,000 | 150,000 | 9,000 | 3,000 | 1500 | 2,500 |
Additional Information:
- Cash on hand 1082018 $12,500.
- 50% of credit sales are released in the month following the sale and the remaining 50% in the second month following. Creditors are paid in the month following the month of purchase.
- Lag in payment of manufacturing expenses half a month.
- Lag in payment of other expenses one month.
Need answer below:
Cash budget for 3 months from August to October 2018 | |||
Particulars | August ($) | September ($) | October ($) |
Receipts: | |||
Opening balance | |||
Sales | |||
Total Receipts | |||
Payments: | |||
Purchases | |||
Wages | |||
Manufacturing expenses | |||
Office expenses | |||
Selling expenses | |||
Total payments | |||
Closing Balance |
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr