Data File needed for this Case Problem: NP$\_$EX$\_3-4.$xlsx

Canvas Scribe Michael Feinbaum is a production manager for Canvas Scribe, a manufacturer of digital games. To produce and release a quality game requires a team of programmers, animators, writers, and testers. Typically a game will take a year to develop from its initial planning stages to final release. Michael wants to create a production schedule for a new game called Escape from Dunkirk, to be released in time for holiday sales. To create this production schedule, you will use the WORKDAY and NETWORKDAYS functions described in Figure $318$ and in the InSight box, $$Date Calculations with Working Days.$$ Complete the following:

Open the NP$\_$EX$\_3-4.$xlsx workbook located in the Excel$3>$ Case$2$ folder included with your Data Files, and then save the workbook as NP$\_$EX$\_3\_$Schedule in the location specified by your instructor.

In the Documentation sheet, enter your name in cell B$3.$ Use a function to enter the current date in cell B$4.$

In the Production Schedule worksheet, in cell B$4,$ enter $9/12/2021$ as an initial proposed start date for the project.

In cell B$10,$ enter the formula $=$B$4$ to reference the start date you entered in cell B$4.$

$5.$ In cell C$10,$ calculate the date on which the Idea Development phase ends using the WORKDAY function. Use cell B$10$ as the starting date, cell D$10$ as the number of workdays, and the range $H$$10$:$H$$29$ as the reference to the holiday dates.

Use AutoFill to extend the formula in cell C$10$ to the range C$10$:C$28$ but do not extend the formatting.

In cell B$5,$ enter the formula $=$B$28$ to display the date on which the game will be released.

$8.$ In cell B$6,$ use the NETWORKDAYS function to calculate the total number of working days that will be devoted to creating the Escape from Dunkirk game. Use cell B$4$ as the start$\_$date, cell B$5$ as the end$\_$date, and the range $H$$10$:$H$$29$ as the holidays argument.

In cell B$7,$ calculate the total number of calendar days devoted to the project by taking the difference between the release date and the start date.

The game must be released no later than $10/12/2022$ to take advantage of holiday sales. Use Goal Seek to determine the starting date that will meet this goal by entering cell B$5$ in the Set cell box, the date $10/12/2022$ in the To value box, and cell B$4$ in the By changing cell box.

In cell D$4,$ write a summary of your findings in developing this production schedule.

Save the workbook, and then close it$.$