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
This course focuses on ways in which financial statements reflect business operations and emphasizes use of financial statements in the decision-making process. The course encompasses all business forms and various sectors such as merchandising, manufacturing and service. Students make extensive use of spreadsheet applications to analyze accounting records and financial statements. Prerequisites: COMP100 and MATH114 / 4-4
Schenck, J., McInerney, J. 1998. Applying vendor-managed inventory to the apparel industry. Automat. I.D. News 14(6) 36-38
In this table, it reflects the changes in fixed plant overhead from $420,000 to $378,000. The company still has the fixed selling and administrative expense per quarter of $118,000. The new company fixed overhead is now at $496,000 from the past $538,000 ($42,000) change from past to
330-10-30330-10-30-1 The primary basis of accounting for inventories is cost, which has been defined generally as the price paid or consideration given to acquire an asset. As applied to inventories, cost means in principle the sum of the applicable expenditures and charges directly or indirectly incurred in bringing an article to its existing condition and location. It is understood to mean acquisition and production cost, and its determination involves many considerations. 330-10-30330-10-30-2 Although principles for the determination of inventory costs may be easily stated, their application, particularly to such inventory items as work in process and finished goods, is difficult because of the variety of considerations in the allocation of costs and charges.
b. The inventory write down recorded, as an expense by the company is $4.4 million. It is measured at lower of cost and net realizable value. Cost is measured by weighted average using standard cost method or
With this company the inventory management ratios further indicate that there may be an issue with inventory and inventory controls. The inventory turnover ratio is lower than the industry average and the days’ sales in inventory are high. A company wants to turn inventory quickly to reduce storage costs, and
Although the shelves are selling well, the total profit of the company is a concern. An engineer suggested that the current production of model S should be cut back because Model S shelves are sold for $1800 per unit but their costs are $1839. Therefore, company is losing money on each one. But
Jones over forecasts his inventory and has a low inventory turnover ratio. This drastically increases his accounts payable, as he isn’t able to pay due to low cash inflow. His account’s payable increased by nearly 9 percent in 2006. Nearly half of his current assets are in inventory. Also Jones isn’t able to take advantage of the cash discounts offered by his suppliers due to his slow cash collection process. In order to perform well, the company must improve its inventory system and its cash collection policies.
Determine the types of inventories these companies currently manage and describe their essential inventory characteristics.
Considering these above mentioned features, to take over the company, it is essential for Joe Jr. to take due attention to a proper approach for inventory management, calculate an appropriate inventory level for each product, making it in line with the company’s business strategy, the market demand in the upcoming period:
When offers of reduced pricing are accepted for equipment, meeting delivery expectations becomes an important part of enhancing the customer experience to maintain satisfied loyal customers. An inventory specialist in the current distribution center would be given the additional task of segregating and maintaining inventory levels to meet the needs of the customer loyalty department.
Evaluate the changes Dore-Dore has made in its children’s knitwear division. How does the performance of the traditional operation and the cellular manufacturing system differ? For example, how does work-in-process inventory change when cells are implemented?
Identify 3 possible actions the firm could take to deal with its excess inventory problem. These actions may be options identified by characters in the case, or actions you think of yourself.
Tim Horton's one of North America's largest coffee and fresh baked goods chains. Today, Tim Horton's has more than 2,200 stores across Canada and a steadily growing base of 160 locations in key markets within the United States. Our project is focus on the Inventory management of Tim Horton's which located in Bay Shore, 2970 Carling Ave. Inventory Management is the practice of planning, directing and controlling inventory so that it contributes to the business' profitability. Inventory management can help business be more profitable by lowering their cost of goods sold and/or by increasing sales.