Reference no: EM132536940
The sales budget is provided below for the product of Company ABC.
Jan :10,000 units
Feb :40,000 units
Mar :50,000 units
Apr :60,000 units
May :40,000 units
a. Finished goods at the end of each month must be 20% of the next month's budgeted sales.
b. On Dec 31 of the last year, the finished goods totaled 3,000 units.
c. The selling price is $1 per unit.
d. 70% of the credit sales are collected in the month of sale, 25% in the month following sale, and the remainder are uncollectible.
Question 1. Create a budget showing the required production each month for January, February, March, and the quarter.
Question 2. Prepare the cash collection for each month for January, February, March, and the quarter.