Please Use Excel to calculate the following Mr. Milligan asks you to determine for each inventory item
Question:
Please Use Excel to calculate the following
Mr. Milligan asks you to determine for each inventory item the:
• Cost of average inventory
Annual sales
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.
FIND THE FOLLOWING:
Using Financial Accounting Information The Alternative to Debits and Credits
ISBN: 978-1133161646
7th Edition
Authors: Gary A. Porter, Curtis L. Norton