Calculate the margin percentages and the sell-thru percentages for the listed items in the following spreadsheet: Sample Inventory Performance Report

Managers analyze data to make business decisions and recommendations. This exercise gives you practice in calculating, analyzing, and recommending your observations to management.
You will compose a business memo addressed to your manager that includes both parts 1 & 2, below. To begin, download the following memo template: Walmart Memo Template
1. Calculate the margin percentages and the sell-thru percentages for the listed items in the following spreadsheet: Sample Inventory Performance Report
a. Assume the targeted margin percentage for the group of items in the report is 57.8%. Which items have a margin percentage that is on target, below target, or above target?
b. Assume the targeted sell-thru percentage on the group of items is 44.5%. Was the target achieved? If not, identify which items were most responsible for under-performance.
2. Select one of the scenarios below and present a persuasive case to management for its implementation:
a. Lower-than-targeted average margin percentage for the group of items. (Be sure to consider the sell-thru rate when considering what action to recommend.)
b. An item that may have a lower-than-targeted sell-thru percentage. (Be sure to consider the cost and retail price when considering what action to take.)
c. An item that is expected to stockout before the next order can be received.
Format Instructions: For this assignment, please use the memo template provided and include all required information. See the Supplemental Resources for assistance with your writing. Upload your completed spreadsheet with your memo.

Related Posts

Quality Writing Features

Price Start $10
  • 24/7 Customer Support
  • All Subject Areas
  • Money-Back Guarantee
  • Timely Delivery
  • Originality report
  • Confidentiality guaranteed

Ordering Homework Writing Service

You can get our ideal online homework help services with four easy steps. All you have to do is inform us of your requirements. Immediately we will match with a specialist in your academic discipline. After that, we will track your order, review it to ensure it meets your requirements, and submit it to your email.


Submit Requirements

Fill in your assignment instructions on the order form


Writer match

Immediately you contact us for homework help; we will assign your assignment to an academic expert.


Quality review

We have a team of editors, who will thoroughly review your assignment, ensuring there are no errors before submission


Get Your Completed Paper

Once we have completed the assignment, we will deliver it to your account. Additionally, we will send a notification to your email.



Budget-friendly writing services



We don’t share our client’s information with a third party



We write every assignment from scratch

Amazing Homework Writing Features

Once you consult us for homework help online services, you will attest to why we are among the USA's best essay writing services.

Read on and find out some of the features that make our services superlative.

Free Homework Writing Services

Free plagiarism checker

You can confirm that the content you get is original for free using our plagiarism checker.

Free samples

We offer unlimited access to our essay homework samples.

Free title page and bibliography

Once you place an order, we format it accordingly without demanding additional charges.

Free unlimited revisions

We offer free unlimited revisions until your assignment is of your desired quality..

Free editing and proofreading

We have a team of specialized editors who review your assignment before submission.

Free customer support

You can track the progress of your homework for free.

Request for Homework Writing Service Today!

We have over 500 homework writing experts, ready and waiting to help you improve your writing skills