test 1

docx

School

La Trobe University *

*We aren’t endorsed by this school

Course

361

Subject

Business

Date

Nov 24, 2024

Type

docx

Pages

Uploaded by Sayitsnow

Enterprise Resources Student ID Reference: Concepts in enterprise resource planning by Monk & Wagner Multi-dimensional Reporting With PivotTables by Paul Hawkin 1 Tutorial 5 In-Class Assessment ERP Concepts and Implementation (Total: 20 Marks/4 = 5%) Part A. Fill in the Blanks (Questions 1 to 10) (10 marks) 1. _marketing and sales, supply chain management, accounting and finance, human resources, business functions ________________ are activities specific to that functional area of operation. 2. ____sales forecast ___________ are estimates of future product demand, which is the amount of a product customers will want to buy. 3. ___Raw data______________ are simply numbers collected from sales, manufacturing, and other operations—without any manipulation, calculation, or arrangement for presentation. 4. _____safety stock____________ can result in an overinvestment in inventory. 5. A(n) ___return of investment______________ is an assessment of an investment project’s value, calculated by dividing the value of the project’s benefits by the project’s costs. 6. The ___work flow______________ module is a set of tools that can be used to automate any of the activities in SAP ERP. 7. The term ___integrated information system______________ is used to describe the best, most efficient way of handling a certain business process. 8. _____ERP software ____________ integrates business functional areas with one another. 9. ____data mining_____________ is the statistical and logical analysis of large sets of

transaction data, looking for patterns that can aid decision making and improve customer sales and service. 10. Marketing and campaign planning includes task scheduling, resource allocation, and ___budgeting______________. Enterprise Resources Student ID: Reference: Concepts in enterprise resource planning by Monk & Wagner Multi-dimensional Reporting With PivotTables by Paul Hawkin 2 Part B. ERP Reporting Techniques Using Excel Pivot Tables (Questions a to f) (10 marks) Multi-dimensional Reporting With PivotTables Answer the following questions from the data. a. Which Material sold the most in terms of Quantity? (2 marks)  Conception Palermo Q= 8062 b. How many 7 Gear bikes were sold in June 2007? (1 mark)  820 c. How many 7 Gear bikes were sold in June 2007 in Berlin? (1 mark)  158 d. Which material provided the most revenue in Sydney? (2 marks)  4314639.06 e. What is the total sales revenue for Sydney? (2 marks)  30000063.91 f. What is the total wholesale quantity? (2 marks)  81683

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

What are the factors impacting Digital transformation in fast food industries in Egypt (1).docx

BSBTWK301 Use inclusive work practices task 2.docx

Tesla company market analysis.edited.docx

Guide for PSKC CW2 (1) (2).docx

Learning_Team_Agreement.docx

Reflection Exercise 2.edited.docx

HW2.pdf

BSBMKG501 Assessment 2-13.pdf

spanish 2 assignment 236.docx

Digital transformation of zoom.edited.docx

2.-Practica-1-costos-estimados-ordenes-de-produccion-1.pdf

BUSINESS ANALYTICS.docx

Recommended textbooks for you

BUSN 11 Introduction to Business Student Edition

Business

ISBN:9781337407137

Author:Kelly

Publisher:Cengage Learning

Essentials of Business Communication (MindTap Cou...

Business

ISBN:9781337386494

Author:Mary Ellen Guffey, Dana Loewy

Publisher:Cengage Learning

Accounting Information Systems (14th Edition)

Business

ISBN:9780134474021

Author:Marshall B. Romney, Paul J. Steinbart

Publisher:PEARSON

Introduction to Business

Business

ISBN:9781947172548

Author:OpenStax

Publisher:OpenStax College

International Business: Competing in the Global M...

Business

ISBN:9781259929441

Author:Charles W. L. Hill Dr, G. Tomas M. Hult

Publisher:McGraw-Hill Education

Bcom

Business

ISBN:9780357026595

Author:LEHMAN, Carol M.

Publisher:Cengage Learning,

SEE MORE TEXTBOOKS

Recommended textbooks for you

BUSN 11 Introduction to Business Student Edition
Business
ISBN:9781337407137
Author:Kelly
Publisher:Cengage Learning
Essentials of Business Communication (MindTap Cou...
Business
ISBN:9781337386494
Author:Mary Ellen Guffey, Dana Loewy
Publisher:Cengage Learning
Accounting Information Systems (14th Edition)
Business
ISBN:9780134474021
Author:Marshall B. Romney, Paul J. Steinbart
Publisher:PEARSON
Introduction to Business
Business
ISBN:9781947172548
Author:OpenStax
Publisher:OpenStax College
International Business: Competing in the Global M...
Business
ISBN:9781259929441
Author:Charles W. L. Hill Dr, G. Tomas M. Hult
Publisher:McGraw-Hill Education
Bcom
Business
ISBN:9780357026595
Author:LEHMAN, Carol M.
Publisher:Cengage Learning,