Question: Reorder amounts lookup table CATEGORY PREMIUM REGULAR A 25 20 B 20 5 C 15 12 Excel sheet: Column A B C D ROW CATEGORY

Reorder amounts lookup table

CATEGORY	PREMIUM	REGULAR
A	25	20
B	20	5
C	15	12

Excel sheet:

Column	A	B	C	D
ROW	CATEGORY	PREMIUM?	REORDER?	REORDER QUANTITIES?
1	A	Y	Y	?
2	B	N	N	?
3	C	Y	N	?

QUESTION: In column D calculate the number of items to reorder if a reorder is required. if not the calculation should return 0 (not"0"). Reorder quantities are based on 2 factors, the category shown in columnA and whether or not is premium or regular, the look up table as "Reorder amounts look up" .

for e.g. category A premium items need to reorder 25 whereas a regular only 20.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

State Construction Company is owned equally by Andy, Bill, and Charlie. Andy works in the corporation full-time, and Bill and Charlie work elsewhere. Andys employment contract with State specifies a...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

1: Describe and explain the terms climate sensitivity, fat tail, and low beta, and how they relate to climate change. 2: What are the estimated economic costs of global warming? Can we trust these...

Chapter 3 Describe and explain the terms climate sensitivity, fat tail, and low beta, and how they relate to climate change. What are the estimated economic costs of global warming? Can we trust...

E1 E2 E3 The Inventory sheet contains a list of all the items the company keep in stock to build customer networks. Each part is identified by a unique item code. Convert the Range A3:K1245 to a...

help! im stuck on this!! especially 8-11 questions. thanks! U ab X, X A E. Font Paragraph II. ...6 7. For the past year, you have been working with a medium-sized painting contractor, RJ Construction...

Unilever Brazil Case Write-up After three successful years in the Personal Care division of Unilever in Pakistan, Laercio Cardoso was contemplating an attractive leadership position in China when he...

Calculate the number of itemsto reorder if a reorder is required. If not the calculation should return 0 (not 0). Reorder quantities are based on two factors, the category shown in column C and...

What excel formula needs to be used for E6-E9?? E6 4 0 In column calculate the number of items to reorder if a reorder is required. If not the calculation should return 0 (not "O"). Reorder...

Part 1) In column G some items have a Y against them indicating that they are Premium items. Premium items incur a higher mark-up than standard items, both, the standard and premium mark-up rates can...

Rival Inc. uses the lower of cost or market rule in valuing its inventory. One unit has a ceiling constraint of $45.50. The following is other information concerning this unit: Estimated...

Four years ago Jeanne Nolen decided to invest in a project. At that time she had projected annual net cash inflows would be $54,000. Over its expected four-year useful life, the project had produced...

Which of the following is correct regarding the flow of costs for a manufacturer?A . Inventories move from Raw Materials to Work in Process to Finished GoodsB. Work in Process Inventory Costs...

a=2 b= 0 c= 2 d=0 e=0 f=9 g=3 5. Draw the Network diagram for the following project. Estimate the Earliest start time and Latest finish time for each activity. If every day it cost 200 rials for this...