Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me how to plot these in MS Excel. 1. Find the estimated sales in units and $cost 2. Find the estimated inventory level

Please help me how to plot these in MS Excel. image text in transcribedimage text in transcribed

1. Find the estimated sales in units and $cost 2. Find the estimated inventory level by Dec 31st, 2021 and March 31, 2022 3. Include our in transit inventory in units & cost 4. Plot this in a graph with sliders by SKU XNM Creations Inc. Transaction Report October 1-21, 2021 # Product YOGI BANDS PASTEL CA AO Cutting Mat 36 x 48 CAN Yogi Bands Mat - Blue/Green Pastel CA Yogi Bands Pastel USA A1 Cutting Mat 24X36 CAN A3 Cutting Mat 12x18 CAN A2 Cutting Mat 18x24 USD A2 Cutting Mat 18x24 USD YOGI BANDS TPR YOGI BANDS - CANADA AO Cutting Mat 36 x 48 USA A1 Cutting Mat 24X36 UK A1 Cutting Mat 24X36 USA A3 Cutting Mat 12x18 USA Yogi Bands Mat - Blue/Green Pastel US Baking Cups - PASTEL - USA A2 Cutting Mat 18x24 CAN A2 Cutting Mat 18x24 UK Baking Cups - Standard - CANADA Baking Cups - Pastel - CANADA A3 Cutting Mat 12x18 UK Yogi Bands TPR - USA Date 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 Name Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Memo/Description HC-5X84-SOZG 2H-OE3Y-WOOB YZ-000Q-1U7E EB-LA3C-YBOL 6W-R74M-V5QK J6-04TO-IC9E 5K-CEEI-G18R 5K-CEEI-G18R LV-OEZL-UG80 RZ-VH76-OYTR 8M-OV8L-ZM80 KP-RHOA-WDZC FT-0845-E5XF 84-E5AR-XU72 FB-ZF6U-7UA6 PE-TAKT-INZA K2-B5XO-31CY 2C-BSUF-V7OB 1B-3B53-LY19 FG-J2EL-1ES6 2U-JPWE-WNAX SA-H4CZ-GM7W Balance 12,413.32 10,840.60 10.159.67 9,429.20 6,929.24 6,566.30 6,348.55 6.253.13 5,898.51 5,793.73 5,334.44 4,333.49 3,830.49 3,818.99 3,565.50 2,534.87 2.381.10 2,039.56 1.947.70 1,369.14 1,233.74 1.096.94 1. Find the estimated sales in units and $cost 2. Find the estimated inventory level by Dec 31st, 2021 and March 31, 2022 3. Include our in transit inventory in units & cost 4. Plot this in a graph with sliders by SKU XNM Creations Inc. Transaction Report October 1-21, 2021 # Product YOGI BANDS PASTEL CA AO Cutting Mat 36 x 48 CAN Yogi Bands Mat - Blue/Green Pastel CA Yogi Bands Pastel USA A1 Cutting Mat 24X36 CAN A3 Cutting Mat 12x18 CAN A2 Cutting Mat 18x24 USD A2 Cutting Mat 18x24 USD YOGI BANDS TPR YOGI BANDS - CANADA AO Cutting Mat 36 x 48 USA A1 Cutting Mat 24X36 UK A1 Cutting Mat 24X36 USA A3 Cutting Mat 12x18 USA Yogi Bands Mat - Blue/Green Pastel US Baking Cups - PASTEL - USA A2 Cutting Mat 18x24 CAN A2 Cutting Mat 18x24 UK Baking Cups - Standard - CANADA Baking Cups - Pastel - CANADA A3 Cutting Mat 12x18 UK Yogi Bands TPR - USA Date 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 14/10/2021 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 1066 Name Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Amazon Canada Memo/Description HC-5X84-SOZG 2H-OE3Y-WOOB YZ-000Q-1U7E EB-LA3C-YBOL 6W-R74M-V5QK J6-04TO-IC9E 5K-CEEI-G18R 5K-CEEI-G18R LV-OEZL-UG80 RZ-VH76-OYTR 8M-OV8L-ZM80 KP-RHOA-WDZC FT-0845-E5XF 84-E5AR-XU72 FB-ZF6U-7UA6 PE-TAKT-INZA K2-B5XO-31CY 2C-BSUF-V7OB 1B-3B53-LY19 FG-J2EL-1ES6 2U-JPWE-WNAX SA-H4CZ-GM7W Balance 12,413.32 10,840.60 10.159.67 9,429.20 6,929.24 6,566.30 6,348.55 6.253.13 5,898.51 5,793.73 5,334.44 4,333.49 3,830.49 3,818.99 3,565.50 2,534.87 2.381.10 2,039.56 1.947.70 1,369.14 1,233.74 1.096.94

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of International Financial Accounting And Reporting

Authors: Roger Hussey

1st Edition

9814280232, 9789814280235

More Books

Students also viewed these Accounting questions

Question

Design an internal skills transfer system through tutoring.

Answered: 1 week ago