please answer in 30 mins. b) Determine the gross quantities needed of each item if you are to assemble 50 brackets.Base:units (enter your response as a whole number).Spring:units (enter your response as a whole number).Clamp:units (enter your response as a whole number).Housing:units (enter your response as a whole number).Handle:units (enter your response as a whole number).Casting:units (enter your response as a whole number).Bearing:units (enter your response as a whole number).Shaft:units (enter your response as a whole number). As the production planner for Xiangling Hu Products, Ic., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 3 clamps. The base is assembled from 1 clamp and 1 housing. Each clamphas 1 handle and 2 castings. Each housing has 1 bearing and 1 shaft. There is no inventory on hand.This exercise contains only parts b and c.The product structure is as follows:BracketBase(1)Spring(2)Housing(1)Clamp(3)Clamp(1)Handle 1) |Casting2) Bcaring(1)Shafi 1) |Handle ı) |Casting 2)

A product structure helps to identify the component and material relationship of each items. Using…

b) Determine the gross quantities needed of each item if you are to assemble 50 brackets. Base: units (enter your response as a whole number). Spring: units (enter your response as a whole number). Clamp: units (enter your response as a whole number). Housing: units (enter your response as a whole number). Handle: units (enter your response as a whole number). Casting: units (enter your response as a whole number). Bearing: units (enter your response as a whole number). Shaft: units (enter your response as a whole number).

b) Determine the gross quantities needed of each item if you are to assemble 50 brackets. Base: units (enter your response as a whole number). Spring: units (enter your response as a whole number). Clamp: units (enter your response as a whole number). Housing: units (enter your response as a whole number). Handle: units (enter your response as a whole number). Casting: units (enter your response as a whole number). Bearing: units (enter your response as a whole number). Shaft: units (enter your response as a whole number).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

As the production planner for Xiangling HuProducts, Inc., you have been given a bill of material fora bracket that is made up of a base, two springs, and fourclamps. The base is assembled from one clamp and twohousings. Each clamp has one handle and one casting. Eachhousing has two bearings and one shaft. There is no inventoryon hand. a) Design a product structure noting the quantities for eachitem and show the low-level coding.b) Determine the gross quantities needed of each item if youare to assemble 50 brackets.c) Compute the net quantities needed if there are 25 of thebase and 100 of the clamp in stock.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and\ 1 housing. Each clamp has 1 handle and 2 castings.Each housing has 1 bearing and 2 shafts.There is no inventory on hand. C) Compute the net quantities needed if there are 25 of the base and 75 of the clamp in stock. (Product structure picture attached) Base = (?) units Spring = (?) units Clamp = (?) units Housing = (?) units Handle = (?) units Casting = (?) units Bearing = (?) units Shaft = (?) units
Refer to this product tree: A hierarchical diagram that depicts the subassemblies and components that are needed to produce and/or assemble a product P.P requires 2 components of A, 3 components of B and 4 components C. A further requires 3 components of M and 4 components of N. B further requires 4 components of C and 5components of D. If 1000 Ps are needed, and on-hand inventory consists of 200 Ps and 100 each of all other components and subassemblies, how many Cs are needed? Multiple Choice 9200 3200 12300 12200 3100
Draw a simple bill-of-materials (BOM) for a smart phone given the following requirements: (a) clearly label the end item and each component, (b) the BOM must contain no more than ten items, (c) the BOM must contain at least three levels (you may count the end-item level zero).
Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan. Week Gross requirements 1 30 Week Gross requirements On-hand at beginning of week 40 On-hand at end of week Order receipt Order release Total relevant cost for this plan is = $ 2 3 30 1 30 4 2 5 40 70 20 Also, for this plan the Holding cost = $2.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40 units. Use the table below to develop a PPB solution for MRP (enter your responses as whole numbers). 3 30 6 7 8 4 5 40 (enter your response as a whole number). 6 ॥ 70 9 10 70 7 20 10 11 8 D 12 50 9 10 11 12 10 70 50
Bhatti Company produces plastic photo frames. Two departments, molding and finishing, are involved in the manufacturing. The molding department fills the molds with hot liquid plastic that is left to cool and then opens them. The finishing department removes the plastic frame from the mold and strips the edges of the frames of extra plastic. The following information is available for the month of January: January 1 Quantity (pounds) January 31 Quantity (pounds) Work-in-Process Inventory Cost Cost Molding department Finishing department None None 5,000 $ 15,000 2,000 The WIP Inventory in the finishing department is estimated to be 40% complete for conversion both at the beginning and end of January. Costs of production for January follow: Direct Costs of Production Materials Conversion Molding department Finishing department $ 450,000 $ 90,000 80,290 The molding department started 50,000 pounds of product in January. The firm uses the FIFO method of process costing. Required: 1. Prepare…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: units
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 1 housing. Each clamp has 1 handle and 2 castings. Each housing has 1 bearing and 2 shafts. There is no inventory on hand. Part 2 a) Design a product structure noting the quantities for each item and show the low-level coding. Match each number in the structure below with the corresponding item. Number Item I Spring Subscript left parenthesis 2 right parenthesisSpring(2) II Housing Subscript left parenthesis 1 right parenthesisHousing(1) III Casting Subscript left parenthesis 2 right parenthesisCasting(2) IV Shaft Subscript left parenthesis 2 right parenthesisShaft(2) Bracket Base(1) Clamp(1) Handle(1) Clamp(4) Bearing(1) Handle(1) Casting(2) IIIIIIIV Part 3 b) Determine the…
Given the following Product Structure Diagram The number of G’s required for each A is _________.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 1 spring, and 3 clamps. The base is assembled from 2 clamp and 1 housing. Each clamp has 1 handle and 1 casting. Each housing has 2 bearing and 2 shaft. There is no inventory on hand. Part 2 a) Design a product structure noting the quantities for each item and show the low-level coding. Match each number in the structure below with the corresponding item. Number Item I Bracket II Spring Subscript left parenthesis 1 right parenthesis III Clamp Subscript left parenthesis 3 right parenthesis IV Bearing Subscript left parenthesis 2 right
Consider the following product structure. If the demand for product A is 50 units, how many units of component D will be needed? Part 2 A. 200 B. 300 C. 50 D. 100 E. 150
What is the net requirement using a Material Requirements Planning program if the gross requirement is 1,250 and the inventory on hand is 50?