4-29. EXCEL APPLICATION: Create a column that lists Sales Price per Pack. Use a Managing Catering Supplies formula to calculate a 25% markup. Set up an assumpLisa Noriega developed the spreadsheet shown in Figure 4-27 tion cell to input the percentage markup rather than so that she can better manage her inventory of dispos- include the markup value in the formula. able catering supplies. Download the spreadsheet named Format the spreadsheet to make it easy to read and Ch04Ex01 so you can help her with the inventory analysis. visually appealing. Lisa listed her inventory items in "Case" quantities, but 1. What is Lisa's total investment in disposable catering she now wants to analyze items according to "Pack" quantisupplies? ties and create a price list to show to her customers. For exam- 2. What is the total sales value of her inventory? ple, a case of Heavy Duty Deluxe Disposable Plastic Knives 3. How much profit will she make if she sells all of her has 12 packs of 24knives each. She wants to calculate a inventory at a 25% markup? "Sales Price per Pack" based on her cost plus a 25% markup. 4. How much profit will she make if she uses a 35% Lisa asks that you complete the following operations markup instead? and answer the following questions. Create columns that list Case Pack, Packs on Hand, and Cost per Case Pack for each item. Use a formula to calculate the Cost per Case Pack. FIGURE 4-27 Catering supplies spreadsheet