Once a spreadsheet is set up correctly in Excel®, values can be modified at any time, and the electronic spreadsheet will automatically update itself. Students will create a spreadsheet of computer equipment for a small fictional business where they are the owner. They will include the cost of all hardware and software needed for their employees, and calculate a monthly budget for the equipment.
Scenario: Imagine you are the owner of a small internet business where you employ five people. You need to budget for the cost of hardware and software needed to run company operations. Each employee is required to work both in the office and remotely, and needs access to company data at all times.
Choose the hardware and software that will provide your employees with the ability to stay connected to internal company data, communicate and collaborate with coworkers, and process data and sales information using wording, processing, and spreadsheet software applications.
Create a business budget sheet using Microsoft® Excel®. In the budget sheet, do the following:
The Budget sheet answers should include 1,400 words.
Note: this assignment only requires that you submit an Excel® Workbook file. There are no written or APA guideline requirements.
Budget Item Spotlight Business Analysts Consultancy Firm BudgetEmployeesSharedLizEdnaEliudJane Hardware RequirementLenovo Ideapad laptopWifi-Router$Office ChairsOffice tablesModem(Arris…