Prepare an annual budget in an excel spreadsheet

Assignment Help Basic Computer Science
Reference no: EM131050

Assignment Task:

Prepare working solutions in Excel that will manage the annual budget, current month's inventory, and a list of the current month's transactions for a company of your choosing. Your solutions could use formulas as well as functions specifically demonstrating use of "sum", "if", and "vlookup". You must also show appropriate use of filtering, sorting, referencing, and formatting where appropriate.

Appropriate use of both formulas and functions such as "sum", "if", and "vlookup" should be displayed. Absolute, relative, and mixed referencing as well as filtering, sorting, and formatting should also be used where appropriate. Charts and graphs should be used to provide visual representation of the data, where appropriate.

Budget:

Prepare an annual budget in an Excel spreadsheet for the company that details projected expenses and income for the year. The expenses should include: salaries/staff, rent/lease, telephone/internet, business rates, loans, gas, electricity, water, insurance, and stock items. The projected income, taxes, and profit as well as average, minimum, and maximum expenses for the year should also be displayed using functions and formulas.

Inventory:

 The inventory spreadsheet should display a detailed list of items offered by the company and should monitor the number of items left in stock for the current month. It should also include the "sum" function as well as two other appropriate functions.

Transactions:

 The transactions spreadsheet should provide a detailed display of the current month's transactions or sales carried out for the company. It should also include the "sum" function as well as two other appropriate functions.

Reference no: EM131050

Questions Cloud

Determine the critical path : Determine the critical path and the expected project completion time
International finance problem : International Finance Problem
Write a theoretical perspective for dissertation research : Write a Theoretical Perspective for your en visioned dissertation research.
Advanced stress analysis : Advanced Stress Analysis
Prepare an annual budget in an excel spreadsheet : Prepare working solutions in Excel that will manage the annual budget
Calculate consolidated net income : Calculate consolidated net income and identify the amount attributable to shareholders
Draw the production possibility curve : Draw the production possibility curve and a. Define consumer surplus and producer surplus.
How a transformer works : How a transformer works and apply those rules to a transformer where the primary core cross-sectional area is twice.
Evaluate lim sup ek : Evaluate lim sup Ek

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd