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

Consuela Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data: What will each of the two fo llowing strategies cost?a) Vary the workforce so that production meets demand. Chuahad eight workers on board in June.b) Vary overtime only and use a constant workforce of eight.
Dohini Manufacturing company had following 12 months of data on purchasing cost and number of purchase orders. Required: 1. Determine the high point and low point. 2. Calculate the variable rate for purchasing cost based on the number of purchase orders. (Round to nearest cent) 3. Calculate the fixed monthly cost of purchasing.(Round to nearest dollar). 4. Write the cost formula for the purchasing activity showing the fixed cost and the variable rate. 5. If Dohini manufacturing company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for the that month?(Round to nearest dollar) 6. What if Dohini manufacturing wants to estimate purchasing cost for the coming year and expects 5340 purchase orders? What will estimated total purchasing cost be? What is the total fixed purchasing cost? Why doesn't equal the fixed cost calculated in Requirement 3?(Round to nearest dollar)
Miller Landscaping is attempting to estimate costs for future projects. Miller has compiled data anddecided to use the high-low costing method. The low value is $250,000 for 5,000 hours, and the highvalue is $400,000 for 8,000 hours. What is the variable cost per hour?
In planning its operations for the year based on sales forecast of P 6,000,000, the company prepared the following estimated data:Cost and expensesVariableFixedDirect materialsP 1,600,000Direct labor1,400,000Factory overhead600,000900,000Selling expenses240,000360,000Administrative expenses60,000140,000P 3,900,000P 1,400,000What would be the amount of sales in pesos at the break- even point?a. P2,250,000c. P4,000,000b. P3,500,000d. P5,300,000
What are demand forecasting and capacity strategy? Give an example of demand forecasting for a business.
After six months of work on the project’s site, your company collected the following information relating to work done so far on the project BAC=$156,478.00, planned value=$95,565.24, Earned value =$92, 985.56, Actual cost =$95986.60. Calculate the cost and schedule performance indices and interpret your results
Jack has gathered the following information for Work Center 2, the work center that directly feeds Work Center 3. Complete the input/output analysis of Work Center 2. Input Information(in hours) 4 5 6 7 8 Planned input 60 70 70 80 80 Actual input 15 25 25 30 30 Output Information(in hours) 4 5 6 7 8 Planned output 40 70 70 80 80 Actual output 45 45 45 55 80 Backlog165 hours Jack has asked you to calculate the following for Work Center 2. (a) Calculate the percentage of planned output needed to complete the planned inputs [(planned input + backlog)/ planned output] at Work Center 2.(Round your answers to 1 decimal place, e.g. 17.5.) 4 5 6 7 8 Percentage of planned output · 100% enter percentages % enter percentages Percentages shoul be # 4 through 8
Collins Title Insurance Ltd. wants to evaluate its labor and multifactor productivity with a new computerized title-search system. The company has a staff of four, each working 8 hours per day (for a payroll cost of $640/day) and overhead expenses of $400 per day. Collins processes and closes on 8 titles each day. The new computerized title-search system will allow the processing of 14 titles per day. Although the staff, their work hours, and pay are the same, the overhead expenses are now $800 per day.
Peppers Lockdown produces keys for homes and cars. As Peppers planned for next year’s production,the company decided to implement a high-low system to forecast future costs. With total productionof 2,500,000 keys at a total cost of $10,000 in 2018, and total production of 3,000,000 keys at a totalcost of $20,000 in 2019, what is the variable cost per key?
Jack has gathered the following information for Work Center 2, the work center that directly feeds Work Center 3. Complete the input/output analysis of Work Center 2. Input Information(in hours) 4 5 6 7 8 Planned input 60 70 70 80 80 Actual input 15 25 25 30 30 Output Information(in hours) 4 5 6 7 8 Planned output 40 70 70 80 80 Actual output 45 45 45 55 80 Backlog165 hours Jack has asked you to calculate the following for Work Center 2. alculate the percentage of planned input that actually happened [(actual input + backlog)/(planned input + backlog)] at Work Center 2.(Round your answers to 1 decimal place, e.g. 17.5.) 4 5 6 7 8 Actual input + Backlog Planned input + Backlog · 100% enter percentages % enter percentages % enter percentages % enter percentages % enter percentages %
The following table details the tasks required for Indiana-based Frank Pianki Industries to manufacture a fully portable industrial vacuum cleaner. The times in the table are in minutes. Demand forecasts indicate a need to operate with a cycle time of 11 minutes. Activity Activity Description Performance Time (mins) Predecessors A Attach wheels to tub 5.0 − B Attach motor to lid 1.5 − C Attach battery pack 2.8 B D Attach safety cutoff 4.0 C E Attach filters 3.0 B F Attach lid to tub 2.0 A, E G Assemble attachments 3.0 − H Function test 3.7 D, F, G I Final inspection 2.0 H J Packing 2.0 I a-b) One of the possible assignment of tasks to workstations is shown correctly in…
Summertime Products makes outdoor shirts. Data relating to the coming year’s planned operations follows: Sales (200,000 shirts) P 5,000,000 Cost of good sold 3,500,000 Gross profit P 1,500,000 Selling and administrative expenses 1,100,000 Income P 400,000 The factory has capacity to make 240,000 shirts per year. Fixed cost included in cost of goods sold was P 1,000,000. The only variable selling, general, and administrative expenses are a 10% sales commission and a P 2.00 per shirt licensing fee paid to the designer. A chain store manager has approached the sales manager of Summertime Products offering to buy 30,000 shirts at P18 per shirt. These shirts would be sold in areas where Summertime’ shirts are not now sold. The sales manager believes that the accepting the offer would result in a loss because the average total cost of a shirt is P 23 ([3,500,000+P 1,100,000]/200,000). He feels that even though sales commissions would not be paid on the order, a loss would still result.…