Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2015, 11:10 AM
Project_Newb Project_Newb is offline Major Project Guidance Windows 7 32bit Major Project Guidance Office 2010 32bit
Novice
Major Project Guidance
 
Join Date: Mar 2015
Posts: 1
Project_Newb is on a distinguished road
Default Major Project Guidance

I’ve recently needed to manage several programs and I’m trying to see if there is a good way to do it in MS Project. I’ve played around with Project and taken basic tutorial classes, but I’m not sure if there are “best practices” or techniques that will solve my problem. Or maybe I’m expecting too much. But anyways, here is what I’d like to attempt.

First task:
Let’s assume I’m in the business of making phones – lots of different types. Duration is takes to make a phone is set – 4 weeks. Throwing more resources to it does not change, as there are set equipment limitations. Also, I would use a 24-hour calendar (not standard). However, I can make up to 4 phones in the 4 weeks, as the equipment use is not 100% the entire 4 weeks. Additionally, let's say I have 4 types of equipment with different max usage available (i.e. 80, 80, 60, 50)



I’d like to stagger productions of a new types of phone every couple weeks. As I schedule the phone productions, what is the best way to see when equipment is available for use (to stagger productions) or when something is overused in a given time.

Second task:
Next – I have pre-determined timeframes for phone production. So I want to plan it out in Project (I think this is baseline?) But of course, not everything goes to plan and sometimes the production is delayed a week. What is the best way of visual when and how often I miss deadlines?

Third task:
This involved forecasting. Assuming I’ve gotten tasks 1 and 2 covered, I should hopefully have an understanding of resource utilization and be able to maximize production by using my equipment more efficiently. With that said, if I wanted to increase my phone production for the following year, I want to be able to somehow project how much more equipment I’ll need.

I know this is complicated and a lot of work, and problem seems stupid because I need to be told everything step by step. But I’ve been wracking my brains for a couple weeks trying to sort this out and I haven’t had much success. I’ve debated somehow using Excel, but I think that’s even more inefficient for what I’m trying to achieve. Hopefully someone can provide guidance, minimal or not, it would be greatly appreciated!
Reply With Quote
  #2  
Old 03-26-2015, 11:40 AM
JulieS JulieS is offline Major Project Guidance Windows 7 64bit Major Project Guidance Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Quote:
First task:
Let’s assume I’m in the business of making phones – lots of different types. Duration is takes to make a phone is set – 4 weeks. Throwing more resources to it does not change, as there are set equipment limitations. Also, I would use a 24-hour calendar (not standard). However, I can make up to 4 phones in the 4 weeks, as the equipment use is not 100% the entire 4 weeks. Additionally, let's say I have 4 types of equipment with different max usage available (i.e. 80, 80, 60, 50)

I’d like to stagger productions of a new types of phone every couple weeks. As I schedule the phone productions, what is the best way to see when equipment is available for use (to stagger productions) or when something is overused in a given time.
You can certainly assign the 24 hours calendar either to the project (Project Information) or if you have a mixture of human and machine resources, set the 24 hours calendar as the base calendar for the machines and keep the human resources' calendar to the standard.

When you say the equipment is not used 100% for the tasks - you can certainly assign different assignment units to each task and resource pairing. You can also set different max units on the Resource Sheet View.

To see what else resources can do, look at the Resource Usage view and add the Remaining Availability field to the right hand side. If a resource is assigned at about its max units, the resource name will appear in red and the hours will appear red in the right hand side.

Quote:
Second task:
Next – I have pre-determined timeframes for phone production. So I want to plan it out in Project (I think this is baseline?) But of course, not everything goes to plan and sometimes the production is delayed a week. What is the best way of visual when and how often I miss deadlines?
Project will calculate variance for you by comparing baseline (start, finish, work, duration, cost) against actuals. You also can create deadlines in Project. They are not the same thing, however.

Quote:
Third task:
This involved forecasting. Assuming I’ve gotten tasks 1 and 2 covered, I should hopefully have an understanding of resource utilization and be able to maximize production by using my equipment more efficiently. With that said, if I wanted to increase my phone production for the following year, I want to be able to somehow project how much more equipment I’ll need.
You should be able to see overall resource utilization and help you tell when there are down periods in the cycle.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Guidance recreating a 28 page document 20GT Word 22 11-10-2014 01:35 AM
Major Project Guidance Need guidance on creating a Word doc generator mikeman Word VBA 1 10-26-2014 10:35 PM
Major Project Guidance Need guidance on creating special use table bookbean Word Tables 3 02-06-2013 04:55 PM
Need guidance with formatting pewe Word 4 11-22-2011 11:56 AM
Outlook Major issue Epic7 Outlook 0 03-31-2011 10:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft