Part A: Projected sales for the month of january are 1200 units and february is expected to sell 1400 each unit is expected to be sold for $30. Jan is expected to have a beginning finished goods inventory of 150 units and the required ending inventory for Jan and Feb is 160 units respectively.
Prepare the sales budget for Jan and Feb
Prepare the production budget for Jan and Feb
Part B: Each unit requires 3sq ft of material that costs $1.10 per square foot. The materials inventory at the start of Jan has 400 square foot and the ending inventory for Jan is expected to be 500 sq ft and in Feb they expect to have 700 sq ft on hand. The monthly fixed overhead is $3500 with variable overhead of $.65 per unit produced.
Prepare the materials purchases budget for Jan and Feb.
Prepare a budget of Manufacturing overhead costs for Jan and Feb.
Part C: the following sales are expeceted in the second quarter
April 1500
May 1700
June 2000
Thirty percent of the sales are for cash. Of the credit sales 60% are collected in the month of thw sale and 37% are collected in the month after the sale. Three percent are never collected (bad debt). The April beginning balance in accounts receivable was $8400 (40% of March credit sales of which $630 will not be collected)
Prepare a budget of cash recipts for the months of April, May, and Jun.