Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
view Help Comments X fx Question c: A B D H K L M N O P Q R a) Calculate the cells that are
view Help Comments X fx Question c: A B D H K L M N O P Q R a) Calculate the cells that are highlighted in yellow. Express dollar amounts to the nearest penny and percentage answers to the nearest tenth. (7 points) Beginning Week - On Week 1 Sell Thru Sales in On Order % Units 6 Line Div Item # Description Margin % Cost $ Retail 1.78 1 Screw Drivers Screw Drivers Phillips Head Small 4" Phillips Head Medium 4" 2 Week 2 Week 3 - Week 4- MTD Sales in Sales in Sales in Sales in MTD Sales Units Units Units Units $ 32 53 55 33 21 0033 64 0 67 3 Hand 178 118 200 47 $ 3 Screw Drivers $ 66 0 47 4 43 44 35 421 Screw Drivers $ 3 -9 Vendor Acme Acme Acme Acme Acme Acme Acme Acme Acme Acme Screw Drivers $ 55.5% 52.8% 52.9% 50.0% 55.5% 52.8% 52.9% 50.0% 61.4% 18.0% 17.8% 33.5% 6.4% 38.2% 19.4% 24.7% 21.3% 89 34 51 665780 665781 665782 Phillips Head Large 6" 665783 Phillips Head Extra Large 7" 665784 Regular Head Small 4" 665785 Regular Head Medium 4" 665786 Regular Head Large 6" 665787 Regular Head Extra Large 7" 665788 6-in-1 Racheting Screwdriver 665789 Screwdriver Assortment Pack 22 12 1.89 2.12 2.25 1.78 1.89 2.12 $ 2.25 $ 3.46 $ 5.55 $ $ 62 12 23 65 120 $ 1 76 33. 22 54 65 43 Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers, 23 76 66 8 89 150 333 345 32 78 21 23.4% 57 77 95 9 18.88 70.6% 1500 29.6% 102 110 134 154 500 $9,438.78 10 1611 1791 403 453 596 574 TOTALS 19 b) Assume that the products in the spreadsheet are ordered every 3 weeks and take another week to arrive in the store. Consider the products' on-hand numbers, the sell thru percentages, and the month-to-date sales in units. Identify and comment on any products that may cause you concerns about inventory and order levels, and the ability to meet demand over the next 4-week period. (4 points) 20 Question b: 22 23 c) Comment on any trend(s) that may be developing and recommend one action to address the trend(s). (4 points) 22: A 100% Inventory & Sales Report 324 7 8 9 10 11 12 13 $99589 14 15 16 17 18 21 4 5 6 7 5 Share
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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