Question: I really need help on this, I do not know where to begin. Excel Project #1 Made uses a periodic itventory system and hashired you




Excel Project #1 Made uses a periodic itventory system and hashired you as a contulant to help with their inventory ma nagement and accountine. Ther have provided theit inventory transction for the past year (purchases and saler) and asked that you provide the folowiris: (4) Indwe inventery, Cost of Goads Sold, and Grow Proft for three diferest inventory contis methods (ro, LFO and Average Cont) (2) Thee waphs to help management undervand the defferences between the inventory conting methods (s separate graph for ending inventory, cort of goodi soid and grost proft) (3) Youe recommendation of what imentory coiting method they thould use and Wry, Any adstional insquitsyou have aould be greatiy apprecated: You wat NOT be able to eda the sales or purchaves data or add a new sheet. You should be able to do any work (cakulations, creating formiglas, etc.) in any empty cell in the purchases and ales she in provided that you can use for deling any work, but you do not need to use that sheet. Mrer coneleting the requirements below, save the file and submit en Canvas. input your name and CWID for the data to populate. Name CWiD 2. Hace your three paphs comparing the inventory costing methads in the spoce below fone for ending inventary, one for cent of goeds sold and one for gross profit): i2. rour craphs sheusd have clearly bbeied anes and a tite. Face the sraphs sise by side horlaonaly in the space provided. 2. Flace your three oraphs comparing the inventory costing methods in the spoce below fone for ending inventory, one for cort of goeds sold and ane for gross profit): Your graphs should have clearly labeled aves and a titie. Place the eraphs side by side horizonally in the space provided. 3. Ghe your recommendotion of which inventory cosfing method Riddle should use in the spore below: Hespenses with ne eaplanation of why you recommend a particular methed will recelve NO credit. Cacel Trick: Uhe Ah + fater to os to o new line. 3. Give your recommendotion of which inventory corting method Alddle should ver in the spoce below: Responses with no erplanation of why rou recommend a particular method will recelve NO credit. Ereel Thick Use Aft inter to go to a new ine. Excel Project #1 Made uses a periodic itventory system and hashired you as a contulant to help with their inventory ma nagement and accountine. Ther have provided theit inventory transction for the past year (purchases and saler) and asked that you provide the folowiris: (4) Indwe inventery, Cost of Goads Sold, and Grow Proft for three diferest inventory contis methods (ro, LFO and Average Cont) (2) Thee waphs to help management undervand the defferences between the inventory conting methods (s separate graph for ending inventory, cort of goodi soid and grost proft) (3) Youe recommendation of what imentory coiting method they thould use and Wry, Any adstional insquitsyou have aould be greatiy apprecated: You wat NOT be able to eda the sales or purchaves data or add a new sheet. You should be able to do any work (cakulations, creating formiglas, etc.) in any empty cell in the purchases and ales she in provided that you can use for deling any work, but you do not need to use that sheet. Mrer coneleting the requirements below, save the file and submit en Canvas. input your name and CWID for the data to populate. Name CWiD 2. Hace your three paphs comparing the inventory costing methads in the spoce below fone for ending inventary, one for cent of goeds sold and one for gross profit): i2. rour craphs sheusd have clearly bbeied anes and a tite. Face the sraphs sise by side horlaonaly in the space provided. 2. Flace your three oraphs comparing the inventory costing methods in the spoce below fone for ending inventory, one for cort of goeds sold and ane for gross profit): Your graphs should have clearly labeled aves and a titie. Place the eraphs side by side horizonally in the space provided. 3. Ghe your recommendotion of which inventory cosfing method Riddle should use in the spore below: Hespenses with ne eaplanation of why you recommend a particular methed will recelve NO credit. Cacel Trick: Uhe Ah + fater to os to o new line. 3. Give your recommendotion of which inventory corting method Alddle should ver in the spoce below: Responses with no erplanation of why rou recommend a particular method will recelve NO credit. Ereel Thick Use Aft inter to go to a new ine
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
