Shredder Manufacturing has the following projected unit sales (at $18 per unit) for four months of operations:
January .......................25,000
February ....................30,000
March ......................32,000
April ........................35,000
Twenty-five percent of the customers are expected to pay in the month of sale and take a 3 percent discount; 70 percent of the customers are expected to pay in the month following sale. The remaining 5 percent will never pay.
It takes 2 pounds of raw material (costing $0.75 per pound) to produce a unit of product. In January, no raw material is in beginning inventories, but management wants to end each month with enough material for 20 percent of the next month's production. (April's production is assumed to be 34,000 units.) Shredder Manufacturing pays for 60 percent of its material purchases in the month of purchase and 40 percent in the following month.
Each unit of product requires 0.5 hours of labor time. Labor is paid $15 per hour and is paid in the same month as worked. Overhead is estimated to be $2 per unit plus $25,000 per month (including depreciation of $12,000). Overhead costs are paid as incurred.
Shredder will begin January with no Work in Process or Finished Goods Inventory. Inventory policy for these two accounts is set at zero ending WIP and 25 percent of the following month's sales for FG.
a. Prepare a sales budget for January, February, and March.
b. Prepare a production budget for January, February, and March.
c. Prepare a purchases budget for January, February, and March.
d. Prepare a direct labor budget for January, February, and March.
e. Prepare an overhead budget for January, February, and March.
f. Prepare a cash receipts schedule for sales and a cash payments schedule for material purchased.