Reference no: EM131038689
ASSIGNMENT: SRKL ELECT RONICS BUSINESS DAT A ANALYSIS
PURPOSE OF THE ASSIGNMENT
The purpose of this assignment is to give you the opportunity to use office automation tools to develop an information system to assist an organisation in this modern business world.
The assignment will test students:
1. Ability to develop Excel spread sheets, and
2. Prepare analysis reports for managers' perusal. At the completion of the assignment students will have:
1. Described basic financial operational data and business processes
2. Acquired skills which will enable them to gain better appreciation of how ICT is employed by users in organisations.
BACKGROUND
SRKL electronics (SRKLE) is a distributor of electrical and electronic goods to 10 small shops in Australia. SRKLE is centrally located in Waterloo, Sydney. The office is above the warehouse. The office is divided into several cubicles from which the administration, sales, service, purchases, and other departments operate. Each department has their own computers and almost all of the business information is stored in Excel Spread Sheets. The way of information exchange generally is by swapping excel spread sheets.
Lalith, the new owner of SRKLE, is very ambitious and wants to increase the number of their customers to 100. You have decided to help Lalith by analysing their business data and provide him with some recommendations. Lalith accepted your offer and supplied you with last years (2014-15) sales spread sheet (SRKLE-salesData.xlsx enclosed with this document). The excel spreadsheet consists of 3 pages; Sales data, sales report, and Questions. Your task is to:
1. Complete the sales page by calculating the total sales, total cost and profit columns.
2. Complete the sales report page and answer the questions in the solution page.
Note that BN105 students have to answer four more questions as noted in the solutions page.
3. Write a professional report addressing Lalith, including
a. Analysis of the questions posed by Lalith in the Excel file.
b. Recommendations to improve the data visibility.
Hint: You may recommend implementation of a new information system, purchasing of additional hardware and software to maintain the existing infrastructure, implementation of new policies, procedures, and employing new personnel. In all, your report needs to be a technical document not one strategizing "How to improve sales?" . Refer to lectures 7 and 8 for some helpful information.
Attachment:- SRKLE-Sales-2015.xlsx
|
What backs the money supply in the united states
: What "backs" the money supply in the United States? What determines the value (domestic purchasing power) of money? How does the purchasing power of money relate to the price level? Who in the United States is responsible for maintaining money's p..
|
|
Write ten reaction pages paper about the movie even the rain
: Watch the movie called "Even the Rain" then write 10 reaction pages paper about the movie. I want strong theises that reflect your paper. Focus on the them and what a the problems and what are the solution.
|
|
Discussing problems of plagiarism associated with this kind
: Purpose: Craft a logical, well-organized argumentative essay in support of a clear position which is supported by secondary sources that are accurately cited and quoted.
|
|
Determine the firm profit function
: Determine the firm's profit function and the level of output at which Firm Perfcomp should produce in order to maximize profits. Confirm that this quantity represents maximum profits for the firm by using the second-order condition.
|
|
Prepare analysis reports for managers perusal
: Prepare analysis reports for managers' perusal. At the completion of the assignment students will have - described basic financial operational data and business processes
|
|
Some of the most popular online auction sites
: Write a paper that uses the material we have studied thus far in our course to analyze, compare, and contrast some of the most popular online auction sites. As always, acknowledge and properly credit all outside references.
|
|
What kind of culture are you going to be studying abroad in
: What kind of culture are you going to be studying abroad in. Is it an individualistic culture, masculine, high context, or a tight culture? Describe the culture you will be going too, (this will also help you to shape what type of exercise or les..
|
|
How you can best read process and respond to feedback
: In this unit, we have focused on revising and editing; understanding expectations; ways to outline your paper; the importance of keeping the reader in mind; and how you can best read, process, and respond to feedback.
|
|
Describe different types of classes for language minority
: How to provide effective feedback to limited English speakers without embarrassing or frustrating them: consider error correction, questioning in a non-threatening manner, wait time, consistency, etc.
|