Please help me fill in this table ,how must I proceed. Please help me. How to find the beginning inventory ,personnel on staff,units produced ,hire/layoff Consuelo Chua, Inc is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data. Therare 8 hours of production per dayCostsS8/disk drive/Month$80/disk driveOther DataCurrent workforce (June) 8 peopleLabor-hours/disk driveHolding costSubcontractingRegular-time labor $12/hourOvertime laborHiring costLayoff cost4 hours$18/hour (above 8 hours)$40/worker$80/workerWorkdays/monthBeginning InventoryEnding Inventory*Note that there is no holding cost for June.20 days150 disk drives*0 disk drivesWhat will each of the two following strategies cost?a) Vary the workforce so that production approximates demand Chua had eight workers on board in June. (Enter all responses as whole numbers).Fill in the table below. (Enter all responses as whole numbers. In the hire/layoff column, use positive numbers for hires-plus signs omitted, negative numbers forlayoffs)Plan ABeginning Personnel onInventory150UnitsHireStaffProduced LayoffMonth0June1JulyDemand8A00Clear allCheck answerHelp me solve thisCalculatorP Pearson80°Fere to search What will each of the two following strategies cost?a) Vary the workforce so that production approximates demand. Chua had eight workers on board in June. (Enter all responses as whole numbers).Fill in the table below. (Enter all responses as whole numbers. In the hire/layoff column, use positive numbers for hires-plus signs omitted, negative numberlayoffs)Plan ABeginning Personnel onInventory150UnitsHire /MonthDemandStaff*Produced LayoffO JuneJuly4002 August5003 September5504 October7005 November8006 December700* No costs are incurred for unmet demand**When computing "Personnel on Staffif 0.5 or more of an employee is needed round up and hire one more employee, if less than 0.5, round down.Clear allCheck answerHelp me solve thisCalculatorO Pearson80°Fe to searchhp口口口

Consuelo Chua, Inc. is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the fo are 8 hours of production per day Costs $8/disk drive/Month $80/disk drive $12/hour $18/hour (above 8 hours) $40/worker $80/worker Other Data Current workforce (June) 8 people Labor-hours/disk drive Holding cost Subcontracting Regular-time labor Overtime labor Hiring cost Layoff cost 4 hours Workdays/month Beginning Inventory Ending Inventory "Note that there is no holding cost for June. 20 days 150 disk drives* 0 disk drives What will each of the two following strategies cost? al Vary the workforce so that production approximates demand Chua had eight workers on board in June. (Enter all responses as whole numbe

Consuelo Chua, Inc. is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the fo are 8 hours of production per day Costs $8/disk drive/Month $80/disk drive $12/hour $18/hour (above 8 hours) $40/worker $80/worker Other Data Current workforce (June) 8 people Labor-hours/disk drive Holding cost Subcontracting Regular-time labor Overtime labor Hiring cost Layoff cost 4 hours Workdays/month Beginning Inventory Ending Inventory "Note that there is no holding cost for June. 20 days 150 disk drives* 0 disk drives What will each of the two following strategies cost? al Vary the workforce so that production approximates demand Chua had eight workers on board in June. (Enter all responses as whole numbe

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

Ripeka, the warehouse manager at Hine would like to update the company’s inventory locator system so that the picking operation can be streamlined. While conceptually simple to do, she knows that there will be several steps to the update process that will have to be carefully managed. She needs to complete upgrade and train her staff in operating the new system before the busy season, which is only 4 months away. She identifies the various activities, expected time duration, predecessors and costs, as shown in the table. Draw the AON Network, and then determine the critical path. [Show your workings, using the grid network.] Identify the project duration – is this project feasible within the required timeframe?
Problem 21-16 (Algo) One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 20, 50, 30, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 50, 100, and 90, respectively, to be purchased. B has scheduled receipts of 20 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 20 units in Period 1, 10 units in Period 2, 55 units in Period 6, and 50 units in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)
2. Semiconductor wafers are made in a set of machines in a company. Part A is a classic one, while part B is a more technologically advanced one. Additional sets of information are also provided in the tables. Every month, 1500 units of raw material for item A and 2000 units of raw material for item B are processed. a. `Construct a diagram for each product showing the routings and the yield per b. How much does each unit of products A and B cost? Present costs using two decimal places. Would both products be profitable? How much is the total profit/loss per product If the company is successful in eliminating scrap, how does it affect the product profit? d. ' machine. C. line? Machine 1 2 3 4 Part A Part B. Cost per unit processed $10 $15 $20 $25 123 Product Operation On Machine 1 2 3 4 A B M1 M2 M3 M1 M3 M4 M1 Unit Selling Price 65 150 Fraction Scrap 0.05 0.10 0.15 0.20 0.15 0.10 0.05 Unit Raw Material Cost 20 25
Explain the terms flow rime and lateness.
What is the difference between raw materials, finished goods and work in progress inventories?
Hand written solutions are strictly prohibited
In a well constructed paragraph discuss the material requirements needed for the production of and the consumer’s use of a single handled cooking pot.
Acquire a working knowledge of the fundamental components of ERP systems and buying databases.
A metric that measures the percentage of orders shipped according to schedule.