Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make an excel table with 18 records, listing the goods sold by your company during the last three years. Order ID Year Product type Units
- Make an excel table with 18 records, listing the goods sold by your company during the last three years.
Order ID | Year | Product type | Units sold | Price/Unit | Cost/Unit | Revenue | Profit |
1 | 2020 |
|
|
|
|
|
|
2 | 2020 |
|
|
|
|
|
|
3 | 2020 |
|
|
|
|
|
|
4 | 2020 |
|
|
|
|
|
|
5 | 2020 |
|
|
|
|
|
|
6 | 2020 |
|
|
|
|
|
|
7 | 2021 |
|
|
|
|
|
|
8 | 2021 |
|
|
|
|
|
|
9 | 2021 |
|
|
|
|
|
|
10 | 2021 |
|
|
|
|
|
|
11 | 2021 |
|
|
|
|
|
|
12 | 2021 |
|
|
|
|
|
|
13 | 2022 |
|
|
|
|
|
|
14 | 2022 |
|
|
|
|
|
|
15 | 2022 |
|
|
|
|
|
|
16 | 2022 |
|
|
|
|
|
|
17 | 2022 |
|
|
|
|
|
|
18 | 2022 |
|
|
|
|
|
|
- Fill in the table with RANDOM values for: Product type Units sold Price/Unit Cost/Unit Revenue Profit
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