Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 $7 per unit per month
Subcontracting cost $25 per unit
Average 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 unit 1.5 hours per unit
Units per day produced 50
Beginning inventory 0
Planned ending inventory 0
Lost sales per unit $30

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 1300 22
June 1200 20

Complete the steps in each section and then submit your assignment for grading. Submit one spreadsheet containing a tab for each step. STEP 1:

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 2: Update Your Aggregate Plan Using Overtime

STEP 2:

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.

Continue to Step 3: Update Your Aggregate Plan Using Outsourcing

STEP 3:

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 4: Summarize and Submit

STEP 4:

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.

image text in transcribed Costs (per unit) \begin{tabular}{|c|c|c|c|c|} \hline Reg time & $18 & & & \\ \hline Overtime & & & & \\ \hline Subcontract & $25 & & & \\ \hline Holding & & & & \\ \hline Lost sales & $30 & & & \\ \hline Increase & & \multicolumn{3}{|c|}{ This is the cost of INcreasing production } \\ \hline Decrease & & \multicolumn{3}{|c|}{ This is the cost of DEcreasing production b} \\ \hline Starting Conditions & & & & \\ \hline Initial inventory & & \multicolumn{3}{|c|}{ This is the number of units in inventory a } \\ \hline Units last period & & \multicolumn{3}{|c|}{ This is the number of units produced in th } \\ \hline Data & & & & \\ \hline Period & Demand & \begin{tabular}{l} Reg Time \\ Production \\ \end{tabular} & \begin{tabular}{l} Overtime \\ Production \end{tabular} & \begin{tabular}{l} Subcontract \\ Production \end{tabular} \\ \hline January & 1200 & 1100 & & \\ \hline February & 800 & 900 & & \\ \hline March & 600 & 1050 & & \\ \hline April & 1500 & 1050 & & \\ \hline May & 1300 & 1100 & & \\ \hline June & 1200 & 1000 & & \\ \hline Total & 6600 & 6200 & 0 & 0 \\ \hline Average & 1100 & & & \\ \hline Cost & & $111,600 & & \\ \hline Total Cost & $123,600 & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Of Electronic And Digital Media

Authors: Alan B. Albarran

6th Edition

1305077563, 978-1305077560

More Books

Students also viewed these General Management questions

Question

What are the objectives of Human resource planning ?

Answered: 1 week ago

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago