Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Use Excel formulas to complete the calculations and then answer the short-answer questions in the following spreadsheet: Inventory Analysis at Walmart Click for more options

Use Excel formulas to complete the calculations and then answer the short-answer questions in the following spreadsheet: Inventory Analysis at Walmart Click for more options

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question

Use Excel formulas to complete the calculations and then answer the short-answer questions in the following spreadsheet: Inventory Analysis at Walmart Click for more options

Hint: When calculating retail price {RP} based on cost {C} and markup percentage {M%} on RP, use the Cost Complement formula we have discussed previously in class: RP = [(C)/(100% - M%)] x 100

s at Walmart Example Spreadsheet Seet are fictitious and are not intended to represent actual data related to actual Walmart products s to the nearest tenth. 9 2 5 8 9 H Retail 5 6 55 18.88 Margin % 55.5% 52.8% 52.9% 50.0% 55.5% 52.8% 52.9% 50.0% 61.4% 70.6% Beginning Week-On Hand 178 118 200 47 89 62 89 150 333 345 1611 On Order 66 0 47 4 43 1 1791 Week 1 Sell Thru Sales in % Units 18.0% 17.8 % 33.5% 6.4% M 38.2 % 19.4% 24.7% 76 33 21.3% 21 23.4% 1500 29.6% 32 21 67 3 34 12 22 228 32 78 102 403 Week 2 Sales in Units 53 33 44 5 51 23 54 23 525 57 110 453 Week 3- Sales in Units 55 64 35 3 SERBIEM 22 65 65 76 77 134 596 Week 4- Sales in Units 33 0 42 MTD Sales in Units 9 12 120 43 66 95 154 574 MTD Sales $ 500 $9,438.78
Transcribed Image Text:s at Walmart Example Spreadsheet Seet are fictitious and are not intended to represent actual data related to actual Walmart products s to the nearest tenth. 9 2 5 8 9 H Retail 5 6 55 18.88 Margin % 55.5% 52.8% 52.9% 50.0% 55.5% 52.8% 52.9% 50.0% 61.4% 70.6% Beginning Week-On Hand 178 118 200 47 89 62 89 150 333 345 1611 On Order 66 0 47 4 43 1 1791 Week 1 Sell Thru Sales in % Units 18.0% 17.8 % 33.5% 6.4% M 38.2 % 19.4% 24.7% 76 33 21.3% 21 23.4% 1500 29.6% 32 21 67 3 34 12 22 228 32 78 102 403 Week 2 Sales in Units 53 33 44 5 51 23 54 23 525 57 110 453 Week 3- Sales in Units 55 64 35 3 SERBIEM 22 65 65 76 77 134 596 Week 4- Sales in Units 33 0 42 MTD Sales in Units 9 12 120 43 66 95 154 574 MTD Sales $ 500 $9,438.78
TOTALS Line a) Calculate the cells that are highlighted in yellow. Express dollar amounts to the nearest penny and percentage answers to the nearest tenth. (7 p 1 2 3 4 5 6 7 8 9 10 D Div Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Inventory Analysis at Walmart Exam SKU numbers, unit costs, retail pricing, and other numbers in the spreadsheet are fictitious and are Vendor Item# Acme Acme Acme Acme Acme Acme Acme Acme Acme Acme G 665780 665781 665782 665783 665784 665785 665786 665787 665788 665789 Description Phillips Head Small 4 Phillips Head Medium 4" Phillips Head Large 6 Phillips Head Extra Large 7" Regular Head Small 4" Regular Head Medium 4 Regular Head Large 6 Regular Head Extra Large 7 6-in-1 Racheting Screwdriver Screwdriver Assortment Pack Cost $ $ $ $ $ $ $ $ S S 1.78 1.89 2.12 2.25 1.78 1.89 2.12 2.25 Retail 3.46 5.55 S 18.88 Marg
Transcribed Image Text:TOTALS Line a) Calculate the cells that are highlighted in yellow. Express dollar amounts to the nearest penny and percentage answers to the nearest tenth. (7 p 1 2 3 4 5 6 7 8 9 10 D Div Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Screw Drivers Inventory Analysis at Walmart Exam SKU numbers, unit costs, retail pricing, and other numbers in the spreadsheet are fictitious and are Vendor Item# Acme Acme Acme Acme Acme Acme Acme Acme Acme Acme G 665780 665781 665782 665783 665784 665785 665786 665787 665788 665789 Description Phillips Head Small 4 Phillips Head Medium 4" Phillips Head Large 6 Phillips Head Extra Large 7" Regular Head Small 4" Regular Head Medium 4 Regular Head Large 6 Regular Head Extra Large 7 6-in-1 Racheting Screwdriver Screwdriver Assortment Pack Cost $ $ $ $ $ $ $ $ S S 1.78 1.89 2.12 2.25 1.78 1.89 2.12 2.25 Retail 3.46 5.55 S 18.88 Marg
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS