Question: Use Excel to fill in the table in the EOQ sheet in 1 5 2 4 Lab 5 data.xlsx , given the following: annual demand

Use Excel to fill in the table in the EOQ sheet in 1524Lab5data.xlsx, given the following:
annual demand (D)=18000
fixed cost per order(S)=$40
annual holding cost per unit (H)=$9.00
number of units per order(Q)= values from 300 to 850 in increments of 50
If you begin entering the data with cell A2, which of the following are correct?
I. B8=$300.00
II.C6=$1,800.00
III. D9= $4,032.69
 Use Excel to fill in the table in the EOQ sheet

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!