In ACCT $2102,$ you will complete a Manufacturing Budget Project. You will learn many Excel skills by completing the Manufacturing Budget Project, including but not limited to the following:

Assigning range names to input cells.

Exploring the Name Manager feature in Excel.

Crafting formulas to project monthly sales in units

$-$Saving one's work in Excel frequently by way of various methods.

Summing multiple cells at once with the AutoSum feature.

Establishing a table that shows percent of collections received each month.

Contrasting brute$-$force method of allocating collections across $3-$month periods with using SUMIF.

$-$Employing the SUMIF function for looking up amounts in a spreadsheet. Unlike other assignments, this project is submitted through

studentsexcel.com. Because this is an external provider that is not integrated into D$2$L$,$ you will need to carefully follow the video at

studentsexcel.com to ensure that you receive points.

Registration: you will start by registering an account on

studentsexcel.com or using your existing studentsexcel account. You will need to pay $$9\mathrm{.}95$ to purchase the Manufacturing Budget Project.

Completing the project: You will download the assignment from the student portal of studentsexcel and complete it using Excel by following the tutorial that you can find on the portal. Be prepared to spend at a minimum $2-3$ hours on this project.

Submitting the project and grading: The final step is submitting your completed work to the student portal of studentsexcel. Your submitted file will be graded based on the extent to which your work matches the steps in the tutorial.