Chapter 8: Aggregate Planning in a Supply Chain A manufacturing company faces the aggregate planning problem...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Chapter 8: Aggregate Planning in a Supply Chain A manufacturing company faces the aggregate planning problem for the next five months. The monthly demand data Di, where i=1, 2, 3, 4 and 5 is given. The company currently employs 100 workers. It takes a worker an hour to make a unit and workers are paid $20/hour. The company works 20 days a month, 8 hours a day. Overtime can't exceed 20% of the regular hours per month per employee. The cost of overtime is $30/hour. The material cost is $5/unit. The company can possibly use subcontracting from a plant in China. The cost of subcontracting is ¥60/unit ($1 = ¥6). The cost of carrying a unit in inventory from one month to the next is $2. The inventory at the beginning is 100 units. Assuming no new hires, no layoffs and by policy, management wants to avoid stockouts. The decision variables are defined as follows: Wt: workforce size for month t, t=1, ...,5 Pt: number of units produced in month t, t=1, ...,5 It: inventory at end of the month t, t-1, ...,5 Ct: number of units subcontracted in month t, t=1, ...,5 Ot: number of overtime hours worked in month t, t-1, ...,5 a. Formulate the total cost that the company is trying to minimize. Substitute data where applicable. b. C. What are the constraints? If the plant capacity of the manufacturing company is 20,000 units, that is, the total production cannot exceed 20,000 units per month, what constraint you need to add? Chapter 8: Aggregate Planning in a Supply Chain A manufacturing company faces the aggregate planning problem for the next five months. The monthly demand data Di, where i=1, 2, 3, 4 and 5 is given. The company currently employs 100 workers. It takes a worker an hour to make a unit and workers are paid $20/hour. The company works 20 days a month, 8 hours a day. Overtime can't exceed 20% of the regular hours per month per employee. The cost of overtime is $30/hour. The material cost is $5/unit. The company can possibly use subcontracting from a plant in China. The cost of subcontracting is ¥60/unit ($1 = ¥6). The cost of carrying a unit in inventory from one month to the next is $2. The inventory at the beginning is 100 units. Assuming no new hires, no layoffs and by policy, management wants to avoid stockouts. The decision variables are defined as follows: Wt: workforce size for month t, t=1, ...,5 Pt: number of units produced in month t, t=1, ...,5 It: inventory at end of the month t, t-1, ...,5 Ct: number of units subcontracted in month t, t=1, ...,5 Ot: number of overtime hours worked in month t, t-1, ...,5 a. Formulate the total cost that the company is trying to minimize. Substitute data where applicable. b. C. What are the constraints? If the plant capacity of the manufacturing company is 20,000 units, that is, the total production cannot exceed 20,000 units per month, what constraint you need to add?
Expert Answer:
Answer rating: 100% (QA)
a Salary cost per worker per month 20 days 8 hours a day 20 per hour 3200 ... View the full answer
Related Book For
Mathematical Applications for the Management Life and Social Sciences
ISBN: 978-1305108042
11th edition
Authors: Ronald J. Harshbarger, James J. Reynolds
Posted Date:
Students also viewed these general management questions
-
Given the following data: Period 1 2 3 4 5 6 7 8 9 Gross Requirements 70 30 90 30 80 20 90 60 80 The beginning inventory is 0 and there are no scheduled receipts. The order cost is $90 and the...
-
The following data is specified in a supply chain contract. P = 68, L Min = 6, Q Min = 300, Alpha = 0.05 and Beta = 2000. The mean demand is 852 units/week and the mean supply lead time is 3 weeks....
-
Chapter 10: Coordination in a Supply Chain Reflection Assignment The purpose of this assignment is to reinforce your learning from the corresponding chapter. Note: You should use your computer for...
-
John dies on 3 March 2021. Between 6 April 2020 and 3 March 2021, he has capital gains of 1,200 and capital losses of 15,400. His net gains in recent tax years (and the annual exemption for each...
-
What three functions are typically performed by a production control department?
-
Prepare journal entries for each of the following: a. Issued a check to establish a petty cash fund of $1,150. b. The amount of cash in the petty cash fund is $250. Issued a check to replenish the...
-
Consider the following network (in technical terms, a directed graph or "digraph"). Each circle, here marked with one of the letters A to P, represents a node of the network. Some of these nodes...
-
Selected ledger accounts for Rolm Company are given below for the just completed year: Required: 1. What was the cost of raw materials put into production during the year? 2. How much of the...
-
On January 1, Year 1, X Company leases some non-specialized equipment to Y Company on a non-cancelable lease. The cost to X of the equipment is $250,000, but it's fair value is $300,000. The lease...
-
Bruce also requires a calculation of taxable income for the most recent year ended December 31, 2019. The calculation should be prepared in Excel. He has also requested that you prepare the year-end...
-
If an event handler contains more than one statement, in what order are the statements executedsolve this What is the purpose of the Me.Close() statementsolve this The keyword Me is shorthand for...
-
What is long-form audit report?
-
How is an auditor of banking company appointed?
-
How will you as an auditor deal with the following? (a) Cash (d) Unpaid dividends (b) Provision for taxation (e) Goods in transit (c) Leasehold properties (f) Disposal of plant
-
In an automated payroll system, all employees in the finishing department were paid at the rate of $7.45 per hour when the authorized rate was $7.15 per hour. Which of the following controls would...
-
Which of the following is the least persuasive documentation in support of an auditors opinion? a. Schedules of details of physical inventory counts conducted by the client b. Notation of inferences...
-
Solow Corp. has a bond with annual interest payments of $140 maturing in 16 years at a value of $1,000 per bond. The current market price is $820. What will the nominal yield be? A. 17% B. 18% C.16%...
-
Government is advised to tax goods whose demand curves are inelastic if the goal is to raise tax revenues. If the goal is to discourage consumption, then it ought to tax goods whose demand curves are...
-
A store finds that its sales decline after the end of an advertising campaign, with its daily sales for the period declining at the rate S'(t)= - 1477.8e-0.2t, 0 t 35, where t is the number of days...
-
In Problems 1 and 2, use a change-of-base formula to evaluate each logarithm. 1. log9 2158 2. log12 (0.0195)
-
In the analysis of traffic flow, a certain city estimates the following situation for the "square" of its downtown district. In the following figure, the arrows indicate the flow of traffic. If x1...
-
Correctly apply the rules for the order of operations to accurately compute the following: \((10-3) \times 5^{3}\).
-
Correctly apply the rules for the order of operations to accurately compute the following: \((-8) / 2 \times 3-9 \times 2^{4} / 12+9 \times(-4)^{2} / 2^{3}\).
-
Correctly apply the rules for the order of operations to accurately compute the following: \(10-3 \times 5^{3} / 15+56 / 4\)
Study smarter with the SolutionInn App