Background: You are the assistant project manager to Rass.s$.$ Brown, who is in charge of a project called "Nightingale". The goal of this project is to develop a handheld electronic medical reference guide. Nightingale will be designed for emergency medical technicians and paramedics who need a quick reference guide to use in emergency

situations. Rassy and her project team developed a project plan aimed at producing $30$ working units in time for MedCON, the biggest medical equipment trade show each year. Meeting the MedCON September $24,2026$ deadline is critical to success. They plan to start the project on January $5,2026.$ All the major medical equipment manufacturers take orders for new products at MedCON. Rass.sy has heard rumors that several competitors are considering developing a similar product, and she knows that being first to market would have a significant sales advantage. Besides, top management made funding contingent upon developing a workable plan for meeting the MedCON deadline. They also made it clear that they would not compromise on product features, as the competition would surely be putting out a robust and high quality product.

Respond to the following, making sure to USE THE SCREENSHOT OF EXCEL TEMPLATE PROVIDED IN THIS QUESTION:

A$.)$ Estimating Duration

Respond to the following in your Excel file on the worksheet titled Task A:

The company decided to outsource the software development portion of the project $($not depicted in the Projectlijbre file$)$ to a company called Champion Software $($CS$),$ with a goal of having it finished at least one month before the rest of the project. Rass.ey asks you to work with the project lead from CS to create an estimate of the amount of time it will take them to complete the software.

USE THE COMPLEXITY WEIGHTING SCHEME $\backslash$& THE TABLE $2$: TOTAL FUNCTION POINT COUNT, AS BOTH PROVIDED IN THIS QUESTION to estimate the total function point count for their portion of the project.

For the purpose of this question, assume that the software project is expected to follow the U$.$S$.$ average of one person working one month can generate on average about five function points.

B$.)$ Respond to the following in your Excel file on the worksheet titled Task B:

Top management would like a traditional AON project network showing the estimated amount of days it will take to get to the end of the "Document design" activity in the Nightingale project. Create an AON project network up to and including the "Document design" activity $($do not include the activities that follow "Document design"$).$ Follow these specifications:

$-$ Move the boxes around as needed $($the boxes have been created for you in the Excel template$).$

$-$ Show all task dependencies with arrows.

$-$ Include values for ES$,$ EF$,$ DUR, SL$,$ LS$,$ and LF for each activity.

$-$ For the IDs, use the row numbers from the Projectulibre file.

$-$ Clearly indicate which tasks are along the critical path. You may either highlight the boxes or change the weight on the arrows so they are visibly different.

$-$ Set the late finish for the "Document design" activity equal to its early finish.

ATTACHED IN THIS QUESTION IS THE SCREENSHOTS OF THE EXCEL TEMPLATES TOTAL FUNCTION POINT COUNT:

$\backslash$begin$\{$tabular$\}\{$l$|$l$|$l$\}$

$\backslash$hline $\backslash$multicolumn$\{3\}\{$l$\}\{$ Table $2$: Function Point Complexity Weight Table $\}\backslash \backslash$

$\backslash$hline Number of inputs & $25$ & Rated complexity high $\backslash \backslash$

$\backslash$hline Number of outputs & $15$ & Rated complexity average $\backslash \backslash$

$\backslash$hline Number of inquiries & $12$ & Rated complexity high $\backslash \backslash$

$\backslash$hline Number of files & $8$ & Rated complexity average $\backslash \backslash$

$\backslash$hline Number of interfaces & $10$ & Rated complexity low $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$ COMPLEXITY WEIGHTING SCHEME:$|\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$l$|\}\{$D$56\}$ & & $\backslash ($ f x $\backslash )$ & $\backslash \backslash$

$\backslash$hline & A & B & C & D $\backslash \backslash$

$\backslash$hline $1$ & Key & & & $\backslash \backslash$

$\backslash$hline $2$ & ES & ID & EF & $\backslash \backslash$

$\backslash$hline $3$ & SL & Key & & $\backslash \backslash$

$\backslash$hline $4$ & LS & DUR & LF & $\backslash \backslash$

$\backslash$hline $5$ & & & & $\backslash \backslash$

$\backslash$hline $6$ & & & & $\backslash \backslash$

$\backslash$hline $7$ & & & & $\backslash \backslash$

$\backslash$hline $8$ & & & & $\backslash \backslash$

$\backslash$hline $9$ & & & & $\backslash \backslash$

$\backslash$hline $10$ & & Arch deci & & $\backslash \backslash$

$\backslash$hline $11$ & & & & $\backslash \backslash$

$\backslash$hline $12$ & & & & $\backslash \backslash$

$\backslash$hline $13$ & & & & $\backslash \backslash$

$\backslash$hline $14$ & & Internal s & & $\backslash \backslash$

$\backslash$hline $15$ & & & & $\backslash \backslash$

$\backslash$hline $16$ & & & & $\backslash \backslash$

$\backslash$hline $17$ & & & & $\backslash \backslash$

$\backslash$hline $18$ & & External s & & $\backslash \backslash$

$\backslash$hline $19$ & & & & $\backslash \backslash$

$\backslash$hline $20$ & & & & $\backslash \backslash$

$\backslash$hline $21$ & & & & $\backslash \backslash$

$\backslash$hline $22$ & & Feature s & & $\backslash \backslash$

$\backslash$hline $23$ & & & & $\backslash \backslash$

$\backslash$hline $24$ & & & & $\backslash \backslash$

$\backslash$hline $25$ & & & & $\backslash \backslash$

$\backslash$hline $26$ & & Case & & $\backslash \backslash$

$\backslash$hline $27$ & & & & $\backslash \backslash$

$\backslash$hline $28$ & & & & $\backslash \backslash$

$\backslash$hline $29$ & & & & $\backslash \backslash$

$\backslash$hline $30$ & & Screen & & $\backslash \backslash$

$\backslash$hline $31$ & & & & $\backslash \backslash$

$\backslash$hline $32$ & & & & $\backslash \backslash$

$\backslash$hline $33$ & & & & $\backslash \backslash$

$\backslash$hline $34$ & & Speaker o & jacks & $\backslash \backslash$

$\backslash$hline $35$ & & & & $\backslash \backslash$

$\backslash$hline $36$ & & & & $\backslash \backslash$

$\backslash$hline $37$ & & & & $\backslash \backslash$

$\backslash$hline $38$ & & Micropho & und & $\backslash \backslash$

$\backslash$hline $39$ & & & & $\backslash \backslash$

$\backslash$hline $40$ & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$