Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cape Machinery sells various types of machinery and equipment. You have been provided with the attached sales data records. You noted different date formats
Cape Machinery sells various types of machinery and equipment. You have been provided with the attached sales data records. You noted different date formats are used in the document. The records are for the February to May 2023 period. From the knowledge you have acquired from the Computer Advanced module, create a sales report for the company's management by answering the following questions. Required: 1.1 Correct the date format in the sales record to use the YYYYMMDD date format (4 marks) 1.2 Calculate the total sales recorded for each item and the total sales for the period. (3 marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Based on the provided sales data I will create a corrected report for the companys management Correc...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