Question

In: Accounting

TASK-4  Calculate the total quantity of materials required for a production process and the total funds required...

TASK-4  Calculate the total quantity of materials required for a production process and the total funds required to purchase the materials.

Mr. Fateh is the operations manager in an electrical equipment manufacturing company producing 3 different products. He needs to prepare a materials requirement plan for all THREE of his Products A, B & C, that is good for 6 months operation. Prepare an MRP chart for him and calculate the total budget (money) required for these materials. The BOM for each item is given under.

B.O.M (Bill of Materials)

Material

Material for one unit of Product

Description

Price (SR)

Unit

A

B

C

Steel

20

KG

5

6

4

Glass

10

SFT

2

3

2

Plastic

50

KG

3

4

2

Electric Motor

200

No

1

2

3

Wires

2

Meter

10

12

8

Capacitor

12

No

5

8

6

Resistances

3

No

10

15

12

Screws

0.02

No

20

25

24

Monthly Demand for Item-A is 700 units, Item-B is 500 units and Item-C is 900 units. (Use the table format as shown in the slide show for MRP)

Solutions

Expert Solution

Material Description PRICE UNIT PRODUCT WISE - A PRODUCT WISE - B PRODUCT WISE - C
1 UNIT 1M - 700 1M - Budget 6M - 4200 6M - Budget 1 UNIT 1M - 500 1M - Budget 6M - 3000 6M - Budget 1 UNIT 1M - 900 1M - Budget 6M - 5400 6M - Budget
Steel 20 KG                                       5                          3,500                             70,000                        21,000          420,000            6            3,000            60,000          18,000              360,000            4            3,600            72,000            21,600              432,000
Glass 10 SFT                                       2                          1,400                             14,000                          8,400            84,000            3            1,500            15,000            9,000                90,000            2            1,800            18,000            10,800              108,000
Plastic 50 KG                                       3                          2,100                          105,000                        12,600          630,000            4            2,000          100,000          12,000              600,000            2            1,800            90,000            10,800              540,000
Electric Motor 200 No                                       1                              700                          140,000                          4,200          840,000            2            1,000          200,000            6,000          1,200,000            3            2,700          540,000            16,200          3,240,000
Wires 2 Meter                                     10                          7,000                             14,000                        42,000            84,000          12            6,000            12,000          36,000                72,000          18          16,200            32,400            97,200              194,400
Capacitor 12 No                                       5                          3,500                             42,000                        21,000          252,000            8            4,000            48,000          24,000              288,000            6            5,400            64,800            32,400              388,800
Resistances 3 No                                     10                          7,000                             21,000                        42,000          126,000          15            7,500            22,500          45,000              135,000          12          10,800            32,400            64,800              194,400
Screws 0.02 No                                     20                        14,000                                   280                        84,000              1,680          25          12,500                  250          75,000                  1,500          24          21,600                  432          129,600                  2,592
                       39,200                          406,280                      235,200      2,437,680          37,500          457,750       225,000          2,746,500          63,900          850,032          383,400          5,100,192
Material Description PRICE UNIT MATERIAL WISE
1M - Total Quantity 1M - Total Budget 6M - Total Quantity 6M - Total Budget
Steel 20 KG                             10,100                      202,000    &nbs

Related Solutions

Required: Calculate the cost of raw materials used in production.
                                               Costs Raw materials purchased $ 75,000 Direct Labor   55,000 Indirect labor     33,000 Factory equipment maintenance and depreciation     15,000 Factory rent     36,000 Factory supplies       6,000 Selling & administrative expenses 100,000 Inventories Beginning Balance Ending Balance Raw Materials $ 5,000 $20,000 Work in Process 25,000 30,000 Finished Goods 20,000 35,000 Required:   Calculate the cost of raw materials used in production. Required:  Calculate the cost of goods manufactured Calculate the cost of goods sold. Required:  Calculate the prime costs   Calculate the conversion costs.
Production quantity and the total cost of production are given in the form of a table....
Production quantity and the total cost of production are given in the form of a table. Production quantity (100 tons) 42 16 48 50 30 12 18 28 Total cost (1000 of Rs.) 22 10 14 20 14 8 12 16 Determine the total cost production for (i) 2500 tons (ii) 4500 tons If the total production cost is Rs. 50,000, then how many quantities were produced?
Required: 1. For direct materials: a. Compute the price and quantity variances. b. The materials were...
Required: 1. For direct materials: a. Compute the price and quantity variances. b. The materials were purchased from a new supplier who is anxious to enter into a long-term purchase contract. Would you recommend that the company sign the contract? 2. For direct labor: a. Compute the rate and efficiency variances. b. In the past, the 20 technicians employed in the production of Fludex consisted of 7 senior technicians and 13 assistants. During November, the company experimented with fewer senior...
Task 4: Develop Strategies for Improved Cultural Safety As part of this task, you are required...
Task 4: Develop Strategies for Improved Cultural Safety As part of this task, you are required to develop strategies for improved cultural safety when working with the Aboriginal and Torres Strait Islander people in your region (in relation to providing the information session). Activities you need to complete are provided in the questions below. Your answers must be 30-40 words each and specific to the Aboriginal and Torres Strait Islander people in your region and the information session being planned....
Materials are added at the beginning of a production process, and ending work in process inventory...
Materials are added at the beginning of a production process, and ending work in process inventory is 40% complete with respect to conversion costs. Use the information provided to complete a production cost report using the weighted-average method. Costs to Account For Beginning inventory: materials $11,000 Beginning inventory: conversion 20,000 Direct material 46,200 Direct labor 75,000 Applied overhead 42,340 Total costs to account for $194,540 Units to Account For Beginning work in process 4,000 Units started into production 22,000 Transferred...
The Company uses a single department production process.  Materials are added at the start of the production...
The Company uses a single department production process.  Materials are added at the start of the production process and labor and overhead are added as indicated. The Company records have the following information for the month of November: UNITS: Beginning WIP:  2/3 complete for labor; 1/3 complete for overhead                                    12,000 units Units started in process                                                                                               40,000 units Units completed                                                                                                          44,000 units Ending WIP:  50% complete for labor; 25% complete for overhead                           8,000 units PRODUCTION COSTS: Work in Process, Beginning of the Month: Materials                                          $ 32,000 Labor                                                  20,000 Overhead                                              9,400               61,400 Current...
Compute the total quantity of heat (both in Kcal and J) required to raise the temperature...
Compute the total quantity of heat (both in Kcal and J) required to raise the temperature of 1.00 kg of ice at -10.0 degrees C to 1.00 kg of steam at 110.0 degrees C. Assume no loss of mass or heat in this process. Note that this will requires several computations that must be completely added up, and you must include all phase changes and use the correct specific heats.
3.1 Required: Calculate the following: 3.1.1 Break-even quantity. (4) 3.1.2 Break-even value using the marginal income...
3.1 Required: Calculate the following: 3.1.1 Break-even quantity. (4) 3.1.2 Break-even value using the marginal income ratio. (3) 3.1.3 Margin of safety (in terms of units). (3) 3.1.4 Expected total marginal income and net profit. (5) INFORMATION Sharpe Ltd manufactures calculators. The following information was extracted from the budget for the year ended 31 December 2017: Sales Selling price per calculator Variable production cost per unit Fixed production costs Variable selling and administrative costs per unit Fixed selling and administrative...
Calculate the quantity of energy, in joules, required to raise the temperature of 486 g tin...
Calculate the quantity of energy, in joules, required to raise the temperature of 486 g tin from room temperature, 25.0 °C, to its melting point, 231.9 °C, and then melt the tin at that temperature. (The specific heat capacity of tin is 0.227 , and the enthalpy of fusion of this metal is 59.2 J/g.)
4. Advice on how to determine to purchase materials at larger quantities with quantity discounts or...
4. Advice on how to determine to purchase materials at larger quantities with quantity discounts or smaller quantities (or at economic ordering quantity) but without discounts.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT