Assignment Task :
Accounting Assignment Help
Case Study 1:BONES & NARBLE BOOKS
Bones & Narble Books is a large book distributor whose office is located in Springvale. It was established in 1982 by two friends (Bob and Nick) who invested some of their savings to buy an abandoned warehouse and convert it into a bookstore, mainly selling used books that were donated by friends and family. The business proved to be very popular and by the end of the first financial year it had grossed $20,000 in sales. Over the next decade, more employees were hired, more books were traded in and more sales were achieved each passing year. However, during the mid-1990s the business was faced with two problems: many large, upscale book-stores were being built in the area, and the use of the Internet for finding and ordering books was becoming cheaper and more popular for current customers. In 1995 sales finally started to decline. Deciding to take a risk because of the newfound competition, Bob and Nick closed their doors to the local trade, invested more money to expand the building and transformed the business from just selling used books to being a distributor of new books. The business now stores books that have been sent to it by publishers and then resells the books to large bookstore chains upon request. Bones & Narble has rapidly become one of the largest book distributors in Australia. Although the business is still at its original location in Springvale, it distributes books to each state and territory of Australia, making over $1 million per year. From simple beginnings of two workers, the business has expanded to now having more than 145 employees. As already mentioned, all of Bones & Narble’s customers are large-chain bookstores who themselves see many millions of dollars in revenue per year. However, some of these bookstores have had bad relationships with the business in the past year. There have been many disputes between them, such as books that were ordered from Bones & Narble but were never sent, poor inventory management by Bones & Narble, and the inability of the business to provide legitimate documentation of transactions. According to projections of this year’s financials, the sour relationship that Bones & Narble Book and many of its customers have is going to take a toll on year-end revenue. Bob is convinced that some of the business’s problems are due to a lack of proper internal controls. You have been hired as an independent expert to inspect and analyze the internal controls currently in place at Bones & Narble Books. You start by documenting the existing systems to better understand the people, processes, and documents involved. Expenditure Cycle. Questions: a) create a physical data flow diagram of the Purchases system b) create a logical data flow diagram of the Cash Disbursements system c) create a systems flowchart of the existing systems
Case Study 2: JEN & BERRY’S ICE-CREAM SHOP
‘Jen & Berry’s’ is a small ice-cream shop located on Warrigal Road, just over the road from Holmesglen Institute. Jen & Berry’s serves walk-in customers only. The shop carries 26 flavors of ice cream. Customers can buy cones, sundaes or shakes. When a customer pays for individual purchase, a sale transaction usually includes just one item. When a customer pays for a family or group purchase, however, a single sale transaction includes many different items. All sales must be paid for at the time the ice cream is served. Joe’s maintains several bank accounts but deposits all sales receipts into its main cheque account.
Questions:
a) Draw an REA diagram, complete with cardinalities, for Jen & Berry’s revenue cycle. Use the REA Entity-Relationship (ER) modeling techniques as discussed in class. You can use Microsoft Word or Visio to complete this part.
b) Convert your REA diagram into a relational database structure, i.e. tables and relationships. At this stage, you are designing the database on paper. There is no need to start entering it in Access. Make sure you use meaningful table and attribute names and show primary and foreign keys. Use the conventions as discussed and shown in classes. You can use Microsoft Word or Visio to complete this part.
This Accounting Assignment has been solved by our Accounting Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
