Graphical Method of Aggregate Planning

Graphical Method of Aggregate Planning.

Help me study for my Excel class. I’m stuck and don’t understand.

Scenario

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.

Variables Cost
Inventory carrying cost $6 per unit per month
Subcontracting cost $25 per unit
Average pay rate $12.50 per hour (8 hours per day)
Overtime pay rate $18 per hour (above 8 hours per day)
Labor-hours needed to produce one unit 1.5 hours per unit
Units per day produced 50
Beginning inventory 0
Planned ending inventory 0
Lost sales per unit $100

This chart provides the demand for the product and the number of production days per month.

Months Demand Production Days
January 1200 22
February 800 18
March 600 21
April 1500 21
May 1400 22
June 1300 20

Step 1: 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. The intent is to use a level strategy (or level scheduling) with no overtime, no safety stock, and no subcontractors.

Hint 1 – Need to 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.

Step 2: Update Your Aggregate Plan Using Overtime

In the plan produced in Step 1, 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.

Step 3: Update Your Aggregate Plan Using Outsourcing

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.

Step 4: Summarize and Submit

On a fourth tab of the spreadsheet, summarize your cost and determine which of the three options produces the lowest overall cost.

Graphical Method of Aggregate Planning

Posted in Uncategorized

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Graphical Method of Aggregate Planning

Graphical Method of Aggregate Planning. 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.
VariablesCostInventory carrying cost$7 per unit per monthSubcontracting cost$25 per unitAverage pay rate$12 per hour (8 hours per day)Overtime pay rate$18 per hour (above 8 hours per day)Labor-hours needed to produce one unit1.5 hours per unitUnits per day produced50Beginning inventory0Planned ending inventory0Lost sales per unit$30 This chart provides the demand for the product and the number of production days per month.
MonthsDemandProduction DaysJanuary130022February80018March60021April150021May130022June130020Step1:Prepare your Aggregate Plan
Step 2: Update Your Aggregate Plan Using Overtime
Step 3: Update Your Aggregate Plan Using Outsourcing
Step 4: Summarize and Submit

done
Seen
2 mins ago[supanova_question]

7-1 Discussion: Business Combinations

Organizations often face the “build it or buy it” decision: whether to expand “organically,” or to expand through some form of business combination such as mergers or acquisitions, joint ventures, licensing, franchising (a form of licensing), or contractual, strategic alliances.Discuss the key advantages and disadvantages of organic expansion and each of the listed forms of business combination for an international expansion. Support your views with relevant examples.

done
Seen
few seconds ago[supanova_question]

Management Question

Graphical Method of Aggregate Planning Management Assignment Help This is your final assignment for which a sample format is provided in the blackboard (Week 11 materials). It is already attached to the next page. You
must submit the same as per the given sample format. Adherence to the
format is necessary. This final research proposal must contain all the
stages and processes involved in a typical research proposal. Read
Chapter 16 of your textbook to have clarity on writing a report or
proposal.
Submit your findings in a 10-12 page document, excluding the title page, abstract and required reference page
[supanova_question]

Humanities Question

Instructions: Choose a musical artist (from any music era). Choose one of his or her main works (songs or compositions) and listen to the piece so that you can comment on your reaction to the work. Write a 1-2 page essay about the following:
A brief summary of the background or history of the artist
The meaning of the song you chose
The musical elements being used, with examples
The contribution that the piece has had to the development of music and how it influenced future music
Your assignment should be written in APA format and should include in-text citations and a reference page.

done
Seen

Nov 24th, 2021[supanova_question]

Graphical Method of Aggregate Planning

Graphical Method of Aggregate Planning