Problem #$1$ Budgeting

Dixon Corporation has the following sales budget for September$-$January:

Sept Oct Nov Dec Jan

Sales Revenue $$80,000$ $$100,000$ $$120,000$ $$90,000$ $$110,000$

Required:

$1.$ The company$$s inventory policy is to keep sufficient ending inventory on hand to cover $40\%$ of next month's sales. Selling price per unit is $$10.$

Complete the following production budget for September, October, November and December.

September October November December

Unit Sales

End.

Inventory

Beg.

Inventory $($given for September$)3,200$

Units to

Produce

$2.$ Four pounds of materials are required for each unit produced. Ending inventory levels for raw materials are $25\%$ of next month's production needs. Cost of one pound of material is $$1\mathrm{.}50.$ Based on this information and your production schedule from above, complete the following material purchase budget for September and October.

September October

Pounds of Material Needed for Production

End. Inv.

Beg.Inv. $($given for September$)8,800$

Pounds to Purchase

Cost per Pound

Total Purchase Cost

$$

The sales forecasts from the previous page has been reproduced below:

Sept Oct Nov Dec Jan

Sales Rev. $$80,000$ $$100,000$ $$120,000$ $$90,000$ $$110,000$

$20\%$ sales are cash sales. Approximately $10\%$ of credit sales are never collected. The collectible portion of credit sales are collected as follows:

$70\%$ in the month of the sale

$30\%$ in the month following the sale

Cash Payments:

Preliminary Cash Balance

Financing Required

Ending Cash Balance