Question
ABC Company makes one (1) product. Its sales price is expected to be P80 per unit. Actual sales for November 201A are 3,100 units, and
ABC Company makes one (1) product. Its sales price is expected to be P80 per unit. Actual sales for November 201A are 3,100 units, and 3,400 units for December 201A. ABC budgets its sales for the next six (6) months for 201B: January 2,700 April 2,500 February 2,600 May 2,900 March 2,750 June 3,000 All sales are on account. ABC collects its accounts as follows: 70% in the month of sale 20% in the month following sale 10% in the second month following sale Uncollectible accounts are negligible and can be disregarded. The beginning inventory on January 1, 201B is 270 units. ABC desires an ending inventory of 10% of the next months budgeted sales. Each unit of finished goods requires 4 kg of raw materials that cost P3.00/kg. ABC desires an ending inventory of direct materials equal to 20% of the following months production needs. Assume that ABC met this requirement at the end of December, 201A. ABC makes all purchases on account and pays its accounts payable as follows: 60% in the month of purchase and 40% in the month following purchase. Purchases in December 201A were P31,000. Required (20 items x 5 points): Prepare the following by month for the first quarter of 201B and for the first quarter as a whole. a. Sales budget (4 items) b. Production budget (4 items) c. Purchases budget (4 items) d. Schedule of cash receipts (4 items) e. Schedule of cash dibursements (4 items) I need help of a, b, c, d, e
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started