Calculate the total expenditure for each of the categories

Assignment Help Database Management System

Reference no: EM13780478

The data in the table on the data sheet contains the operational expenditure and the budget for a small department. Use the data set on the Data-sheet and do the following:

(1) Format the title by using the Font and Alignment groups on the ribbon.

(2) Change the column widths so that all the data is visisble.

(3) Change the heading of Row 9 to Office Sundry.

(4) Calculate the total expenditure (in column I) for each of the categories.

(5) Calculate the balance left/overspent in column J.

(6) Repeat (4) and (5) for all the categories.

(7) Change the formatting of the amounts so that two decimal digits show.

(8) Calculate the total budget in row 11.

(9) Use this formula to calculate the total expenditure for each month.

(10) Enhance the spreadsheet by adding borders.

(11) Use 'Conditional formatting' to indicate overspending.

(12) Insert a staked bar chart to indicate the monthly expenditure for each of the categories.

(13) Place the legend at the bottom of the graph.

(14) Add data labels.

(15) Do not display the decimals in the data labels

(16) Remove those data labels where the amount is 0.

(17) Add a chart title.

(18) Insert a callout to highlight the overspending in Training.

(19) Change the colour of the callout to Red.

(20) Copy the callout to Printing.

Submit your completed assignment on eFundi.

Department A- Operational Costs

	Budget	January	February	March	April	May	June
Stationary	6000.00	1349.18	245.67	135.80	3050.00	854.30	62.90	11697.85	6697.85
Telephone	7200.00	1150.00	1034.90	1237.00	853.20	954.70	638.54	13068.34	5868.34
Printing	4800.00	230.00	1584.00	1623.30	135.00	1350.00	1693.20	11415.50	6615.50
Travel	12000.00	353.00	458.90	568.00	226.00	648.00	587.30	14841.20	2841.10
Office Sundry	2500.00	201.80	1024.00	268.70	352.00	411.00	824.00	5581.50	3081.50
Training	12000.00	0.00	0.00	6700.00	0.00	6300.00	0.00	25000.00	13000.00
Refreshments	3000.00	35.80	506.80	381.54	145.90	532.00	600.00	5202.04	2202.04
	47500.00

2173_OPERATIONAL COSTS DATA TABLE.png OPERATIONAL COSTS DATA TABLE

Reference no: EM13780478

Questions Cloud

What is the optimal stocking level : Henrique's Correa's bakery prepares all its cakes between 4am and 6am so they will be fresh when customers arrive. Day-old cakes are virtually always sold but at a 50% discount off the regular $16 price. The cost of baking a cake is $10 and demand is..

Describe how the disease is spread : How would you suggest treating patient - describe how the disease is spread - What is the most likely diagnosis and answer the questions.

What additional annual cost is the shop incurring by staying : Garden Variety Flower Shop uses 830 clay pots a month. The pots are purchased at $3.40 each. Annual carrying costs per pot are estimated to be 10 percent of cost, and ordering costs are $10 per order. The manager has been using an order size of 2,000..

What percentage of all violent crimes was not reported : According to the 2011 national crime victimization survey, approximately what percentage of all violent crimes was not reported to the police by victims

Calculate the total expenditure for each of the categories : The data in the table on the data sheet contains the operational expenditure and the budget for a small department.

Underlie policymaking in the united states : In this assignment, you will examine the ideological struggles that underlie policymaking in the United States. This includes the following:

Examine philosophical underpinnings of economic system : In this assignment, you must examine the philosophical underpinnings of the economic system and its relationship to ethics and social justice by examining income support policies.

Review information on core measure set from joint commission : review the information on the Core Measure Sets from The Joint Commission. Pick one of the core measures from the list at the bottom of this webpage.

Particular work day to fully satisfy expected demand : A check-in desk at local car repair center has a capacity to serve 35 customers per work day. If the check-in desk had to utilize 60% of its capacity during a particular work day to fully satisfy expected demand, how much of a capacity cushion did th..

User Account

All Pages