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...
-
Samuel and Annamaria are married, file a joint return, and have three qualifying children. In 2016, they earn wages of $34,000 and no other income. Determine the amount of their earned income credit...
-
An ambulance service responds to emergency calls for two counties in Virginia. One county is an urban county and the other is a rural county. A sample of 471 ambulance calls over the past two years...
-
Journalize the following transactions for Antique Furniture, Inc., that occurred during the month of April. Antique Furnitures cost of inventory is 70% of the sales price. Apr 3 Sold $2,100 of...
-
Wilburton Riding Stables provides stables, care for animals, and grounds for riding and showing horses. The account balances at the beginning of 2009 were: Cash ....................$ 2,200 Accounts...
-
Bob is 37 years old and is an account manager with a large telecom company.He's been dragging his feet with his retirement plan, opting instead for expensive trips to Vegas and Aspen.He's decided...
-
Lasky Manufacturing has two divisions: Carolinas and Northeast. Lasky has a cost of capital of 7.5 percent. Selected financial information (in thousands of dollars) for the first year of business...
-
Bravo Corporation recently issued 270-day commercial paper with a face value of $2,000,000 and a simple interest rate of 11 percent. The company paid a transaction fee equal to 0.4 percent of the...
-
Cool Scoops makes ice cream in two processes, Mixing and Packaging. During April, its first month of business, the packaging department transferred 50,800 units and $198,120 of production costs to...
-
Which countries are most affected by natural disasters? A . Developed countries B . Developing countries
-
In the following table, choose the correct type of resource illustrated by each example. A field used for crops, such as corn or wheat Your talent to seek new business opportunities The ability to...
-
Tim s Bicycle Shop sells 2 1 - speed bicycles. For purposes of a cost - volume - profit analysis, the shop owner has divided sales into two categories, as follows: Product Type Sales Price Invoice...
-
A gas at a pressure of 2 bar occupies a volume of 0.2 m3.If the temperature of the gas is 25C and the characteristic constant for the gas is 0.35 kJ kg-1K-1, calculate : (a)the mass of the gas (b)the...
-
Consider a system of distinguishable particles with energy levels 0.8.28.38.4&....... For a system with 2 (in the units ofk). (Upto two decimal places) particles and energy 28, the entropy of the...
-
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....
-
Creative Traders Ltd. (CTL) is a Canadian company that conducts business in several countries, using a variety of currencies. The notes to the financial statements pertaining to fair values of...
-
Classification: Elkridge Corporation issued the following financial instruments in \(20 X 4\) : 1. Convertible debentures issued at 103 . The debentures require interest to be paid semiannually at a...
-
Omni Services Ltd., a Canadian public company, is a conglomerate involved in publication of newspapers, media services, and information technology consulting. It recently entered into an agreement to...
Study smarter with the SolutionInn App