Aggregate plan for 3 periods to achieve demand of total 8700 units (i.e. 4000, 2300 and 2400 units for period 1, 2 and 3 respectively) is as given below: | |
Beginning Inventory | 400 units |
Add: Regular time production for period 1 as per capacity | 2600 units |
Add: Regular time production for period 1 as per capacity | 2600 units |
Total units production during regular time for period 1 | 5600 units |
Less: Demand for period 1 i.e. 4000 units | 4000 units x Rs. 100 per unit = Rs. 400,000 |
Ending / Beginning Inventory for Period 2 | 1600 units |
Add: Regular time production for period 2 as per capacity | 2600 units |
Total units production during regular time for period 2 | 4200 units |
Less: Demand for period 2 i.e. 2300 units | 2300 units x Rs. 100 per unit = Rs. 230,000 |
Ending / Beginning Inventory for Period 3 | 1900 units |
Add: Regular time production for period 3 as per requirement | 500 units |
Total units production during regular time for period 2 | 2400 units |
Less: Demand for period 3 i.e. 2400 units | 2400 units x Rs. 100 per unit = Rs. 240,000 |
Ending Inventory for Period 3 | 0 units |
Cost of unutilized capacity during regular time production | 2600 units - 500 units (production of period 3) = 2100 units x Rs. 50 per unit = Rs. 105,000 |
Therefore, an aggregate plan and total cost of the plan | Rs 400,000 (cost of production as per demand for period 1 as calculated above) + Rs. 230,000 (cost of production as per demand for period 2 as calculated above) + Rs. 240,000 (cost of production as per demand for period 3 as calculated above) + Rs. 105,000 (cost of unutilized capacity during regular time production as calculated above) = Rs. 975,000 |
6. A manufacturer has the following information on its major product. Regular time production capacity is...
A manufacturer wants to develop a production plan for the month of February through June. The forecasted demand for those months are 2500, 3700, 3900, 5000, and 2000 units, respectively. The regular-time production capacity in February and March are 3000 units and 2500 units, respectively. The overtime production capacity in February and March are 600 units and 500 units, respectively. The regular production cost is $30 per unit and the overtime production cost is $45 per unit. The cost of...
Company AAA produces only one product which other manufacturers purchase as a component for their final products. The operations manager wants to plan the production and inventory quantities of the product for the first six months of the next year. The monthly demand is forecasted as follows. January February March April May June 1200 1400 1800 2400 2600 2200 The company has three production options: regular production, overtime production, and subcontracting. Production cost per unit during regular time is $80...
USE LEVEL AGGREGATE PLAN: Cost data Regular time labor cost per hour $10 Overtime time labor cost per hour $15 Subcontracting cost per unit $80 Back order cost per unit per period $20 Inventory holding cost per unit per period $10 Hiring cost per employee $400 Firing cost per employee $500 Capacity data Beginning workforce 40 employees Beginning inventory 0 units Beginning backorders 0 units Production standard per unit (hours) 2 hours of labor per unit Regular time available per...
You would like to construct an aggregate production plan for four quarters of 2021. Product name: TRX3010 Cost of regular production = 50 $/u Cost of overtime production = 65 $/u Inventory holding cost = 5 $/u/qtr Cost of increasing production = 40 $/u Cost of decreasing production = 45 $/u Previous quarter's regular production = Beginning inventory level = 250 u 4200 u The forecasted demand for the next four quarters is 3700, 4000, 2600, and 3900 units. You...
Summer-Fun, Inc., produces a various commodities related to recreation and leisure. The production manager has developed an aggregate forecast: Apr May Aug Sep Total Mar June July Demand 50 1 44 | 55 | 59 | 50 | 41 51 350 Use the following information to develop aggregate plans. Regular production cost $ 80 per unit Overtime(OT) production cost $ 120 per unit Subcontracting(SC) cost $ 140 per unit Regular capacity 40 units per month Overtime capacity 8 units per...
Nowjuice, Inc., produces bottled pomegranate juice. A planner has developed an aggregate forecast for demand for the next six months. Month May Jun jul Aug Sep oct Forecast 4000 4800 5600 7200 6400 5000 Use the following information to develop aggregate plans. Regular production cost $ 10 per case Regular production capacity 5000 cases Overtime production cost $ 16 per case Subcontracting cost $ 20 per case Inventory cost $ 1 per case per month Beginning inventory 0 Develop...
Demand over the next four months are 450, 500, 350, and 400 respectively. Regular time production costs $10 per item, and we can make a maximum of 400 items in a given month in regular time. Overtime production costs $16 per item, and as many as 200 items may be produced in overtime each month (in addition to the regular time production). Keeping an item in inventory incurs a cost of $1 per period; backorders cost $3 per period per...
Demand over the next four months are 450, 500, 350, and 400 respectively. Regular time production costs $10 per item, and we can make a maximum of 400 items in a given month in regular time. Overtime production costs $16 per item, and as many as 200 items may be produced in overtime each month (in addition to the regular time production). Keeping an item in inventory incurs a cost of $1 per period; backorders cost $3 per period per...
Given the following demand forecasts, costs, and constraints for a company. Regular Prod. Capacity = 27,000 units/qtr Regular Prod. Cost = $12/unit Overtime Prod. Capacity = 3000 units/qtr Overtime Prod. Cost = $20/unit Subcontracting Capacity = 16,000 units/qtr Subcontracting Cost = $25/unit Inventory Capacity = 32,000 units/qtr Inventory Cost = $5/unit/qtr Beginning Inventory = 0 Backorder Cost = $15/unit/qtr Quarter Demand (units) 1 19,200 2 42,000 3 27,000 4 10,800 What is the cost if the company uses level production...
A manager has projected demand for the next six months (below). Given this information, prepare a LEVEL aggregate plan for production. Assume maximum regular time production is 350 units per month. Overtime is limited to 75 units per month. The limit for subcontracting is 400 per month. The company has a zero beginning inventory and cannot have ending inventory or a backlog at the end of the 6th period. Unit costs are as noted below. Regular Time Cost: $10/unit Overtime...