2.17 For the following data, calculate the number of workers required for level productionand the resulting month-end inventories. Each worker can produce 14 units per day, andthe desired ending inventory is 9000 units.MonthWorking DaysForecast DemandPlanned ProductionPlanned Inventory11,5001234Total2024121928,00027,500 28,50028,500

Firstly calculate Total Forecasted Demand:Remember that,Total Production = Total Forecasted Demand −…

Answered: 2.17 For the following data, calculate…

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

A part is produced in lots of 1,000 units. It is assembled from2 components worth $50 total. The value added in produc-tion (for labor and variable overhead) is $60 per unit, bring-ing total costs per completed unit to $110. The average leadtime for the part is 6 weeks and annual demand is 3,800 units,based on 50 business weeks per year.a. How many units of the part are held, on average, in cycleinventory? What is the dollar value of this inventory?b. How many units of the part are held, on average, in pipe-line inventory? What is the dollar value of this inventory?(Hint: Assume that the typical part in pipeline inventoryis 50 percent completed. Thus, half the labor and variableoverhead cost has been added, bringing the unit cost to$80, or $50 + $60>2).
OQ18
WAI knows from historical records that approximately 40percent of its labor is used in Department 101 and 60 percentis used in Department 102. Th e reverse is true of machine time;60 percent is used in Department 101 and 40 percent is used inDepartment 102.(a) Calculate the labor and machine hours needed inDepartment 101 for each period of the MPS developed inProblem 4.(b) Calculate the labor and machine hours needed inDepartment 102 for each period of the MPS developed inProblem 4.
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
The Big Black Bird Company (BBBC) has a large order for special plastic-lined military uniforms to be used in an urgent military operation. Working the normal two shifts of 40 hours each per week, the BBBC production process usually produces 2,500 uniforms per week at a standard cost of $120 each. 68 employees work the first shift and 30 the second. The contract price is $220 per uniform. Because of the urgent need, BBBC is authorized to use around-the-clock production six days per week. When each of the two shifts works 72 hours per week, production increases to 3,800 uniforms per week but at a cost of $144 each. a. The multifactor productivity level for two shifts working 72 hours when compared to the level of the normal two shifts.
ssume you are the manager of a shop that assembles power tools. You have just received an order for 50 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 Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 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.)
1. which of the following aggregate plan utilizes a constant amount of labor to fulfill customer orders in each period a. Chase b. Mixed c. level d. Constant e. none of the above 2. Calculate the upper control limit for a c chart when the total number of defects are 120 in 20 batches. 3. Suppose that you want to measure the percentage of the wires that are longer than 9.2 inches. Which control chart would be appropriate to monitor the percentage of the defective wires per batch in a production line? 4. Suppose that you have 192 finished goods in your inventory and the forecast of monthly demand is as follows. Implement a level aggregate plan and calculate the production rate for the plan. June = 310 July = 190 August = 200 September = 210 October = 240 November = 200 a. 193 b. 270 c. 192 d. 216 e. 250
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
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
For the following bill of material, if we need to produce 10 units of finished product P, how many component C do we need? Assume there is no on-hand inventory. P M(3) 80 0 120 O 16 40 160 N(4) B(3) C(4) D(5) C(4)
1 of 2 Gateway International Airport Gateway International Airport (GIA) has experienced substantial growth in both commercial and general aviation operations during the past several years. (An operation is a landing or takeoff.) Because of the initiation of new commercial service at the airport, which is scheduled for several months in the future, the Federal Aviation Administration (FAA) has concluded that the increased operations and associated change in the hourly distribution of takeoffs and landings will require an entirely new work schedule for the current air traffic control (ATC) staff. The FAA feels that GIA might need to hire additional ATC personnel, because the present staff of five probably will not be enough to handle the expected demand. After examining the various service plans that each commercial airline submitted for the next six-month period, the FAA developed an average hourly demand forecast of total operations (Figure 12.14) and a weekly forecast of variation…

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