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/