16 Nov Prepare a Power Point presentation discussing what recommendations you would make to your client, given the information you have gathered in parts 1-4, and what you have learned in this

10

Customer and Labor Intensiveness Within Business Operations

Valery Salazar

Keiser University

Data Analysis for Accounting

Dr. Wendy Achiilles

October 29, 2022

1. Determine the number of cash registers required.

From the information given, it can be determined that the average period it takes to place and receive an order is 1.25 minutes. This means that the restaurant can serve approximately 80 customers per hour. To accommodate 500 customers per hour, the restaurant would need at least six cash registers.

The number of cash registers required can be determined using the following equation:

For Fat Charlie's, this would be:

500 * 1.25 = 625

625/60(1-2) = 13.021 = 13 registers

500/4 = 125

13.0208/4 = 3.255 = 3 registers

From the above calculations, it can be seen that Fat Charlie's would need approximately 3 cash registers to accommodate their 500 customers per hour.

3. Assuming ideal conditions, what is the maximum capacity of process B annually?

Assuming key ideal conditions, with maxim. capacity of process B could be 2,880 jobs annually. This is because two employees are working in process B, each working 8 hours a day, 5 days a week, and 250 days per annually.

7.5 x 60 = 450 minutes

Process B = 450/15 = 30 days

Based on the calculation, it is recommended that process B be used to maximize the capacity of the Pre-Cast Shop. This is because process B can produce 2,880 jobs annually, while process A can only produce 1,000 jobs annually (Sima et al. 2020).

4. If Rocky's is primarily interested in providing low-cost customers, which process should he implement?

Process A has a single worker do both the job's initial planning and its first casting. Using this method, a skilled worker may finish around 20 tasks each day.

Process B requires a team of 2. Setup is handled by one person, while pre-casting is completed by another. Pre-casting may be done in parallel with job setup, however a task must be finished before the pre-cast machine can begin processing the next project. With some experience, the second procedure takes an average of just 15 minutes of hands-on time in pre-casting and 8 minutes of setup time (Grewal, & Roggeveen, 2020).

Assume an eight-hour workday, five days a week, and two hundred and fifty working days a year. The two employees in process B can start their shifts at different times.

Process A will require 20 hours of labor per day, while Process B will require 16 hours of labor per day. Process B will require an additional investment in a labor of $4 per day. Based on these two factors, Process A is the more cost-effective option.

References

Grewal, D., & Roggeveen, A. L. (2020). Understanding retail experiences and customer journey management.  Journal of Retailing,  96(1), 3-8. https://www.sciencedirect.com/science/article/pii/S0022435920300051

Sima, V., Gheorghe, I. G., Subić, J., & Nancu, D. (2020). Influences of the industry 4.0 revolution on the human capital development and consumer behavior: A systematic review.  Sustainability,  12(10), 4035. https://www.mdpi.com/2071-1050/12/10/4035/pdf?version=1589469726

,

2

Week 2 Writing Project

Valery Salazar

Keiser University

Data Analysis for Accounting

Dr. Wendy Achiilles

November 5, 2022

Orlando University Bookstore Flowchart

When ordering textbooks, individuals need to be organized, converse with others and act in a certain way. So, it's important to look at the sales process and the data to determine what the bookstore process needs. The process will begin with the class's lesson plan or the teacher of the class. The professor must either require or suggest that the students buy a certain textbook for that class. Either in the syllabus or a message, the department chair who sets the orders needs to know the title, ISBN, edition, publisher, and copyright date of the required textbook. Once the checks are done, copies of the requisition order are sent to the right departments. The order is sent to the designated department, which keeps three copies of the invoice. Each copy is for a faculty member, a department, and the bookstore that asks for it. The bookstore puts together the university's requisition forms to send purchase orders to the publisher, the purchasing department, and the accounting department. The publisher then sends copies of the textbooks to the bookstore along with a receipt and bill, which are sent to the university's accounting division. When the reports have been harmonized and checked, the accounting department wires funds to the producer. The bookstore finally sorts the books by department and class number.

Report

