preview

Milligan's Backyard Storage Kits

Better Essays

Milligan’s Backyard Storage Kits

CASE BACKGROUND

Milligan’s Backyard Storage Kits, a mail order company, sells a variety of backyard storage unit kits and landscaping decorations to its customers. Although the company makes a profit, David Milligan, the company’s owner, realizes that he can improve his company’s operations if he better manages his inventory. Mr. Milligan requests your help in preparing an Inventory Analysis worksheet. The Inventory Analysis worksheet provides Mr. Milligan with information about his annual sales, cost of goods sold, gross profit, and markup on this products. Preparing the worksheet for Mr. Milligan requires you to insert columns, use several functions, and apply proper formatting to the …show more content…

Lately, Mr. Milligan has become concerned with his inventory management methods. he now wants to better manage his inventory. As a starting point, he wants to examine his costs, sales, markup percentages, gross profits, and inventory levels. He asks you to review his inventory and make suggestions for improvement. He provides you with the data and asks you to prepare an Inventory Analysis worksheet.

Design Specifications

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

Get Access