Complete the sales budget for Product C & D and the production budget for ABC Company

The selling price of product C is $45. Units sold were January 6,000, February 8,000, March 10,000, and April 9,000. The selling price of product D is $80. Units sold were January 3,500, February 2.800, March 5,000, and April 3,800. Prepare a sales budget that shows the monthly and four month total for each product and the total sales for the company.

ABC company predicts sales for January 10,000, February 7,000, March 9,000 and April 7,000. They wish to maintain an ending inventory of 15% of the next months sales. Sales for May are expected to be 9,000. The beginning inventory for January was 1,200 units. Prepare a production budget for January through April.

Cash Budget

Sales for ABC Corp are as follows: November $220,000, December $175,000, January $190,000, February $120,000, March $135,000. They are 70% credit and 30% cash. Cash sales are collected in the month of the sale and credit sales are collected 50% in the month, 40% one month later and 10% two months later.

Purchases are as follows: November $140,000, December $112,000, January $121,600, February $76,800, March $186,400. The purchases are paid for the next month. Other expenditures are $10,000 a month for rent, other expenses of $20,000 per month. The company plans a capital expenditure in February of $30,000. They plan to partially finance this with a bank loan of $15,000. A tax payment of $10,000 needs to be made in March. Prepare a cash budget for January through March with a beginning cash balance of $22,000.