Bear corporation will begin business operations on January 1, 2021. Below is the anticipated sales budget (in units):

Jan 30,000

Feb 90,000

Mar 40,000

a. Ending finished goods inventory should be equal to 10% of next months sales projections

b. Each unit requires 3 pounds of material at a raw material cost of $5 per pound

c. Labor cost is $10 per unit produced

d. Ending raw materials inventory should be equal to 20% of next month's material requirement

e. Factory overhead is $18,000 per month of which $8,000 is for depreciation

f. All costs are paid in the month incurred except for purchases which is paid in the following month

g. The selling price per unit is $100

Required Using Excel

Prepare a SALES BUDGET for the first quarter (January through March)

Prepare a PRODUCTION BUDGET for the first quarter (January through March)

Prepare a Raw Materials PURCHASE BUDGET for the first quarter (January through March)

Prepare a CASH DISBURSEMENTS budget for the first quarter (January through March)