Question

In: Accounting

Given a certain forecast, aggregate planning is to determine operational parameters over a specified time horizon,...

Given a certain forecast, aggregate planning is to determine operational parameters over a specified time horizon, such as production rate, workforce size, machine capacity
level, inventory, etc.
a) The fundamental trade-offs in aggregate planning are among capacity (regular time, overtime, subcontracted), inventory and backlog/lost sales because of delay. Briefly explain the three strategies that are most widely used in aggregate planning.
[6]
b) A gardening tool company aims to establish an aggregate plan to minimise its operation cost in the next month, in terms of units of production, units of subcontracted, number of overtime hours, and inventory (at the end of the next month). Formulate a mathematical optimisation problem for this company by using the information below. You may wish to define extra variables as necessary.
 Workforce. The company pays a monthly cost of £1000 for each of the W workers, and decides not to hire or to lay off any workers in the month. Each worker can produce 40 units per month on regular time.
 Overtime. Overtime labour cost is £12 per hour per worker. Every four hours of overtime per worker can produce one unit. No one can work more than 10 hours of overtime each month.
 Inventory. At the beginning of the month the inventory is 1000 units. The inventory cost for a certain month is calculated from the average at the beginning and the end of that month. The actual cost is £2 per unit per month. The company decides that at the end of next month the inventory must be more than 500 units.
 Production. Production cost is £10 per unit.
 Subcontract. Subcontracted production cost is £30 per unit.
 Demand. The demand for the next month has been forecasted to be 1500 units.

Solutions

Expert Solution

Aggregate Planning Strategies

There are three types of aggregate planning strategies available for organization to choose from. They are as follows.

Level Strategy

As the name suggests, level strategy looks to maintain a steady production rate and workforce level. In this strategy, organization requires a robust forecast demand as to increase or decrease production in anticipation of lower or higher customer demand. Advantage of level strategy is steady workforce. Disadvantage of level strategy is high inventory and increase back logs.

Chase Strategy

As the name suggests, chase strategy looks to dynamically match demand with production. Advantage of chase strategy is lower inventory levels and back logs. Disadvantage is lower productivity, quality and depressed work force.

Hybrid Strategy

As the name suggests, hybrid strategy looks to balance between level strategy and chase strategy.

1. Change inventory levels

• Increase in low periods to meet high demand later

• Costs: storage, insurance, handling, obsolescence, and capital investment

• Shortages may mean lost sales

2. Varying workforce size by hiring or layoffs

• Training and separation costs for hiring and laying off workers

• New workers may have lower productivity

• Laying off workers may lower morale and productivity

3. Varying production rates through overtime or idle time

• May be difficult to meet large increases in demand

• Overtime can be costly and may drive down productivity

• Absorbing idle time may be difficult

4. Subcontracting

• Meet peak demand, may be costly

• Assuring quality and timely delivery may be difficult

• Exposes your customers to a possible competitor

5. Using part-time workers

• Useful for filling unskilled or low skilled positions

  • WORKFORCE = 1000*40 = 40000
  • OVERTIME = 12 *10 =120
  • INVENTORY = 1000/500 = 2
  • PRODUCTION = 10
  • SUBCONTRACTED PRODUCTION = 30
  • DEMAND = 1500

THEREFORE COST = 40000+120+2+10+30+1500

= 41662


Related Solutions

(Inventory Policy) Please determine an optimal inventory policy for following demand and cost parameters. Planning horizon                     &nbsp
(Inventory Policy) Please determine an optimal inventory policy for following demand and cost parameters. Planning horizon                           One year Expected total annual demand 560,275 Units Fixed ordering cost                       700 USD Holding cost                                   20% of product cost Product cost                                   20 USD per unit Retail price                                     38 USD per unit Salvage value                                 15 USD per unit Lead time (fixed)                           3 days What is the optimal order size Q? Assuming the daily demand is constant and known, what is the reorder...
Emma Limited’s current and forecasted free cash flows to the firm (FCFF) over the forecast horizon...
Emma Limited’s current and forecasted free cash flows to the firm (FCFF) over the forecast horizon and the terminal period are as follows ($ millions): ($ millions) Current Forecast Horizon Terminal Period 2020 2021 2022 2023 2024 2025          FCFF 1,697 1,799 1,907 2,021 2,051 2,082 Valuation assumptions and other information for Emma Limited are as follows: Terminal growth rate 1.5% Shares outstanding in millions 2,250 Net nonoperating obligations (NNO) ($ millions) 9,000 WACC 8.00% REQUIRED: Estimate Emma Limited’s equity...
Aggregate Planning Given the projected demands for the next six months, prepare an aggregate plan that...
Aggregate Planning Given the projected demands for the next six months, prepare an aggregate plan that uses inventory, regular time, overtime, subcontract and backorders. Regular time is limited to 150 units per month (Cost per Unit = $20 ). Overtime is limited to a maximum of 30 units per month (Cost per Unit =$30). Units purchased from the subcontractor (Cost per Unit = $26 ) cannot exceed 40 per month and the total purchases from the subcontractor over the 6...
Think about how demand and supply may change over time given certain events. What is the...
Think about how demand and supply may change over time given certain events. What is the relationship between average total cost and marginal costs?
Use the method of variation of parameters to determine the general solution of the given differential...
Use the method of variation of parameters to determine the general solution of the given differential equation. y′′′−2y′′−y′+2y=e^(8t)
Use the method of variation of parameters to determine a particular solution to the given equation....
Use the method of variation of parameters to determine a particular solution to the given equation. y′′′+27y′′+243y′+729y=e^−9x yp(x)=?
Given the following information concerning a four-year planning horizon for a particular ERP system implementation: Licensing...
Given the following information concerning a four-year planning horizon for a particular ERP system implementation: Licensing rights for all four (4) years - $400,000 Application server and database server purchase - $75,000 (four-year expected life) Computer purchases and upgrades - $28,000 (one-time charge) Maintenance contract for computers and servers -- $5,500 per year Training - $10,000 for the first year, $5000 for the remaining three years Consulting - Free for the first 6 months then $12,000 per year (prorated for...
3. The components of planned aggregate spending in a certain economy are given by Consumption Function:...
3. The components of planned aggregate spending in a certain economy are given by Consumption Function: C = 800 + 0.75(Y - T) – 2000r Planned Investment: I p = 400–3000r Government Revenue and Spending: T = 300 and G = 450 Net Export: NX = 75 where r is the real interest rate (For example, r = 0.01 means that the real interest rate is 1 percent). (1) Find the level of public saving. (2) Suppose that the real...
Given specified circumstances of an employment relationship, determine the circumstances under which an employer is liable...
Given specified circumstances of an employment relationship, determine the circumstances under which an employer is liable to an employee for employment discrimination or wrongful discharge. FACTS: Minnie and Daisy both sue the School of Prof Arts and Professor Goofy for discrimination and further, for liability for their injuries (the stabbing damages Minnie's son sustained when Professor Goofy did not stop a fight and the damages to Daisy’s son’s health from watching the stabbing.) You are one of the board of...
Eastern Motors Auto Dealership wanted to estimate the average CLV over a 5 year time horizon...
Eastern Motors Auto Dealership wanted to estimate the average CLV over a 5 year time horizon of a customer who purchases a new vehicle. The average vehicle sells for $25,800 and has a margin of 10%. Based on historical averages, 74% of people buying a new vehicle at Eastern will return for service 12 times over the next 5 years. Though it varies considerably, Eastern generates approximately $142 in margin on each service visit after accounting for parts and direct...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT