Question
ABC Co. makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted
ABC Co. makes one product and has provided the following information to help prepare the master budget for the next four months of operations:
| Budgeted selling price per unit | $76 |
| Budgeted unit sales (all on credit): |
|
| January | 9,500 |
| February | 9,900 |
| March | 10,600 |
| April | 12,600 |
| Raw materials requirement per unit of output | 3 | pounds |
| Raw materials cost | $5.00 | per pound |
| Direct labor requirement per unit of output | 2.2 | direct labor-hours |
| Direct labor wage rate | $18.00 | per direct labor-hour |
Credit sales are collected:40% in the month of the sale60% in the following month
Raw materials purchases are paid:30% in the month of purchase70% in the following month
The ending finished goods inventory should equal 10% of the following month's sales. The ending raw materials inventory should equal 40% of the following month's raw materials production needs.
Required:
a. What are the budgeted sales for February?
b. What are the expected cash collections for February?
c. What is the budgeted accounts receivable balance at the end of February?
d. According to the production budget, how many units should be produced in February?
e. If 32,400 pounds of raw materials are needed for production in March, how many pounds of raw materials should be purchased in February?
f. What is the estimated cost of raw materials purchases for February?
g. If the cost of raw material purchases in January is $145,680, then in February what are the total estimated cash disbursements for raw materials purchases?
h. What is the estimated accounts payable balance at the end of February?
i. What is the estimated raw materials inventory balance at the end of February?
j. What is the total estimated direct labor cost for February assuming the direct labor workforce is adjusted to match the hours required to produce the forecasted number of units produced?
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