# Question: Lisa Noriega developed the spreadsheet shown in Figure 4 27 so

Lisa Noriega developed the spreadsheet shown in Figure 4-27 so that she can better manage her inventory of disposable catering supplies. Download the spreadsheet named Ch 04 Ex 01 so you can help her with the inventory analysis.

Lisa listed her inventory items in “Case” quantities, but she now wants to analyze items according to “Pack” quantities and create a price list to show to her customers. For example, a case of Heavy Duty Deluxe Disposable Plastic Knives has 12 packs of 24 knives each. She wants to calculate a “Sales Price per Pack” based on her cost plus a 25% markup.

Lisa asks that you complete the following operations 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.

Create a column that lists Sales Price per Pack. Use a formula to calculate a 25 percent markup. Set up an assumption cell to input the percentage markup rather than include the markup value in the formula.

Format the spreadsheet to make it easy to read and visually appealing.

1. What is Lisa’s total investment in disposable catering supplies?

2. What is the total sales value of her inventory?

3. How much profit will she make if she sells all of her inventory at a 25%markup?

4. How much profit will she make if she uses a 35% markup instead?

Lisa listed her inventory items in “Case” quantities, but she now wants to analyze items according to “Pack” quantities and create a price list to show to her customers. For example, a case of Heavy Duty Deluxe Disposable Plastic Knives has 12 packs of 24 knives each. She wants to calculate a “Sales Price per Pack” based on her cost plus a 25% markup.

Lisa asks that you complete the following operations 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.

Create a column that lists Sales Price per Pack. Use a formula to calculate a 25 percent markup. Set up an assumption cell to input the percentage markup rather than include the markup value in the formula.

Format the spreadsheet to make it easy to read and visually appealing.

1. What is Lisa’s total investment in disposable catering supplies?

2. What is the total sales value of her inventory?

3. How much profit will she make if she sells all of her inventory at a 25%markup?

4. How much profit will she make if she uses a 35% markup instead?

**View Solution:**## Answer to relevant Questions

1. Describe the manner in which data elements are linked across databases.2. What technical and physical challenges does this information system face?3. What human capital capabilities for law enforcement are necessary to ...What is customer relationship management (CRM)? What are the objectives of CRM? How do organizations measure their customer relationship? How do information systems support each objective of CRM? What are three basic ...What measures are these human services agencies taking to make it easier for people to obtain services that are designed for them?How is a URL related to a registered Web site name? Why does a URL include a protocol identifier? What are the components of a Web site address? What are typical suffixes that identify top-level domains?What is m-commerce? What is near-field communication and how does it facilitate mobile payments?Post your question