create budget sheet Research hardware and software to satisfy operational requirements

Purpose of Assignment

Electronic spreadsheets are useful tools, especially when creating a business budget. 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.

Assignment Steps


  • Research hardware and software to satisfy operational requirements described above
  • Microsoft Office 365, Office 2016: Introductory: Module 1: Creating a Worksheet and a Chart
  • Microsoft Office 365, Office 2016: Introductory: Module 2: Formulas, Function, and Formatting

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:

  • List the make and model of desired hardware devices and their cost.
  • List software operating systems and applications for each device and their costs.
  • Sum up the cost for both hardware and software for each employee, and then calculate the average monthly costs to maintain these systems.
  • Insert a graph or chart displaying total costs graphically.
  • Label columns/rows with titles reflecting data they contain.
  • Use no more than two sheets in one workbook to display required data.
  • Format data to highlight important totals.
You can leave a response, or trackback from your own site.


10 Responses to “create budget sheet Research hardware and software to satisfy operational requirements”

  1. 670610 742071I see something actually intriguing about your web website so I saved to bookmarks . 155157

  2. 59009 651909Merely wanna state that this really is really helpful , Thanks for taking your time to write this. 679070

  3. 457283 71964I was just searching for this information for some time. After 6 hours of continuous Googleing, finally I got it in your website. 711441

  4. 960883 685644I conceive this web site has got some real great information for everyone : D. 335618

  5. 580127 717401Hiya! Great weblog! I happen to be a everyday visitor to your site (somewhat much more like addict ) of this internet site. Just wanted to say I appreciate your blogs and am seeking forward for more! 477000

  6. Firearms USA says:

    94746 537937Respect to post author, some fantastic information . 870683

  7. 180435 988880I saw two other comparable posts although yours was the most beneficial so a whole lot 792518

  8. 3D printing says:

    415000 575570Beneficial info and excellent design you got here! I want to thank you for sharing your tips and putting the time into the stuff you publish! Fantastic function! 729837

  9. 249117 660213Echt tolle Seite. Rubbish bin eigentlich nur per Zufall hier gelandet, aber ich bin jetzt schon complete von der tremendous Seite beeindruckt. Gratuliere dazu!! Viel Erfolg noch durch der sehr guten Home-page mein Freund. 172280

  10. 393965 462485This is going to be an excellent site, might you be interested in doing an interview about how you developed it? If so e-mail me! 393568

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes