report akaun

7/30/2019 Report Akaun

1/12

MANAGEMENT ACCOUNTING

1. Prepare the following budgets for 2012:

a) Sales budget (in units and RM)

Safiyya Sdn Bhd

Sales Budget for the year 2012

Q1 Q2 Q3 Q4 TOTAL

Sales Quantity 7,100 7,000 18,300 8,000 40,400

Price/unit (RM) 38 38 38 38 38

269,800 266,000 695,400 304,000 1,535,200

COMMENTS:

18%

17%

45%

20%

Sales Budget for the year 2012

Q1

Q2

Q3

Q4


2/12

b) Production budget (in units)

Safiyya Sdn Bhd

Production Budget for the year 2012

Q1 Q2 Q3 Q4 TOTAL

Quantity produced 7,100 7,000 18,300 8,000 40,400

Add: Closing stock 400 600 1,800 400 2,600

Less: Opening stock - (400) (600) (1,800) (2,200)

Total Production Budget 7,500 7,200 19,500 6,600 40,800

COMMENTS:

18%

18%

48%

16%

Production Budget for the year 2012

Q1

Q2

Q3

Q4


3/12

c) Material usage and purchase budget for cotton cloth only. (In units and RM)

Safiyya Sdn Bhd

c) Material usage and purchase budget for the year 2012

Q1 Q2 Q3 Q4

Production unit 7,500 7,200 19,500 6,600

Direct Material per unit 1 1 1 1

Material usage 3,750 3,600 9,750 3,300

Add: Closing stock 850 1,450 2,200 2,100

Less: Opening stock - (850) (1,450) (2,200)

4,600 4,200 10,500 3,200

Purchase price (RM) 18 18 18 18

Total Material Purchase 82,800 75,600 189,000 57,600

COMMENTS:

0

50000

100000

150000

200000

Q1 Q2 Q3 Q4

Series1 67500 64800 175500 59400

RM

Material Usage Budget for the year 2012


4/12

COMMENTS:

-

50,000

100,000

150,000

200,000

Q1 Q2 Q3 Q4

Series1 82,800 75,600 189,000 57,600

RM

MATERIAL PURCHASE BUDGET


5/12

d) Direct labour budgets (in hours and RM)

Safiyya Sdn Bhd

Direct Labour Budget for the year 2012 (Cutting Department)

Q1 Q2 Q3 Q4

Production unit 7,500 7,200 19,500 6,600

Direct Labour per unit 0.30 0.30 0.30 0.30

Total Direct Labour Hour 2,250 2,160 5,850 1,980

Direct Labour Rate (RM) 9 9 9 9

Total Direct Labour Cost 20,250 19,440 52,650 17,820

Safiyya Sdn Bhd

Direct Labour Budget for the year 2012 (Sewing Department)

Q1 Q2 Q3 Q4

Production unit 7,500 7,200 19,500 6,600

Direct Labour per unit 0.25 0.25 0.25 0.25

Total Direct Labour Hour 1,875 1,800 4,875 1,650

Direct Labour Rate (RM) 7 7 7 7

Total Direct Labour Cost 13,125 12,600 34,125 11,550

COMMENTS:

Q1 Q2 Q3 Q4

cutting 20250 19440 52650 17820

sewing 13125 12600 34125 11550

0100002000030000400005000060000

RM

Direct Labour Budget for the year 2012


6/12

e) Manufacturing overhead budget

SAFFIYA SDN BHD

e) MANUFACTURING OVERHEAD BUDGET FOR THE YEAR ENDED 2012

OVERHEAD TOTAL Q1 Q2 Q3 Q4

Indirect Materials 12,150 2,484 2,268 5,670 1,728

Utilities 4,800 1,200 1,200 1,200 1,200

Electricity 21,600 5,400 5,400 5,400 5,400

Purchasing and material handling 1,200 300 300 300 300

Quality control 14,400 3,600 3,600 3,600 3,600

Supervisor salaries 18,000 4,500 4,500 4,500 4,500

Depreciation:

Cutting Machine 3,000 750 750 750 750

Sewing Machine 8,960 2,240 2,240 2,240 2,240

Building 11,250 2,813 2,813 2,813 2,813

Insurance:

Sewing machine 800 200 200 200 200

