Lipman Bottle Company Case Study
Essay by Joseph Littleton • September 30, 2018 • Case Study • 947 Words (4 Pages) • 1,501 Views
Abstract
Lipman Bottle Company has to use a product-costing method to explore the severity of variable costs per unit, time-based fabrication, capacity of their operation and growth in the current market. The competition in their current market has caused Lipman Bottle Company to barely break-even. Lipman Bottle Company needs to avoid loss in the future. Lipman Bottle Company would like to expand their current market and increase production. The analysis I will do will be created from three printing differences on the smallest bottle and an average order of 10,000 bottles. The operating costs will include the setup and operation of the machines for each type of variation, the recommended prices will be made from break-even projections and the company want to achieve a 30% profit.
Case Study 17.2 Lipman Bottle Company
Lipman Bottle Company distributes bottles and is located in Albany, New York. Lipman Bottle company was founded in 1909. The company earns their profits from printing. The company is able to print 1 million bottles. Lipman Bottle Company has 10 printing machings and 8 drying ovens. There are two primary types of bottle printer’s simple designers and custom decorators. Simple designers have a standard design and a set price list. Custom decorators have special prices because they have difficult designs. Robert Lipman is the company’s vice president and has set a goal to make a 30 percent profit margin. The vice president would also like to expand the business to new areas. Robert Lipman has asked for analysis of their current product line and what the current costs are so he will be able to make a projection to increase the company’s profits and suggest new prices.
Variable Costs
I have completed the variable costs for a thousand bottles for many combinations. The table below shows the variable costs for the Albany area. I have analyzed bottle sizes from 0 to 1 ounce and 17 to 32 ounces. The prices range for the quantities of the number of bottles ordered from 5000 to 9999 and 100000 to 249999. Variable cost analysis for Mr. Lipman to be able to set prices: 1000000 – 128332.80 – 300000 = 571667 for variable costs.
Please see the table below:
Albany | ||||||
Round | Round | Oval | ||||
Ounce size of bottle | # Ordered 5000 to 9999 | # Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 |
0 to 1 ounce | 22.56 | 18.81 | 51.47 | 43.96 | 42.11 | 34.60 |
17 to 32 ounces | 24.06 | 20.31 | 54.47 | 46.96 | 45.11 | 37.60 |
I have added the table below to show the variable costs for New York and New Jersey area. This will include the cost for shipping but not freight. Freight is defined as the products that are being moved by means of commercial gain (A, 2014). Freight shipping is less expensive to both parties. Both tables have analysis for bottle sizes from 0 to 32 ounces. The prices range for the quantities of the number of bottles ordered within two data sets.
Please see table below:
New Jersey and New York Area | ||||||
Round | Round | Oval | ||||
Ounce size of bottle | # Ordered 5000 to 9999 | # Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 |
0 to 1 ounce | 22.22 | 18.49 | 49.23 | 41.77 | 39.87 | 32.40 |
17 to 32 ounces | 47.35 | 43.62 | 74.36 | 66.90 | 65.00 | 57.53 |
30 Percent Profit Margin
Mr. Lipman has set a goal of earning a 30 percent profit margin. The first table shows current status. The company’s break-even point. The second table shows Mr. Lipman with a 30% percent profit margin. In these tables it shows that Round bottle 2 costs almost double of Round Bottle 1. As the size of the bottle increases the cost increases but the bigger sized orders lower the costs.
Break-Even | ||||||
Round | Round | Oval | ||||
Ounce size of bottle | # Ordered 5000 to 9999 | # Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 |
0 to 1 ounce | 29.46 | 25.73 | 58.37 | 50.91 | 49.00 | 41.54 |
17 to 32 ounces | 30.96 | 27.23 | 61.37 | 53.91 | 52.01 | 44.54 |
Profit Margin of 30 Percent | ||||||
Round | Round | Oval | ||||
Ounce size of bottle | # Ordered 5000 to 9999 | # Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 | # Ordered 5000 to 9999 | Ordered 100000 to 249999 |
0 to 1 ounce | 42.09 | 44.23 | 83.39 | 87.68 | 70.01 | 74.30 |
17 to 32 ounces | 36.75 | 38.90 | 72.72 | 77.01 | 59.35 | 63.63 |
...
...