Milligan’s Backyard Storage Kits

865 words 4 pages
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…
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. 2. Mr. Milligan wants to know the maximum unit cost and sales price, as well as the minimum unit cost and sales price. 3. He also wants to know the

Related

  • Qua 900 Job Knowledge Questions
    5124 words | 21 pages
  • Childhood Obesity
    2077 words | 9 pages
  • Term Paper
    2041 words | 9 pages
  • Mu2.4 Contribute to Children and Young People's Health and Safety
    1946 words | 8 pages
  • Case Study of Lyons Document Storage Corporation: Bond Accounting
    1320 words | 6 pages
  • Chapter 04: the Procurement Process Exercise 04-02: Review Procurement Master Data
    3729 words | 15 pages
  • Report on Existing Approaches to the Collection Formatting Storage and Dissemination of Information and Knowledge
    964 words | 4 pages
  • Bus 250 Week 1 Case Study a Brawl in Mickey Backyard
    1316 words | 6 pages
  • Term Paper on Marketing Plan
    2562 words | 11 pages
  • safety and sanitation in the kitchen
    7603 words | 31 pages