Cutting machine 440 110 110 110 110

Building 3,750 938 938 938 938

Maintenance 18,000 4,500 4,500 4,500 4,500

Interest on loan 8,550 2,138 2,138 2,138 2,138

126,900 31,172 30,956 34,358 30,416

COMMENTS:

28000

29000

30000

31000

32000

33000

34000

35000

Q1 Q2 Q3 Q4

Series1 31172 30956 34358 30416

RM

Manufacturing Overhead Budget for the year 2012


7/12

f) Cash budget

SAFFIYA SDN BHD

f) CASH BUDGET FOR THE QUARTERS 1,2,3,AND 4

Q1 Q2 Q3 Q4

BALANCE b/d 113,380 214,731 502,023

RECEIPTS

SALES COLLECTION:

CASH 80% 215,840 212,800 556,320 243,200

CREDIT 20% 53,000 53,960 53,200 139,080

268,840 380,140 824,251 884,303

PAYMENT

DIRECT MATERIAL:

AWNING 30,000 28,800 78,000 26,400

COTTON CLOTH CASH 50% 41,400 37,800 94,500 28,800

CREDIT 50% 27,800 41,400 37,800 94,500

DIRECT WORKERS:

CUTTING DEPARTMENT 20,250 19,440 52,650 17,820

SEWING DEPARTMENT 13,125 12,600 34,125 11,550

INDIRECT MATERIAL:

INDIRECT MATERIAL: 2,484 2,268 5,670

UTILITIES 1,200 1,200 1,200 1,200

ELECTRICITY 5,400 5,400 5,400 5,400

PURCHASING & MATERIAL

HANDLING

300 300 300 300

QUALITY CONTROL 3,600 3,600 3,600 3,600

SUPERVISOR SALARY 4,500 4,500 4,500 4,500

INSURANCE:

SEWING MACHINE 200 200 200 200

CUTTING MACHINE 110 110 110 110

BUILDING 938 938 938 938

MAINTENANCE 4,500 4,500 4,500 4,500

(-) INTEREST ON LOAN 2,138 2,138 2,138 2,138

155,460 165,409 322,228 207,625

BALANCE c/d 113,380 214,731 502,023 676,678


8/12

COMMENTS:

COMMENTS:

-

100,000

200,000

300,000400,000

500,000

600,000

Q1 Q2 Q3 Q4

Receipt- cash (80%) 215,840 212,800 556,320 243,200

- credit (20%) 53000 53960 53200 139080

RM

Cash Budget for the year 2012

-

50,000

100,000

150,000

200,000

250,000

300,000350,000

Q1 Q2 Q3 Q4Payment 155,460 165,409 322,228 207,625

RM

Cash Budget for the year 2012


9/12

2. Calculate production cost per unit using budgeted and actual data.

SAFFIYA SDN BHD

PRODUCTION COST PER UNITS

BUDGET ACTUAL1 UNIT COST COST/UNIT 1 UNIT COST COST/UNIT

DIRECT MATERIAL

AWNING 1.00 RM4.00 RM4.00 1.00 RM4.00 RM4.00

COTTON CLOTH 0.50 RM18.00 RM9.00 0.50 RM18.00 RM9.00

DIRECT LABOUR

CUTTING DEPARTMENT 0.30 RM9.00 RM2.70 0.30 RM10.00 RM3.00

SEWING DEPARTMENT 0.25 RM7.00 RM1.75 0.25 RM7.00 RM1.75

OVERHEAD 1.00 RM2.96 RM2.96 1.00 RM2.89 RM2.89

TOTAL PRODUCTION

COST/ UNIT RM20.41 RM20.64

COMMENTS:


10/12

3. Calculate the break-even point for DSAFY (in units and RM).

BREAK- EVEN POINT (UNITS) = Fixed cost

Cn/ unit

= 126,900

(38 - 17.45)

= 6,175 Units

BREAK- EVEN POINT (RM)

= BEP (units) x sp

= 6175 x 38

= RM234,650


11/12

4. The company plans to introduce a new design of hijab known as JAMEELA.

JAMEELA will be sold at RM45.00 per piece and its variable cost is 20% higher than

DSAFY. Calculate the break-even point (in units and RM).


12/12

report akaun

Documents