Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 131 units. The following is the BoM in indented form: ITEM X DESCRIPTION Bracket assembly USAGE 1 A Wall board 4 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 3 F Metal tong G Plastic cap 5 2 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 23 18 55 25 200 170 1,100 90

Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 131 units. The following is the BoM in indented form: ITEM X DESCRIPTION Bracket assembly USAGE 1 A Wall board 4 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 3 F Metal tong G Plastic cap 5 2 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 23 18 55 25 200 170 1,100 90

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

Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
LMNO Gaskets has formulated a production plan for a product to meet demand over the upcoming four quarters. Demand in each of the four quarters and production, overtime, and subcontracting capacities are reported in the table below, in addition to the feasible production plan. The relevant costs are: • Regular time production cost is $10/unit. Overtime production cost is $14/unit. Subcontracting cost is $18/unit Inventory is held at a cost of $1/unit/quarter. • Units may be backordered at a cost of $4/unit/quarter. Production Resource Regular Time Q1 Overtime Q1 Subcontract Q1 Regular Time Q2 Overtime Q2 Subcontract Q2 Regular Time Q3 Overtime Q3 Subcontract Q3 Demand in Quarter Demand in Quarter Q2 0 20 0 550 Q1 550 230 0 0 0 0 40 40 0 860 250 470 0 40 0 1330 What is the inventory cost for the year? What is the backorder cost for the year? What is the total cost for the year? Q3 0 0 0 0 0 30 510 160 0 700 What is the total overtime production cost for the year? Capacity 550 250 500…
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
The total cost, excluding normal time labor costs, for Plan A = $. (Enter your response as a whole number.) Plan B: Vary the workforce to produce the prior month's demand. Demand was 1,300 units in June. The cost of hiring additional workers is $30 per unit produced. The cost of layoffs is $65 per unit cut back. (Enter all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of 1,300 in July to 1000 in August requires a layoff (and related costs) of 300 units in August). Month 1 2 3 September 4 October July August 5 November 6 December Demand 1000 1200 1400 1800 1800 1800 Hire Production (Units) The total hiring cost = $ The total layoff cost = $ The total inventory carrying The total stockout cost = $ The total cost, excluding normal time labor costs, for Plan B = (Enter your response as a whole number.) (Enter your response as a whole number.) cost = $ (Enter your response as a whole number.) Layoff…
Id-6c An aggregate plan provides justification for: Select one: a. the budget amount requested b. demand for individual products c. demand for product families d. the demand for the parts of each product and. number of customers
QtyI Standard Labor Hour Raw Material Standard Labor 2 Hours Raw Material INDEPENDENT DEMAND Period 2 3 4 5 Total 6 Product A 1,000 1,000 1,000 1,000 1,000 1,000 6,000 Product B 500 500 500 1,500 15. The standard labor capacity required to support this plan is A. 9,000 hours B. 13,500 hours C. 18,000 hours D. 21,000 hours 16. Products A and B are produced on two different dedicated production lines. If both lines work on the same shift schedule, the ratio of workers on line A to workers on line B is A. 2:1 В. 2:3 С. 2:5 D. 4:1
The Bawl Corporation supplies alloy ball bearings to automanufacturers in Detroit. Because of its specialized manu-facturing process, considerable work-in-process and rawmaterials are needed. The current inventory levels are$2,470,000 and $1,566,000, respectively. In addition, fin-ished goods inventory is $1,200,000 and sales (at cost) forthe current year are expected to be about $48 million. Ex-press total inventory asa. Weeks of supplyb. Inventory turns
n1
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).
Using the information in(You need to schedule I0 units of product Alpha fordelivery in 6 weeks. Three units of D and 2 units ofF are requiredfor each Alpha. The lead time for Alpha is I week. Lead time forD is I week, and lead time for F is 2 weeks.a) Construct a product structure.b) Prepare a time-phased product structure.c) Prepare a gross requirements plan for Alpha. ), construct a netmaterial requirements plan. There are 2 Alphas on hand and 4 Ds.
Gary’s Seasoning wants to increase its capacity by adding more blending and packagingmachines. Two vendors have presented proposals. Vendor A’s equipment costs $11,500 and the variable cost per unit is $2.00. Vendor B’s equipment costs $13,500 and the variable cost per unit is $1.75. Selling price for each seasoning packet for $4.00.a. What is the break-even point for each proposal?b. If the expected volume is 7,500 packages, which vendor should be chosen? (Show all calculations to earn full credit)
You have developed the following simple product structure of items needed for your gift bag for a rush party for prospective pledges in your organization. You forecast 200 attendees. Assume that there is no inventory on ha nd of any of the items. Explode the bill of material. (Subscripts indicate the number of units required.)