Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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.

Budget:

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.

Inventory:

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.

Transactions:

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

1 rewrite the computer terms glossary application using the

1. Rewrite the computer terms glossary application using the customdesigned Hash class developed in the chapter. Experiment with different hash functions and collision-resolution strategies. 2. Using the Hashtable class, ...

Read the scenario carefully and then discuss how the

Read the scenario carefully and then discuss how the concepts of confidentiality, integrity, and availability relate to the value of each asset. For example, the school would normally have the student's health records. W ...

1 assume we have created a packet-switched internet using

1. Assume we have created a packet-switched internet. Using the TCP/IP protocol suite, we need to transfer a huge file. What are the advantage and disadvantage of sending large packets? 2. Match the following to one or m ...

Write a menu-driven program that uses your function from

Write a menu-driven program that uses your function from the previous question to extract the sales data and can produce any of the following reports: (a) Each of the four types of reports described in the chapter. (b) T ...

1 how does a planner know when a task has been subdivided

1. How does a planner know when a task has been subdivided to an adequate degree and can be classified as an action step? 2. What is a deliverable? Name two uses for deliverables. 3. What is a resource? What are the two ...

1 please provide a brief answera what are the components of

1. Please provide a brief answer: a. What are the components of a Local Area Network (LAN) and common protocols? b. What are the components of Wireless Local Area Network (WLAN) and common protocols? c. How do they diffe ...

1 how many cycles does it take for all instructions in a

1. How many cycles does it take for all instructions in a single iteration of the above loop to execute? 2. When an instruction in a later iteration of a loop depends upon a data value produced in an earlier iteration of ...

A read hit occurs in way2 of set 17 within an 8-way set

A read hit occurs in way2 of set 17 within an 8-way set associative cache that uses a line size of 128 bytes. The total number of lines in the cache is 32768. The system employs 32-bit addresses and the tag for way2 with ...

Design an algorithm that reads lines of text reformats it

Design an algorithm that reads lines of text, reformats it and writes it out in pages of two columns (each forty characters wide) separated by a 10-space gap. The first column of the output should correspond to the first ...

Case study 2 software system architecture read the case

Case Study 2: Software System Architecture Read the case study titled "A Patient Information System for Mental Health Care", located in Chapter 1 of your textbook. Develop an overall architecture for the system described ...

  • 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