



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A detailed breakdown of budget allocations and expenses for various categories, teams, and operations during July 2020. It includes spending on people, infrastructure, travel & entertainment, and IT distributions, as well as sales data and product information. The document also includes calculations for total spending, average spending, maximum spending, and minimum spending.
What you will learn
Typology: Exercises
1 / 7
This page cannot be seen from the preview
Don't miss anything!
Team Category Type Line Item Fiscal Month Operations People Infrastructure WW IT Distributions July 2020 Marketing People Infrastructure WW IT Distributions July 2020 Marketing Shared Operations Allocated Azure Compute July 2020 Engineering People Infrastructure WW IT Distributions July 2020 Engineering Shared Operations Allocated Azure Storage July 2020 Engineering Shared Operations Allocated Azure July 2020 Sales People Infrastructure WW IT Distributions July 2020 General ManaShared Operations Allocated Azure Compute July 2020 Satellite OperaShared Operations Allocated Azure Compute July 2020 Operations People Other People Travel & Entertainment July 2020 Marketing People Other People Travel & Entertainment July 2020 Sales People Other People Travel & Entertainment July 2020 Support People Other People Travel & Entertainment July 2020 Hardware People Other People Travel & Entertainment July 2020 IT People Other People Travel & Entertainment July 2020 Question 1: What is the total spending in July 2020? Question 2: What is the average spending in July 2020? Question 3: What is the maximum spending in July 2020? Question 4: What is the minimum spending in July 2020? Question 5: What is the average between the maximum and the minimum?
Value 1 Value 2 Value 3 Value 4 Value 5 Result 1 2 3 4 5 7 1 9 9 6 5 4 6 2 3 2 7 5 2 7 0 4 5 2 3 -5 6 5 A B C 5 4 2 3 8 9 5 1 6 6 9 -4 -2 6 -5 2 1/2 5 3/4 1/2 10 Fill in Result column by multiplying all values.
Category Product Area Retail Price in $ Sale in $ Hardware Keyboard California 20 2500 Hardware Mouse Tennesse 15 3000 Software Mother-board New York 100 12000 Software CPU Ohio 700 70000 Hardware Cables Utah 70 3000 Hardware Monitor Colarado 500 5000 Product Sale in $ Keyboard 2500 Cables CPU Monitor Mouse Mother-board Fill in Sale in $ column based on the first table.