Question: 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 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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)...

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)...

This chart provides the variables and cost for each variable. V a r i a b l e s C o s t I n v e n t o r y c a r r y i n g c o s t $ 7 p e r u n i t p e r m o n t h S u b c o n t r a c t i n g c o s t...

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...

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...

1. After completing the Aggregate Planning Template for the data provided in the template (name the worksheet DEMO), make a copy of that worksheet (in the same excel file) and name that worksheet...

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,...

Answer using the Aggregate Planning Spreadsheet The operations manager of Ebay must determine how many part-time stockpickers to maintain on the payroll. She wants to develop a staffing plan that...

The protein content of wheat flour can be determined with reasonable accuracy using the gravimetric factor 5.70+0.01. A 2.060.01 g sample of flour was taken through a Kjeldahl procedure and the...

Show that the functions (0(x) = 1/2, (1(x) = cos x. . . (n(x) = cos nx, (n+1(x) = sin x, . . . , (2n1(x) = sin(n 1)x are orthogonal on [, ] with respect to w(x) 1.

What kind of interest rate swap ( of liabilities ) would an FI with a positive funding gap utilize to hedge interest rate risk exposure? Question 2 7 options: 1 ) Swap floating - rate payments for...

1 2 -2 Find the value(s) of k for which A = 3 -1 1 is invertible. -2 k 1 A. all values of k B. all k #0 C. k = 1 only D. all k #6 E. all k 1