Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Your boss gives you three sets of data. One set of data includes item numbers, descriptions, and standard costs. Another is a sales report showing
Your boss gives you three sets of data. One set of data includes item numbers, descriptions, and standard costs. Another is a sales report showing the sales of each item for a given period, and a calculation of total revenues derived from the sales of each item. The third set includes a sales price list from the system.
Your boss was sent this data from one of the accountants on the India accounting team and has not had time to verify the quality of the work or data integrity. Information from the system is generally accurate, but other pieces of data and formulas may not be accurate based upon previous experience with this particular accountant. Given this data, your boss would like you to find out how much contribution margin was derived from the sale of each item during the period, some recommendations based on that data, and a list of any concerns.
For this exercise please query and combine the data to gather the necessary information, analyize the data then list any concerns and recommendations based on your findings. Please keep your original formulas in the spreadsheet, and present the data, findings and recommendations in as concise a manner as possible. Also please track and report the total time required for this task.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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