Develop aggregate production plan

Assignment Help Operation Management

Reference no: EM132173932

A planner has developed an aggregate forecast for demand for the next 6 months as shown below: Month January- 6000 February-5000 March-6000 April-5500 May-6000 June-7000

Use the following information to develop aggregate plans:

Regular production cost: $10.00 per case

Regular production capacity:

5500 cases/month

Overtime production cost: $15.00 per case

Subcontracting cost: $20.00 per case

Holding/Carrying cost: $2.00 per case per month

Develop an aggregate production plan for each of the following guidelines and compute the total cost for each plan. Note: backlogs are not allowed. Use level-capacity production and supplement with inventory and subcontracting as needed. Use a combination of inventory, regular production, overtime (maximum 200 cases per month), and subcontracting (maximum 300 cases per month) as needed. Use regular production, inventory and overtime (500 cases maximum per month). Use "Solver" to set up and answer all three parts. Save all parts in three separate worksheets (e.g., part 1, part 2 and part 3) in a single spreadsheet file (make sure that your Excel file name includes your last name). Moreover, please make sure that that all Solver parameters inputs (e.g., "Set objective cell", "By Changing Variable cells", and constraints) are all reflected in each corresponding Excel worksheet.

Reference no: EM132173932

Questions Cloud

How would you have voted on the proposal : If you were a member of the union, how would you have voted on the proposal? Why?

Development similar or different in nature and function : How are training and development similar or different in nature and function?

Cultural norms-values play significant role in organizations : Cultural norms and values play a significant role in all organizations, from businesses in the economic sector to religious, political, and sports organizations

What types of marketing techniques were used to produce : Since the iPhone came out in 2007 Apple Inc. stock has been rising impressively, what types of marketing techniques were used to produce such an amazing rise?

Develop aggregate production plan : Develop an aggregate production plan for each of the following guidelines and compute the total cost for each plan.

Partner is favored by firms when forming new alliances : What type of partner is favored by firms when forming new alliances? The reasons cited for a large percent of expats sent abroad who return home early are.

Discuss organizational change through appreciative inquiry : Evaluate and discuss organizational change through appreciative inquiry. Include the names and descriptions of the specific phases.

Jobs should be the basis for market segmentation : Sasha, the marketing head of a firm, believes that customers hire products to do jobs for them and that these jobs should be the basis for market segmentation.

Behaviours were prompting executive decision making to shift : What changes in consumer behaviours were prompting executive decision making to shift?

User Account

All Pages