In: Accounting
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)
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 SolutionsRequired: 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
Latest Questions
ADVERTISEMENT
|