In: Finance
Tangshang Industries production budget from the 2nd quarter of 2018, projected the following amounts of units to be produced:
April 1,000 units
May 1,200 units
June 1,250 units
Each unit requires 2 parts of component A and 3 parts of component B. Component A cost is $1.25 per unit and component B cost is $.80 per unit.
A. Calculate the Direct Material budgeted cost for May 2018
B. Calculate the Direct Material budgeted cost for the quarter April - June 2018
C. The raw materials inventory policy is 0 ending inventory, 0 beginning inventory. How much inventory of component A is required in April 2018?
Computation of direct material Budgeted cost for Apr-Jun | ||
B. | unit to be produced in | |
Apr-18 | 1000 | |
May-18 | 1200 | |
Jun-18 | 1250 | |
Total Unit in quarter -2 | 3450 | |
Material required | ||
Component A ( in No.) | 6900 | |
( 2part for each unit) = ( 3450*2) | ||
Cost /per Unit | $1.25 | |
Total cost of Component A for producting 3450 unit (1) | $8,625.00 | |
(6900*$1.25) | ||
Component B ( in No.) | 10350 | |
( 3part for each unit) = ( 3450*3) | ||
Cost /per Unit | $0.80 | |
Total cost of Component B for producting 3450 unit (2) | $8,280.00 | |
(10350*$0.80) | ||
Direct material Budget cost ( 1+2) | $16,905.00 | |
A. | Computation of direct material Budgeted cost for May | |
unit to be produced in | ||
May-18 | 1200 unit | |
Material required | ||
Component A ( in No.) | 2400 | |
( 2part for each unit) = ( 1200*2) | ||
Cost /per Unit | $1.25 | |
Total cost of Component A for producting 1200 unit (1) | $3,000.00 | |
(2400*$1.25) | ||
Component B ( in No.) | 3600 | |
( 3part for each unit) = ( 1200*3) | ||
Cost /per Unit | $0.80 | |
Total cost of Component B for producting 3450 unit (2) | $2,880.00 | |
(3600*$0.80) | ||
Direct material Budget cost ( 1+2) | $5,880.00 | |
C. | Computation of direct material Budgeted cost for May | |
unit to be produced in | ||
Apr-18 | 1000 unit | |
Material required | ||
Component A ( in No.) | 2000 | |
( 2part for each unit) = ( 1000*2) | ||
Cost /per Unit | $1.25 | |
Total cost of Component A for producting 1000 unit (1) | $2,500.00 | |
(2000*$1.25) | ||
2000 unit of Component A are required in April month |