84CHAPTER ELEVEN11.19. A company that manufactures snow shovels has one plant and two distributioncenters (DCs). Given the following information for the two DCs, calculate thegross requirements, projected available, and planned order releases for the two DCsand the gross requirements, projected available, and planned order releases for thecentral warehouse.Distribution Center A2 weeksTransit Time:Order Quantity: 500 units43251Week275150300200300Gross Requirements500In Transit200Projected AvailablePlanned Order ReleaseDistribution Center B2 weeksTransit Time:Order Quantity: 200 units54321Week1501251007550Gross RequirementsIn Transit150Projected AvailablePlanned Order ReleaseCentral Supply1 weekLead Time:Order Quantity: 600 units5Week1243Gross RequirementsScheduled ReceiptsProjected Available400Planned Order Release

Materials requirement planning for DC A, DC B, and central supply:

Answered: 84 CHAPTER ELEVEN 11.19. A company that…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Farmers Groceries To You (FGTY) is a fast-growing company started by JMU alumni, which delivers fresh groceries collected in Virginia farms to families in the Shenandoah region. As part of an expansion plan, FGTY is considering approaching the northern Virginia market through printed product lists (PLs) containing deals, coupons and customers testimonies. The initial plan is to send 200,000 PLs to households in Fairfax and Arlington, expecting new customers to place orders. The company estimates to incur a fixed cost of $30,000 associated with design, printing setup and transportation contracting. Beyond this, the average transportation cost per PL is ¢20, while the printing cost per PL is ¢10. Also, FGTY incurs in an average cost of ¢25 for processing each order placed by a customer using the PL’s promotion codes. The expected size of an order is $50, and FGTY’s variable cost per order (mainly product costs labor) is close to 80% of the order’s average. You’ve been hired to help FGTY…
Problem 21-9 (Algo) Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 5 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 4 F Metal tong 3 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 30 20 73 22 200 149 1,000 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)
corrugated carton number of units profit 6 4 0 constraints cutting 2 3 0 = < 120 pinning 2 1 0 = < 60 LHS SIGN RHS Part B Step 1: Use the formulated problem as in part A with the return and constraint coefficients to set up Excel sheet Step 2 Setting up the worksheet Key in the profit coefficients per box type in range B3:c3 ■ key in the LHS constraint coefficients in terms of Decision variables, for example variable "x1" or "b" has a coefficient of 2 is written 2x1 or 2b using the range B5:C7…
The BOMs for products A & B and data from the inventoryrecords are shown in Figure 11.41. Data from the inventoryrecords are shown in Table 11.10. In the MPS for product A,the MPS start row has 85 units in week 2 and 200 in week 4and 50 in week 8. In the MPS for product B, the MPS start rowhas 65 units in week 3 and 50 in week 4 and 50 in week 5 and75 in week 8.a. Develop the material requirements plan for the next8 weeks for items C, D, and E. Note any difficulties youobserve in the inventory records.b. Can the difficulties noted in part (a) be rectified byexpediting any Scheduled Receipts?
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the allowable range for the right-hand-side for Resource C?
1. RBF, an emerging singer, is getting ready to cut his first album. The cost of recordingthe CD is Php 500,000 but copies are Php 500 apiece. If the album can be sold forPhp1,500 each, (a) how many CDs must be sold to break even? (b)What is thebreakeven point in dollars?RBF is confident that demand for his album will substantially exceed the break-evenpoint computed above. So, Mikey is contemplating having his album at a classier (andpricier) studio. The cost to record the CD would rise to Php 90,000. However, since thisnew studio works with very high volume, production costs would fall to Php 200 per CD.(c) What is the breakeven point for this new process?(d) Compare this process to the process proposed in the pre SHOW COMPLETE SOLUTION.
Electro Fans has just received an order for one thousand 20˝ fans due in week 7. Each fan consists of a housing assembly, two grills and a fan assembly. The housing assembly consists of a frame, two supports and a handle. The following table gives lead times, on-hand inventory, and scheduled receipts. Table 1.1: Lead time and quantity on hand Item Lead Time Qty on hand Lot size# Scheduled receipt 20˝ Fan Housing Frame Supports (2) Handle Grills (2) Fan Assembly 1 1 2 1 1 2 3 80 90 - 50 400 200* 150 - - - 100 400 450 - 50 fan assembly in week 2 * In week 3 it was found that 50% of the on hand inventory of the grills was damaged. # Items without any lot size given should be considered as lot-for-lot. (i) Construct a product structure. (ii) Construct a time-phased product structure. (iii) Prepare a net requirement plan.
Should BestLine’s ordering department have been more involved during the project?2. Sarah used expert interviews for this project. Were there more effective methods for gathering therequirements?3. What crucial step(s) did Sarah skip in the requirements process?4. Which downstream activities would likely be affected by her approach? At what point in the projectwould the problems likely emerge?5. Should Sarah have presented the requirements to the ordering manager at this point? Should the orderingmanager have signed off on them?
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
Francesca’s Boutique has a merchandise budget that includes $53,420 in planned sales for Dresses, $5342 in planned reductions, and $63,762 in planned purchases. The assortment includes 4 sub classifications (Casual (30%), dressy (20%), day-to-night (35%), date night (15%)) with 5styles, 4 colors, 4 sizes (for each sub class). The average first price on the dress is $45. Francesca’s expects to devote about 50 square feet to displaying the dresses in each store (10 stores), and the shirts to generate approx. $107 per square foot during the fall selling period. Markdowns are expected to be 10% of sales. Average Markup is 63%. Based on the information provided: What is the planned volume of the assortment? (Note: Use Planned Merchandise to Receive figures) How many SKUs are in this assortment? What is the model stock for the entire dress assortment?
6. Laura is trying to decide whether to sell her knitted hats on Etsy, at a holiday bazaar, or in a local boutique. Demand could be 0 hats/month, 10 hats/month, or 20 hats/month. Given the payoff matrix below, what is her decision under equally likely? Demand = 0 Demand = 10 Demand = 20 Etsy -$70 $80 $230 Bazaar -$60 $90 $240 Boutique -$80 $70 $220 Select one: a. Etsy and boutique. b. Etsy only. c. Etsy and bazaar. d. Bazaar and boutique. e. All 3 are equally good. f. Bazaar only. g. None of them are good options. h. Boutique only.
Item4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 eBookReferences Item 4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 The production planner for a private label soft drink maker is planning the production of two soft drinks: root beer (R) and sassafras soda (S). There are at most 12 hours per day of production time and 1,500 gallons per day of carbonated water available. A case of root beer requires 2 minutes of time and 5 gallons of water to produce, while a case of sassafras soda requires 3 minutes of time and 5 gallons of water. Profits for the root beer are $6.00 per case, and profits for the sassafras soda are $4.00 per case. The firm’s goal is to maximize profits. What is the time constraint? rev: 09_21_2020_QC_CS-229783 Multiple Choice 5R + 5S ≤ 720. 3R + 5S ≤ 720. 2R + 5S ≤ 720. 3R + 2S ≤ 720. 2R + 3S ≤ 720.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS