Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years.1 2 3 4 58690YearForecast demandCurrently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are250 workdays in a year. Each manufactured good takes 20 minutes to produce.a. What is the effective capacity of the factory? Round your answer down to the nearest whole number.units, yearb. Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity, Round your answers to the nearest whole number.Year1Additional machines needed2124Extra capacity needed (units)C. Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number.4345PE

Answered: a. What is the effective capacity 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

I need typing no chatgpt used
Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 45% 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,500 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 $550 and a per loaf ingredient cost of $0.40. Current multifactor productivity for 640 work hours per month = loaves/dollar (round your response to three decimal places).
Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). Answers that need formulas must have them within the answer cell to receive full credit. City is trying to determine future demand for their public pool in order to help with staffing decisions. City thinks that demand could be related to temperature in Fahrenheit. Below is the most recent data from the last two weeks. Pool Attendance Temperature (°F) 150 89 100 82 125 81 130 86 155 93 170 98 200 99 180 87 190 88 140 83 120 82 90 81 130 87 120 93 What is the regression equation? Use the equation to forecast pool attendance if temperature is 88°
Need in 30 mins pls
answer 321 is incorrect
. An airline company must plan its fleet capacity and its long-term schedule of aircraft usage. For one flight segment, the average number of customers per day is 70, which represents a 65 percent utilization rate of the equipment assigned to the flight segment. If demand is expected to increase to 84 customers for this flight segment in 3 years, what capacity requirement should be planned? Assume that management deems that a capacity cushion of 25 percent is appropriate.
A process requires a 20 second setup for each batch. When producing, the process can produce one unit every 12 seconds. Demand for the product is 7 units per minute. With a batch size of 20 units, what is the process utilization? Note: Do not round your intermediate calculations. Round your answer to 2 decimal places
A Company Is Considering Buying One Of The Following Two Machines. Show the complete solution for each question.
Please answer it without using software.
Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 45%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 $650 and a per loaf ingredient cost of $0.40. After increasing the number of work hours to 928 per month,what is the multifactor productivity =? loaves/dollar (round your response to…
A restaurant has a capacity of serve 150 customers during the dinner time from 5 to 9 pm. In a typical evening, the restaurant serves an average of 120 customers. What is the restaurant's capacity cushion? a. 20% b. 67% c. 25% d. 50%
In a job shop, effective capacity is only 88 percent of design capacity, and actual output is 69 percent of effective output. What design capacity would be needed to achieve an actual output of 11 jobs per week? What is its effective capacity?a. The Design Capacity needed to achieve the required actual job outputs =( ) (round to whole number)b. The Effective Capacity needed to achieve the required actual job outputs =( ) (round to whole number)

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