Old MathJax webview

relevant info to complete the MOH

N34 3.960 3,250 7.450 9,133 A B C D E F G H H M N 1 1 Altec Manufacturing Inc. 2 Manufacturing Overhead Budget 3 For the year ended December 31, 2022 4 5 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Dec Year 6 Production in Unts 4,116 3.200 5,024 6,784 4,800 5,712 7,200 5,376 4.832 10,016 13.216 10 540 80916 7 Variable overhead rate per unit $ 2595 5 25.955 25.955 25.955 25.955 25.955 25.95 5 25.955 25 95 5 25.955 25.95 5 25.95 $ 2595 8 8 Variable manufacturing overhead $ 106 810 583,040 $ 130,373 176,045 $ 124,560 5 148.226 186,849 $ 139.507 $125,390 $ 259,915 5 342.955 275.108 52099.770 $ $ $ 9 10 Fed manufacturing overhead 11 Training and development 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,360 12 Property and business taxes 3.250 3,250 3,250 3,250 3,250 3,250 3.250 3.250 3.250 3,250 3,250 3,250 13 Supervisor Salaries 7,450 7,450 7.450 7,450 7.450 7,450 7.450 7.450 7.450 7.450 7,450 7,450 14 Amortization on equipment 18,980 18,980 18,900 18,980 18,980 18,980 18,980 18.980 18,980 18,980 18.980 18,980 15,980 15 Insurance 7,705 7,705 7,705 7,705 7705 7,705 7,705 7,705 7,705 7,705 7,705 7.705 7,705 16 Other 9,133 9,133 9,133 9.133 9,133 9,133 9.133 9,133 9,133 9,133 9.133 9.133 17 Total fixed manufacturing OH 50,478 50.478 50,478 504478 50.478 50.478 50 478 50,478 50.478 50/478 50.478 50.478 50,478 18 19 Total manufacturing OH $ 157,288 5 133,518 $ 180,851 $ 180,851 5 226,523 5 175,038 $ 198704 5. 226,523 5 175,038 % 198,704 5237 318 3189,985 $ 175,868 5 310,3935393.433 5 326,586 52150,248 20 21 22 Altec Manufacturing Inc. 23 Schedule of Expected Cash Disbursement for Manufacturing OH 24 For the year ended December 31, 2022 25 26 Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec Year 27 Total manufacturing oH for month 157 288 133 518 180.851 226,523 175 038 198,704 237 318 189.985 175,868 310 393 393,433 28 Noncash tems 325 586 2,150,248 29 property tax 3.250 3,250 3.250 3.250 3,250 3.250 3,250 30 3.250 3.250 3.250 3,250 3.250 39000 insurance 7705 7.705 7,705 7,705 7,705 7,705 7.705 71705 7,705 7.705 7.705 7,705 92 460 31 amortization 18.980 18,980 18.980 18,980 18.980 18,980 18,980 18,980 18 980 18,980 18.980 18.900 277760 Monthly cash disbursements for 32 manufacturing OH 127,350 103.583 150 916 196 588 145, 103 165,769 207,383 160,050 145,933 280 458 363 498 296.651 1.741028 33 Lump sum payments 93,300 39,000 122.300 34 property tax 35 insurance Cash disbursements for 36 manufacturing OH $_127.353 5 103,583 5.150 916 5 103 288. S. 145.103 $ 129,789 S 207.383 160,050 $ 145,833 $ 280,458 $363.498 $ 296,651 $1.608.728 37 38 Jul $ 127,353 S 103,563 $ 150,916 5 103,288 145,103 5 129,769 3. 207 353 $ 160,050 $ 145,933 $ 280,458 S 363 498 5 296 651 51608,728 Altec Manufacturing Inc. Schedule of Prepaid Insurance For the year ended December 31, 2022 Jan Feb Jul Sep Dec 23115 6705 15,410 23115 705) 15 410 23115 (7705) 15,410 Apr 23115 (7,705) 15.410 May 23115 (0,705) 15,410 Jun 23115 (7,705) 15,410 23115 (7,705) 15,410 Aug 23115 (7,705) 15,410 23115 (7705) 15.410 Oct 23115 (7.705 15.410 23115 (7.705 15.410 23115 17705 ( 15,410 Year 23115 192 160) (69 345) 15,410 15.410 15.410 15.410 15.410 15,410 15,410 LO 36 manufacturing OH 37 38 39 40 41 42 43 44 Balance at beginning of month 45 Expensed during the month 45 Balance before premiums paid 47 Premium paid 48 Balance at end of month 49 50 51 52 53 54 55 56 57 58 59 60 61 62 15,410 15,410 15,410 15,410 15,410 (59,345) 6) Beginning accounts payable will consist of $227,800 arising from the following estimated direct material purchases for November and December of 2021: SAA purchases in November 2021: $450,000 SAA purchases in December 2021: $306,000 7) Altec's manufacturing process is highly automated. Employees are paid on a per unit basis. Their total pay each month is, therefore, dependent on production volumes and averages $20.00 per hour before benefits. The employer'sportion of employee benefits adds 20% to the hourly rate. All payroll costs are paid in the period in which they are incurred. Each unit spends a total of 75 minutes in production. 8) Due to the similarity of the equipment in each of the production stages and the company's concentration on a single product, manufacturing overhead is allocated based on volume (i.e. the units produced). The variable overhead manufacturing rate is $25.95 per unit, consisting of: Utilities--$12.00; Indirect Materials--$5.00; Plant maintenance--$4.50; environmental fee--$1.95, and Other--$2.50. 9) The expected fixed manufacturing overhead costs below cover the twelve months ended December 31, 2021 and are based on actual costs to date and budgeted costs for the duration of the year. Training and development Property and business taxes Supervisor's salary Amortization on equipment Insurance Other $ 47.520 36.000 89.400 227.760 192.460 109.600 $ 602 140 Alignment Number Styles C15 A B @ D K L M M N E F G H Altec Manufacturing Inc. Direct Labour Budget For the year ended December 31, 2022 Woo AWN 2 3 4 5 6 7 Jan Feb Mar Apr Jun Jul Aug Oct Year May 4.800 Units to be produced 4,116 Sep 4,832 3.200 Nov 13,216 5.024 Dec 10.640 6,784 5.712 7,200 5,376 10,016 80,916 1.25 1:25 1.25 1.25 1.25 1.25 1.25 1125 1.25 11.25 1.25 1.25 1.25 5.145.00 s 24.00 4,000.00 24.00 6,280.00 24.00 8,480.00 24.00 6.000.00 24.00 7.140.00 24.00 9.000.00 S 24.00 6.720.00 24.00 6.040.00 24.00 12.520.00 S 24.00 16.520.00 24.00 13,300.00 24.00 101,145.00 24.00 S $ IS S S $ $123.480 s 96,000 $ 150.720 S 203.520 $ 144,000 S 171,360 S 216.000 S 161,280 $ 144.960 $ 300,480 S396,480 $ 319,200 $ 2.427 480 8 Direct Labour time per unit (hours) Total hours of direct labour time 9 needed 10 Direct Labour cost per hour 11 Total direct labour cost 12 13 14 15 16 17 18 19 20 21 22 23 N34 3.960 3,250 7.450 9,133 A B C D E F G H H M N 1 1 Altec Manufacturing Inc. 2 Manufacturing Overhead Budget 3 For the year ended December 31, 2022 4 5 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Dec Year 6 Production in Unts 4,116 3.200 5,024 6,784 4,800 5,712 7,200 5,376 4.832 10,016 13.216 10 540 80916 7 Variable overhead rate per unit $ 2595 5 25.955 25.955 25.955 25.955 25.955 25.95 5 25.955 25 95 5 25.955 25.95 5 25.95 $ 2595 8 8 Variable manufacturing overhead $ 106 810 583,040 $ 130,373 176,045 $ 124,560 5 148.226 186,849 $ 139.507 $125,390 $ 259,915 5 342.955 275.108 52099.770 $ $ $ 9 10 Fed manufacturing overhead 11 Training and development 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,960 3,360 12 Property and business taxes 3.250 3,250 3,250 3,250 3,250 3,250 3.250 3.250 3.250 3,250 3,250 3,250 13 Supervisor Salaries 7,450 7,450 7.450 7,450 7.450 7,450 7.450 7.450 7.450 7.450 7,450 7,450 14 Amortization on equipment 18,980 18,980 18,900 18,980 18,980 18,980 18,980 18.980 18,980 18,980 18.980 18,980 15,980 15 Insurance 7,705 7,705 7,705 7,705 7705 7,705 7,705 7,705 7,705 7,705 7,705 7.705 7,705 16 Other 9,133 9,133 9,133 9.133 9,133 9,133 9.133 9,133 9,133 9,133 9.133 9.133 17 Total fixed manufacturing OH 50,478 50.478 50,478 504478 50.478 50.478 50 478 50,478 50.478 50/478 50.478 50.478 50,478 18 19 Total manufacturing OH $ 157,288 5 133,518 $ 180,851 $ 180,851 5 226,523 5 175,038 $ 198704 5. 226,523 5 175,038 % 198,704 5237 318 3189,985 $ 175,868 5 310,3935393.433 5 326,586 52150,248 20 21 22 Altec Manufacturing Inc. 23 Schedule of Expected Cash Disbursement for Manufacturing OH 24 For the year ended December 31, 2022 25 26 Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec Year 27 Total manufacturing oH for month 157 288 133 518 180.851 226,523 175 038 198,704 237 318 189.985 175,868 310 393 393,433 28 Noncash tems 325 586 2,150,248 29 property tax 3.250 3,250 3.250 3.250 3,250 3.250 3,250 30 3.250 3.250 3.250 3,250 3.250 39000 insurance 7705 7.705 7,705 7,705 7,705 7,705 7.705 71705 7,705 7.705 7.705 7,705 92 460 31 amortization 18.980 18,980 18.980 18,980 18.980 18,980 18,980 18,980 18 980 18,980 18.980 18.900 277760 Monthly cash disbursements for 32 manufacturing OH 127,350 103.583 150 916 196 588 145, 103 165,769 207,383 160,050 145,933 280 458 363 498 296.651 1.741028 33 Lump sum payments 93,300 39,000 122.300 34 property tax 35 insurance Cash disbursements for 36 manufacturing OH $_127.353 5 103,583 5.150 916 5 103 288. S. 145.103 $ 129,789 S 207.383 160,050 $ 145,833 $ 280,458 $363.498 $ 296,651 $1.608.728 37 38 Jul $ 127,353 S 103,563 $ 150,916 5 103,288 145,103 5 129,769 3. 207 353 $ 160,050 $ 145,933 $ 280,458 S 363 498 5 296 651 51608,728 Altec Manufacturing Inc. Schedule of Prepaid Insurance For the year ended December 31, 2022 Jan Feb Jul Sep Dec 23115 6705 15,410 23115 705) 15 410 23115 (7705) 15,410 Apr 23115 (7,705) 15.410 May 23115 (0,705) 15,410 Jun 23115 (7,705) 15,410 23115 (7,705) 15,410 Aug 23115 (7,705) 15,410 23115 (7705) 15.410 Oct 23115 (7.705 15.410 23115 (7.705 15.410 23115 17705 ( 15,410 Year 23115 192 160) (69 345) 15,410 15.410 15.410 15.410 15.410 15,410 15,410 LO 36 manufacturing OH 37 38 39 40 41 42 43 44 Balance at beginning of month 45 Expensed during the month 45 Balance before premiums paid 47 Premium paid 48 Balance at end of month 49 50 51 52 53 54 55 56 57 58 59 60 61 62 15,410 15,410 15,410 15,410 15,410 (59,345) 6) Beginning accounts payable will consist of $227,800 arising from the following estimated direct material purchases for November and December of 2021: SAA purchases in November 2021: $450,000 SAA purchases in December 2021: $306,000 7) Altec's manufacturing process is highly automated. Employees are paid on a per unit basis. Their total pay each month is, therefore, dependent on production volumes and averages $20.00 per hour before benefits. The employer'sportion of employee benefits adds 20% to the hourly rate. All payroll costs are paid in the period in which they are incurred. Each unit spends a total of 75 minutes in production. 8) Due to the similarity of the equipment in each of the production stages and the company's concentration on a single product, manufacturing overhead is allocated based on volume (i.e. the units produced). The variable overhead manufacturing rate is $25.95 per unit, consisting of: Utilities--$12.00; Indirect Materials--$5.00; Plant maintenance--$4.50; environmental fee--$1.95, and Other--$2.50. 9) The expected fixed manufacturing overhead costs below cover the twelve months ended December 31, 2021 and are based on actual costs to date and budgeted costs for the duration of the year. Training and development Property and business taxes Supervisor's salary Amortization on equipment Insurance Other $ 47.520 36.000 89.400 227.760 192.460 109.600 $ 602 140 Alignment Number Styles C15 A B @ D K L M M N E F G H Altec Manufacturing Inc. Direct Labour Budget For the year ended December 31, 2022 Woo AWN 2 3 4 5 6 7 Jan Feb Mar Apr Jun Jul Aug Oct Year May 4.800 Units to be produced 4,116 Sep 4,832 3.200 Nov 13,216 5.024 Dec 10.640 6,784 5.712 7,200 5,376 10,016 80,916 1.25 1:25 1.25 1.25 1.25 1.25 1.25 1125 1.25 11.25 1.25 1.25 1.25 5.145.00 s 24.00 4,000.00 24.00 6,280.00 24.00 8,480.00 24.00 6.000.00 24.00 7.140.00 24.00 9.000.00 S 24.00 6.720.00 24.00 6.040.00 24.00 12.520.00 S 24.00 16.520.00 24.00 13,300.00 24.00 101,145.00 24.00 S $ IS S S $ $123.480 s 96,000 $ 150.720 S 203.520 $ 144,000 S 171,360 S 216.000 S 161,280 $ 144.960 $ 300,480 S396,480 $ 319,200 $ 2.427 480 8 Direct Labour time per unit (hours) Total hours of direct labour time 9 needed 10 Direct Labour cost per hour 11 Total direct labour cost 12 13 14 15 16 17 18 19 20 21 22 23