1. The numbers in cells B18 to B20 should be formulas that refer to B15. This allows the number of cases to be changed in cell 815 with the other cells changing automatically. Exce2. The formula in cell B21 uses a function named ROUNDUP to calculate the even number of batches. The formula should be =ROUNDUP(B15/1000,0) where the zero refers to rounding up to the nearest whole number. H17 10 11 3. (Ungraded) Explore the power of formulas by copying cells A14 to G23 into the scratchpad area below. Try different order sizes (such as 2,000) or different prices to see the effect on contribution to profit. Number of units Differential revenue Relevant Information for Special Order * Unit-level costs 17 18 Materials 19 20 Labor 21 Supplies Batch-level costs 27 Total cost Contribution to income Calcu Type here to search O $ 2.40 = $ 3.20 X $ 1.20 X $ 5,000 TF Mostly