Regarding the sales report, a few areas of concern need to be brought up to Mr Stone about the specifics of all the textbooks available at the Orlando University Bookstore. From the previous month, we can see in several of the Excel file cells that essential information needs to be added, such as the department, ISBN, book title, and publisher. Here we can give fuzzy matching to compare the master file with this database table to detect commonalities. As a result, this update can assist in verifying the proper books for the relevant information that is missing. To calculate the final price that will be charged to the university's students, we must check with the accounting and procurement departments on the cost, the sale price, and the taxes. The ability to extract data from the past and present allows us to use this information to create predictions. Automating sales forecasting can be done by software that uses predictive analytics to predict future risks and opportunities. As a result, we can get in touch with the purchasing departments to confirm how much the book costs, after which we can determine our sale price and add any applicable taxes to produce our final bookstore sales price.

To avoid making these kinds of mistakes, we need first to establish some criteria for the accreditation process and the content presented to the students. Given the numerous inaccuracies derived from its database, the company might look undervalued if there were no internal controls, predetermined procedures, or an effective ordering system. To ensure that their bookshop meets customers' needs well, Mr Stone will need to conduct additional work with his ordering system, accounting department, educational department, faculty members, and supervisors. The used bookstore needs to perform an annual update on the most recent copyright date and updates to the latest titles, ISBNs, authors, editions, and publishers. This indicates that they will need to update their ordering system annually to determine their costs, sale price, taxes accurately, and ultimate sale price to keep their ordering system operating effectively. In general, they can reduce the time spent on risk assessment by using classification analysis, which finds and assigns categories. Because this particular bookshop has its issues, we can determine the required critical components, such as the sales order ID, the date entered by and approved, and the amount of the local sales order.

References

Srikanth, (2021, August 12). How Is Data Analytics Used In Accounting To Influence Finance And Accounting.. Techiexpert.com. https://www.techiexpert.com/how-is-data-analytics-used-in-accounting-to-iunfluence-finance-and-accounting/

,

1

Memorandum

Valery Salazar

Keiser University

Data Analysis for Accounting

Dr. Wendy Achiilles

November 11, 2022

Memorandum

From: Valery Salazar

To: Manager

Date: November 11, 2022

Comprehensive Risk Assessment and Mitigation

Risks that are there for a University Bookstore in sourcing books for their students include the challenge of miscommunication among the stakeholders. There are professors, tutors, and students that know about the books that are needed to facilitate learning, and the key details of concern include the book title, ISBN, publisher, and copyright date. The risks occur when the books ordered are different from the required books based on title and publisher, and this becomes a disadvantage to the institution and the learner because some information will be missing. The reason why the books undergo regular updates and publishing is critical for adding the missing information and limitation in previous versions making it better for the students to learn. There is a huge gap in the education sector where student feedback is given limited consideration making it challenging to curb the problem of having the wrong books in the store. There is a huge challenge in the process of communicating about the right books that are needed since there is an updated version annually, and the school store manager has to understand this (Landoll, 2021). I found out that the problem is experienced in the ordering system where there needs to be a gap in terms of communicating the right information that facilitates knowing the right costs, sale price, accurate taxes, and the type of the book. The manager is responsible for ensuring that the bookstore is subjected to an annual update that ensures the students' needs are addressed accordingly. The stakeholders are not involved as needed since the student understands what they are learning and the gaps that are there. The educators and professors are responsible for developing lesson plans and understanding the best book versions. Sourcing the information from different departments is challenging because there is limited understanding of what is needed since the process is not harmonized. The mitigation strategies towards the risks of having wrong books in the University store include adopting the classification analysis that plays the role of finding and assigning categories reducing errors and mistakes. Classification analysis makes it possible that when the bookshop has issues makes, it is possible that can trace where the problem originated by looking into the sales order ID, the date entered and approved, and the amount spent on the local sales order. There is a need to strengthen systems of book orders and the information is extracted, making it possible that the manager can adapt the predictive analytics software that helps in the prediction of future risks and opportunities. The stakeholder involvement is another intervention that would work well in reducing the possible risks because sharing the book's requirement information makes it possible for the customer needs to be known to the bookstore and makes it possible that they are targeted. Understanding customer needs is an essential strategy towards increasing sales, and this would work for the bookstore where the student needs need to be addressed, making it possible that regular book update version is brought to the store annually. The improvement of the existing order system ensures that all books required are evaluated and ensured that it fits the required needs of the students and within the lesson plan for the students to pass their courses. The manager is responsible for ensuring this happens by coordinating with the necessary stakeholders and communicating effectively to serve the students' needs. Analysis of internal control is important, where the organization should have procedures and guidelines that assist in ordering and getting the right books.

References

Landoll, D. (2021). Security risk mitigation. The Security Risk Assessment Handbook, 421–433. https://doi.org/10.1201/9781003090441-11