15. Seher Aydinlatma is manufacturing light bulbs based on three months plan. We have thefollowing demand and total capacity forecasts for the next months. Also we know the unit costsfor inventory carrying, subcontracting capacity, regular and overtime working costs.MarchAprilMayOvertimeBeginninginventoryRegular timeRegular timeSubcontractOvertimeSubcontractRegular timeOvertimeDemandCapacityRegularOvertime60050Subcontracting100Beginning inventory 50COSTS1545553Regular timeOvertimeSubcontractCarrying costSALES PERIODMarch650NApril700700100100May1000Unit$/product$/product$/product$/product/month800100100March April May Total Capacity Available (Supply)5060050100700100100800100SubcontractDEMAND650700 1000Fill the above table using the optimal (transportation) algorithm to generate the aggregate plan thatmatch supply and demand estimates.100

Find the Given details below:Given…

Answered: 15. Seher Aydinlatma is manufacturing…

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 manufacturing company has the following financial information (in millions of $)Sales $562Cost of goods soldDirect labor 43Purchased materials 267Overhead 35All other costs 142Pretax earnings 75a. What is the profit leverage effect of purchasing in this company?b. What is the percent increase in earnings from a 5 percent savings in purchasing?
A steel workshop of PT Mental Baja produces leaf springs for cars. theyhave a demand forecast for the next 6 months as anext:i. January 446 units (production time 20 days)ii. February 600 units (production time 18 days)iii. March 700 units (production time 20 days)iv. April 900 units (production time 20 days)v. May 650 units (production time 20 days)vi. June 550 units (production time 20 days) The following are some important information to be the basis for doingcalculation of production costs as follows:i. Inventory cost $4 per unitii. Subcontractor fee $15 per unitiii. Workers cost $10 per hour or $80 per dayiv. Production time per unit 1.6 hours Tasks and questionsa. Assuming that the number of units that can be produced is 35 units per dayand 1 person can make 7 units, make an estimated cost by usingConstant Workforce approach. b. Assuming that internal processing is carried out usingcapacitors of daily production are the lowest for 6 months and constant,calculate estimated…
15. Seher Aydinlatma is manufacturing light bulbs based on three months plan. We have the following demand and total capacity forecasts for the next months. Also we know the unit costs for inventory carrying, subcontracting capacity, regular and overtime working costs. March April May Beginning inventory Regular time Overtime Subcontract Overtime Regular time Subcontract Demand Capacity Regular Overtime Overtime 600 50 Subcontracting 100 Beginning inventory 50 Regular time Overtime Subcontract Carrying cost Regular time SALES PERIOD March 650 COSTS 15 45 in 55 3 April 700 700 100 100 May 1000 800 100 100 Unit $/product $/product $/product $/product/month March April May Total Capacity Available (Supply) 50 600 50 100 700 100 100 800 100 Subcontract DEMAND 650 700 1000 Fill the above table using the optimal (transportation) algorithm to generate the aggregate plan that match supply and demand estimates. 100
Q2: A company has seasonal demand, with the forecast for the next 12 months as given below. The current labor force can produce 500 units per month. Each employee can produce 20 units per month, and is paid $2,000 per month. The inventory carrying cost is $50 per unit per period. It costs $100 to hire or layoff an employee. Assume 200 units of initial inventory and we would like to keep the similar level at the end of the year. Month 1 3 4 7 8 9 10 11 12 Demand 660 700 840 700 660 500 600 840 80 900 700 600 Please use level and chase strategy to calculate the total cost of two plans (please show your work).
Standard Direct Labor Wage Rate and Direct Labor Efficiency Variance Informationregarding Maxwell’s direct labor cost for the month of January follows:Direct labor hourly rate paid $28.50Total standard direct labor hours for units produced this period 11,000Direct labor hours actually worked 10,800Direct labor rate variance $16,000 favorableRequired Compute the following:1. Standard direct labor wage rate per hour, rounded to 2 decimal places, in January.2. Direct labor efficiency variance for January; round your answer to the nearest whole dollar. Was thisvariance favorable (F) or unfavorable (U)?
Borsberry Medical has a gross income of $7million for the year. Depreciation and operating expenses total $5 million. The combined state and local tax rate is 7.6%. (a) Use an effective federal rate of 34% to estimate the income taxes. (b) Borsberry’s president hopes to have a total of $2 million left after taxes. What reduction in OE is necessary to realize this goal if the effective tax rate and depreciation are constant? please show all formulas! Thank you!
. Gerald Glynn manages the Michaels Distribution Center.After careful examination of his database information, hehas determined the daily requirements for part-time loadingdock personnel. The distribution center operates 7 days aweek, and the daily part-time staffing requirements are Find the minimum number of workers Glynn must hire. Pre-pare a workforce schedule for these individuals so that eachwill have two consecutive days off per week and all staffingrequirements will be satisfied. Give preference to the S–Supair in case of a tie.
5) period. MARR is 10% per year compounded annually. Maintenance costs for a bridge are cyclic with the following costs occurring over a 5-year ΕΟΥ 2 3 4 5 Maintenance $50 million S75 million $75 million $75 million $150 million Cost a) b) capıtalized cost (worth) of the maintenance costs. Compute an equivalent uniform annual cost over a single 5-year maintenance cycle. It is anticipated that the sequence of costs will repeat every 5 years forever. If so, determine the
Which of the followilA a Interest payments b) Property taxes O Raw materials costs di Rental cost e) All the above are variable costs. 3500 at the end of 5 years. Yearly rental cost 4 A project has a basic cost of 5000 and a market value oft will be 2000 dollars and the vearly labor cost is $2000/labor where 15 labors works on this project The operating cost will be 1.15 dollars per hour. The project operates 7 hours every day (working 365 davs in year), taxes and insurances will be 1500 dollars every year. Find the Equivalent UniformAppual Ca of this project (Hint: EUAC-CR+yearly total expenses) using i-5% a) 37,960 b) 36,960 c) 41,000 d) 38.960 e) 35,600 5. A service system has a rental cost of 2000 dollars per year, the operating cost is 5 dollars per hour and the selling price is 7 dollars per hour. This system operates 8 hours per day 5 days a week. What is the o% reduction in breakeven point in hours (sensitivity) if the selling price increased by 20% a) 58% b) 41% c) 44% d) 51%…
Lissette Jones, the materials manager for an upscale retailer,wants to measure her customer service level. She has collected thefollowing representative data. Assuming that orders 1–6 and 8–10 shipped on schedule:(a) Calculate the customer service level using the percentageof orders that shipped on schedule.(b) Calculate the customer service level using the percentageof line orders that shipped on schedule.(c) Calculate the customer service level using the percentageof dollar volume that shipped on schedule.(d) Which of these measures would you recommend toLissette?
Labors Hours Required (Hours/Unit) Department Product 1 Product 2 Hours Available Overtime Available Overtime Cost A 1 0.35 100 10 18 B 0.3 0.2 36 6 22.5 C 0.2 0.5 50 8 12 Profit Contribution/Unit 30 15 X1 X2 Production Constraints Used Available Dept A Hours Dept B Hours Dept C Hours Dept A Overtime (XA) Dept B Overtime (XB) Dept C Overtime (XC) Objective: Profit Suppose that 10, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is $18 in department A, $22.50 in department B, and $12 in department C. What are the optimal production quantities using the avallable overtime? What is the…
Suppose an Excel spreadsheet model has been partially created as shown below. 1 2 3 4 5 6 7 8 9 10 11 12 A From 0 0.2 0.5 0.9 B To 0.2 0.5 0.9 1 C Lead Time Probability Lead Time (in days) 1 2 3 4 0.2 0.3 0.4 0.1 D What formula should be used to generate a lead time (in days) from this distribution? =VLOOKUP(RAND(),A6:D9,3) =VLOOKUP(RAND(),A6:D9,4) =VLOOKUP(A6:A9,A6:D9,3) =VLOOKUP(A6:A9,A6:D9,4) E

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