Ask Question, Ask an Expert


Ask Computer Engineering Expert

You are needed to develop working solutions in Excel which 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 must use formulas and also functions specifically demonstrating use of “sum”, “if”, and “vlookup”. You should as well demonstrate appropriate use of filtering, sorting, referencing and formatting where suitable.

The solution must illustrate the following:

Correct use of both formulas and functions such as “sum”, “if”, and “vlookup” must be displayed. Absolute, relative, and mixed referencing and also filtering, sorting and formatting should as well be used where suitable. Charts and graphs must be employed to give visual representation of the data, where suitable.


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


The inventory spreadsheet must display a detailed list of items offered by the company and must monitor the number of items left in stock for the current month. It must as well comprise the “sum” function also as two other suitable functions.


The transactions spreadsheet must provide a detailed display of the current month’s transactions or sales taken out for the company. It must as well comprise the “sum” function and also two other suitable functions.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M984

Have any Question? 

Related Questions in Computer Engineering

Based on the design requirements and decisions that have

Based on the design requirements and decisions that have been made, what wireless access points would you recommend for WVCC? Do some Internet research to find an access point that will meet WVCC's needs and write two or ...

Assignment 1 identify a firm with an it budgeting process

Assignment 1: Identify a firm with an IT budgeting process you are familiar with. Using the material in the text and that from your external research, write a paper in which you re-engineer the firm's budget process. You ...

Given that the internet is a shared network discuss whether

Given that the Internet is a shared network, discuss whether preventing denial of service attacks is inherently possible or not possible. Do systems connected to the Internet violate the principle of least common mechani ...

1 describe the defend strategy list and describe the three

1. Describe the "defend" strategy. List and describe the three common methods. 2. Describe the "transfer" strategy. Describe how outsourcing can be used for this purpose. 3. Describe the "mitigate" strategy. What three p ...

Deterministic and random behavior it is human nature to

Deterministic and random behavior It is human nature to assume that there is a causal force behind everything that we observe, but some times this is not the case. However, even when we have a perfect understanding of a ...

Assignment preparing for a company-wide migration to

Assignment: Preparing for a Company-Wide Migration to Windows 8.1 Crescent Manufacturing Inc. (CMI) is a luxury leader in crafted and customized home furnishings. The corporate headquarters and a production facility are ...

The prolog interpreter as described in this chapter

The PROLOG interpreter, as described in this chapter, performs a prescribed resolution at each step. If all of the statements in a PROLOG program were con-verted to disjunction of literals, describe a control strategy fo ...

Consider the following case studymusicondemand is a new

Consider the following case study. MusicOnDemand is a new subscription-based service for on-demand Internet streaming audio media. There are three types of users for MusicOnDemand: 1. Standard users; 2. Premium users; 3. ...

1 describe all constructors of the savings account class

1. Describe all constructors of the Savings Account class. List all methods that are inherited from the Bank Account class. List all methods that are added to the Savings Account class. 2. Can you convert a superclass re ...

A food processing company makes meatloaf to be sold in the

A food processing company makes meatloaf to be sold in the frozen food section of supermarkets. Each week the recipe used changes based on the current cost of ingredients. Ingredients and current costs are as shown below ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment


Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion


Section onea in an atwood machine suppose two objects of


Part 1you work in hr for a company that operates a factory


Details on advanced accounting paperthis paper is intended


Create a provider database and related reports and queries
