Problem 5-11 (Algo)A manager must decide which type of machine to buy, A,B, or C. Machine costs (per individual machine) are asfollows:MachineABсCost$80,000$70,000$40,000Product forecasts and processing times on the machinesare as follows:AnnualProduct Demand.123425,00022,00020,0009,000ABсPROCCESSING TIME PERUNIT (minutes)A5335B4116Total processingtime in minutesper machine:C2Click here for the Excel Data File462a. Assume that only purchasing costs are beingconsidered. Compute the total processing time requiredfor each machine type to meet demand, how many of eachmachine type would be needed, and the resulting totalpurchasing cost for each machine type. The machines willoperate 10 hours a day, 250 days a year. (Enter totalprocessing times as whole numbers. Round up machinequantities to the next higher whole number. Computetotal purchasing costs using these rounded machinequantities. Enter the resulting total purchasing cost as awhole number.) BсABCBuyABCb. Consider this additional information: The machinesdiffer in terms of hourly operating costs: The A machineshave an hourly operating cost of $12 each, B machineshave an hourly operating cost of $13 each, and Cmachines have an hourly operating cost of $12 each. Whatwould be the total cost associated with each machineoption, including both the initial purchasing cost and theannual operating cost incurred to satisfy demand?(Userounded machine quantities from Part a. Do not roundany other intermediate calculations. Round your finalanswers to the nearest whole number.)Total cost for each machineNumber of each machine needed andtotal purchasing costBuy

Answered: A manager must decide which type of…

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

Old Pueblo Engineering Contractors creates six-month “rolling” schedules, which are recomputed monthly. For competitive reasons (it would need to divulge proprietary design criteria, methods, and so on), Old Pueblo does not subcontract. Therefore, its only options to meet customer requirements are (1) work on regular time; (2) work on overtime, which is limited to 30 percent of regular time; (3) do customers’ work early, which would costan additional $5 per hour per month; and (4) perform customers’ work late, which would cost an additional $10 per hour per month penalty, as provided by their contract. Old Pueblo has 25 engineers on its staff at an hourly rate of $30. The overtime rate is $45. Customers’ hourly requirements for the six months from January to June are January 5000 February 4000 March 6000 April 6000 May 5000 June 4000 Develop an aggregate plan using a spreadsheet. Assume 20 working days in each month. 12. Alan Industries is expanding its product line to include three…
A manager faces peak (weekly) demand for one of her op-erations, but is not sure how long the peak will last. She caneither use overtime from the current workforce, or hire/lay off and just pay regular-time wages. Regular-time pay is$500 per week, overtime is $750 per week, the hiring cost is$2,000, and the layoff cost is $3,000. Assuming that peopleare available seeking such a short-term arrangement, howmany weeks must the surge in demand last to justify a tem-porary hire? Hint: Use break-even analysis (see SupplementA, “Decision Making”). Let w be the number of weeks ofthe high demand (rather than using Q for the break-evenquantity). What is the fixed cost for the regular-time option?Overtime option?
Jefferson Company’s demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units. Actual run time this week 6,106 minutes Machine time available per week 8,600 minutes Actual run rate this week 4.32 units per minute Ideal run rate 6.00 units per minute Defect-free output this week 11,315 units Total output this week (including defects) 15,500 units 1. Compute the utilization rate.2. Compute the efficiency rate. 3. Compute the quality rate. 4. Compute the overall equipment effectiveness (OEE).
Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 5555% in the last year. On far too many occasions, customers have not been able to purchase the bread of their choice. Because of the size of the store, no new ovens can be added. At a staff meeting, one employee suggested ways to load the ovens differently so that more loaves of bread can be baked at one time. This new process will require that the ovens be loaded by hand, requiring additional manpower. This is the only production change that will be made in order to meet the increased demand. The bakery currently makes 1,800 loaves per month. Employees are paid $8 per hour. In addition to the labor cost, Charles also has a constant utility cost per month of $800 and a per loaf ingredient cost of $0.35 Current multifactor productivity for 640 work hours per month =0.27loaves/dollar (round your response to three decimal places).
Majestic Corporation provides call-center ordering services for Essential Oils magazine. Majestic receives an annual fee of $200,000 for providing such services and is also eligible to receive a performance bonus up to $65,000 if the average customer wait times are below certain thresholds at the end of the year. Using historical results as well as current expectations, Majestic estimates the chances of achieving the different performance bonuses as shown in the table here. Assume there are NO revenue constraints, and the entity uses the expected value approach to record variable consideration when recognizing revenue during the period. Which is the amount of the performance bonus management can recognize in the transaction price? Average wait times Performance Bonus % Chance of Achieving $65,000 15% < 1 minute < 2 minutes < 3 minutes < 4 minutes < 5 minutes $45,000 $25,000 $5,000 0 10% 50% 20% 5% a. Management would include the variable consideration in the transaction price in the…
Lance’s Diner has a hot-lunch special each weekday and Sunday afternoon. The cost of food andother variable costs for each meal served is $3.50; weekly fixed costs (e.g., building depreciationand equipment rental costs) are $6,000, regardless of how many days the diner is open per week.Lance has an average of 500 customers per day. What is the lowest price in total (not per meal) thatLance should charge for a special group of 200 that wants to come on Saturday for a family reunion?What should be the lowest price per meal that Lance should charge for the hot-lunch special servedon weekdays and Sunday afternoons?
Problem 16-15 (Algo) The owner of a large machine shop has just finished its financial analysis from the prior fiscal year. Following is an excerpt from the final report: Net revenue $ 378,000 Cost of goods sold 323,000 Value of production materials on hand 42,500 Value of work-in-process inventory 55,000 Value of finished goods on hand 21,500 Compute the inventory turnover ratio (ITR). (Round your answer to 1 decimal place.) Compute the weeks of supply (WS). (Do not round intermediate calculations. Round your answer to 1 decimal place.)
Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. Number of orders 6 30 Units per order 1,000 420 Sales returns: Number of returns 4 5 Total units returned 50 140 Number of sales calls 13 5 Colleen sells its products at $290 per unit. The firm’s gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $ 800 per visit Order processing 180 per order Deliveries 410 per order Sales returns 270 per return and $3 per unit returned Sales salary 107,000 per month Required: 1. Using customers as the cost objects, classify the activity costs…
Kilmer Company's customer demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units: Actual run tine this week Machine time available per week Actual run rate this week Ideal run rate Defect-free output this week Total output this week (including defects) 1-a. Utilization rate 1-b. Efficiency rate. 1-c. Quality rate 1-d. Overall equipment effectiveness 2-a. Utilization loss in units 12,800 minutes 16,000 minutes. 2-b. Efficiency loss in units 2-c. Quality loss in units 6.30 units per minute. 9 units per minute. Required: 1. and 2. With respect to the company's overall equipment effectiveness, calculate the following: Note: Do not round intermediate calculations. Round final answers to 2 decimal places and "Units" answers to the nearest whole number. 72,576 units 80,640 units
Pendryl Office Supplies is evaluating the profitability of leasing a photocopier for its customers to use on a self serve basis at 10 cents/copy. The copier may be leased for $300 per month plus 1.5 cents per copy on a full service contract. Pendryl can purchase paper at $5 per 500 sheet ream. Toner costs $100 per bottle, which in normal use will last for 5000 pages. Pendryl thinks that there are additional other costs of 0.5 cents per copy. A. How many copies per month must be sold in order to break even? (6000 copies/month) B. What will be the increase in monthly profit for each 1000 copies sold above the break-even point? ($50 per month)
Charles Lackey operates a bakery in Idaho Falls,Idaho. Because of its excellent product and excellent loca-tion, demand has increased by 25% in the last year. On far toomany occasions, customers have not been able to purchasethe bread of their choice. Because of the size of the store, nonew ovens can be added. At a staff meeting, one employeesuggested ways to load the ovens differently so that moreloaves of bread can be baked at one time. This new processwill require that the ovens be loaded by hand, requiring addi-tional manpower. This is the only thing to be changed. If thebakery makes 1,500 loaves per month with a labor produc-tivity of 2.344 loaves per labor-hour, how many workers willLackey need to add? (Hint: Each worker works 160 hours permonth.)
De Mar, a plumbing, heating, and air-conditioning companylocated in Fresno, California, has a simple but powerful product strategy: Solve the customer’s problem no matter what, solvethe problem when the customer needs it solved, and make sure thecustomer feels good when you leave . De Mar offers guaranteed,same-day service for customers requiring it. The company provides 24-hour-a-day, 7-day-a-week service at no extra charge forcustomers whose air conditioning dies on a hot summer Sundayor whose toilet overflows at 2:30 A.M. As assistant service coordinator Janie Walter puts it: “We will be there to fix your A/C onthe fourth of July, and it’s not a penny extra. When our competitors won’t get out of bed, we’ll be there!”De Mar guarantees the price of a job to the penny before thework begins. Whereas most competitors guarantee their work for30 days, De Mar guarantees all parts and labor for one year. Thecompany assesses no travel charge because “it’s not fair to chargecustomers for…

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