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

For this discussion use the pest and porter 5-forces model

For this discussion, use the PEST and Porter 5-Forces Model to respond to the following: Identify environmental and industry influences that should be a concern or present an opportunity to Ford Motor Company. Provide a ...

Given that all ascii codes are less than 128 design an

Given that all ascii codes are less than 128, design an algorithm that reads a given set of data and decides whether or not it may contain decimal data.

1 what is the length of the value field in the following

1. What is the length of the value field in the following BER encoding? 04 09 48 65 6C 4C ... 2. Distinguish between SMI and MIB. 3. What does the if object in MIB define? Why does this object need to be managed?

A program is to perform two products one is a vector

A program is to perform two products: one is a vector product of two 100-element vectors and the other is the product produced by multiplying the corresponding elements of a 1000 by 1000 element matrix by a scalar consta ...

Assignmentyou have been recently hired to assist with

Assignment You have been recently hired to assist with purchasing computer forensics tools and resources for a major corporation. Using the concepts that you learned in chapters nine through twelve recommend specific too ...

Powerpoint presentationin this presentation you will

PowerPoint Presentation In this presentation, you will describe the different data types and give examples of each. Conduct a brief research on the Internet about different data types. This research should supplement you ...

1 discuss the future of wireless lans2 what is a wireless

1. Discuss the future of wireless LANs. 2. What is a wireless WAN? What kind of technology can be used in it? Is this the wave of the future? 3. With the future in mind, compare and contrast ATMs and ISDN technologies.

When installing utp cable for a horizotnal link it is very

When installing UTP cable for a horizotnal link, it is very important to minimize crosstalk. Explain what crosstalk is, why crosstalk can be a problem, and how it is minimized when terminating UTP cables.

The ietf internet protocol performance metrics ippm working

The IETF Internet Protocol Performance Metrics (IPPM) working group develops standard metrics that can be applied to the quality, performance, and reliability of a network. How could this group's work help a network desi ...

Write a c function minimum this function is passed a

Write a C++ function minimum. This function is passed a vector parameter and returns the smallest value stored in the array list. Write an additional code fragment to test this function. Include any declarations and init ...

  • 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

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

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

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen