I have attached a file with details. I would like to get help on assigning resources with no over-allocation on Microsoft Project. there is also a budget and a 28 week deadline for the project to be done.
Class Exrcise Project Team Members Assign the following resources to the project: Task Duration M (hrs) O (hrs) E (hrs) P (hrs) Select and order equipment - 120 240 120 Receive Equipment - - 320 320 Install and set up equipment - 160 480 - Finalize bill of material - 160 80 - Order component parts - 80 80 120 Receive component parts - - 200 200 first production run - 240 480 - Finalize marketing plan 320 160 - - Produce Magazine ads. 320 - - - Script for TV ads. 240 - - - Produce TV ads. 320 - - - Begin ad campaign 480 - - - Ship product to customers - 40 - 80 M: Marketing; O: Operations; E: Engineering; P: Procurement; PM: Project Manager Available Personnel and Percent of time: Marketing: Barrios (100%), Bede (50%), Bello (50%), Chavez (50%) Operations: Cruz (100%), Diaz (50%), Garcia (50%) Engineering:Huerto (100%), Leyva (100%), Martinez (50%), Mirza (50%), Olmos (50%) Procurement:Rodas (100%), Solis (50%) Project Manager TOM The following table shows the annual salary: Team Member Annual salary ($) Barrios 42,000 Bede 44,000 Bello 46,000 Chavez 47,000 Cruz 59,000 Diaz 56,000 Garcia 60,000 Huerto 68,000 Leyva 70,000 Martinez 66,000 Mirza 64,000 Olmos 70,000 Rodas 40,000 Solis 42,000 TOM 150,000 Assign resources and compute the direct resource cost to the project assuming 2,000 working hours per year. Requirements TaskDurationM (hrs)O (hrs)E (hrs)P (hrs)Hrs. per DepartmentTeam MemberAnnual salary ($)Hourly RateOvertimeDepartmentPercent of time AvailableHrs a Day Select and order equipment0120240120480Barrios42,00021.0031.5Marketing (M)100%822.3833.56 Receive Equipment00320320640Bede44,00022.0033Marketing (M)50%4 Install and set up equipment01604800640Bello46,00023.0034.5Marketing (M)50%4 Finalize bill of material0160800240Chavez47,00023.5035.25Marketing (M)50%4 Order component parts08080120280Cruz59,00029.5044.25Operations (O)100%829.1743.75 Receive component parts00200200400Diaz56,00028.0042.00Operations (O)50%4 first production run02404800720Garcia60,00030.0045.00Operations (O)50%4 Finalize marketing plan32016000480Huerto68,00034.0051.00Engineering ('E)100%8 Produce Magazine ads.320000320Leyva70,00035.0052.50Engineering ('E)100%8 Script for TV ads.240000240Martinez66,00033.0049.50Engineering ('E)50%4 Produce TV ads.320000320Mirza64,00032.0048.00Engineering ('E)50%4 Begin ad campaign480000480Olmos70,00035.0052.50Engineering ('E)50%433.8050.70 Ship product to customers040080120Rodas40,00020.0030.00Procurement (P)100%8 Must total Total5360Solis42,00021.0031.50Procurement (P)50%420.5030.75 TOM150,00075.00112.50 Project overhead cost/ day1000 Min. Hrs. in a Day4 Max. Hrs. in a Day10 Max Hrs. in a Year2000 Total Weeks per Year50 Overtime Pay Rate150% Budget Allocation Direct Labor$150,000 Overhead and other expenses$150,000 Constraints Project completion within 28 weeks from start date The goal is to finish a document in microsoft project with the lowest cost. no more than 150000. Activities of the project are on the second sheet Activities and Duration Task ModeTask NameDurationWorkStartFinishPredecessorsResource Names Auto ScheduledProcure Equipment and Setup11 wks0 hrsWed 2/2/22Tue 4/19/22 Manually Scheduled Select and Order Equipment3 wks0 hrsWed 2/2/22Tue 2/22/22 Manually Scheduled Receive Equipment8 wks0 hrsWed 2/23/22Tue 4/19/222 Manually Scheduled Install and Setup Equipment4 wks0 hrsWed 2/23/22Tue 3/22/222 Auto ScheduledProcure Component Parts7 wks0 hrsWed 3/23/22Tue 5/10/22 Manually Scheduled Finalize Bill of Materials2 wks0 hrsWed 4/20/22Tue 5/3/223 Manually Scheduled Order Component Parts2 wks0 hrsWed 3/23/22Tue 4/5/224 Manually Scheduled Receive Component Parts5 wks0 hrsWed 4/6/22Tue 5/10/227 Manually ScheduledFirst Production Run6 wks0 hrsWed 5/11/22Tue 6/21/226,8 Manually ScheduledFinalize Marketing Plan4 wks0 hrsWed 2/2/22Tue 3/1/22 Manually ScheduledProduce Magazine Ads4 wks0 hrsWed 3/2/22Tue 3/29/2210 Manually ScheduledScript for TV Ads3 wks0 hrsWed 3/2/22Tue 3/22/2210 Manually ScheduledProduce TV Ads4 wks0 hrsWed 3/23/22Tue 4/19/2212 Manually ScheduledBegin and Campaing6 wks0 hrsWed 4/20/22Tue 5/31/2211,13 Manually ScheduledShip Product to Customers1 wk0 hrsWed 6/22/22Tue 6/28/229,14 Requirements TaskDurationM (hrs)O (hrs)E (hrs)P (hrs)Hrs. per DepartmentTeam MemberAnnual salary ($)Hourly RateOvertimeDepartmentPercent of time AvailableHrs a Day Select and order equipment0120240120480Barrios42,00021.0031.5Marketing (M)100%822.3833.56 Receive Equipment00320320640Bede44,00022.0033Marketing (M)50%4 Install and set up equipment01604800640Bello46,00023.0034.5Marketing (M)50%4 Finalize bill of material0160800240Chavez47,00023.5035.25Marketing (M)50%4 Order component parts08080120280Cruz59,00029.5044.25Operations (O)100%829.1743.75 Receive component parts00200200400Diaz56,00028.0042.00Operations (O)50%4 first production run02404800720Garcia60,00030.0045.00Operations (O)50%4 Finalize marketing plan32016000480Huerto68,00034.0051.00Engineering ('E)100%8 Produce Magazine ads.320000320Leyva70,00035.0052.50Engineering ('E)100%8 Script for TV ads.240000240Martinez66,00033.0049.50Engineering ('E)50%4 Produce TV ads.320000320Mirza64,00032.0048.00Engineering ('E)50%4 Begin ad campaign480000480Olmos70,00035.0052.50Engineering ('E)50%433.8050.70 Ship product to customers040080120Rodas40,00020.0030.00Procurement (P)100%8 Must total Total5360Solis42,00021.0031.50Procurement (P)50%420.5030.75 TOM150,00075.00112.50 Project overhead cost/ day1000 Min. Hrs. in a Day4 Max. Hrs. in a Day10 Max Hrs. in a Year2000 Total Weeks per Year50 Overtime Pay Rate150% Budget Allocation Direct Labor$150,000 Overhead and other expenses$150,000 Constraints Project completion within 28 weeks from start date The goal is to finish a document in microsoft project with the lowest cost. no more than 150000. Activities of the project are on the second sheet Activities and Duration Task ModeTask NameDurationWorkStartFinishPredecessorsResource Names Auto ScheduledProcure Equipment and Setup11 wks0 hrsWed 2/2/22Tue 4/19/22 Manually Scheduled Select and Order Equipment3 wks0 hrsWed 2/2/22Tue 2/22/22 Manually Scheduled Receive Equipment8 wks0 hrsWed 2/23/22Tue 4/19/222 Manually Scheduled Install and Setup Equipment4 wks0 hrsWed 2/23/22Tue 3/22/222 Auto ScheduledProcure Component Parts7 wks0 hrsWed 3/23/22Tue 5/10/22 Manually Scheduled Finalize Bill of Materials2 wks0 hrsWed 4/20/22Tue 5/3/223 Manually Scheduled Order Component Parts2 wks0 hrsWed 3/23/22Tue 4/5/224 Manually Scheduled Receive Component Parts5 wks0 hrsWed 4/6/22Tue 5/10/227 Manually ScheduledFirst Production Run6 wks0 hrsWed 5/11/22Tue 6/21/226,8 Manually ScheduledFinalize Marketing Plan4 wks0 hrsWed 2/2/22Tue 3/1/22 Manually ScheduledProduce Magazine Ads4 wks0 hrsWed 3/2/22Tue 3/29/2210 Manually ScheduledScript for TV Ads3 wks0 hrsWed 3/2/22Tue 3/22/2210 Manually ScheduledProduce TV Ads4 wks0 hrsWed 3/23/22Tue 4/19/2212 Manually ScheduledBegin and Campaing6 wks0 hrsWed 4/20/22Tue 5/31/2211,13 Manually ScheduledShip Product to Customers1 wk0 hrsWed 6/22/22Tue 6/28/229,14