ABC company is making production plans for the coming 12 months. Important parameters are given in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ABC company is making production plans for the coming 12 months. Important parameters are given in the table below Manufacturing is primarily an assembly operation, and capacity is related to the number of workers Produce an aggregate plan that count for the following constraints. - The plant currently employs 1,000 workers Layoff is not allowed. New hires is not allowed. • Overtime is limited to a maximum of 40 hours per month per employee. • Assume that ABC has no inventory to start with • Backlogs is not allowed Subcontracting is not allowed For consistency, use the following decision variables, • P. Production at the beginning of each period Or Overtime worked in each period • Inventory level at the end of each period Item Around 159 Millions Around 154 Millions Around 151 Millions Cost 20 days worker 12 hour day Working day per worker Working hour per day Production time for each product 2 hour unit Material cost $70/unit Inventory holding cost $1 Sumit Regular time cost $15 hour Overtime cost $25 hour te the demand forecasts within the Excel sheet provided with exam to calculate the minimum cost Around 161 Millions Around 160 Millions ABC company is making production plans for the coming 12 months. Important parameters are given in the table below Manufacturing is primarily an assembly operation, and capacity is related to the number of workers Produce an aggregate plan that count for the following constraints. - The plant currently employs 1,000 workers Layoff is not allowed. New hires is not allowed. • Overtime is limited to a maximum of 40 hours per month per employee. • Assume that ABC has no inventory to start with • Backlogs is not allowed Subcontracting is not allowed For consistency, use the following decision variables, • P. Production at the beginning of each period Or Overtime worked in each period • Inventory level at the end of each period Item Around 159 Millions Around 154 Millions Around 151 Millions Cost 20 days worker 12 hour day Working day per worker Working hour per day Production time for each product 2 hour unit Material cost $70/unit Inventory holding cost $1 Sumit Regular time cost $15 hour Overtime cost $25 hour te the demand forecasts within the Excel sheet provided with exam to calculate the minimum cost Around 161 Millions Around 160 Millions
Expert Answer:
Answer rating: 100% (QA)
The answer is Around 154 Million To calculate the minimum cost ABC needs to consider the following factors 1 Production ABC needs to decide the number ... View the full answer
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Posted Date:
Students also viewed these accounting questions
-
The data given in the table below are the midterm scores in a course for a sample of 10 students and the scores of student evaluations of the instructor. (In the instructor evaluation scores, 1 is...
-
The formulas of several chemical substances are given in the table below. For each substance in the table, give its chemical name and predict its molecular structure. Formula CO NH3 SO3 HO CIO Name...
-
Quigley Inc. is considering two financial plans for the coming year. Management expects sales to be $301,770, operating costs to be $266,545, assets to be $200,000, and its tax rate to be 35%. Under...
-
Name the five levels of the Capability Maturity Model.
-
Utease Corporation has many production plants across the midwestern United States. A newly opened plant, the Bellingham plant, produces and sells one product. The plant is treated, for responsibility...
-
A microwave oven is used to heat 250 g of water. On its maximum setting, the oven can raise the temperature of the liquid water from 20C to 100C in 1 min 45 s (= 105 s). (a) At what rate does the...
-
Rank the two types of light-sensitive cells, rods and cones, in terms of (a) ability to see in dim light, (b) ability to make out fine details, and (c) ability to distinguish different colors.
-
The Sasoon Barber Shop employs four barbers. One barber, who also serves as the manager, is paid a salary of $3,000 per month. The other barbers are paid $1,500 per month. In addition, each barber is...
-
How can the cultural differences might impact business negotiations between TechMow's U.S. executive and potential business partners in Brazil and India? What should those U.S. executives expect?
-
Childrens Best Hope (CBH) provides day care ser-vices to low income families. CBH bills the state for its services under a service contract. Billings for the first four months of 2013 are anticipated...
-
When reconciling original documents with entries in the ledger, the auditor obtains evidence for the conclusion regarding which audit objective: a.Existence. b.Accuracy. c.Completeness. d....
-
The displacement (in feet) of a certain particle moving in a straight line is given by y = 22. = (A) Find the average velocity for the time period beginning when t (i) .01 s: 9.03 (ii) .005 s: 3.3...
-
Two identical metal conducting spheres A and B , and sit a top insulating stands and carry charges qA = 1 . 3 0 mu C and qB = + 3 . 1 0 mu C . The spheres are placed into contact so that charge can...
-
Explain the nature of any hazards caused by ( Ionization Radiation used or other hazards particular to the imaging procedure ) if any to patients and staff when the imaging procedure takes place. ...
-
John leaves the base camp and hikes 11 km, north and then hikes 11 km east. Determine John's resulting displacement.
-
No matter how great bankers are at their jobs, they will ultimately be "failures" if credit risk and interest rate risk is not managed properly. The good thing is that bankers have found different...
-
1 A. What is sourcing? B. State TWO (2) reasons as to why sourcing is important in the supply chain? C. List any TWO (2) types of sourcing. D. From question 3 explain how you would use any of the...
-
1. Use these cost, revenue, and probability estimates along with the decision tree to identify the best decision strategy for Trendy's Pies. 2. Suppose that Trendy is concerned about her probability...
-
Refer to the Big Rig Rental Company case. Design a spreadsheet that will allow the firm to determine the Net Present Value of cash flows over the five-year period. The following exercises refer to...
-
Refer to the Cox Cable and Wire-Company case. In the role of Meredith, design a spreadsheet that will evaluate the profitability of any particular production and delivery schedule. a. Find a machine...
-
Refer to the Racquetball Racket case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem. a. Develop a base case. You may create any data you need for...
-
Enter up the relevant accounts in the purchases and general ledgers from the columnar purchases day book you completed for Review Question 20.2. Data From Review Question 20.2 20.2 Enter up a...
-
A Enter up a columnar purchases day book with columns for the various expenses for F. Graham for the month from the following information on credit items. 2016 June Bought goods from J. Syme 4 Bought...
-
Enter up the relevant accounts in the purchases and general ledgers from the columnar purchases day book you completed for Review Question 20.4A. Data From Review Question 20.4A 20.4A Enter up a...
Study smarter with the SolutionInn App