Automotive Parts Productions (APP) is a manufacturer of motor parts for family cars based in Bendigo, Australia. These motor parts are sold directly to car manufacturers in Australia for use in making motors. The accountant of APP has compiled information regarding Part-1, one of the parts produced and sold by the company. The forecasted monthly sales units for part of 2018 are presented as follows:
|
June
|
30,000
|
|
July
|
40,000
|
|
August
|
50,000
|
|
September
|
54,000
|
|
October
|
60,000
|
|
November
|
64,000
|
The following part presents data obtained from the budgeting documents of the company:
1. Inventory balances and the related desired ending inventory policies are stated as follows:
|
Description
|
July 1 balances
|
Desired ending inventory policy (monthly)
|
|
Finished Goods
|
28,000
|
70% of next month's sales quantity
|
|
Raw Materials:
|
|
|
|
Mat-AA
|
To be computed
|
60% of next month's production needs
|
|
Mat-BB
|
To be computed
|
50% of next month's production needs
|
2. Data on raw material standards:
|
Raw Materials:
|
Standard quantity per unit
|
Standard cost per unit
|
|
Mat-AA
|
4 Kilograms @$40 each
|
$ 160
|
|
Mat-BB
|
3 Kilograms @$30 each
|
$ 90
|
3. The standard quantity of direct labour hours required to produce one unit of Part-1 is five. The standard rate of pay per hour is $18.
4. Manufacturing overhead cost is estimated using flexible budget formula and the selected cost driver is direct labour hours. Monthly fixed overhead costs are estimated to be $150,000 and the variable component is budgeted at $3 per hour.
5. Monthly fixed selling and administrative expenses are estimated to be $70,000 while the variable portion is estimated to cost $2 per unit sold during each month.
6. The sales price per unit of Part-1 is $550.
7. Sales of each month are estimated to be 40% on cash and the remaining balance on account. The company collects total monthly credit sales in the first month following sales. Half of monthly purchases are paid in cash within five days of purchases and the remaining balance is on credit that is always paid in full in the month following sales. The credit term agreed for with suppliers is 2/10, n/60. The company has benefited discounts for the monthly cash purchases that are paid within the discount period.
8. The cash balance on the 1st of July 2018 is estimated to be $850,000. Desired monthly ending cash balance is required to be 10% of next month's sales revenue.
Required:
I. Prepare monthly budgets as well as the total quarterly estimates for the third quarter of 2018 for each of the following items:
A. Sales budget
B. Production budget
C. Direct materials purchases budget (for each component and in total)
D. Monthly direct materials usage budget
E. Direct labour budget
F. Overhead budget
G. Selling and administrative expenses
II. Prepare cash budget for the month of July 2018.
III. Prepare budgeted income statement for the month of July 2018.