Question: (Aggregate Planning) The demand for a product for the next four months and the number working days in each month are as follows: Assume that

 (Aggregate Planning) The demand for a product for the next four

(Aggregate Planning) The demand for a product for the next four months and the number working days in each month are as follows: 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!