The partially completed inventory record for the driveshaft subassembly in the table belowhows gross requirements, scheduled receipts, lead time, and current on-hand inventory.1. Complete the last three rows of the record for an FOQ of 55 units. (Enter your responses asntegers. A response of "0" is equivalent to being not applicable.)tem: Driveshaft subassemblyGrossequirementsScheduledeceiptsProjected on-handnventoryPlannedeceipts1514070225310420Lot Size: FOQ = 55 unitsLead Time: 3 weeksWeek55088888(0)650740840

MRP, is the production planning and inventory control system that efficiently controls the…

Answered: The partially completed inventory…

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

The president of HiU Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 monthsas follows: Her operat ions manager is considering a new pla n, whichbegins in January with 200 uni ts on hand . Stockout cost of lostsales is SlOO per unit. Inventory holding cost is $20 per unit permonth. Ignore any idle-time costs. The plan is called plan A.Plan A: Vary the workforce level to execute a strategy that producesthe quantity demanded in the prior month. The Decemberdemand and rate of production are both I ,600 units per month. Thecost of hiring additional workers is $5,000 per I 00 uruts. The cost oflaying oiTworkers is $7,500 per 100 units. Evaluate this plan.
Given the bill of material and the on-hand quantities below, compute the net requirements for each item. The gross requirement for A is 150 units. Summarize your solution in a table. Item On-Hand Inventory A 40 B 50 C 100 D 70 E 25
Upton Enterprises produces a variety of switches. Below, you will find a bill-of-material file for their simplest switch: Part A. The number in the parentheses represents the number of units required for the upper level. LT stands for the lead time, measured in weeks.Assuming that Upton Enterprises has none of Switch A in inventory, and the inventory levels of Parts B, C, D, E, and F are also zero, how many weeks would it take to produce 100 units of Switch A? What would be the total requirement for part E?
Directions Select one of these concepts: How the Aggregate Operations Plan combines required materials, capacity, and staffing. Inputs and application of the different Production Planning Strategies: Chase strategy, level strategy, Stable workforce Aggregate planning techniques that minimize the costs of operations. Application of Materials Requirement Planning methods as a manufacturing scheduling tool Use of Bills of Materials and Lot Sizing in MRP systems
Production data show 35,920 units were transferred out of a stage of production and 6,150 units remained in ending WIP inventory that was 100% complete to material and 35% complete to conversion. The unit material cost is $5 for material and $8 for conversion. What is the amount of inventory transferred out and remaining in ending work in process inventory? Round to the whole unit and whole dollar, no decimals. Complete the tables below: Equivalent units data Units Materials Conversion Transferred out 35,920 Ending inventory 6,150 Units accounted for, equivalent units Cost data Transferred out $ Ending work in process: materials Ending work in process: conversion Ending work in process: total Costs to account for $ please fill in the blank boxes
Production data show 35,920 units were transferred out of a stage of production and 6,150 units remained in ending WIP inventory that was 100% complete to material and 35% complete to conversion. The unit material cost is $5 for material and $8 for conversion. What is the amount of inventory transferred out and remaining in ending work in process inventory? Round to the whole unit and whole dollar, no decimals. Complete the tables below: Equivalent units data Units Materials Conversion Transferred out 35,920 Ending inventory 6,150 Units accounted for, equivalent units Cost data Transferred out $ Ending work in process: materials Ending work in process: conversion Ending work in process: total Costs to account for $ please fill in the information in the grid exactly as provided
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 8. Subscripts indicate quantity required for each parent. Assume lot-for-lot ordering. b. Choose correct time phased-structures c. Develop a net material requirements plan for F (enter your responses as whole numbers).
SOLVE USING EXCEL Given the bill of material and the on-hand quantities below, compute the net requirements for each item. The gross requirement for A is 150 units. Summarize your solution in a table. Item On-Hand Inventory A 40 B 50 C 100 D 70 E 25
Why is there a need for aggregate planning? please help me, the answer must be clear and need typed answer. please dont copy.
SOLVE MANUALLY Jet skis and snowmobiles are assembled by Mobile Incorporated. Because both end-items use the same small engine, you can aggregate demand for the engine assembly. Develop an aggregate plan that uses a level production strategy each quarter and the information that follows. What is the total cost? Assume lost sales are backordered and filled during the next quarter. Summarize the plan, its costs, and consequences using manual computations. Initial Inventory Level = 1,000 units Regular Time = $15 Lost Sales Cost/Unit = $24 Inventory Carry Cost per unit = $3 Quarter 1 2 3 4 Totals Beginning Inventory Jet Ski Engine 10,000 15,000 16,000 3,000 44,000 600 Snowmobile Engine 9,000 7,000 19,000 10,000 45,000 400 Total Engines 19,000 22,000 35,000 13,000 89,000 1,000 Average Demand Rate/Quarter 22,000 units Regular Time Production Rate 22,000 units
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders occur. There are 100 workers on January 31. You are given the following demand forecast: February, 90,000; March 65,000; April 110,000; May, 55,000. Productivity is four units per worker hour, eight hours per day, 20 days per month. Assume zero inventory on February 1. Costs are hiring, $50 per new worker; layoff, $70 per worker laid off; inventory holding, $10 per unit-month; straight-time labor, $10 per hour; overtime, $15 per hour; backorder, $20 per unit a. Find the total cost of this plan?
The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sales of $125 per unit, inventory carrying costs of $20 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,200 units per month and subcontract additional units at a $60 per unit premium cost. Subcontracting capacity is limited to 500 units per month. (Enter all responses as whole numbers). Month Demand Production Ending Inventory Subcontract (Units) 1 July 1200 1,200 0 Insert 2 August 1300 1,200 0 Insert 3 September 1200 1,200 0 Insert 4 October 1700 1,200 0 Insert 5 November 1650 1,200…

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