13. Go to the MPG Pivot Table worksheet. This sheet includes a Pivot Table created from the data on the MPG Data worksheet. Refresh the Pivot Table data. b. Apply the White, Pivot Style Medium 1, or Pivot Style Medium 1 Quick Style to the PivotTable. c. Display a slicer for the SmartWay field and show only data where the SmartWay value is Elite. 14. To pay for the new car, you've decided to start a bakery business out of your home kitchen. You have limited capital and capacity, so you need to make wise decisions about which products to bake each day. Go to the Bakery Business worksheet. Cell B1 uses a SUMPRODUCT formula to calculate profit. Carefully review the assumptions and formulas in this worksheet before entering the following Solver parameters: Find the maximum possible profit (cell B1) by changing the values in cells C7:C10. b. The working hours required (B3) must be less than or equal to the number of working hours in the day (D3). c. The total cost of ingredients (B4) must be less than or equal to the available capital (D4). a. - AE w 29 Title de Pabile de DA OYNA. PERE ap 81 IND w w WOW de POR AS Wide Wide HADH - Se 10 20 Corbel ' the Copy General Wapest 0.A-1 Merge a Carte $ - % Input Conditional to Norman Formatting - Norma 2 Note LAR Norm 20 Title#... Clipboard Font Annen must be less than or equal to E G H 1 Labor hours Max per day 3 1 What is my profit? Available capital 200.00 Working hours required must be less than or equal to Total cost of ingredients must be less than or equal to 200 00 5 Optimal number to make each 6 Price (retail) day Cost ingredients 7 Burthday Cake 1 60.00 14.00 8 Cupcakes (daten) 2500 OS 0.00 9 Cookies Shorthread (dozen) $ 18.00 DS 6.00 10 Cookies, Lemon Bars (dozen) 20.00 625 21 13 Total labor hours must be less than or equal to working houes per day 13 Total cost must be less than or equal to capital 14 Number to make of each item cannot be more than the manum per day possible 15 16 17 t 4 6 6 1 1 DI 20 22 23 24 25 26 27 29 30 31 32 33 34 13. Go to the MPG Pivot Table worksheet. This sheet includes a Pivot Table created from the data on the MPG Data worksheet. Refresh the Pivot Table data. b. Apply the White, Pivot Style Medium 1, or Pivot Style Medium 1 Quick Style to the PivotTable. c. Display a slicer for the SmartWay field and show only data where the SmartWay value is Elite. 14. To pay for the new car, you've decided to start a bakery business out of your home kitchen. You have limited capital and capacity, so you need to make wise decisions about which products to bake each day. Go to the Bakery Business worksheet. Cell B1 uses a SUMPRODUCT formula to calculate profit. Carefully review the assumptions and formulas in this worksheet before entering the following Solver parameters: Find the maximum possible profit (cell B1) by changing the values in cells C7:C10. b. The working hours required (B3) must be less than or equal to the number of working hours in the day (D3). c. The total cost of ingredients (B4) must be less than or equal to the available capital (D4). a. - AE w 29 Title de Pabile de DA OYNA. PERE ap 81 IND w w WOW de POR AS Wide Wide HADH - Se 10 20 Corbel ' the Copy General Wapest 0.A-1 Merge a Carte $ - % Input Conditional to Norman Formatting - Norma 2 Note LAR Norm 20 Title#... Clipboard Font Annen must be less than or equal to E G H 1 Labor hours Max per day 3 1 What is my profit? Available capital 200.00 Working hours required must be less than or equal to Total cost of ingredients must be less than or equal to 200 00 5 Optimal number to make each 6 Price (retail) day Cost ingredients 7 Burthday Cake 1 60.00 14.00 8 Cupcakes (daten) 2500 OS 0.00 9 Cookies Shorthread (dozen) $ 18.00 DS 6.00 10 Cookies, Lemon Bars (dozen) 20.00 625 21 13 Total labor hours must be less than or equal to working houes per day 13 Total cost must be less than or equal to capital 14 Number to make of each item cannot be more than the manum per day possible 15 16 17 t 4 6 6 1 1 DI 20 22 23 24 25 26 27 29 30 31 32 33 34
