The demand for a product for the next four months and the number working days in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The demand for a product for the next four months and the number working days in each month are as follows: Month Number of working days Demand forecasted (units) 1 20 450 2 13 380 3 25 500 4 18 210 Assume that there are 100 workers at the beginning of the first month, and workers can be hired or fired at the beginning of the first month, but after that workforce size will be constant. For regular time production, each worker can produce 0.3 aggregate units in any workday. It is possible to produce below regular capacity. Overtime production is not allowed. Workers are paid $1000 per month. The cost of producing one unit of product is $40, excluding the worker wages. Keeping one unit of product in inventory costs $2. Beginning inventory is zero units, and the ending inventory is also planned to be zero. (a) What should be the minimum number of workers to be employed at the beginning of the first month so that monthly demand is met with no backorders. (b) Using the minimum number of workers determined in part (a) and the spreadsheet approach, develop a production plan with constant workforce strategy in which backorders are not allowed. (c) Using Microsoft Excel, on the same graph, plot the cumulative production and cumulative demand curves over the time. The demand for a product for the next four months and the number working days in each month are as follows: Month Number of working days Demand forecasted (units) 1 20 450 2 13 380 3 25 500 4 18 210 Assume that there are 100 workers at the beginning of the first month, and workers can be hired or fired at the beginning of the first month, but after that workforce size will be constant. For regular time production, each worker can produce 0.3 aggregate units in any workday. It is possible to produce below regular capacity. Overtime production is not allowed. Workers are paid $1000 per month. The cost of producing one unit of product is $40, excluding the worker wages. Keeping one unit of product in inventory costs $2. Beginning inventory is zero units, and the ending inventory is also planned to be zero. (a) What should be the minimum number of workers to be employed at the beginning of the first month so that monthly demand is met with no backorders. (b) Using the minimum number of workers determined in part (a) and the spreadsheet approach, develop a production plan with constant workforce strategy in which backorders are not allowed. (c) Using Microsoft Excel, on the same graph, plot the cumulative production and cumulative demand curves over the time.
Expert Answer:
Answer rating: 100% (QA)
a To determine the minimum number of workers to be employed at the beginning of the first month we need to calculate the maximum production capacity required to meet the monthly demand without backord... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
Hydro Sports budgets overhead cost of $793,500 for the year; of this amount, $586,500 is traceable to the Assembly department and $207,000 is traceable to the Finishing department. The company...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Situation You are the operations manager for a manufacturing plant that produces pudding food products. One of your important responsibilities is to prepare an aggregate plan for the plant. This...
-
Describe what happens if you apply binary search to an unordered array. Why shouldn't you check whether the array is sorted before each call to binary search? Could you check that the elements binary...
-
According to an Opinion Dynamics Poll published in USA TODAY, roughly 54% of U.S. men and 33% of U.S. women believe in extraterrestrial aliens. Of U.S. adults, roughly 48% are men and 52% women. a....
-
Determine the free-end displacements and the element stresses for the plate discretized into four triangular elements and subjected to the tensile forces shown in Figure P7-12. Compare your results...
-
Bowen Corporation has the following shares outstanding: 15,000 shares of \(\$ 50\) par value, six percent preferred stock and 50,000 shares of \(\$ 5\) par value common stock. During its first three...
-
Sam and Drew are equal partners in SD LLC formed on June 1 of the current year. Sam contributed land that he inherited from his uncle in 2007. Sam's uncle purchased the land in 1982 for $30,000. The...
-
A capital budget: Question 10 options: is a budget for short-term goals involving recurring items. is a budget for long-term goals involving recurring items. is a budget for long-term goals involving...
-
The financial statements of Merdana Trading Ltd. are given below: 2014 2013 2014 2013 Cash and Cash Equivalents 12,250 10,470 Total Assets 128,980 113,110 Receivables 9,065 8,055 Inventory 6,620...
-
Ram of Bombay sends out goods costing 80,000 to Mohan of Kanpur so as to show 20% profit on invoice value. 3/5th of the goods received by consignee is sold at 5% above invoice price. The amount of...
-
Analyze the molecular basis of apoptosis, highlighting the orchestrated activation of caspases, mitochondrial outer membrane permeabilization (MOMP), and the role of Bcl-2 family proteins in...
-
A company's year-end balance sheet shows the following financial data: Accounts Receivable: $200 Inventory: $700 Fixed Assets: $900 Accounts Payable: $500 Long-Term Debt: $1000 What is this company's...
-
Most economies today are "mixed economies," in which there is a both a public sector and a private sector. Explain the following justifications for government intervention in the economy: public...
-
Diversity means to me that you have different cultures, religions or skin tones surrounding you. That it's not just one kind of person putting out ideas out there that it varies with different...
-
Write 3 sentences about the difference in Dismantling the patriarchy and the importance of play
-
The Fenring Corporation ended 2023 with $218,000 in assets, $97,400 in liabilities and $120,600 in stockholders equity. During January of 2024, the company had the following transactions: A. Sold...
-
General Electric Capital, a division of General Electric, uses long-term debt extensively. In a recent year, GE Capital issued $11 billion in long-term debt to investors, then within days filed legal...
-
Frank Willingham has the following transactions during the year: Sale of office equipment on March 15 that cost $20,000 when purchased on July 1, 2010. Frank has claimed $5,000 in depreciation and...
-
For each of the following situations, indicate whether the taxpayer(s) is (are) required to file a tax return for 2012. Explain your answer. a. Helen is a single taxpayer with interest income in 2012...
-
Larry and Lisa Williams, both 33 years old, have been married for 9 years. They live at 638 Arctic Way, Fairbanks, AK 99701. Lisa's Social Security number is 445- 81-1423 and Larry's is 798-09-8526....
-
If the bylaws give the members specifi c rights to infl uence how the board functions, why should a bylaws clause also give the members the right to approve amendments to the document?
-
Which of the following measures the potential amount of data that might be lost due to a system disaster? a. checkpoint c. RTO b. restoration d. RPO
-
Which of the following statements is true? a. Encrypting data is sufficient to protect confidentiality and privacy. b. Cookies are text files that only store information and cannot do anything. c. A...
Study smarter with the SolutionInn App