Question
The company developed a Price Master File which captures the price in which inventory should be purchased from suppliers and the price is in which
"The company developed a Price Master File which captures the price in which inventory should be purchased from suppliers and the price is in which it should be sold to customers. Employees do not have permission to deviate from these standards, as the difference between the two prices is the profit for the organization. Due to old software, and poor controls, there is no integration between the purchasing system, sales system and the master file, and as such employees are required to manually enter pricing information at the time of each purchase and sale. As such, the ""purchase price"" on the purchases table represents the actual price paid for the purchase. Management wants to ensure that the company did not overpay for product. If any anomalies are found, Management would like you to investigate for trends or unusual findings related to the individual / companies involved. In addition, Management would like to know how any findings impacted overall profitability when considering the sales price of the item. Perform an analytic(s) over ""Purchases"" and ""Price Master File"" data to provide adequate insights to Management. Put all relevant output on the Question 4 Support tab."
Step by Step Solution
There are 3 Steps involved in it
Step: 1
The companys Price Master File captures purchase and sales prices to ensure profitability However du...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started