75|EXCEL – Audit Schedule Solver

[Nicole_Humpherys]

Here are my answers to the challenge. Class credit for 09/18/23.
EXCEL – Audit Schedule Solver.xlsx (11.9 KB)

[Ella_Wilson]

Challenge75_Data.xlsx (11.6 KB)

[Izaac_McCann]

Challenge75_Data.xlsx (14.7 KB)

[Mason_Ethington]

A bit lengthy and inefficient with all the parameters but it does the trick.

[Sabrina_Gooch]

[Kyle_Scott]

Here’s my solution – much easier than solving by hand.

[Parker_Clegg]

Challenge75_Data_Parker.xlsx (11.6 KB)

[Jacob_Farnsworth]

Here is my solution! It was a great refresher.

[Abbie_Nielson]

Challenge75_Data_AbbieNielson.xlsx (14.7 KB)

[Randee_Skidmore]

Here is my solution.

0606_Skidmore_TrainingTechHubHomeworkFile.xlsx (20.0 KB)

[Camilla_Farnsworth]

Here is my solution!

[Patrick_Hayden]

Thanks for the fun challenge it was a great way to brush up on my Solver skillz!

[alexpeek]

Here are two photos from my attempt. You’ll see that I added a few more parameters than it seems was needed. Though I got the correct answer in minimizing the cost of the audit, I did not optimize the Solver tool and related parameters. I’m excited to keep playing around in Solver and get better at using it!

[Sydney_Livingston]

Challenge75_Data.xlsx (18.5 KB)

[Christina_Goodin]

Hi! This is how I solved it using the formulas of sum product and sum!

[Presleigh_Thomas]

This is my solution using solver and my IS 201 knowledge!

[cccarlyyy]

This is what I got!

[Gabby_Wilson]

Challenge75_Data_GabbyWilson.xlsx (15.2 KB)
Here’s my solution! This was a great refresh on Solver.

[Sam_Garrison]

Here’s my solution in Excel:
Challenge75_Data.xlsx (11.6 KB)

[Kaleb_Jensen]

Here’s my solution! Thanks for the refresher!