Oriole Company expects to have a cash balance of $ 57,550 on January 1, 2017. These are the relevant monthly budget data for the first two months of 2017. 1. Collections from customers: January $ 82,550, February $ 157,550. 2. Payments to suppliers: January $ 51,550, February $ 86,550. 3. Wages: January $ 30,850, February $ 40,850. Wages are paid in the month they are incurred. 4. Administrative expenses: January $ 21,850, February $ 24,850. These costs include depreciation of $ 1,000 per month. All other costs are paid as incurred. 5. Selling expenses: January $ 15,850, February $ 20,850. These costs are exclusive of depreciation. They are paid as incurred. 6. Sales of short-term investments in January are expected to realize $ 12,850 in cash. Oriole Company has a line of credit at a local bank that enables it to borrow up to $ 25,000. The company wants to maintain a minimum monthly cash balance of $ 31,550.

Beginning cash balance 57550 24850 Cash recelpts Collectlons from customera 2 850 Sale ofshort-term weatmanta Total recelpts 95350 157550 Total avaleble cash 152900 5700 Cosh dlebursements Paymenta to aupplers 30 850 Wagea 20850 23350 Selling expenses 20050 Ending cash balance Extess declencyl of avallable cash over disbursemenes 25000 Add Excess (dehclencyi of avallabile cash over dlaburseents 1200