Question: A bakery is trying to write a formula in Excel to advise them on how much flour to order each week from their supplier. The

A bakery is trying to write a formula in Excel to

A bakery is trying to write a formula in Excel to advise them on how much flour to order each week from their supplier. The order amount will be dependent on considering their past sales history, their future customer orders, and their current inventory levels. The bakery has decided that it will only order 75 pounds of flour if ALL of the following criteria is true What excel formula below would display TRUE, given these variables? - The bakery has more than 50 customer pre-orders for the week. This data is in cell A2. - They have less than 10 pounds of flour in inventory. Their current flour inventory is in cell B2 - The same week in the prior year had more than $1000 in sales. This data is in cell C2. =AND(A2>50,B21000) =AND(A2>50),AND(B21000) =IF(A2>50,IF(B21000),TRUE,FALSE)) =IF(A2>50,B21000, TRUE,FALSE)

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 General Management Questions!

A bakery is trying to write a formula in Excel to advise them on how much flour to order each week from their supplier. The order amount will be dependent on considering their past sales history,...

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

I have attached the discussion board 6 questions,scenario. and lectures for yourreview and response. I will submit a students questions for a response when I receive one. Thank You MKT500 Discussion...

Can someone please explain to me what I am doing wrong on a and b for this question? I am stuck here and I must follow the given formula. I am having a hard time figuring out what R, K and H equal as...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

Background Hamilton Bakery: Master Budgeting Hamilton Bakery is a medium-sized regional bakery that specializes in providing orders to grocery and convenience stores. Because of the popularity of its...

PLEASE JUST ANSWER PART B (Note: While this is a word problem, each of the situations reflects an inventory formula, or part of one, illustrated in your reading. It is important in your answer to...

Corelli Company provides below a listing (in alphabetical order) of all the accounts it uses (far left column). For each line you are provided five choices of families of accounts to which the...

Northern Company processes 100 gallons of raw materials Into 75 gallons of product GS-50 and 25 gallons of GS-80. GS-50 is further processed into 50 gallons of product GS-505 at a cost of $10,000,...

True or False? "Perspective - taking" and "comeunicated perspective - taking" are equivalent teres referring to the same concept. True False

What is an example of constructive feedback? provide reference