Question

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)

Answer 1

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 ekkarill92 Next > < Previous 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... 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. TASK 3 - PC 4.3 Calculate sales mix and quantity variances (20 marks) Ghaya LLC a... TASK 3 - PC 4.3 Calculate sales mix and quantity variances Ghaya LLC a producer of personal hygiene items for medical facilities has the following information relating to its sales: Units Price Actual Product A 14,900 6.20 Actual Product B 7,800 12.10 Actual 22,700 Budgeted Product A 13,000 5.90 Budgeted Product B 7,000 10.50 Budgeted 20,000 Required: Use the Actual and Budgeted Information to answer the following: a)Calculate the Budgeted Product “A” Sales Mix in Percentage b)Calculate the Budgeted Product... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Strategy(China’s Didi Chuxing Offers Ride-Hailing Service in Mexico) write a one page research essay on this... The following sentences and paragraphs highlight some of the problems you learned about in this chapter.... Raising Extra Capital As companies mature, their business needs change. This typically causes the need to... insert code in all TODO part, it's about pointer. atmel studio 7.0. this should be able... Consider the two variables service quality and customer satisfaction. Service quality is independent variable and customer... Python Language: In the CIS 41A version of Battleship, the user tries to find the computer's... Questions 9-13 concern general information about each of the invertebrate phyla we discussed this semester. If... ADVERTISEMENT About @ 2020 WizEdu