Question

In: Accounting

Jaka Sdn Bhd., manufactures and sells concrete blocks for residential and commercial building. Jaka expects the...

Jaka Sdn Bhd., manufactures and sells concrete blocks for residential and commercial building. Jaka expects the following sales unit, price per unit and desired ending inventory for year 2021.

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Sales unit

2,000,000

6,000,000

6,000,000

2,000,000

Price/unit (RM)

0.70

0.70

0.80

0.80

Ending Inventory

500,000

500,000

100,000

100,000

Inventories for both 1st January 2021 and 1st January 2022 are expected to be 100,000 blocks.

The raw materials and direct labour required for each concrete block are as follows:

Units

Cost

Raw materials

26kg

RM0.01/kg

Direct labour

0.015 hour

RM14/hour

Jaka’s policy is to have 5 million kg of raw materials in ending inventory for the third and fourth quarters and 8 million kg of the materials in ending inventory for the first and second quarters.

Required:

Prepare the following budgets for the year 2021: -

  1. Sales budget. Show total sales by quarter and in total for the year.                                    

  1. Production budget. Show total production unit by quarter and in total for the year.   

  1. Direct material usage and purchase budget.

  1. Direct labour budget.

Solutions

Expert Solution

Sr. No. Sales Budget Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year 2021 Remarks
1 Sales units 2,000,000 6,000,000 6,000,000 2,000,000 16,000,000
2 Price/unit 0.70 0.70 0.80 0.80
3 Sales value 1,400,000 4,200,000 4,800,000 1,600,000 12,000,000 1 X 2
Sr. No. Production budget Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year 2021 Remarks
1 Opening Inventory 100,000 500,000 500,000 100,000 100,000
2 Add: Sales units 2,000,000 6,000,000 6,000,000 2,000,000 16,000,000
3 Less: Closing inventory -500,000 -500,000 -100,000 -100,000 -100,000
4 Production units 1,600,000 6,000,000 6,400,000 2,000,000 16,000,000 1 + 2 - 3
Sr. No. Material usage and purchase budget Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year 2021 Remarks
1 Production units 1,600,000 6,000,000 6,400,000 2,000,000 16,000,000
2 Raw material usage (26kg per block) 41,600,000 156,000,000 166,400,000 52,000,000 416,000,000 2 X 26kg
3 Add: Opening stock of Raw material 5,000,000 8,000,000 8,000,000 5,000,000 5,000,000
4 Less: Closing stock of Raw material -8,000,000 -8,000,000 -5,000,000 -5,000,000 -5,000,000
5 Raw material purchased in units 38,600,000 156,000,000 169,400,000 52,000,000 416,000,000 2 + 3 - 4
6 Raw material cost (RM 0.01/kg) 386,000 1,560,000 1,694,000 520,000 4,160,000 5 X RM0.01
Sr. No. Labour Budget Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year 2021 Remarks
1 Production units 38,600,000 156,000,000 169,400,000 52,000,000 416,000,000
2 Labour in hrs (0.015 hrs per unit) 579,000 2,340,000 2,541,000 780,000 6,240,000 1 X 0.015 hrs
3 Labour cost (RM14/hr) 8,106,000 32,760,000 35,574,000 10,920,000 87,360,000 2 X RM 14

Related Solutions

TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell the following in 20x1: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 2,000,0000 6,000,000 6,000,000 2,000,000 Unit Selling Price $0.70 $0.70 $0.80 $0.80 Quarter Units Sales Ending Inventory 1 2,000,000 500,000 2 6,000,000 500,000 3 6,000,000 100,000 4 2,000,000 100,000 Inventory on both January 1, 20x1, and January 1, 20x2, is expected to be 100,000 blocks. Each block requires 26 pounds of raw...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell the following in 20x1: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 2,000,0000 6,000,000 6,000,000 2,000,000 Unit Selling Price $0.70 $0.70 $0.80 $0.80 Quarter Units Sales Ending Inventory 1 2,000,000 500,000 2 6,000,000 500,000 3 6,000,000 100,000 4 2,000,000 100,000 Inventory on both January 1, 20x1, and January 1, 20x2, is expected to be 100,000 blocks. Each block requires 26 pounds of raw...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell the following in 20x1: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 2,000,0000 6,000,000 6,000,000 2,000,000 Unit Selling Price $0.70 $0.70 $0.80 $0.80 Quarter Units Sales Ending Inventory 1 2,000,000 500,000 2 6,000,000 500,000 3 6,000,000 100,000 4 2,000,000 100,000 Inventory on both January 1, 20x1, and January 1, 20x2, is expected to be 100,000 blocks. Each block requires 26 pounds of raw...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell...
TBA, Inc., manufactures and sells concrete block for residential and commercial building. TBA expects to sell the following in 20x1: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Units 2,000,0000 6,000,000 6,000,000 2,000,000 Unit Selling Price $0.70 $0.70 $0.80 $0.80 Quarter Units Sales Ending Inventory 1 2,000,000 500,000 2 6,000,000 500,000 3 6,000,000 100,000 4 2,000,000 100,000 Inventory on both January 1, 20x1, and January 1, 20x2, is expected to be 100,000 blocks. Each block requires 26 pounds of raw...
Hakim Sdn Bhd manufacturers water filtration system products that are used in both residential and commercial...
Hakim Sdn Bhd manufacturers water filtration system products that are used in both residential and commercial building. One of its products named product B is made using two different raw materials and two types of labour. The company operate a standard absorption costing system and now preparing its budgets for the first quarter for the year ending 31 December 2020. In order to produce one unit of product B, two types of materials are required namely material X and Y....
Preston Concrete is a major supplier of concrete to residential and commercial builders in the Pacific...
Preston Concrete is a major supplier of concrete to residential and commercial builders in the Pacific Northwest. The company's general pricing policy is to set prices at $128 per cubic yard. Deliveries for 2019 were 380,000 cubic yards, and total costs were: Material costs $25,536,000   Yard operation costs $5,700,000   Administrative costs $1,140,000   $4,218,000 of the estimated total yard operation costs were variable, and all of the administrative costs were fixed. In addition to the costs above, estimated fixed delivery costs...
Preston Concrete is a major supplier of concrete to residential and commercial builders in the Pacific...
Preston Concrete is a major supplier of concrete to residential and commercial builders in the Pacific Northwest. The company's general pricing policy is to set prices at $117 per cubic yard. Deliveries for 2019 were 400,000 cubic yards, and total costs were: Material costs $22,840,000 Yard operation costs $5,600,000 Administrative costs $2,360,000 $1,456,000 of the estimated total yard operation costs were fixed, and all of the administrative costs were fixed. In addition to the costs above, estimated fixed delivery costs...
ZACK Sdn Bhd manufactures one standard product, which sells at RM10.00. You are required to: (a)...
ZACK Sdn Bhd manufactures one standard product, which sells at RM10.00. You are required to: (a) prepare from the data below, a break even and profit volume graph showing the results for the six months ending 30 April 2019 and to determine: (i) the fixed cost; (ii) the variable cost per unit; (iii) the profit-volume ratio; (iv) the break-even point; (v) the margin of safety; QUESTION 1 Month Sales (units) Profit/(Loss) (RM) November 30,000 40,000 December 35,000 60,000 January 15,000...
Question 3 Barbie Sdn Bhd (BSB) manufactures and sells a single product which is a barbie...
Question 3 Barbie Sdn Bhd (BSB) manufactures and sells a single product which is a barbie doll. Following information are provided below: RM Manufacturing costs: Direct materials cost per unit 55 Direct labor cost per unit 45 Variable overhead cost per unit 36 Fixed overhead cost in total 51,000 Selling expenses: Variable selling expenses per unit 14 Fixed selling expenses in total 18,000 The selling price for each unit of barbie doll is RM220.00. Required: a) Differentiate between variable cost...
Below is the information on the operation of Spice Sdn. Bhd. which manufactures a health product...
Below is the information on the operation of Spice Sdn. Bhd. which manufactures a health product under the brand name SS: Standard Cost Card                                       RM             Direct material           0.8kg at RM12 per kg                                       9.60             Direct labour              3 hours at RM6 per hour                  18.00             Variable overhead     4 hours at RM2.90 per hour             11.60                                                                                                              39.20 For the month of July 2020, the company has estimated to manufacture and sell 4,875 units of SS at a standard...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT