QUESTION 1A master production schedule shows the following informationMPSWeekWeekWeekWeekBeginning inventory =30031Forecast1.0001,2001,3001.200800700Actual customer ordersProjected on-handinventoryAvailable to promise8001,000MPSBased on the information in the MPS, what is the amount that is available to promise in week 4?O a. 1,200Ob.700Oc. 1.500O d. 500

Find the Given details below: Weeks 1 2 3 4 Forecasted Demand 1000 1200 1300 1200 Actual…

Answered: QUESTION 1 A master production schedule…

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

Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2 280 125 680 770 3 400 170 280 4 290 265 640 650 5 250 150 390 6 260 265 965 840 7 250 240 715 8 290 125 1295 870 555 9 310 190 985
Q2) Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1400 Beginning inventory 200 units 2 1000 Stockout cost $50 per unit 3 1500 Inventory holding cost $8 per unit at end of quarter 4 1300 Hiring workers $5 per unit Laying off workers $10 per unit Unit cost $30 per unit Overtime $10 extra per unit Which of the following production plans is better: Plan A—chase demand by hiring and layoffs; or Plan B—produce at a constant rate of 1200 and obtain the remainder from overtime? Finish the calculation. image
Bill of Material for Office Table Top Assembly (1 required) Bracket (required) Office Table Final Assembly Gross Requirements Scheduled Receipts Projected On-Hand Inv Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) Lot Size Table-Top Assembly Gross Requirements Scheduled Receipts Projected On-Hand Inv Net Requirements Planned Order Receipts Planned Order Releases Wood Screw (48 required) Lead Time (in weeks) Lot Size MS.53 An office furniture manufacturer needs to calculate material requirements for one of its most popular tables. The graphic above shows the bill of material for this item. Below are the MRP tables for the top-level assembly (the Office Table Final Assembly) and one of its sub-assemblies (the Table-Top Assembly Final Assembly 320 1 100 130 2 50 Support Assembly 8/1 Center Support (1 required) 150 8/1 8/8 8/15 8/22 8/29 9/5 9/12 9/19 9/26 200 200 500 300 800 400 Side Support [2 required) 8/3 8/15 315 3/12 9/19 3/26 For the Office Table…
Q. "You are also trying to convince Super Sweets owner to incorporate an ERP system to integrate the business processes of the organization. In this activity, you are producing a paper illustrating how the problems and/or challenges that may occur during the production planning process can be best solved by integrated ERP systems." Identify the use of any necessary resources: 1) At least ten problems that may emerge in the preparation processes for sales and operational activities (SOPs) and material specifications (MRPs); 2) The way an integrated ERP framework can be used to solve your perceived problems/challenges.
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 48,000 of these trikes. Current schedules yield the following information. Component Front Seat/Frame Rear wheel (each) Available Requirement Plastic 12 16 .20 S Model Regular Deluxe Heavy 100000 Time 40 24 8 2 2 320000 60000 Page 4 of 9 Space Manufacture 8 16 8 4 Cost to 12 2 3 4 5 Cost to Purchase 24 The company obviously does not have the resources available to manufacture everything needed for the completion of 24000 tricycles so has gathered purchase information for each component. Requested: Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 24000 fully completed tricycles at the minimum cost. 18 6 4) A paint supply company makes three styles of Paint Rollers, regular, deluxe and heavy.…
A factory has just received an order for 95 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Lead Time On Hand Scheduled Item Order Direct (weeks) Inventory receipts Policy Components End item 15 lot for lot A(3), B(2) A 2 10 33 at week 3 lot for lot C(1), D(4) B. 2 20 15 at week 4 lot for lot D(2) min. of 500 lot for lot 100 20 Develop the material requirements plan (please print out an empty MRP table to work with), and determine how many units of component Care needed in the "planned order release". Input should be an exact number.
Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: • Production plans for complete kits are as follows: Start assembling 4,500 kits in week 2 Start assembling 1,000 kits in weeks 3, 4, and 5 Start assembling 8,000 kits in week 6 • The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. • All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time = 1 week; Minimum order quantity = 3,500 Week 1 2 3 Gross requirements 4,500 1,000…
QUESTION #1 Mrs. Johnson, the owner of a small manufacturing business has patented a new device for kitchen appliance. Before trying to commercialize the device and add it to her existing product line, the she wants reasonable assurance of success. Variable costs are estimated at $8 per unit produced and sold. Fixed costs are about $60,000 per year. a. Forecasted sales for the first year are 15,000 units if the price is reduced to $20. With this pricing strategy, what would be the product's total contribution to profits in the first year? b. If the selling price is set at $30, how many units must be produced and sold to break even? Use both algebraic and graphic approaches
Qty Standard Labor Hour Raw Material В Standard Labor 2 Hours Raw Material INDEPENDENT DEMAND Period 1 2 3 4 5 6 Total Product A 1,000 1,000 1,000 1,000 1,000 1,000 6,000 Product B 500 500 ,500 500 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
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: ahandlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. Thecompany has orders for 48,000 of these trikes. Current schedules yield thefollowing information. Requirements Component Plastic Time Space Cost to Manufacture Cost to Purchase Front seat /Frame Rear wheel (each) 12 16 .20 40 24 8 8 8 .4 16 12 2 24 18 6 Available 100000 320000 60000 The company obviously does not have the resources available to manufactureeverything needed for the completion of 24000 tricycles so has gathered purchaseinformation for each component. Develop a linear programming model to tell thecompany how many of each component should be manufactured and how manyshould be purchased in order to provide 24000 fully completed tricycles at theminimum cost.
Q5) Metters Cabinets, Inc., needs to choose a production method for its new office shelf, the Maxistand. To help accomplish this, the firm has gathered the following production cost data. Metters Cabinets projects an annual demand of 24,000 units for the Maxistand. The Maxistand will sell for $120 per unit. Which process type will maximize the annual profit from producing the Maxistand? What is the value of this annual profit? Annualized fixed Variable costs (per unit) ($) cost of plant & Process type equip. LABOR MATERIAL ENERGY Mass Customization $1,260,000 30 18 12 Intermittent $1,000,000 24 26 20 Repetitive $1,625,000 28 15 12 Continuous $1,960,000 25 15 10
The units of Manganese Plus available for sale during the year were as follows: Mar. 1 June 16 Nov. 28 Inventory Purchase Purchase 23 units @ $29 32 units @ $30 42 units @ $36 97 units $667 960 1,512 $3,139 There are 14 units of the product in the physical inventory at November 30. The periodic inventory system is used. a. Determine the inventory cost by the FIFO method. $ b. Determine the inventory cost by the LIFO method. $ c. Determine the inventory cost by the weighted average cost methods. Round intermediate calculations and final answer to two decimal places.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS