: Production Budget

Enjoy Cooking Inc. produces two version of its popular electric mixer - Basic and Super Aid. The anticipated unit sales of these two versions by sales region for November are as follows:

	Basic	Super Aid
Western Region unit sales	40,500	30,800
Eastern Region unit sales	38,000	35,500
Total	78,500	66,300
Estimated Finished goods inventory at November 1	5,000	3,000
Desired finished goods inventory at November 30	4,000	3,500

Required:

Prepare a production budget for the Basic and Super Aid versions for the month ended November 30. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Enjoy Cooking Inc.
Production budget for the month November
	Basic	Super Aid
Expected units to be sold
Plus, Desired inventory November 30
= Total units available
less, Estimated inventory November 1
Total units to be produced

Question 3: Schedule of Cash Payments for selling and admin expenses

Aristo Pharma Inc. projected selling and administrative expenses for the last quarter of 20Y1 as follows:

	Total expenses
October	72,000
November	95,000
December	120,000

Depreciation, insurance, and property taxes represent $12,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in January 7 20Y2.

Sixty percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month.

Required:

1. Prepare a schedule of cash payments for selling and administrative expenses for October, November and December.

Aristo Pharma Inc.
Schedule of Cash Payments for Selling and Administrative Expenses
For the last quarter of the year ended December 31 20Y1
	October	November	December
October expenses
Paid in October	?
Paid in November		?
November expenses
Paid in November		?
Paid in December			?
December expenses
Paid in December			?
Total cash payments	?	?	?