Reference no: EM131956766
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.
|
Prototyping as a development tool
: Briefly, explain what is prototyping? What are the advantages of using the prototyping as a development tool?
|
|
What is the significance of this to the american economy
: What is the significance of this to the American Economy? (let this answer be lengthy and apply and financial concepts that are appplicable to this article?)
|
|
What is the difference in maturity risk premiums on security
: An investor in Treasury securities expects inflation to be 2.1% in year 1, 2.7% in year 2 and 3.65% each year afterwards.
|
|
What is total non-direct cost
: Company has call centre which generates many projects. Call-centre stuff is paid 90000 overall. In company also work one accountant, who is paid 30000.
|
|
Prepare budgeted income statement
: BBAC501 Management Accounting - Prepare monthly budgets as well as the total quarterly estimates for the third quarter - Prepare cash budget for the month
|
|
What is the accounts receivable turnover in terms of days
: Company Baker has total sales of $367,450, of which, $63,475 represent cash sales. Its annual average accounts receivable balance is $54,500.
|
|
Does it still make sense to develop an efficient frontier
: There are investors who claim they only invest in companies with great products and outstanding management, and ignore the stock price.
|
|
Identify the ecological and human health issues
: Identify the cause(s) of the environmental problem. Identify the ecological and human health issues associated with the environmental problem.
|
|
What would be the appropriate fair market value for property
: Based upon the below data, what would be the appropriate fair market value for each property?
|