Question
Problem 1. (Resource Planning-AggPlan. Total 15 pts,) Given the next 6 months aggregated demand forecast and other related information from the following 4 tables. Table
Problem 1. (Resource Planning-AggPlan. Total 15 pts,) Given the next 6 months aggregated demand forecast and other related information from the following 4 tables.
Table 1. next 6 months aggregated demand forecast
Table 2. Types of available productions and costs to produce each product
Table 3. The inventory cost for one product per month, and the Backlog cost for each product that needs to be backlogged.
Table 4. Inventory of products that is available at the beginning of January.
Table 1. Demand forecast |
| Table 2. Types of available production and Other Related Information | ||||
Month | Project Demand (unit) |
| Available Production | Regular | Overtime | Subcontract |
Jan | 250 |
| Monthly Capacity (in units) | 200 | 40 | 150 |
Feb | 200 |
| Operation Cost (per unit) | $100 | $130 | $140 |
Mar | 200 |
|
|
|
|
|
Apr | 650 |
| Table 3. Inventory and Backlog Costs |
| ||
May | 550 |
|
| Inventory | Backorder |
|
Jun | 100 |
| Cost (per Month) | $10 | $15 |
|
Total |
|
|
|
|
|
|
|
|
| Table 4. Inventory Relatd Information (in unit) |
|
| |
|
|
| Given Beginning | 50 |
|
|
|
|
| Required End of June | 100 |
|
|
To do the followings
a) i) develop a Feasible Aggregate Plan for the coming six-month demand forecasted. A Feasible Aggregate Plan is a plan that meets the end-of-June inventory requirement. ii) For the aggregate plan you have developed in a-i), calculate the 6-month costs of Regular production; Overtime production; subcontract; plus costs that occurred due to Inventory and Backlog, Finally. the Total 6-month costs of your Aggregate Plan.
b) Discuss whether or not the plan you developed in a) is the Best. Explain why? If it is not the Best, use a systematic approach to revise your plan so that the total costs are Minimized, or at least better. Please explain why your revised plan will be better. Varify your result by recalculate the total costs.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started