XYZ Company is preparing its aggregate production plan for 2022. The monthly demand forecasts are given...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
XYZ Company is preparing its aggregate production plan for 2022. The monthly demand forecasts are given in Table 1. Demand 500 600 600 800 1300 2000 2500 3000 2400 1800 1500 12 1200 The company is expected to have 100 workers on the payroll and 150 units in inventory at the end of 2021. Each worker can produce 10 units per month on regular time and 2 units per month in overtime. Table 1 Monthly Demand Forecasts Month RK-F013- RO 1 2 3 4 5 6 7 8 Additional data: 1. Regular time production cost-$200 per unit. 9 2. Overtime production cost-$300 per unit. 3. Hiring cost-$500 per worker 4. Firing cost-$3000 per worker 5. Desired final inventory (December 2022)-100 units 6. Desired final workforce (December 2022)-150 workers ii. 10 iv. 7. Inventory holding cost is charged based on the average inventory at the beginning and end of the month at $50 per unit per month 8. No shortages are allowed. 20.09.2023 a. Determine a production plan using the "chase strategy". b. Determine a production plan using the "level strategy". c. Formulate a LP model that will determine the optimal production plan for 2022. You must define your variables clearly, write out the constraints that must be satisfied explaining the significance of each, and write the objective function with explanation d. Solve the LP model using Excel Solver. You should also submit your Excel file. e. Compare the three production plans (chase strategy, level strategy, and LP solution) with respect to the following: i. Monthly inventory levels Hiring and firing Overtime use Total cost XYZ Company is preparing its aggregate production plan for 2022. The monthly demand forecasts are given in Table 1. Demand 500 600 600 800 1300 2000 2500 3000 2400 1800 1500 12 1200 The company is expected to have 100 workers on the payroll and 150 units in inventory at the end of 2021. Each worker can produce 10 units per month on regular time and 2 units per month in overtime. Table 1 Monthly Demand Forecasts Month RK-F013- RO 1 2 3 4 5 6 7 8 Additional data: 1. Regular time production cost-$200 per unit. 9 2. Overtime production cost-$300 per unit. 3. Hiring cost-$500 per worker 4. Firing cost-$3000 per worker 5. Desired final inventory (December 2022)-100 units 6. Desired final workforce (December 2022)-150 workers ii. 10 iv. 7. Inventory holding cost is charged based on the average inventory at the beginning and end of the month at $50 per unit per month 8. No shortages are allowed. 20.09.2023 a. Determine a production plan using the "chase strategy". b. Determine a production plan using the "level strategy". c. Formulate a LP model that will determine the optimal production plan for 2022. You must define your variables clearly, write out the constraints that must be satisfied explaining the significance of each, and write the objective function with explanation d. Solve the LP model using Excel Solver. You should also submit your Excel file. e. Compare the three production plans (chase strategy, level strategy, and LP solution) with respect to the following: i. Monthly inventory levels Hiring and firing Overtime use Total cost
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
Pablo Management has two employees, each of whom earns $210 per day. They are paid on Fridays for work completed Monday through Friday of the same week. Near year-end, the two employees worked...
-
Find the charge in coulomb on 1 g-ion of Charge on one ion of N-
-
The earnings per share (in dollars) for a company can be approximated by the function f(x) = -5.9 +3.57 In x, where x=7 corresponds to the year 2007. (a) Find the earnings per share for the year...
-
An airplane has a mass of 5000 kg, a maximum thrust of 7000 N, and a rectangular wing with aspect ratio 6.0. It takes off at sea level with a 60 split flap as in Fig. 7.25. Assume all lift and drag...
-
You undoubtedly have read about individuals who seemingly have given single-handed direction to their corporations. Is a participative strategic management approach likely to stifle or suppress the...
-
The ledger of Umatilla Inc. on March 31, 2017, includes the following selected accounts before adjusting entries. An analysis of the accounts shows the following 1. Insurance expires at the rate of...
-
Journalize the following transactions of Cramer, Inc., which ends its accounting year on June 30: Apr 1 Jun 6 30 Loaned $20,000 cash to R. Simpson on a one-year, 8% note. Sold goods to Friday, Corp.,...
-
The following is the pre closing trial balance for Allen University as of June 30, 2017. Additional information related to net assets and the statement of cash flows is also provided. Additional...
-
distinguish between "subjective expected return" and required rate of return what would you do if you believe that a stock will offer a return lower than required rate of return during the next 12...
-
XYZ is a calendar-year corporation that began business on January 1, 2020. For the year, it reported the following information in its current-year audited income statement. Notes with important tax...
-
On March 15, Drexel Corp. provides goods to a retailer through consignment where Drexel Corp, retains ownership of the goods until the goods are sold to the retailer's customer. Sale to the final...
-
Great Family Theme Park Ltd. operates amusement parks similar to those such as Six Flags, Universal Studios, Disneyland etc. Great Family Theme Park's mission is to provide high quality family...
-
A group of seven galaxies each of a total mass 1 0 1 2 M form a stable cluster in a sphere of constant radius 1 . 5 Mpc . At what redshift did this group have the same mean density as the surrounding...
-
Kevin owns a retail store, and during the current year he purchased $578,000 worth of inventory. Kevin's beginning inventory was $58,000, and his ending inventory is $79,000. During the year, Kevin...
-
Based on an evaluation of the organization's current state and recent initiatives, the areas listed below have been identified as being in need of improvement based on the triple-bottom-line...
-
Re-write the information written below in paragraph form. Use the references below to cite evidence and add more information. Navigating the Crossroads: Balancing Rehabilitation and Accountability in...
-
Consider black body radiation inside two-dimensional cavity in thermal equilibrium. If the temperature of cavity of fixed size is doubled. its pressure increases to 16 times of initial value its...
-
The executor of Gina Purcells estate has recorded the following information: Assets discovered at death (at fair value): Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
Show how you would use an acid chloride as an intermediate to synthesize (a) N-phenylbenzamide (PhCONHPh) from benzoic acid and aniline. (b) Phenyl propionate (CH3CH2COOPh) from propionic acid and...
-
When acetone is treated with excess benzaldehyde in the presence of base, the crossed condensation adds two equivalents of benzaldehyde and expels two equivalents of water. Propose a structure for...
-
p-Xylene undergoes nitration much faster than benzene. Use resonance forms of the sigma complex to explain this accelerated rate.
-
State the main audit objectives for (1) purchases and payroll transactions and (2)creditors balances.
-
For each of the six functions associated with processing payroll, identify one control.
-
What is the sequence of functions normally associated with processing of purchase transactions? For each function, identify one control.
Study smarter with the SolutionInn App