Grader – Instructions Excel 2016 Project
Chapter 14 Inventory Problem (v1)
Project Description:
In this problem, you will determine the quantity of muffins to be produced under the demand uncertainty. You will use marginal economic analysis.
Steps to Perform:
Step
Instructions
Points Possible
1
Start Excel. Download and open the workbook named:
Chapter_14_Inventory_Problem_Start.
0
2
In cell D25, by using cell references, calculate the total number of frequencies of the quantities demanded. Use the Excel SUM function and cells D14-D24.
1
3
In cell E14, by using relative and absolute cell references, calculate the probability of the quantity demanded specified in cell C14. Use cells D14 and D25. Copy the formula from cell E14 down the column to cell E24.
1
4
In cell E25, by using cell references, calculate the sum of all the probabilities. Use the Excel SUM function and cells E14-E24.
1
5
In cells F14-F24, do the following:
In cell F24, by using a cell reference, determine the probability of selling the quantity demanded specified in cell C24. Refer to an appropriate cell among E14-E24.
In cell F23, by using cell references, calculate the probability of selling the quantity demanded specified in cell C23 or more. Use cells E23 and F24. Copy the formula from cell F23 up the column to cell F14.
2
6
In cell G14, by using relative and absolute cell references, calculate the probability of selling less than the quantity demanded specified in cell C14. Use cells F14 and E25. Copy the formula from cell G14 down the column to cell G24.
1
7
In cell H14, by using relative and absolute cell references, calculate the expected marginal benefit corresponding to the quantity demanded specified in cell C14 and the frequency specified in cell D14. Use cells D5, D7, and F14. Copy the formula from cell H14 down the column to cell H24.
1
8
In cell I14, by using relative and absolute cell references, calculate the expected marginal cost corresponding to the quantity demanded specified in cell C14 and the frequency specified in cell D14. Use cells D6, D7, and G14. Copy the formula from cell I14 down the column to cell I24.
1
9
In cell E27, by using a cell reference, determine the quantity of muffins the bakery should produce each day. Refer to an appropriate cell among C14-C24.
1
10
In cell E33, by using relative and absolute cell references, calculate the expected marginal benefit assuming the conditions described in part f. Use cells D7, D29, and F14. Copy the formula from cell E33 down the column to cell E43.
1
11
In cell F33, by using relative and absolute cell references, calculate the expected marginal cost assuming the conditions described in part f. Use cells D7, D30, and G14. Copy the formula from cell F33 down the column to cell F43.
1
12
In cell E45, by using a cell reference, determine the new quantity of muffins the bakery should produce each day assuming the conditions described in part f. Refer to an appropriate cell among C33-C43.
1
13
Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0
Total Points
12
Created On: 07/05/2019 1 Chapter 14 Inventory Problem (v1)
The post Grader – Instructions Excel 2016 Project Chapter 14 Inventory Problem (v1) Project appeared first on PapersSpot.
