Business 121 - Managerial Accounting

Excel Assignment

Fall 2020

100 points

Due Date: December 6, 2020

This assignment is not optional. You must successfully complete it to

pass the course. In other words, even though you may have a passing

percentage in the class, without the Excel assignment you will receive an

F for the course.

Part 1:

Prepare Problem 7-4B using Excel (30 points):

(

NOTE: if you do not have access to Excel, please complete in Google Sheets and "save

as" an Excel sheet - let me know if you have questions on this process)

If you are not familiar with Excel or you need a refresher, go to

http://people.usd.edu/~bwjames/tut/excel/

for a tutorial.

Wherever possible, use cell references when you are building your

spreadsheets. This includes using them in your formulas as well.

Not doing so will cost you points.

Typing computational results in the cells is not acceptable and will

result in zero points.

Part 2:

Answer the following questions using Word (5 points each):

1.

Would the manager of an Nabar Manufacturing retail store

participate more in budgeting than a manager at the

corporate offices? Explain.

2.

Would the manager of a local Nabar Manufacturing retail

store participate in long-term budgeting? Explain.

3.

Why should each department participate in preparing its

own budget? Identify three separate departments that would

have participated in preparing Nabar Manufacturing's

budgets. Be sure to include which budget for which

department.

4.

How does budgeting help management coordinate and plan

business activities? Use three specific examples from the

budgets you prepared for Nabar Manufacturing