show all calculations, please.

Question 1 (6 marks)
Part A (1 mark)
Walsh Company expects sales of Product W to be 60,000 units in April, 75,000 units in May and 70,000 units in June. The company desires that the inventory on hand at the end of each month be equal to 40% of the next month's expected unit sales. Due to excessive production during March, on March 31 there were 25,000 units of Product W in the ending inventory. Given this information, Walsh Company's production of Product W for the month of April should be how many units:
A.60,000.
B.65,000.
C.66,000.
D.75,000.
Part B (1 Mark)
Orion Corporation is preparing a cash budget for the six months beginning January 1. Shown below are the company's expected collection pattern and the budgeted sales for the period.
Expected collection pattern:
65% collected in the month of sale
20% collected in the month after sale
10% collected in the second month after sale
4% collected in the third month after sale
1% uncollectible
	Budgeted sales
January	$160,000
February	185,000
March	190,000
April	170,000
May	200,000
June	180,000
The estimated total cash collections during April from sales and accounts receivables will be:
A.$155,900.
B.$167,000.
C.$171,666.
D.$173,400.
Part C (1 mark)
The Tobler Company has budgeted production for next year as follows:
Quarter	First	Second	Third	Fourth
Production in units	10,000	12,000	16,000	14,000
Four kilograms of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 4,000 kilograms. The raw materials inventory at the end of each quarter should equal 10% of the next quarter's production needs. Budgeted purchases of raw materials in kilograms in the third quarter will be?
A.50,400.
B.56,800.
C.62,400.
D.63,200.
Part D (1 mark)
ABC Company has a cash balance of $9,000 on April 1. The company must maintain a minimum cash balance of $6,000. During April expected cash receipts are $45,000. Expected cash disbursements during the month total $52,000. During April the company will need to borrow:
A.$2,000.
B.$4,000.
C.$6,000.
D.$8,000.
Part E (1 mark)
Avril Company makes collections on sales according to the following schedule:
30% collected in the month of sale
60% collected in the month following sale
8% collected in the second month following sale
2% uncollectible
The following sales are expected:
	Expected Sales
January	$100,000
February	120,000
March	110,000
Cash collections in March should be budgeted to be:
A.$105,000.
B.$110,000.
C.$110,800.
D.$113,000.
Part F (1 mark)
The Banderas Company, a merchandising firm, has budgeted its activity for December according to the following information:
1) Sales at $550,000, all for cash.
2) Merchandise inventory on November 30 was $300,000.
3) Budgeted depreciation for December is $35,000.
4) The cash balance at December 1 was $25,000.
5) Selling and administrative expenses are budgeted at $60,000 for December and are paid in cash.
6) The planned merchandise inventory on December 31 is $270,000.
7) The invoice cost for merchandise purchases represents 75% of the sales price. All purchases are paid for in cash.
The budgeted cash receipts for December are:
A.$137,500.
B.$412,500.
C.$550,000.
D.$585,000.
The Banderas Company, a merchandising firm, has budgeted its activity for December according to the following information:
1) Sales at $550,000, all for cash.
2) Merchandise inventory on November 30 was $300,000.
3) Budgeted depreciation for December is $35,000.
4) The cash balance at December 1 was $25,000.
5) Selling and administrative expenses are budgeted at $60,000 for December and are paid in cash.
6) The planned merchandise inventory on December 31 is $270,000.
7) The invoice cost for merchandise purchases represents 75% of the sales price. All purchases are paid for in cash.
The budgeted cash disbursements for December are:
A.$382,500.
B.$442,500.
C.$472,500.
D.$477,500.

Question 2 (10marks)
Western Company has projected sales and production in units for the second quarter of the coming year as follows:
	April	May	June
Sales	55,000	45,000	65,000
Production	65,000	55,000	55,000
Cash-related production costs are budgeted at $7 per unit produced. Of these production costs, 40% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses will amount to $110,000 per month, paid in the month incurred. The accounts payable balance on March 31 totals $193,000, which will be paid in April.
All units are sold on account (as credit sales) for $16 each. There are no cash sales. Cash collections from sales are budgeted at 60% in the month of sale, 30% in the month following the month of sale, and the remaining 10% in the second month following the month of sale. Accounts receivable on April 1 totaled $520,000 ($100,000 from February's sales and the remainder from March).
Required:	Clearly label whether your calculations are for part a. or part b.
a. Prepare a schedule for each month showing budgeted cash disbursements for the Western Company. (5 marks)
b. Prepare a schedule for each month showing budgeted cash receipts for the Western Company. (5 marks)