Please use the case materials of Pixysystems. Please come up with three ways use the case data related to accounts payable, inventory, and sales to provide insights to relevant parties, such as CFO, business process manager, internal audit department, and external audit. Dataset-Pixysystems-2.xlsx You are NOT required to perform the actual analyses. Specific requirements: Please identify two research questions related to accounts payable, inventory, and sales. (It is not necessary to focus on one account at a time. For each question, you may choose a combination of multiple accounts.) (20 pts) Please describe the audience of the analysis; and how they would benefit from the results. (10 pts) Indicate the data fields that is necessary for your analysis using the following format: “table name_field name”. Please include all fields that are necessary for your analysis. Make sure to use data from multiple tables in at least one of your analyses as it is necessary for requirement d. (20 pts) Describe how you will join tables when applicable. For each join, specify which is the left and right table; which data field serves as the matching keys; what is the type of the join; and why you need to use this specific type. It may not be necessary to perform joins for both research questions. Please put NA if a join is not necessary. (10 pts for all)
Which of the following best describes the purpose of initial…
Which of the following best describes the purpose of initial evaluations in home health care?
As an OT in the acute care setting, in your discharge planni…
As an OT in the acute care setting, in your discharge planning, you would be determining the next level of care with collaboration from the medical team.
This type of hearing loss is defined as the loss or damage t…
This type of hearing loss is defined as the loss or damage to the sensory hair cells or the cochlea in the inner ear or to the nerve cells of the cochlear ganglion, brain stem tracts or cortex.
A central venous line is used when peripheral access is unav…
A central venous line is used when peripheral access is unavailable.
In order to qualify for an inpatient rehabilitation facility…
In order to qualify for an inpatient rehabilitation facility, the patient must be able to participate in at least _________________ of therapy per day.
Smell has more associated age-related changes than taste.
Smell has more associated age-related changes than taste.
An OT would not need to consider completing a cognitive scre…
An OT would not need to consider completing a cognitive screen or checking cognitive status prior to providing medication management strategies for their client.
When conducting a client interview for your occupational pro…
When conducting a client interview for your occupational profile, what information would be most useful for identifying occupation-based, client-centered goals?
Now, use the worst-case scenario from the prior problem to p…
Now, use the worst-case scenario from the prior problem to perform a sensitivity analysis where the initial project investment is twice the expected level. Compute and interpret the degree of operating leverage under this worst-case scenario sensitivity analysis. Recall the following details: Fex Ed is considering a new product launch. The project will cost $2,000,000, have a 5-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 500 units per year, price per unit will be $7,500, variable cost per unit will be $6,000, and fixed costs will be $225,000 per year. The relevant tax rate is 21 percent. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate to within ± 5%.