Note:-Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.Answer completely.You will get up vote for sure. esA manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows:Cost$70,000$60,000$50,000MachineABCProduct forecasts and processing times on the machines are as follows:PROCCESSING TIME PERUNIT (minutes)AnnualProduct Demand128,0001JENN21,000621,00017,00023A45B2Total processingtime in minutes561Click here for the Excel Data FileC2423a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type tomeet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. Themachines will operate 8 hours a day, 250 days a year. (Enter total processing times as whole numbers. Round up machinequantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter theresulting total purchasing cost as a whole number.)< Prev5 of 5---Next

Production is the process in which inputs are combined to have the required output. It includes a…

a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 8 hours a day, 250 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) Total processing time in minutes

a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 8 hours a day, 250 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number.) Total processing time in minutes

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section4.8: Data Envelopment Analysis (dea)

Problem 42P

See similar textbooks

Similar questions

A manager must decide which type of machine to buy, A, B, or C. Machine costs are as follows: Machine CostA $40,000B $30,000C $80,000Product forecasts and processing times on the machines are as follows: Processing Time per Unit (minutes) Product Annual Demand A B C 1 16000 3 4 2 2 12000 4 4 3 3 6000 5 6 4 4 30000 2 2 1 a.) Assume that machines operate 10 hours a day, 250 days a year. If we only consider purchasing costs, which machine would have the lowest total cost? b.) Assume machines operate 10 hours a day, 250 days a year. If we select machine A, how many machine A do we need? (Use common sense to decide the answer.)
Observations Actual Data Forecast 1 240 192.39 2 207 202.15 3 168 189.27 Calculate MAD, MSE, MAPE & U All calculations are supposed to be done by hand, not on Excel. Here is the formula sheet
What is CAPACITY REQUIREMENTS FORECASTING?
Using the accompanying log-log graph, answer the following questions: What are the implications for management if it has forecast its cost on the optimum line? What could be causing the fluctuations above the optimum line? If management forecast the tenth unit on the optimum line, what was that forecast in hours? If management built the tenth unit as indicated by the actual line, how many hours did it take?
On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20
Proctoring Enabled: Chapter 12 Computer Simulati. O Help Save & Exit Submit Saved Given this frequency distribution, what demand values would be associated with the following random numbers? (Do not round intermediate calculations.) Demand Frequency 29 1 23 2. 19 3. 29 Random Number Simulated Demand 0.3 0.5 0.9 Mc Graw Hill < Prev 2 of 5 ASUS
A manager must whether to buy machine A or B. Machine costs are as follows: A $52,000 each; B $100,000 each Product forecast and processing times on the machines are as follows Processing Time per unit (minutes) Product Annual Demand A B 1 8,000 2 18,000 3 10,000 Assume that only purchasing costs are being considered. Which machine would have the lowest purchase cost and how many of that machine would be need? Machines operate 8 hours a day 250 days per year. The machines differ in hourly operation costs. The A machines have an hourly operating cost of $12 each and B machines have an hourly operating cost of $30 each. What is the operating cost per year and which alternative should be selected to minimize total cost (for the first year) while satisfying the processing requirements? Edit Format Table 12pt v Paragraph v BIUA ev T?v||: MacBook Air esc 80 888 DII F1 F2 F3 F4 F5 F6 F7 FR @ # $ % 1 2 3 4 5 7 8. Q W E R T Y A S D F G < CO
A manager must decide which type of machine to buy, A, B, or C. Machines costs are as follows: Machine Cost A $40,000 B $30,000 C $80,000 Product forecast, processing times on the machines, and setup times are as follows: Processing Time Per Unit (minutes) Product Annual Demand A B C Setup Times (minutes) Production Lots (units) 1 16,000 3 4 2 20 200 2 12,000 4 5 3 35 100 3 6,000 5 6 3 60 50 4 30,000 2 4 1 15 500 Machines operate 10 hours a day, 250 days a year. The manager wants to have a capacity cushion of 10%. a. Assume that only purchasing costs are being considered. Which machines would have the lowest total cost, and how many of that machines would be needed? b. Consider this additional information: The machines differ in terms of hourly operating costs: The A machines have an hourly operating cost of $11 each, B machines have an hourly operating cost of $10 each, and C machines have an hourly operating cost of $12 each. Which alternative would…
1.A firm has 77 units of a product on hand. Forecasts of demand are 26 units per week. An MPS quantity of 90 units is planned to arrive in period 3. Customer orders are 29 for period 1, 27 for period 2, and 19 for period 3.What is the projected on-hand inventory at the end of period 3? (use excel to show formulas)
Tax Prep Advisers, Inc., has forecasted the following staffingrequirements for tax preparation associates over the next12 months. Management would like three alternative staffingplans to be developed. The company currently has 10 associates. No more than 10new hires can be accommodated in any month because oflimited training facilities. No backorders are allowed, andovertime cannot exceed 25 percent of regular-time capacityon any month. There is no cost for unused overtime capac-ity. Regular-time wages are $1,500 per month, and overtimewages are 150 percent of regular-time wages. Undertime ispaid at the same rate as regular time. The hiring cost is $2,500per person, and the layoff cost is $2.000 per person.a. Prepare a staffing plan utilizing a level workforce strategy,minimizing undertime. The plan may call for a one-timeadjustment of the workforce before month 1.b. Using a chase strategy, prepare a plan that is consistent withthe constraint on hiring and minimizes use of overtime.c.…
Define the term time based competition.
PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month period. Month Demand Forecast 1 492 488 2 470 484 3 485 480 4 493 490 5 498 497 6 492 493 Required: Compute for the MAD, MSE, and MAPE.