Prepare your aggregate plan

Assignment Help Operation Management

Reference no: EM133649102

Assignment: Graphical Method of Aggregate Planning

In the Module Overview, we stated that an "aggregate plan will include the quantity and timing of production for the intermediate future (typically 3-18 months ahead)." Some factors such as demand, pay rate, and the ability to use overtime or subcontract some of the production must be taken into consideration to keep the total cost of production as low as possible.

You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best option.

This chart provides the variables and cost for each variable.

Step I

Use the Excel OM Aggregate Planning spreadsheet and the data to prepare your aggregate plan. Produce a graph of your plan. The intent is to use a level strategy (or level scheduling) with no overtime, no safety stock, and no subcontractors.

Hint 1 - Consider that it takes 1.5 hours to produce a unit when determining your cost per unit for average and overtime pay.
Hint 2 - To determine regular time production, you need to multiply the units per day produced by the number of production days.

Continue to Step II: Update Your Aggregate Plan Using Overtime

Step II

In the plan produced in Step I, the production rate did not meet the total demand. If you were able to use overtime to meet the shortfall, what would your aggregate plan look like?

Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan.

Continue to Step III: Update Your Aggregate Plan Using Outsourcing

Step III

Instead of paying overtime, you might be able to outsource the shortfall in production. Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan using outsources instead of paying overtime.

Continue to Step IV: Summarize and Submit

Step IV

On a fourth tab of the spreadsheet, summarize your cost and determine which of the three options produces the lowest overall cost. Be sure to provide a detailed analysis along with your summary data.

Submit one spreadsheet containing a tab for each step. Save your assignment using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.

Reference no: EM133649102

Questions Cloud

Explain problem and explain how you would address problem : Explain the problem and explain how you would address the problem. If prescribing a new drug, write out a complete medication order just as you would.

How chatgpt has influenced the automation of marketing tasks : How ChatGPT has influenced the automation of marketing tasks and processes, such as content creation, ad targeting, and social media management.

But how does psychotherapy achieve the changes : Changes influenced by psychopharmacology can be explained by the biological basis of treatments. But how does psychotherapy achieve these changes?

What they say about how the pandemic affects these workers : What organizations in your community are working to support migrant women domestic workers, and what they say about how the pandemic affects these workers.

Prepare your aggregate plan : Use the Excel OM Aggregate Planning spreadsheet and the data to prepare your aggregate plan. Produce a graph of your plan.

What are some of the cultural variables that marketers : What are some of the cultural variables that marketers must consider when developing advertising and promotional programs in a foreign market?

Discuss crm as it relates to customer acquisition : Discuss CRM as it relates to Customer Acquisition, Customer Retention, and Profitability for QC Coffee and Bagel Shop. Discuss each one independently.

Explain the processes of new approach that more efficient : Explain the processes of the new approach that would be more efficient for getting the task, job, or work done in your organization.

Explain the nature of the manifest destiny ideology : Explain the nature of the Manifest Destiny ideology as defined by John O'Sullivan in 1845.

User Account

All Pages