cost of goods sold annual gross profit gross margin ratio markup percentage. The determination of these values requires you to add columns to the Inventory Analysis worksheet. Mr. Milligan asks you to use the worksheet provided. As Mr. Milligan will use the Inventory Analysis worksheet during a presentation, he wants the worksheet to have a professional appearance. To enhance the worksheet’s appearance, you include an appropriate header and format to the worksheet, column, and row labels. The header should display the name of the business, the name of the worksheet, and the current date. As you construct the worksheet, you use the currency format for all columns containing dollar values. Also, for any column that contains a percentage, you use the percentage format and format the data to two decimal places. Milligan.xls
Inventory Analysis Worksheet Formulas Annual Gross Profit Annual Sales – Cost of Goods Sold Annual Sales Unit Sales per Year * Price Cost of Average Inventory Average Inventory * Unit Cost Cost of Goods Sold Unit Sales * Cost of Goods Sold Gross Margin Ratio (Price – Unit Cost) / Price Markup Based on Cost (Price – Unit Cost) / Unit Cost Information Specifications 1. Mr. Milligan wants the average, minimum and maximum, value of each for the: cost of average inventory annual sales cost of goods sold annual gross profit gross margin ratio markup percentage values.
You've reached the end of your free preview.
Want to read both pages?
- Spring '17
- David Milligan, Mr. Milligan